Meta & Google Ads Performance Report · Power BI template
Compare what Meta and Google cost you and what they bring in
Built on real client projects, with a deployment guide, an anonymized dataset, email support, and advanced visualization techniques you can reuse in your own reports. If you want a hand, book a session with me.
€69excl. VAT
Taxes calculated at checkout
- Deployment kit included
- Support within 48 business hours
- Consulting available
Connect your ad accounts in minutes
Start from your Meta, Google Ads, and Google Analytics exports, plus your Facebook and Instagram pages, in Excel or CSV. For each tool, the deployment guide gives you the numbers to export and where to put them in the delivered Excel file. The report fills in, then updates with every new export.
- Meta Ads
- Google Ads
- Google Analytics
- Excel
In three steps
Test it
Open the report with the anonymized dataset: everything already works.
Connect your data
Export your Meta and Google campaigns, your Google Analytics numbers, and your page insights, then bring them into the delivered Excel file. Then point Power BI Desktop to that file, with the guide at hand.
Check and publish
Compare the report's spend with Meta and Google Ads and run the guide's five checks, then publish the report for your team.
We list the big names, but the report connects to any data source. Not sure about yours? Email me a sample of your export at emilien@datapilot.fr, and I'll get back to you within 48 business hours.
A report you can use right away
Track Meta and Google side by side vs. last year: your spend, your conversions, their cost, and your return on ad spend. Then read each campaign with the visits and conversions Google Analytics measures on your site. Clear numbers to decide where your budget goes.
| Spend | Reported CPA | Reported ROAS | |
|---|---|---|---|
| Meta | $330,942 | $24.00 | 3.7× |
| $310,928 | $21.50 | 4.9× | |
| Total | $641,870 | $22.72 | 4.3× |
Report extract, anonymized data
Meta and Google side by side, from impression to conversion 
The campaigns to watch closely show in red 
What your visitors do on your site, vs. last year 
Your followers and top posts, excluding ads
Anonymized data. Your own numbers take its place as soon as you connect your export.
Filter, hover, explore: this is the report you get, loaded with the anonymized dataset.
Save 2 months of development
Our experts built this Meta and Google campaign tracking on client projects. Start from this standard instead of from scratch.
With an agency
A project built from scratch
- Timeline
With an agency : 2 months of development- Price
With an agency : From €3,000 excl. VAT
With a template
A standard proven on client projects
- Timeline
- Ready to use today
- Price
- €69 excl. VAT
Timeline and price observed at other agencies for a simple report, custom-built.
Need something specific to your business? At Datapilot, our experts start from this report to build yours. Talk to Datapilot
What you get
The Power BI report
The Power BI Desktop file. It's yours: change it however you like.
The deployment guide
A step-by-step PDF, from opening the report to publishing it.
The anonymized dataset
An Excel file to test everything before you connect your own numbers.
By email, right after payment: one download link to a .zip file with all 3 files.
Consulting services
Would you like one-on-one help while you set up your template?
I'll help you get started with your template and set it up. I have 10 years of experience in reporting, and I can help you figure out how to export your data, deploy the report, or adapt it to your business.
Emilien GrangerFounder and CTO of Datapilot
One hour for €200 excl. VAT, or a half day for €500 excl. VAT, with the report or later.
Taxes calculated at checkout
FAQ
From your tools: Meta Ads and Google Ads for your campaigns, Google Analytics for your site, Meta Business Suite for your Facebook and Instagram pages. The simplest way is an export from each tool, in Excel or CSV; the deployment guide explains how to bring it into the delivered Excel file. We list the big platforms, but the report connects to any data source.
Yes, if you buy ads on Meta and Google. We built it on a project for tourism companies, and its metrics apply to every industry.
No. Leave the tables of the sources you don't use empty: the report fills in with the others. I can help you connect your tools and answer your questions.
Yes. Export the same months from last year too, and the report does the comparison on its own.
Licenses, delivery, support, and payment are covered in the FAQ. See all questions
Technical details
Every report ships connected to an Excel file, the simplest setup when you don't have a data infrastructure. You can swap that file for your own Excel files, and, more importantly, connect the report directly to your sources.
Possible sources
Meta Ads (Facebook and Instagram)
- By export
- Your campaigns, day by day, exported from Ads Manager in Excel or CSV.
- Direct connection
- The Meta Ads API.
Google Ads
- By export
- Your campaign report, day by day, in Excel or CSV.
- Direct connection
- The Google Ads API.
Google Analytics 4
- By export
- Sessions and conversions by channel, device, country, campaign, and page, in Excel or CSV.
- Direct connection
- The Google Analytics API.
Facebook and Instagram pages
- By export
- Your page and post insights, exported from Meta Business Suite in Excel or CSV.
- Direct connection
- The Meta API, for your Facebook and Instagram pages.
A tracker kept in Excel
- By export
- Your numbers, in the format of the delivered file.
- Direct connection
- The report connects to your own Excel file instead.
A direct connection takes some setup on your side, and the closer you get to the source, the more technical it gets. I can help you connect through consulting services, so everything goes as smoothly as possible.
How the report is built today
The tables of the delivered Excel file, as the report reads them today. It stays flexible: your data doesn't need to have this exact shape.
Fact_Ads (Meta and Google ads, by day and campaign)
Date, Campaign_Key (campaign number), Impressions, Clicks, Spend, Reported_Conversions, Reported_Value
Fact_GA4_Channel (site, by day, channel, and device)
Date, Channel, Device, Sessions, Engaged_Sessions, Total_Duration_s (in seconds), Page_Views, New_Users, Returning_Users, Conversions, Value
Fact_GA4_Country (sessions by day and country)
Date, Country, Sessions
Fact_GA4_Campaign (GA4 visits and conversions, by day and campaign)
Date, Campaign_Key, Sessions, Engaged_Sessions, Conversions, Transactions, Value
Fact_GA4_Pages (site pages, by day)
Date, Page, Views, Event_Count, Conversions
Fact_Social_Organic (Instagram and Facebook pages excluding ads, by day)
Date, Network, Followers_End, Followers_Gained, Followers_Lost, Organic_Reach, Organic_Impressions, Interactions, Engagement_Rate, Posts
Fact_Social_Posts (one row per post)
Post, Network, Reach, Interactions, Engagement_Rate, Publish_Date
Dim_Campaign (list of campaigns)
Campaign_Key, Campaign, Platform (Meta or Google), Channel (GA4 channel), Source, Medium, Campaign_Objective, Theme (what the campaign promotes)
Dim_Platform
Platform, Sort_Order
Dim_Channel
Channel, Channel_Type (Paid or Unpaid), Sort_Order
Dim_Device
Device, Sort_Order
Dim_Country
Country, Market (Domestic or International), Code
Dim_Social_Network
Network, Sort_Order
Calendar
built into the report
- Power BI Desktop file (.pbix), ready to publish to the Power BI service.
- Four pages: Overview (eight ad KPIs vs. prior year, spend by month and platform, Meta vs. Google funnel), Acquisition (GA4 sessions and conversions by channel, a scatter chart of spend vs. conversions by theme, a campaign table), Website (seven GA4 KPIs, sessions by device and country, a page table), and Social Media (eight organic KPIs, reach and engagement by month, followers gained and lost, top posts); Year, Month, Platform, Campaign, and Network filters, depending on the page.
- Data loaded by Power Query from the 13 named Excel tables of the anonymized dataset, which you replace with your exports; each table and each column is read by its name, in any order.
- Two separate conversion counts, never mixed: the conversions Meta and Google report (Overview page) and GA4 conversions, measured on the site and credited to a single source (Acquisition and Website pages). Spend is always the amount the ad platforms report.
- Star schema: seven fact tables (ads; sessions by channel and device, by country, by campaign, and by page; social media by day and by post), six lookup tables (platforms, channels, campaigns, devices, countries, networks), and a calendar rebuilt at every refresh, which limits the prior year to the same months. The campaign list links the ad platforms' numbers to GA4's.
- DAX measures: spend, impressions, clicks, conversions, CPA, and ROAS; sessions, engagement, bounce, duration, and GA4 conversions; GA4 CPA and ROAS by campaign; followers, reach, interactions, and organic engagement rate; prior year and variances for every card.
- Rates and ratios calculated on period totals; variances in % for amounts and counts, in points for rates; badges follow the favorable direction: a falling CPA or bounce rate shows in green.
- Followers read as a stock, on the last day of the period, network by network. A campaign shows in red when its GA4 ROAS is in the bottom quarter or its GA4 CPA in the top quarter of the campaigns shown, or when it has no GA4 conversion.
- Add a campaign, channel, or country with one row in the workbook and a refresh: nothing to change in Power BI.
Your report is ready. All it needs is your numbers.
One payment, no subscription. You get the report, its deployment guide, and an anonymized dataset already loaded. Connect your source, and your report is ready to use.
€69excl. VAT
Taxes calculated at checkout
More templates for Marketing
Digital Marketing Analysis
Facebook, LinkedIn, newsletters, and websites vs. last year, in one report.
€129 excl. VAT