Insights

How to Connect Meta I/O Campaign Data to Looker Studio

by Paul Cote on Apr 19, 2024

How to Connect Meta I/O Campaign Data to Looker Studio

Cendyn's Meta I/O is a powerful platform used by many hoteliers to purchase and manage advertisements on popular travel research sites such as Google, Tripadvisor, Trivago, Kayak, and more. The Meta I/O platform can connect to a hotel's availability, rates, and inventory (ARI), then display the best price for the dates customers are researching in the publisher platform's native ad format. Participating hotels have long enjoyed the increase in direct bookings this platform provides for an above average return on advertising spend (ROAS).

The Launchpad Data Transfer Suite, by Calibrate Analytics, recently added a Meta I/O API source integration, giving users the ability to extract their campaign performance data each day and deliver it to their preferred data storage destination such as Google BigQuery, Google Sheets, Snowflake, etc. Once transferred, the data can be visualized using Looker Studio and new data will populate each day after the daily transfer has finished.

Getting Started with Meta I/O and Launchpad

The following steps outline the process for setting up an automated Meta I/O dashboard using the Launchpad Data Transfer Suite, Google BigQuery and Looker Studio. For the purposes of this tutorial we'll assume you have access to each of the aforementioned systems.

Request an API key

Obtain Meta I/O API credentials from your Cendyn account manager.

Configure your source

Configure the Meta I/O source connector in the Launchpad Data Source configuration screen.

Configure your destination

Configure the Google BigQuery destination in the Launchpad Destination configuration screen

Configure your schema

Select your desired dimension and metrics and run your job

Transform your campaign data

Once your data has successfully transferred to your data warehouse you can use a UNION or the SQL equivalent in your visualization app to aggregate data from each of the meta search channels your hotel is participating in.

Schedule your job

Be sure to schedule your data transfer job in Launchpad to refresh your data daily through your desired attribution window (up to 30 days).

Visualize your campaign data

Click on Add Data in Looker Studio. Choose BigQuery as your data source. Select your summarized Meta I/O table and click add. Once you have connected your data you can build charts and dashboards using dimensions and metrics you selected in your data transfer.

Take Control of Your Data

Data Transfer tools are essential to efficiently source and manage big data. Consider an ETL platform like Launchpad the 'gateway' to accessing and owning your data. Launchpad Data Transfer Suite supports a wide array of integrations, like Meta I/O, making it easy to transfer data to your preferred data warehouse. From there you can transform, analyze and create powerful visualizations from a variety of apps.

Need Help?

If you're having any trouble setting up your data pipeline, the experts at Calibrate would be happy to help. From walk-throughs and interactive demos to custom solutions, we'll help you set up a healthy analytics stack that fuels smart business decisions.

Book a Demo

Share this post:
  • Paul Cote

    About the Author

    Paul is head of analytical products at Calibrate Analytics. He is responsible for creating digital analytical solutions that enable better business decisions. He has over 19 years of digital focused leadership, along with vast experience in analytics solutions aiming to deliver the right insights.