Cost per lead dashboard: report customers, not clicks

Most ad reports show clicks and impressions because that's what the platforms give you. The metrics a cost per lead dashboard needs, defined one by one, and how to build it from ad spend and CRM data.

On this page
  1. What does each metric on the dashboard mean?
  2. How do you build the dashboard?
  3. How do you read it without fooling yourself?
  4. Frequently asked questions

A cost per lead dashboard joins two sources: what you spent on Google and Meta, and what happened to each lead in your CRM. Its main page answers one question, what did a customer cost us from each channel, and every other number on it is there to explain that answer. Clicks, impressions and click-through rate belong on a second page for whoever runs the ads.

This guide is for owners, marketing managers and agencies who want a report that changes decisions. Most of the trouble with dashboards comes from metrics that sound the same but count different things, so I define each one before showing how to build the report.

What does each metric on the dashboard mean?

Each metric below says what it counts, where it comes from, and what you shouldn't trust about it. If two people in your business would define a metric differently, settle it in writing before you build anything.

Spend

The money paid to Google and Meta for the period, by campaign and day. It comes from Google Ads and Meta Ads Manager. It's the most reliable number on the page, but watch for tax: decide whether spend includes it and stay consistent.

Lead

A person who made contact: a form, a call, a WhatsApp chat. Count leads from your CRM, not from the ad platforms. Meta and Google each count leads by their own attribution rules and can both claim the same person, so the platform totals added together are usually higher than what your team received.

Qualified lead

A lead your team spoke to who fits what you sell. It comes from a CRM status, so it's only as good as the habit of updating that status. Don't trust this number if leads sit as "new" for days after being called.

Customer and revenue

A lead who bought, booked or signed, and what they paid. It comes from the CRM or your billing system. Don't trust revenue figures reported by the ad platforms for a lead business unless you upload real values from your CRM, for example through Google Ads offline conversion import.

Cost per lead, per qualified lead and per customer

Spend divided by each of the three counts above, for the same channel and period. Calculate them in the reporting tool, never by hand. Cost per lead is the one owners quote and the one I trust least, because it rewards cheap, unqualified enquiries.

Lead source

The channel and campaign a lead came from. It comes from UTM parameters on your ad links, saved into hidden form fields, or from Meta's own lead data for Instant Forms. If a form doesn't save the UTM values, every lead from it lands as "direct", and the ads get no credit.

Unknown source

Leads with no tracked source, and sometimes they're the best ones. Here's an illustrative case. Say a B2B software firm builds a dashboard and finds that 35% of last quarter's customers are marked "unknown". Digging in, most were people who saw an ad, didn't click, and later searched the company name or typed the address in. They arrived as direct or branded search, and the ads got no credit.

How I'd report that honestly:

  • Show "unknown" as its own line, never hidden or spread across channels.
  • Ask "How did you hear about us?" on the form or the first sales call, and record the answer next to the tracked source.
  • Watch the total: if branded searches and direct enquiries rise when ad spend rises and fall when it's paused, the ads are doing more than the tracked numbers show.
  • Judge channels mainly on what you can track, and use the self-reported answers as a check, not a replacement.

Median time to first contact

The middle value of the gap between a lead arriving and someone replying. It comes from CRM timestamps. Use the median rather than the average, because one lead left for a week drags the average up and hides how fast the typical reply is. The speed to lead playbook explains why it belongs on the owner's page.

Platform-reported conversions

What Google and Meta say happened, by their own attribution rules. Keep them on the second page, for the person managing bids. Don't use them as the count of leads or sales.

MetricComes fromDon't trust it when
SpendGoogle Ads, MetaTax is included in some rows and not others
LeadsCRMYou add up platform counts instead
Qualified leadsCRM statusStatuses are updated weekly, not daily
Customers and revenueCRM or billingThe platform reports it without uploaded values
Lead sourceUTMs, hidden fields, Meta lead dataForms drop the UTM values
Median time to first contactCRM timestampsCalls and chats aren't logged in the CRM

How do you build the dashboard?

Join daily spend by campaign with CRM leads by campaign, then calculate the cost metrics per channel and week. Each lead in the CRM must carry its source first, or there's nothing to join on.

  1. Make sure every form saves UTM values into hidden fields, and that Instant Form leads arrive with their campaign name.
  2. Pull daily spend by campaign from Google Ads and Meta, through connectors to a reporting tool or a scheduled export.
  3. Pull leads from the CRM with source, campaign, status and the dates of each status change.
  4. Join them by channel, campaign and week.
  5. Calculate cost per lead, per qualified lead and per customer in the tool.
  6. Break the results down by channel: Google Search, Performance Max, Meta lead forms, Meta website, WhatsApp. Put brand and non-brand Google campaigns on separate lines; the audit checklist explains why.

Google's Looker Studio is free and connects to Google Ads and Google Sheets directly; Meta data usually needs a connector or a scheduled export. For a small account, a shared spreadsheet updated weekly works too, as long as one named person owns it.

How do you read it without fooling yourself?

Count customers by the week the lead arrived, not the week they bought, and accept that recent weeks will fill in later. If your sales cycle is a month, last week's cost per customer will always look terrible, and it means nothing yet. I'd grey out the most recent weeks for exactly this reason.

Once the outcomes are in your CRM, send them back to the platforms as well, through the Meta Conversions API and Google's offline import, so the ads optimise towards the same numbers you report. The performance marketing guide covers that loop.

Frequently asked questions

Which tool should I use?

Looker Studio for most small businesses, a spreadsheet if there are only a few campaigns. The data matters far more than the tool.

How often should I review it?

Weekly for spend, leads and follow-up speed; monthly for cost per customer, since customers take time to close.

Disclosure: Cloudgramam builds reports like this for clients of our performance marketing services, so we have an interest here. Ad spend is paid to Google or Meta directly, and any reporting tool licences go to their vendors. Platform details were checked on 16 November 2026.

performance marketingmarketing dashboardcost per lead reportlooker studioad reporting

Gowtham D

Full Stack Digital Marketer and Full Stack Developer

Gowtham D is a full stack digital marketer and full stack developer, a Microsoft Power Platform developer, content writer and data analyst with 15 years of experience.

Gowtham D on LinkedIn

Ads measured to the sale

Google and Meta ads, tracking and fast lead follow-up, reported on customers and revenue.