A Campaign Report Template: Leads, Qualified, Customers by Campaign
A one-page Facebook ads report with spend, leads, qualified leads, customers, revenue and cost at each stage, by campaign. The columns, where each number comes from, and how to read it.
Written by Qualimize Team
Founder, Qualimize
- Published
- Last updated
- Reading time
- 10 min read
Table of contents
- 01 The short answer
- 02 The columns, in order
- 03 Where each number comes from
- 04 A filled-in example
- 05 How to read the report and decide
- 06 Choosing the date rule
- 07 Weekly, monthly, and for agency clients
Full article
The short answer
A useful Facebook ads campaign report has one row per campaign and columns for spend, leads, cost per lead, qualified leads, cost per qualified lead, customers, cost per customer, revenue and ROAS. Spend comes from Ads Manager; everything after leads comes from your CRM, joined on campaign ID.
That single page answers the question every business owner and agency client actually asks: which campaigns are bringing in customers, and what does each customer cost? Lead counts alone cannot answer it.
The columns, in order
Keep the columns in funnel order so the eye moves from cost to result. Each cost column sits right after the count it is based on.
- Campaign (name, with campaign ID in a hidden column for joining)
- Spend: Ads Manager amount spent in the period
- Leads: leads created in the period from this campaign
- Cost per lead: spend ÷ leads
- Qualified: leads that reached your qualified status
- Qualified rate: qualified ÷ leads
- Cost per qualified lead: spend ÷ qualified
- Customers: leads that reached your customer status
- Close rate: customers ÷ qualified
- Cost per customer: spend ÷ customers
- Revenue: sum of deal value for those customers
- ROAS: revenue ÷ spend
- Open: leads still in progress (so readers know the month is not finished)
Where each number comes from
Spend is the only number from Ads Manager. Export it by campaign for the same dates as your lead period, or pull it through Meta's Insights API if you automate the report. Everything else comes from your CRM: leads with their campaign tag, their current status, and deal value.
Join the two on campaign ID, not campaign name. Names get edited, and a renamed campaign will not match its old rows. Instant Form leads carry the campaign ID automatically; website leads carry it only if you added URL parameters to your ads.
Define 'Qualified' and 'Customer' once, in writing, as specific CRM statuses. If one rep marks a lead qualified after a friendly call and another only after a budget conversation, the qualified column means nothing.
A filled-in example
Example (illustrative numbers). A travel agency in Ahmedabad runs four Meta lead campaigns in October for holiday packages. The report, a few weeks after month end, looks like the first table below.
Read it from left to right. 'Goa weekend' has the cheapest leads but very few qualify. 'Kerala family' costs more per lead but turns more of them into bookings. 'Dubai visa + stay' has few customers but high deal values. 'Retargeting' is small and its leads are among the most expensive, but it has the best qualified rate (40%) and the lowest cost per customer (₹2,500), a reminder that cost per lead alone would have ranked it joint last.
How to read the report and decide
Look at cost per customer and ROAS first, then step backwards to find the cause. A campaign with a high cost per customer and a low qualified rate has a targeting or offer problem: it attracts the wrong people. A high cost per customer with a good qualified rate but a low close rate points at sales follow-up or price, not the ad.
Be careful with small numbers. Two customers versus three is not a trend. When a campaign has fewer than a handful of customers, use cost per qualified lead as the main signal and wait for more data before cutting it.
- Scale: cost per customer well under target, enough customers to trust it
- Fix the ad or audience: low qualified rate
- Fix follow-up or offer: good qualified rate, low close rate
- Wait: under a handful of customers, or many leads still open
- Pause: high cost per qualified lead for several weeks with no customers
Choosing the date rule
Use the date the lead was created for every count on the row. If October leads that buy in November are counted in November, your October cost per customer looks worse than it is and November's looks better. Grouping by lead date keeps each month's spend matched with the results it caused.
That means last month's row keeps changing as late deals close. The Open column tells readers how much is still in play. Re-send the report with updated figures rather than freezing an unfinished month.
Weekly, monthly, and for agency clients
Run a weekly version with only spend, leads, qualified and cost per qualified lead: these move fast enough to act on within a week. Run the full monthly version with customers, revenue and ROAS, re-sent until the month matures.
Agencies reporting to clients get the most value from this template, because it moves the conversation from 'we got you 400 leads' to 'these two campaigns produced customers at ₹3,000 each'. It needs the client's CRM data, so agree up front on who updates statuses and how quickly.
In Qualimize, analytics by campaign show cost per qualified lead next to cost per lead, and each workspace declares which statuses count as Qualified, Demo, Trial or Customer, so most of this report is available without a spreadsheet. A shared sheet with two exports works too, as long as the join is on campaign ID.
Comparison tables
Example report: Ahmedabad travel agency, October 2026 leads (illustrative numbers)
| Campaign | Spend | Leads | CPL | Qualified | CPQL | Customers | Cost per customer | Revenue | ROAS |
|---|---|---|---|---|---|---|---|---|---|
| Goa weekend | ₹40,000 | 320 | ₹125 | 32 | ₹1,250 | 4 | ₹10,000 | ₹1,20,000 | 3.0 |
| Kerala family | ₹40,000 | 200 | ₹200 | 50 | ₹800 | 10 | ₹4,000 | ₹4,50,000 | 11.3 |
| Dubai visa + stay | ₹30,000 | 120 | ₹250 | 24 | ₹1,250 | 4 | ₹7,500 | ₹3,20,000 | 10.7 |
| Retargeting | ₹10,000 | 40 | ₹250 | 16 | ₹625 | 4 | ₹2,500 | ₹1,40,000 | 14.0 |
| Total | ₹1,20,000 | 680 | ₹176 | 122 | ₹984 | 22 | ₹5,455 | ₹10,30,000 | 8.6 |
Weekly vs monthly version
| Version | Columns | Main question it answers | Decision it supports |
|---|---|---|---|
| Weekly | Spend, leads, CPL, qualified, CPQL | Are the leads any good? | Adjust creatives, audiences, forms |
| Monthly | All columns including customers, revenue, ROAS | Which campaigns make money? | Move budget between campaigns |
FAQ
What should a Facebook lead ads report include?
Per campaign: spend, leads, cost per lead, qualified leads, cost per qualified lead, customers, cost per customer, revenue and ROAS, plus how many leads are still open. Spend comes from Ads Manager; the rest comes from your CRM.
How do I combine Ads Manager data with CRM data?
Export spend by campaign from Ads Manager, export leads with their campaign ID, status and deal value from your CRM, and join the two on campaign ID. Avoid joining on campaign name, because names change.
How often should I report on Facebook ad campaigns?
Weekly for early signals (leads, qualified leads, cost per qualified lead) and monthly for customers, revenue and ROAS. Re-send the monthly report as late sales close, until the month stops changing.
What is cost per qualified lead?
Spend divided by the number of leads that reached your qualified status. It sits between cost per lead and cost per customer: faster than waiting for sales, but much closer to business value than lead count.
How should an agency report Meta lead ads to clients?
With campaign rows that run from spend to customers and revenue, using the client's CRM statuses. Agree in advance on who updates statuses, what counts as qualified, and which date rule to use, so the numbers are not disputed later.
Where does Qualimize fit?
Qualimize tags every Meta lead with its campaign, ad set and ad, lets each workspace declare its Qualified and Customer statuses, and shows cost per lead, cost per qualified lead and cost per customer by campaign. If your leads already live in another CRM with campaign tags, you can build the same report from two exports.
Key takeaways
- One row per campaign, columns in funnel order from spend to ROAS.
- Spend comes from Ads Manager; leads, qualified, customers and revenue come from the CRM.
- Join on campaign ID and count everything by lead created date.
- Diagnose backwards: low qualified rate means the ad, low close rate means follow-up or offer.
- Weekly for lead quality, monthly for customers and revenue.