Free ad tool
Type one row per campaign: spend, impressions, clicks, conversions and revenue. The report builder works out CTR, CPC, CPM, CPA and ROAS for each row and for the total, under the title you give it. Download a CSV or copy a markdown table into your client email, deck or doc. It is free and runs in your browser.
Free, runs in your browser. Nothing is uploaded.
It handles the maths and the formatting. CTR is clicks divided by impressions, CPC is spend divided by clicks, CPM is spend per 1,000 impressions, CPA is spend divided by conversions and ROAS is revenue divided by spend. The total row adds up the raw numbers first and then calculates the rates, so the total CPA is real rather than an average of averages.
It does not connect to Facebook. You type the numbers in or paste them field by field from your export. To get them, open Ads Manager, set the date range, choose the columns and use Export table data. This page is the tool. For a written structure around the numbers, the ad performance report template runs the same builder inside a template.
A client will read a two-minute report. They may never open a dashboard. Cover these, in this order:
Lead with the result. CTR and CPM go lower down: they explain the result, but no client buys clicks.
One row per campaign suits a monthly client report. One row per ad set shows which audiences carry the account. One row per ad answers the creative question of which ads to keep and which to replace. Keep the same level month to month so the numbers compare.
When an ad's CPA climbs month after month, creative fatigue is a common cause. Our guide to Facebook ad creative fatigue covers the signs, and the ad analysis tool helps you work out why a winning ad won before you brief the replacement.
Paid Facebook ads reporting software pulls data in automatically, schedules emails and builds dashboards across many accounts. If you report on many clients every week, that saves real time. For one account, a monthly summary or a pitch, a free ad reporting tool that formats the numbers is enough, and the best Facebook ads reporting tool is whichever one your client will read. For the week-to-week log between reports, use the ad performance tracker, and check ROAS targets with the ROAS calculator.
No. You enter the numbers yourself, and nothing is uploaded. Export them from Ads Manager first, then type them in.
Spend, impressions, clicks, conversions and revenue, plus CTR, CPC, CPM, CPA and ROAS for each row and the total.
Yes. Download it as a CSV for Excel or Google Sheets, or copy it as a markdown table for a doc, Notion page or email.
Yes. The maths is the same for any platform that reports spend, impressions, clicks, conversions and revenue.
Keep going: Facebook Ad Cost Calculator, Facebook Lead Ads Testing Tool, AI Facebook Ad Generator, all free ad tools, the ad hook bank, and 3,000+ free Canva ad templates.
Take the angles you spotted into the AI Ad-Making Kit, or start with the free hook and copy tools.