Free ad templates
Enter spend, impressions, clicks, conversions and revenue for each campaign. The builder calculates CTR, CPC, CPM, CPA and ROAS for each row and in total, then lets you download a CSV for Google Sheets or Excel or copy a markdown table. It runs in your browser, so nothing you type is uploaded.
Free, runs in your browser. Nothing is uploaded.
A useful ad performance report template answers four questions: what did we spend, what did we get, what is working and what happens next. That takes a small set of inputs in a clear order: spend and results first, then efficiency metrics, then the creative or audience behind the winners and losers, then the plan.
Keep one row per unit you can act on. For a Meta ad campaign report template that usually means one row per ad set or ad, so the reader can see which creative carries the account. For a Google ad report template it often means campaign or ad group. The same layout also works as a social media ad report template, an ad spend report template or a Facebook ad campaign report template, because the maths underneath doesn't change.
All five come straight from your five inputs.
Read them as a chain. A low CTR points at the creative or the audience. A healthy CTR with a high CPA points at the landing page or the offer. A good ROAS only helps if it clears your break-even point, which you can find with the break-even ROAS calculator. For single metrics, use the CTR, CPC, CPM and ROAS calculators.
Use a weekly report for the team that runs the ads, and a monthly report for the person who pays for them. The weekly version is short and built around decisions: what to pause, what to scale, what to test next. The monthly version zooms out to trend, total spend against goal and what the month taught you.
Don't judge anything on one day of data. Ad platforms need time to settle after a launch or an edit, and small samples swing wildly. Report the same metrics in the same order every time, so the only thing the reader has to interpret is a change in the numbers. Tag your links with the UTM link builder so the traffic in your analytics matches the ads in your report.
Open with one sentence on the result against the goal, then give the table. After it, add three things the table can't say. What you learned: which angle, audience or format won, and why you think so. What you are changing: the creative to retire, the one to scale, the test that starts now. What you need: approvals, assets or budget.
Do not bury a bad number. If CPA rose, say so, give the likely cause, such as creative fatigue, and say what you will do about it. Clients handle a bad week far better than a surprise. For a deeper tracking sheet that stores campaign history, use the ad performance tracker.
At minimum: date range, spend, impressions, clicks, conversions, revenue, and the calculated CTR, CPC, CPM, CPA and ROAS, split by campaign or ad set. Add a short notes column for decisions.
Yes. The inputs and formulas are the same on any platform. Pull the numbers from Meta Ads Manager or Google Ads and enter them in the same columns.
Yes. You can download a CSV that opens in Google Sheets or Excel, or copy a markdown table. Your data stays in your browser.
No. A guardian ad litem report is a court document, not an advertising report. For that, ask the court or your jurisdiction for the required format. This page is for ad campaigns.
Keep going: LinkedIn Ad Template, YouTube Ad Template, Commercial Script Template, all ad templates, the Canva ad template library, and the ad hook bank.
Browse thousands of free Canva ad templates, then fill them with the copy from this page.