Case Study: International luxury hotelier achieves centralised marketing data and up to 60% lower ad costs with Fivetran

International Hotelier Books Big with Fivetran-Facebook Pipeline to Google BigQuery

International Luxury Hotel, a Dubai-based luxury hotelier operating 22 properties across eight countries, faced fragmented marketing data with Google and Facebook analytics in separate silos and limited time/resources to build a custom ETL. To centralise Facebook Ad data in its existing Google BigQuery marketing warehouse and avoid hiring data engineers, the company chose Fivetran to connect Facebook Ad Insights and Ad Accounts into BigQuery so analysts could focus on insights and campaign optimisation.

Fivetran’s automated pipelines delivered Facebook data into BigQuery, powering combined dashboards in Qlik Sense and internal BI and enabling granular analyses (for example, optimal Facebook video length and cost-per-view). With Fivetran, the International Luxury Hotel lowered cost-per-click by 28% on average (up to 50–60% in some campaigns), increased click-through and conversion rates, eliminated the need for an additional ETL engineer, and gained centralized, actionable reporting for marketers and executives.