Creating data-driven relationships between users and properties

Key Results Provided
Mission
Harnessing BigQuery integrations to create data-driven relationships between users and properties, enabling hyper-personalized digital experiences at every stage of the booking journey. This not only streamlined email production—accelerating it by over 300%—but also reduced human errors and allowed us to deliver consistently relevant content to each customer.
Tools
• BigQuery – Centralized data warehousing and advanced analytics
• Python & Pandas – Data processing and transformation scripts
• CRM API – Direct integration for streamlined lifecycle communications
Strategy
1. User-Property Mapping: Leveraged BigQuery to pair user profiles with specific property interests, creating a real-time “relationship graph.”
2. Automated Data Flows: Employed Python and Pandas to transform raw data into CRM-ready insights, ensuring consistent format and quality.
3. Standardized Email Frameworks: Structured email templates around key data fields, dramatically cutting production time and error rates.
4. Lifecycle-Oriented Touchpoints: Personalized communications based on user behavior and property interactions, guiding them through a tailored booking journey.
Results
• +100% Increase in repeat customers
• +40% Boost in flow conversions across automated campaigns
• +200% Higher email open rates, reflecting more relevant and timely messaging
Learnings
• Data Integrity Drives Personalization: A reliable data pipeline was essential for delivering messages that resonated, boosting both retention and conversion.
• Automation Multiplies Efficiency: Standardized email production workflows eliminated manual inefficiencies, letting teams focus on strategy instead of mechanics.
• Integrated Systems Optimize Insights: Directly connecting BigQuery outputs to the CRM API ensured continuous, unified data across all marketing touchpoints.