Quick answer
Avoid double counting by separating a contact from an opportunity. Give each person one contact record, link their calls and form submissions to a single opportunity, capture the source with evidence, and write a duplicate rule with a named owner who decides exceptions, such as two people sharing a phone number.
- A contact is a person and an opportunity is potential work; one request should usually produce one opportunity.
- Record source evidence on each interaction, such as a tracked link, and record unknowns instead of guessing.
- Write a duplicate rule, name an owner for exceptions and review the rules after a month.
When one customer calls twice and submits a form, reports can show three leads. This article shows how to connect phone enquiries to marketing reports without double counting by separating contacts from opportunities, capturing source and setting reconciliation rules. It is written for small business sales and marketing managers and ends with the decision, owner and next step to record.
An illustrative scenario
This is a hypothetical example, not a Web Design Davao client case.
Situation. The same customer calls twice and submits a form, creating three entries in the report.
What happens. A customer calls twice and also fills in a form, producing three entries. The business assigns one contact record to the person, links the interactions to a single opportunity and writes a duplicate rule that says same phone number and name within a set period are merged, with the named owner deciding exceptions.
Contact versus opportunity
Distinguish a contact from an opportunity. A contact is a person; an opportunity is a potential piece of work. Use the contact record and opportunity identifier fields. One person can have many interactions but should usually produce one opportunity for the same request.
Source capture
Capture the source on each interaction where possible, with the evidence that supports it, such as a tracked link or what the caller said. Use the source evidence field. Attribution is imperfect, so record unknowns instead of guessing.
Reconciliation rules
Write reconciliation rules: when two entries are the same, who decides and how exceptions are handled. Use the duplicate rule, owner and exception fields. Examples of exceptions include two people sharing a phone number. Review the rules after a month.
Deduplication rule sheet
Use this at the point described above. The workflow owner completes it and a named reviewer checks it. A completed row shows that the information, owner and next step are recorded; it does not prove the outcome. Keep it somewhere the team can edit, and keep it free of passwords, tokens and real client records.
Blank copy
| Contact record | Opportunity identifier | Source evidence | Duplicate rule | Owner | Exception |
|---|---|---|---|---|---|
Illustrative completed row (hypothetical)
| Contact record | Opportunity identifier | Source evidence | Duplicate rule | Owner | Exception |
|---|---|---|---|---|---|
| Customer record A | Opportunity 1 | Phone call and form submission | Same phone number and name within the set period (business to define) | Sales coordinator | Different people sharing a phone |
Working through the completed row
The row links one customer record to one opportunity, from a phone call and a form on the same number and name within the business’s set period. The exception noted is two people sharing a phone number, which the sales coordinator decides.
Common mistakes
- Treating every interaction as a new lead.
- Merging records without a written rule.
- Having no owner for exceptions.
Questions to settle before you rely on it
- How do phone calls get recorded today?
- What is your rule when a caller also filled in a form?
- Who decides the exceptions?
How you know it is complete
The sheet is complete when each rule has an owner, evidence and an exception route. Record who reviewed it and the date.
Where you may not have the answer
Records conflict. The named owner decides and records the reason. The handoff, not a guess, is the correct next step.
Your next action
Find one customer with several entries and trace them to one opportunity.
Ask Web Design Davao to review this workflow and scope the website or marketing support required. Digital marketing & SEO arrangements are agreed individually; nothing here assumes a particular service, role or timing is already available.
How Web Design Davao works
- Enquiries are generally answered within four hours during support hours (Monday to Friday, business hours), with after-hours help for emergency requests. Scope is agreed individually.
Frequently asked questions
What is the difference between a contact and an opportunity?
A contact is a person; an opportunity is a potential piece of work. One person can have many interactions, such as two calls and a form, but should usually produce one opportunity for the same request, so reports count one enquiry rather than three.
How should we record where an enquiry came from?
Capture the source on each interaction where possible, with the evidence behind it, such as a tracked link or what the caller said. Attribution is imperfect, so record unknowns instead of guessing. A named owner should decide when records conflict.
When should two entries be merged?
Merge them under a written duplicate rule, for example the same phone number and name within a set period that the business defines. Name an owner for exceptions, such as two people sharing a phone number, and review the rule after a month.