Data Studio template
Paid Channel Mix (BigQuery) Data Studio dashboard template
By Supermetrics
PPC / Paid Media Free
Best for: For paid media and analytics teams that centralise multi-channel ad data in a warehouse and need one cross-channel view.
Overview
This Data Studio template reads warehoused paid media data from BigQuery or Supermetrics Storage and presents a cross-channel overview of cost, clicks and conversions. An overview compares channels side by side, and each advertising channel has its own detailed report page for deeper analysis. It requires Supermetrics transfers for each ad platform into the STANDARD table group before the report is connected.
Who it's for
For paid media and analytics teams that centralise multi-channel ad data in a warehouse and need one cross-channel view.
Questions it answers
- How is cost split between channels and how is it developing month to month?
- Which paid media channel performed best last month?
- Which channel drove the most conversions and impressions?
- Which ad creatives have the lowest CPC and CPM?
What's inside
4 report pages:
1Overall paid performance overview
2Channel comparison
3Per-channel detail pages for Google Ads, Facebook Ads, LinkedIn Ads, X Ads, TikTok Ads and Pinterest Ads
4Creative performance
Key features
- Cost split by channel
- CPC comparison across channels
- Month-over-month cost trend
- Clicks, impressions and conversions by channel
- Creative-level CPC and CPM
- BigQuery or Supermetrics Storage as the data source
Set it up in minutes
- Open the template and choose to use your own data.
- Connect the source through the Supermetrics connector for Looker Studio (free trial, then a paid plan).
- The report copies into your own Data Studio account and refreshes automatically.
FAQs
Is the template free?
Yes — the template itself is free to copy. The Supermetrics connector that feeds it has a free trial and then requires a paid plan.
Do I need technical skills?
No. Authorise the data source through Supermetrics and the template fills with your own data — nothing is built from scratch.
Can I customise it?
Yes. Once copied into your account, edit the charts, metrics, filters, colours and layout to match your reporting.
How often does the data update?
Supermetrics refreshes the data on a schedule, so the report stays current without manual exports.
Can I use it for client reporting?
Yes. Copy the template, connect the client's account, customise and share straight from Data Studio.
Which other tools does Supermetrics support?
Besides Data Studio, Supermetrics delivers to Power BI, Google Sheets, Excel, BigQuery, Snowflake and Tableau.