Free tool
Google Ads And Meta Ads Report Template
Enter this month’s and last month’s totals from Google Ads or Meta Ads (Facebook and Instagram): the tool works out each KPI and its change, then lays out a monthly PPC report you can paste into an email or save as a PDF. Add what worked and what changes next month.
Google defines CTR as clicks divided by impressions, average CPC as the total cost of clicks divided by the number of clicks, cost per conversion as cost divided by conversions, and ROAS as conversion value divided by cost. Meta publishes the same divisions for ROAS (purchase value ÷ spend) and CPC (spend ÷ link clicks), and defines CPM as the average cost for 1,000 impressions.
Platform
This month and last month
MetricCostImpressionsClicksConversionsConversion value
Sample figures, made up: replace them with your account totals.Thousands separators and currency symbols are ignored. An empty field or a zero divisor shows “-”.The copy pastes a formatted table into an email or a document, and plain text anywhere else. For a PDF, pick “Save as PDF” in the print window.
Sources read on November 6, 2026: Google Ads API, metrics, Meta, Ads Insights and Metrics and Meta, Ad Account Insights.
Is Your Report Showing A Drop You Cannot Explain?
In the monthly management of your Google Ads and Meta Ads campaigns, I go through these numbers with you, find where the gap comes from and adjust the campaigns every month.
20 minutes · No commitment · 100% confidential
How the report metrics are calculated
Change = (month − previous month) ÷ previous month × 100
Each metric follows the platform’s definition: CTR = clicks ÷ impressions, average CPC = cost ÷ clicks, CPA = cost ÷ conversions, ROAS = value ÷ cost. ROAS shows as a multiple, then as a percentage: 4.00 (400 %) means $4 in value for every $1 spent. On Meta, CPM = amount spent ÷ impressions × 1,000. To see whether that ROAS covers your margin, compare it with your break-even ROAS.
With the sample figures, cost goes from $1,200 to $1,500: (1,500 − 1,200) ÷ 1,200 = +25 %. CPA moves from $30 to $31.25, or +4.2 %, and ROAS from 3.67 to 4.00, or +9.1 %.
When last month is zero, or a divisor is missing (no clicks, no conversions), the cell shows “-”: a change on a zero base cannot be calculated, and the tool does not make one up. The arrow shows the direction of the number, never a verdict: rising cost with rising ROAS is still good news.
What the report does for you every month
- The start-of-month client report: paste the table into your email and add two lines on what worked and what comes next. Your client gets the essentials without opening the ad account.
- One format for Google Ads and Meta Ads: switch platforms and the metrics take each one’s own names, so a Facebook Ads report and a Google Ads report read the same way. Your monthly marketing report stays consistent from one month to the next.
- A PDF for your records: printing keeps the report alone, without the rest of the page. You build a month-by-month history of your campaigns.
Frequently asked questions
Why does my conversion rate differ from Google Ads?
Google divides conversions by interactions: clicks for text and Shopping ads, views for video ads. The tool divides by clicks. On a Search or Shopping account the two figures match; with video campaigns, the interface figure moves away.
Which numbers should I use for Meta Ads?
Amount spent, impressions, link clicks, the results of your objective or purchases, and purchase value, for the whole month. CPC and ROAS then follow the formulas Meta publishes: amount spent ÷ link clicks, purchase value ÷ amount spent.
How do I get the report as a PDF?
Click “Print or PDF”, then pick “Save as PDF” as the printer. Only the report goes to print, in black on white.
Are my numbers sent anywhere?
No. The calculations and the layout happen in your browser: no figure, account name or comment leaves your device. Nothing is stored either: reload the page and the sample comes back.


