QualimizeQualimize
FeaturesHow it worksQualified leadsMeta CAPIComparePricingResourcesContact
LoginBook 1:1 Demo
QualimizeQualimize

The CRM for teams running Meta Ads. Capture every lead, record what your sales team finds, and send those outcomes back to Meta.

+91 94997 11011WhatsApp us

Address

Sama Savli Road, Vadodara,
Gujarat, 390008

Product

  • Features
  • Pricing
  • Product tour
  • How it works
  • Qualified leads
  • Meta CAPI
  • For agencies
  • Partner program

Industries

  • All industries
  • Real estate CRM
  • Travel CRM
  • Education CRM
  • Visa consultancy CRM
  • Healthcare CRM
  • Solar CRM
  • Marketing agencies

Compare

  • All comparisons
  • vs Zoho CRM
  • vs LeadSquared
  • vs TeleCRM
  • vs Privyr
  • vs GoHighLevel
  • vs HubSpot
  • vs Salesgem
  • vs FlowZo
  • LeadSquared alternatives
  • GoHighLevel alternatives
  • Privyr alternatives

Company

  • About
  • Contact
  • What's new
  • Pricing
  • Login

Legal

  • Security & data
  • Privacy policy
  • Terms of service
QualimizeQualimize

The CRM for teams running Meta Ads. Capture every lead, record what your sales team finds, and send those outcomes back to Meta.

+91 94997 11011WhatsApp us

Address

Sama Savli Road, Vadodara,
Gujarat, 390008

Product

  • Features
  • Pricing
  • Product tour
  • How it works
  • Qualified leads
  • Meta CAPI
  • For agencies
  • Partner program

Industries

  • All industries
  • Real estate CRM
  • Travel CRM
  • Education CRM
  • Visa consultancy CRM
  • Healthcare CRM
  • Solar CRM
  • Marketing agencies

Compare

  • All comparisons
  • vs Zoho CRM
  • vs LeadSquared
  • vs TeleCRM
  • vs Privyr
  • vs GoHighLevel
  • vs HubSpot
  • vs Salesgem
  • vs FlowZo
  • LeadSquared alternatives
  • GoHighLevel alternatives
  • Privyr alternatives

Company

  • About
  • Contact
  • What's new
  • Pricing
  • Login

Legal

  • Security & data
  • Privacy policy
  • Terms of service

© 2026 Qualimize. All rights reserved.

Better signals in. Better customers out.

Back to blog
Revenue & ROAS

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
November 16, 2026
Last updated
November 16, 2026
Reading time
10 min read
REVENUE & ROASCPLCPQLCACROASRetargetingKerala familyDubai visaGoa weekend

Table of contents

  1. 01 The short answer
  2. 02 The columns, in order
  3. 03 Where each number comes from
  4. 04 A filled-in example
  5. 05 How to read the report and decide
  6. 06 Choosing the date rule
  7. 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)

CampaignSpendLeadsCPLQualifiedCPQLCustomersCost per customerRevenueROAS
Goa weekend₹40,000320₹12532₹1,2504₹10,000₹1,20,0003.0
Kerala family₹40,000200₹20050₹80010₹4,000₹4,50,00011.3
Dubai visa + stay₹30,000120₹25024₹1,2504₹7,500₹3,20,00010.7
Retargeting₹10,00040₹25016₹6254₹2,500₹1,40,00014.0
Total₹1,20,000680₹176122₹98422₹5,455₹10,30,0008.6

Weekly vs monthly version

VersionColumnsMain question it answersDecision it supports
WeeklySpend, leads, CPL, qualified, CPQLAre the leads any good?Adjust creatives, audiences, forms
MonthlyAll columns including customers, revenue, ROASWhich 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.

Further reading

  • Meta: Marketing API Insights (spend by campaign, ad set and ad)
  • Meta: Retrieving lead ads leads

Keep reading

  • GuideCost per Lead vs Cost per Qualified Lead vs Cost per Customer
  • GuideWhich Ad Brought the Sale? Ad-Level Tracking with URL Parameters
  • GuideHow to get more qualified leads from Meta Ads
  • ProductHow Qualimize sends lead stages to Meta (CAPI)
  • ProductPricing: one plan, every feature
  • CompareCompare CRMs for Meta lead ads
Discuss Qualimize

Keep reading

Related articles

Revenue & ROAS

How to Calculate Cost per Customer from Facebook Ads

Qualimize keeps the campaign, ad set and ad on every Meta lead and lets each workspace mark which status counts as Customer, so cost per customer by campaign is a report rather than a spreadsheet job. Deal values are entered by hand on each lead. If you already have a CRM that keeps ad tags on leads and records sales on the same record, you can do the same calculation there.

Read next
Revenue & ROAS

How to Track Revenue from Facebook Lead Ads When the Sale Happens Offline

Qualimize captures Meta Instant Form leads with campaign, ad set and ad attached, stores a hand-entered deal value on each lead, reports by campaign, and sends status changes to Meta's Conversions API, including Purchase with the deal value. It does not claim support for Meta's Conversion Leads goal, and it does not sync with accounting tools, so the deal value is whatever the rep enters.

Read next
Revenue & ROAS

Which Ad Brought the Sale? Ad-Level Tracking with URL Parameters

Qualimize shows this exact parameter string in Settings → Marketing with a copy button, saves UTM parameters and fbclid on website leads posted to its webhook, and captures ad-level tags on Meta Instant Form leads automatically. You still need your landing page form to pass the values through.

Read next

Build a cleaner Meta Ads sales workflow

Qualimize helps you capture leads, qualify them faster, and connect CRM outcomes back to ad performance.

Book 1:1 Demo
20-minute walkthroughMeta CAPI built-inNo lock-in
See Plans & Pricing