Ad report template for Looker Studio (via BigQuery or Supermetrics Storage)
Track your paid advertising campaigns with our comprehensive template. Connect it to your data storage—either BigQuery or Supermetrics Storage—to pull in data from your paid media sources, providing a central access point to analyze key metrics like cost, clicks, and conversions in Looker Studio. Each advertising channel has its own detailed report page, allowing for in-depth analysis.
Report your overall paid performance
Compare multiple channels
How to use the template
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:
- Click ‘Get the template'.
- Click the ‘Use my own data' button at the top.
- Hover over the data source to find the table name, you'll need this later.
- Click 'Replace data'.
- Authorize Looker Studio to connect to your BigQuery projects.
- Choose the project and dataset where you transferred the data during the initial prep work.
- Choose the corresponding table name from step 3, then click 'Next'.
- 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.
- Click 'Edit and Share' - this will make a copy of the template so you can start toanalyze your data.
- 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.
Questions you can answer with this template
Cost split
- How's the cost split between channels?
- Which channel had the lowest CPC?
- How's the cost developing month to month?
Paid performance analysis
- Which paid media channel performed the best last month?
- How many times were my ads clicked?
Channel specific analysis
- Which channel drove the most website conversions?
- Which channel got the most impressions from the ads?
Creative performance
- Which ad creative had the best performance in campaigns?
- Which ad creative has the lowest CPC and CPM?
Get started with paid media dashboard template
Try our free template to see your paid performance across channels with a 14-day free trial for Supermetrics. No credit card required.
See our other templates
Stay in the loop with our newsletter
Be the first to hear about product updates and marketing data tips