Free template

PPC report template

A free, ready-made PPC report for Google Ads and Meta Ads in one place: spend, conversions, ROAS and cost per conversion, by platform, campaign and day. Copy the template into Mammoth, connect both ad accounts, and get the same dashboard on your own data.

Use this with my Google Ads Book a demo

14-day Pro trial · No credit card · Viewers are always free

The template: paste this into Mammoth

PPC performance across Google Ads and Meta Ads: total spend, conversions, conversion value, ROAS, cost per conversion and CTR as KPIs, a daily spend and conversion value trend, conversion value by platform, and conversion value by campaign

Google Ads and Meta Ads dashboard built in Mammoth, showing Total spend, Conversions, Conversion value, ROAS, Cost per conversion, CTR

The dashboard Mammoth built from that sentence, on sample data.Open the live dashboard →

In production at

What is a PPC report template?

A PPC report template is a ready-made report for your paid ads, with the numbers and charts already chosen. This one is a live PPC dashboard: connect Google Ads and Meta Ads and it fills in with spend, conversions, conversion value and return on ad spend across both platforms, by day and by campaign. It updates itself, so nobody has to export from two ad accounts each week.

What's on it

What's in the PPC report template

Six numbers at the top and three charts below them.

Six numbers at the top

Google Ads and Meta Ads dashboard: Total spend, Conversions, Conversion value, ROAS, Cost per conversion, CTR

Total spend: How much you spent across Google Ads and Meta.
Conversions: How many sales, sign-ups or calls your ads brought in, on both platforms.
Conversion value: How much revenue those conversions were worth.
ROAS: Revenue for every $1 you spend. 3.4x means $3.40 back for each $1.
Cost per conversion: How much you paid, on average, for each conversion.
CTR: The share of people who saw an ad and clicked it.

Daily spend and conversion value

What you spent and what it earned across both platforms, for every day in the period.

Conversion value by platform

Revenue from Google Ads next to revenue from Meta Ads.

Conversion value by campaign

How much revenue each campaign brought in, on either platform, highest first.

How it works

How to use this PPC report template

Step 1
Start with the template
Sign up and the PPC report opens on sample data, so you can see it before you connect anything.
Step 2
Sign in with Google Ads
One sign-in. Your data arrives as one tidy table, the dashboard moves onto it, and it refreshes every day.
Step 3
Share or schedule it
Share a link, or have it emailed every week. Viewers are free.

Compare

PPC report templates compared

This template in Mammoth, the ad platforms' own reports, and a Data Studio template. Data Studio is Google's free report builder, called Looker Studio until recently.

Mammoth template

For one PPC report across Google Ads, Meta and your other data, shared with clients or your team.

✓Ready-made template
~FreeFree plan for uploaded files
✓Google Ads and Meta in one report
✓Share a link anyone can open
✓Change it by asking in plain words

Each platform's reports

For checking one ad account at a time.

✕Ready-made template
✓Free
✕Google Ads and Meta in one report
✕Share a link anyone can open
✕Change it by asking in plain words

Data Studio template

For a free report when most of your data is Google's.

✓Ready-made template
~FreeMeta needs a paid partner connector
~Google Ads and Meta in one reportNeeds a paid partner connector
✓Share a link anyone can open
✕Change it by asking in plain words

PPC report template questions

What should a PPC report include?

Spend, conversions, conversion value and ROAS across every platform at the top, then a daily trend, a split by platform and a breakdown by campaign. Add CTR and cost per click when you need to find out why a number moved.

What is the difference between a PPC report and a PPC dashboard?

A PPC report is usually a fixed document for a period, such as last month. A PPC dashboard shows the same numbers and stays up to date. This template is a dashboard you can also have emailed on a schedule, so it does both jobs.

How do I use this PPC report template?

Connect Google Ads and Meta Ads to Mammoth, or upload a Google Ads and Meta Ads export as a CSV or Excel file. Then paste the template sentence from the top of this page. Mammoth builds the same numbers and charts from your data.

Is the template free?

The template is free to copy. Building it from an uploaded Google Ads and Meta Ads export works on Mammoth's free plan. Connecting your Google Ads and Meta Ads accounts directly needs a paid plan.

Can I change the template?

Yes. Ask for the change in plain words, such as "add clicks by device" or "show last month only", and Mammoth updates the dashboard.

Can Mammoth connect to Google Ads and Meta Ads directly?

Yes. Google Ads and Meta Ads are both of Mammoth's 100+ tested connectors, so the dashboard reads your accounts rather than an export.

How often does the dashboard update?

Each refresh pulls the latest Google Ads and Meta Ads data and every number and chart updates. Daily on Team and every 3 hours on Pro, with no copying and pasting.

Can I combine Google Ads and Meta Ads with other sources?

Yes. Connect Google Ads and Meta Ads alongside GA4, a CRM or a spreadsheet, join them in Mammoth, and build one dashboard across all of them, for example ad spend against the deals it produced.

Can I share it with clients?

Yes. Share a link or have it emailed on a schedule, and viewers are free on every plan. On the Mammoth Pro plan you can put your own logo and domain on it.

Is the data on this page real?

No. It is sample data for an invented brand, in the same columns a Google Ads and Meta Ads export uses. The dashboard itself is real: it was built in Mammoth, and you can open it live.