Documentation

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.

For best results, export the same reporting period from your ad platform and CRM. Align campaign names and use a stable lead ID or contact email for matching.

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,Status
lead_001,Local Search,new
lead_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

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

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.

Open workspace ↗