[Paid Media](/categories/paid-media) November 8, 2026

# PPC report template: what to include, free download

A free PPC report template in Excel and CSV: campaign metrics across ad platforms, the summary to write, and the tracking checks that make ROAS true.

![](/images/65d75b0ae8d69ef95785a5d6_david-pombar.webp)

**[David Pombar](/author/david-pombar)** Swiss army knife at Trackingplan

3 min read · 605 words

A PPC report answers two questions. Where did the money go, and did it work?

The second one is harder than it looks. Every platform reports its own conversions, and none of them knows what your site actually recorded.

This template puts both side by side.

**[Download the PPC report template (Excel)](/downloads/ppc-report-template.xlsx)** or [the CSV](/downloads/ppc-report-template.csv). The Excel file has three sheets: Campaigns, Summary and Tracking checks.

## What the template includes

### Campaigns

One row per campaign, the same columns for every platform:

| Column | Why it is there |
| --- | --- |
| Spend, impressions, clicks | What you bought |
| CTR, CPC | Whether the ads earn the click, and at what price |
| Conversions (platform) | What Google Ads, Meta or TikTok says happened |
| Conversions (site) | What your site recorded for the same campaign |
| Gap | The difference between the two |
| Conversion value, CPA, ROAS | What it was worth |
| Change vs previous period | What moved |

The rows start with Google Ads, Meta Ads, Microsoft Ads, LinkedIn Ads and TikTok Ads, and end in a total. Add the platforms you run and delete the rest.

### Summary

Four lines: the headline, what changed, why, and what happens next. "ROAS fell from 4.1 to 3.2 because the new Performance Max campaign took 40% of spend and its conversions are not reaching the site" tells the reader what to do. A table alone does not.

### Tracking checks

Eight checks to run before you trust the ROAS column:

1.  Auto-tagging is on.
2.  Click IDs (gclid, fbclid, ttclid) reach the site and survive redirects.
3.  Every ad has UTMs.
4.  UTM naming follows one convention across platforms.
5.  Platform conversions match the site's conversions.
6.  Conversion values are right: value, currency, tax and shipping.
7.  Pixel and server-side events are deduplicated.
8.  No ad pixel fires before consent where consent is required.

Each has a column for how to verify it, its status and its owner. The [PPC audit checklist](/blog/ppc-audit-checklist) explains each one in depth.

## Read the gap column first

Platforms optimize on the conversions they see. If Meta counts 240 purchases and your site recorded 180, the bidding is learning from 60 that may not exist, and the ROAS in the report is wrong in the same direction.

A gap is not always an error: each platform has its own conversion window and attribution rules. What matters is the change. A gap that was 5% last month and 25% this month is a tracking problem until proven otherwise.

## Weekly for the team, monthly for the client

-   **Weekly**: campaigns and the gap column, for the people who change bids and budgets. Look for what moved.
-   **Monthly**: the summary sheet on top, totals by platform, and the tracking checks, for leadership or the client.

For the whole marketing picture, traffic, SEO and email included, the [marketing report template](/blog/marketing-report-template) uses the same structure. And if you are choosing a tool to build it, [SEM reporting tools](/blog/sem-reporting-tools) compares eight.

## Automate the report, keep the judgment

Filling this template by hand means exporting from each ad platform, matching campaigns to your analytics and checking the tracking yourself, every week.

Trackingplan does the reading. It pulls spend, impressions, clicks, CTR, CPC, conversions, value and ROAS from [eleven ad platforms](/changelog/spend-from-eleven-ad-platforms), sets them against what your pixels captured, and flags the gaps: clicks without UTMs, conversions the platform counts and the site never sent, campaigns that spend and bring no traffic.

[Trackingplan reports](/landings/reports) turn that into the PPC report: written, with the charts, scheduled daily, weekly or monthly, and sent by email, in Slack or Teams, or as a link. Agencies send it to each client with their own logo. You still read it and add your call before it goes out.

On this page

1.  [*01*What the template includes](#what-the-template-includes)
2.  [*02*Read the gap column first](#read-the-gap-column-first)
3.  [*03*Weekly for the team, monthly for the client](#weekly-for-the-team-monthly-for-the-client)
4.  [*04*Automate the report, keep the judgment](#automate-the-report-keep-the-judgment)

**Stop babysitting tags**

Trackingplan audits your real user data around the clock and flags issues before they cost you.

[Start free trial →](https://app.trackingplan.com/signup)

![](/images/65d75b0ae8d69ef95785a5d6_david-pombar.webp)

**David Pombar** Swiss army knife at Trackingplan

Read more from David, a Senior Product Strategist with 18+ years in digital product development and an atypical error detection knack.

Share Copy link [LinkedIn](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fwww.trackingplan.com%2Fblog%2Fppc-report-template) [X](https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.trackingplan.com%2Fblog%2Fppc-report-template&text=PPC%20report%20template%3A%20what%20to%20include%2C%20free%20download)

Read next

[All Blog →](/blog)

-   [
    
    3 minMarketing MeasurementNovember 8, 2026
    
    ### Marketing report template: free weekly and monthly
    
    A free marketing report template in Excel and CSV: the sections a weekly or monthly report needs, what to write in each, and how to stop rebuilding it.
    
    by **David Pombar**](/blog/marketing-report-template)
-   [
    
    7 minMarketing MeasurementOctober 28, 2026
    
    ### SEM reporting tools: what to report and 8 tools to do it
    
    What an SEM report should include, the SEM and PPC reporting tools that build it, and the check most of them skip: whether the conversions are true.
    
    by **David Pombar**](/blog/sem-reporting-tools)
-   [
    
    28 minPaid MediaApril 9, 2026
    
    ### PPC audit checklist: the 10 points that break campaigns
    
    Our 10-point PPC audit checklist covers tracking, pixels, PII and more. Go beyond settings to find what is really breaking your campaigns and fix it fast.
    
    by **David Pombar**](/blog/ppc-audit-checklist)

Trackingplan

## See everything. Miss nothing.

Your implementations audited around the clock with real-time, real-user data. Real-time alerts about errors or changes in your data, campaigns, pixels, privacy and consent. Let AI flag issues before they cost you.

[Start free trial →](https://app.trackingplan.com/signup) [Book a demo](/demo)