Get from CSV files to a reliable lead report.
TrueCPL is a lightweight reconciliation tool. You supply the data, review the mapping, and download a campaign-level outcome report. It does not connect to or modify Meta Ads, Google Ads or your CRM.
1. Prepare a lead export
A minimal CSV might contain columns named Lead ID, Campaign Name and Status. You can also include Email or Phone Number for matching. Headers can be mapped manually.
Lead ID,Campaign Name,Statuslead_001,Local Search,newlead_002,Social Inquiry,new
2. Optionally add CRM outcomes
Your CRM file may contain Lead ID,Status or email/phone and Status. Where matching identifiers are present, CRM outcomes replace the initial lead status for reporting.
Status categories
- Qualified: relevant prospect, interested, MQL / SQL.
- Booked: appointment or meeting scheduled.
- Won: sale or contract closed.
- Invalid: only statuses explicitly marked spam, fake, invalid, duplicate or wrong number.
- Unqualified: not a fit or not eligible.
- Uncontacted: no answer or not yet contacted. Not necessarily invalid.
- Pending: blank, new or unrecognized statuses.
Booked and won leads are included in the qualified total. Won is also included in booked. These are nested categories, not independent totals to be summed.
3. Optionally add ad spend
Provide Campaign Name,Amount Spent with nonnegative USD values. Spend rows can be combined by campaign. A spend campaign without matching leads remains in the table, not hidden.
4. Review the math
- Cost per lead: total imported spend ÷ unique leads.
- Cost per qualified lead: total imported spend ÷ qualified outcomes.
- Cost per booked outcome: total imported spend ÷ booked or won outcomes.
- Invalid rate: leads explicitly classified invalid ÷ unique leads.
A cost cannot be calculated when the required denominator is zero or when spend is missing. The tool shows a dash rather than suggesting that the cost is free.
5. Export and store a report
Export campaign totals as CSV, download a portable JSON snapshot, or print the summary. Only report aggregates are saved to this browser's local storage when you select Save. Your original CSV row data is not stored persistently by the site.
Important limitations
The tool provides reconciliation based on imported rows. It cannot verify whether a lead is fraudulent, detect invalid phone numbers, guarantee platform refunds, prove revenue attribution, or automatically adjust advertising campaigns. Matching is identifier-based and should be checked when multiple contacts share an email or phone number.