Facebook & Instagram (Meta) Ads report template for Looker Studio

This template works with both BigQuery data warehouses and Supermetrics Storage . To get started, verify that you have access to Google Ads, Facebook Ads, LinkedIn Ads, X Ads, TikTok Ads, Pinterest Ads, and your chosen destination ( BigQuery or Supermetrics Storage). Additionally, ensure you're logged in to Looker Studio and Supermetrics Hub .

Prep work:

• Set-up a BigQuery destination by following these instructions. Supermetrics Storage users can proceed directly to step 2.
• Follow these instructions to create transfers for each data source. In Step 4, select the STANDARD table group for this template to work.
• Follow these instructions to backfill the historical data of each transfer. To start, you can backfill 3 months, proceed with the steps below, and then backfill the rest.
• Once there is some data for each data source transferred to BigQuery, proceed with the next steps.

Looker Studio:

1. Click ‘Get the template'.
2. Click the ‘Use my own data' button at the top.
3. Hover over the data source to find the table name, you'll need this later.
4. Click 'Replace data'.
5. Authorize Looker Studio to connect to your BigQuery projects.
6. Choose the project and dataset where you transferred the data during the initial prep work.
7. Choose the corresponding table name from step 3, then click 'Next'.
8. Repeat steps 2 to 7 with each table/data source. You can skip data sources that you don't use and remove those pages later.
9. Click 'Edit and Share' - this will make a copy of the template so you can start toanalyze your data.
10. If the edit button doesn't appear or errors show on the new copy, reload the page or find the template copy on the Looker Studio homepage .