top of page

Duplicate Leads: Count Unique Sales Opportunities Before Comparing Ads

Writer: DIGITALTHROB
DIGITALTHROB
Oct 31
5 min read

A second form, a follow-up call and a rescheduled appointment can make one project look like several new leads. In the example below, 90 reported rows become 60 confirmed sales opportunities and eight unresolved candidates. That changes the apparent $24 lead cost enough to stop a proposed spending increase.


To resolve duplicate leads in ad reporting, we need to identify the purchase opportunity behind each record. The goal is a count your sales team can explain, with repeat activity preserved and uncertain matches still visible. Then you can judge what the advertising money actually bought.


Clipped cream contact cards and separate coral cards sit beneath a magnifier, Count the Opportunity and the DIGITALTHROB wordmark.

Choose the sales opportunity you want to count


Agree what starts a new opportunity before matching names. For a renovation company, the unit might be one identifiable project at one property entering the sales process. Another message about that project adds history. A separate project from the same customer may start another opportunity.


This distinction matters in both directions. Two household members can contact you about one renovation. A facilities manager can request work at two properties. Counting contacts alone can overstate the first situation and understate the second.


Have the sales owner confirm the definition. Our guide to tracking qualified leads from Google Ads covers the later qualification and sales stages. Establish the distinct opportunities first so those stages have a reliable starting count.


Fix the dates and keep the original records


Use the opportunity's first inquiry date to decide which reporting group it belongs to. Set a cutoff for the review, too. A project opened last month stays in that earlier group when its appointment moves this month.


Build the review from submissions, calls and bookings you can trace to the underlying inquiry. Keep their original identifiers, source labels and timestamps beside the reviewed opportunity identifier. You can count linked activity together without deleting the history.


A dashboard total cannot establish which records concern the same project. Where a reported conversion has no reliable connection to a business record, label the gap. That is a separate question from whether two known inquiries belong together.


Reconcile a fictional 90-row lead report


This fictional teaching example is not client results or a benchmark.


A renovation company counts new opportunities first received October 1–14, reviewing the evidence through October 21. Its starting exports cover inquiry activity during those dates, including repeat contact. Advertising spend is $2,160. There are 50 Google rows and 40 Meta rows linked to inquiry records, producing the headline $24 cost per lead: $2,160 ÷ 90.


The reviewer explains 22 rows that should not add another new opportunity:


  • 12 repeat activity rows: forms and calls update opportunities already represented in the group.

  • Six cross-report rows: six opportunities appear in both exports. Each keeps both advertising claims and counts once in the business total.

  • Four earlier-opportunity rows: rebooked appointments belong to projects first received before October 1.


Each additional row receives one explanation. That prevents the reviewer from subtracting the same row as both repeat contact and cross-report overlap. The first reconciliation is 90 − 12 − 6 − 4 = 68 candidate records.


Now review those 68 candidates: 60 are confirmed distinct new opportunities, while eight still need an identity decision. The full record balances as 60 confirmed + eight unresolved + 22 explained additional or earlier rows = 90.


The 60 confirmed opportunities include 30 appearing only in Google, 24 only in Meta and six appearing in both. That is 60 opportunities with overlapping claims, not 66 separate opportunities. Keep the claims attached so the count does not erase the customer journey.


Resolve identities from the actual inquiry


In one review, a quote form and a later call carry the same project reference. The saved details and sales notes confirm the same renovation. The reviewer links the activity to that opportunity and retains the call in its history.


Another pair uses the same email address but describes different properties and separate work. The sales owner confirms two projects, so both remain separate opportunities. Matching a contact detail does not settle the business question.


A similar phone number or shared surname is a reason to check the original inquiry. If the evidence does not establish a match, keep the records apart and mark what remains unclear. The person handling the project can resolve its context; resemblance alone cannot.


Apply the same rule to rebookings. Moving an existing project's call to Friday changes its appointment record. Its first inquiry date and opportunity identity stay the same.


Keep unresolved matches visible in the cost


All $2,160 of advertising spend stays in the calculation. Counting the 60 confirmed unique opportunities gives $2,160 ÷ 60 = $36 per confirmed opportunity. Including all 68 candidates gives $2,160 ÷ 68 = $31.76 per candidate.


The difference is the eight unresolved records. If every one proves to be a separate new opportunity, the final count reaches 68 and the cost is $31.76. If none adds a new opportunity, the count stays at 60 and the cost is $36. Until the review settles them, show the range and its reason.


That uncertainty does not prevent every decision. This business uses a $30 review limit per new opportunity. Even the most favorable $31.76 outcome exceeds it. The campaign owner holds the proposed increase now; resolving the eight records will refine the number, but cannot bring this group below that limit.


Separate record counting from advertising credit


Counting an opportunity once does not require choosing which advertising report “wins.” Preserve the competing claims and examine their reporting rules separately. Our attribution window comparison guide explains how to interpret those differences.


Counting settings have their own scope. Google's conversion counting guidance describes “One” as one conversion per ad click for a conversion action. It does not establish a single project identity across your CRM and other advertising reports.


For channel comparisons, disclose how you assign sources. Giving each platform the same shared opportunities and presenting the resulting costs as exclusive acquisition figures would obscure the overlap again. Keep shared and unknown sources visible where the evidence cannot support an exclusive assignment.


Put the corrected count into a decision


The review closes with a usable answer: 90 starting rows, 22 explained additional or earlier rows, 60 confirmed opportunities and eight open questions. The proposed increase stays on hold. The sales owner resolves project identity, and the reporting owner updates the count while preserving the exports. The campaign owner then reviews the corrected costs and qualified outcomes.


Repeat this reconciliation when an inquiry or booking route changes. A cleaner count helps you spot where campaign performance needs attention. Qualification and actual sales still decide whether those opportunities are valuable.


Our paid advertising services connect campaign reporting with the opportunities your team recognizes. Bring a dated inquiry export and your opportunity definition to a strategy call. We can work through the repeated records, the open questions and the figures that should guide your next decision.


 
 
 

Comments


Discover clics solution for the efficient marketer
More clics

Never miss an update

bottom of page