Which Leads Became Customers? Connecting Ad Reports with Sales Follow-Up

An enquiry arrives through an ad. Sales sends a quotation. The buyer later orders by phone or WhatsApp. Unless those events are linked, the team cannot reliably answer: which leads became customers?

Lead quality tracking for Indian businesses should be a shared operating process, not just an advertising dashboard. It should distinguish four things: whether an enquiry was genuine, whether it received follow-up, whether it qualified, and whether it produced a verified customer.

Use the following framework as an adaptable starting point for a spreadsheet or CRM. Agree on definitions before automating reports.

1. Give every buying requirement a stable identity

Assign a permanent internal lead ID to each distinct enquiry or buying requirement. Link subsequent interactions to that record rather than automatically counting every form submission, call and WhatsApp message as a new lead.

Maintain three separate identifiers:

• Lead ID: the enquiry or buying requirement being followed up.
• Contact/customer ID: the person or organisation behind it.
• Deal/order ID: the commercial transaction that may result.

Agree whether a customer means an individual or an organisation. Apply that rule consistently when identifying first-time customers. An existing customer's new requirement may create a new opportunity, but not a new customer.

Use phone and email as matching aids, not automatic proof of identity. Review ambiguous matches before merging. Preserve duplicate records with a link to the retained record, then exclude them from unique-lead counts. This keeps the original enquiry total reconcilable.

2. Build one shared lead register

The register should show where each lead came from, what happened next and what supports its outcome.

Preserve the original source when recording later interactions. A prospect who submits an ad form and later calls should retain the original acquisition record; log the call as another touchpoint.

Use unknown source when attribution cannot be established. Do not guess a campaign assignment to make the report look complete.

Restrict personal-data access to people who need it. Marketing reviews can use lead IDs and structured outcomes without circulating every buyer's contact details.

3. Define stages using observable evidence

A stage should describe something that happened, not a salesperson's impression.

Keep rejected enquiries and deferred requirements distinct from lost opportunities.

Qualification should reflect the business. Hypothetically, a machinery supplier might require confirmation of the purchase process, while an installation service might need a serviceable PIN code and feasible installation date.

Define won in writing: an accepted purchase order, signed agreement or receipt of an agreed payment, for example. Track payment separately unless payment is the chosen win criterion. Keep cancellations and refunds visible.

A quotation, positive conversation or platform-reported conversion is not automatically a customer. Check the event behind the conversion label before calling it a sale. Google Ads’ qualified- and converted-lead reference is a background resource for that check; your reporting must still reflect your configured milestone.

Preserve stage history rather than overwriting the only evidence of progress.

4. Separate lead-quality problems from follow-up problems

“Poor lead” is too broad to guide a decision. Use distinct classifications:

Require a reason and brief evidence note when rejecting or closing a record. Allow unknown rather than forcing an unsupported explanation.

An uncontacted prospect has unknown quality, not proven poor quality. An unreachable lead is not necessarily an invalid contact. A deferred lead needs a revisit date rather than an indefinite place in the active pipeline.

5. Agree on a workable follow-up standard

Document four responsibilities:

1. Assignment: who allocates leads and covers absences?
2. First attempt: what target applies within staffed hours, including enquiries received overnight or on holidays?
3. Attempt schedule: which channels and intervals suit customer preferences and team capacity?
4. Escalation: who receives overdue records, and when can a lead be reassigned or marked unreachable?

Choose a standard the team can staff, measure and review. Do not present an arbitrary response-time target as a proven benchmark.

Keep first attempt and first successful contact as separate timestamps. Sending a message is not the same as connecting with a buyer. Every active record should have an owner, next action and due date.

6. Report outcomes using matching cohorts and denominators

A lead-created cohort is the set of leads first recorded during a defined period. Follow that same set through qualification and sales, even when orders arrive later.

For each cohort and source, show raw enquiries, duplicate exclusions, unique leads, attempted contacts, successful connections, qualified leads, opportunities and verified wins. Report first-time customers and repeat-customer orders separately.

Use explicit formulas:

• Attempt coverage: unique leads with at least one attempt ÷ unique leads.
• Connection rate: unique leads with successful contact ÷ unique leads.
• Qualification rate: qualified leads ÷ unique leads.
• Lead-to-customer rate: unique leads credited with producing a first-time customer ÷ unique leads.
• Cost per qualified lead: corresponding acquisition spend ÷ qualified leads from that source and cohort.

For progression counts, include leads that reached a stage by the reporting date—not just those currently sitting in it. A won lead should not disappear from the cohort's qualified-lead count. Show current pipeline status separately.

Where several leads relate to one first-time customer, assign acquisition credit once under an agreed rule. Retain contributing interactions without creating extra customers. If no leads qualify, show cost per qualified lead as not calculable, not zero.

Hypothetical example: a prospect enquires in June and places an accepted order in August. The win updates the June acquisition cohort and appears in August's sales-activity report. Dividing it by August's new enquiries would mix different groups.

Mark recent cohorts as provisional and revisit older ones after an interval appropriate to the sales cycle. Keep this week's calls, quotations and wins separate from acquisition-cohort performance.

7. Make the weekly review produce decisions

Use this suggested 30-minute marketing-sales agenda:

Marketing should own source completeness; sales should own follow-up and outcome updates. A designated reviewer should resolve disputed classifications against the agreed rules.

Use patterns to choose the next action:

• Low qualification despite adequate follow-up: investigate targeting, offer fit and rejection evidence before changing budgets.
• Low attempt coverage: fix assignment or capacity before judging lead quality.
• Qualified opportunities lost over delivery constraints: involve operations rather than assuming different ads will solve the problem.

Once records are dependable, assess whether selected offline outcomes should feed back into advertising systems. Use Google Ads’ offline-conversion reference as a starting point for implementation checks. Verify current technical and data-sharing requirements; do not assume every sale can be matched to an ad.

*Source note: the supplied platform references are background material and were not independently verified for this article. The register, stages and review cadence above are recommendations, not documented performance results.*

Start with one lead-created cohort: link its records, check follow-up evidence and verify its commercial outcomes together. Use that review to agree on definitions before expanding the reporting system.