Blog
Team Collaboration

How duplicate contacts skew marketing attribution

8
min read
A path of contact records leading to a marketing goal flag

Table of contents

Talk to sales
Try for free
View as Markdown

TL;DR

  • Duplicate contacts split a person's touchpoints, so attribution can credit the wrong campaign or channel.
  • One person on two contact records can receive the same marketing email twice.
  • An unsubscribe saved on one duplicate record may not apply to the other record.
  • Before merging, decide which value wins in the fields marketing reports depend on.
  • Dedupely finds duplicate marketing contacts and merges them with the values your team chooses.

Marketing brings a large share of the people in a CRM. Forms, events, webinars, ads, lists and integrations all add contacts, and many of them are people you already have.

Each new record looks harmless on its own. Together, they split one person's history across records, and the reports marketing relies on start to drift. Attribution can credit the wrong campaign, the same person gets the same newsletter twice, and segments miss people they should include.

In this post, you'll see what duplicates break for marketing and where they come from. You'll also see which values to protect when you merge, and how to stay clean.

Attribution is the first thing duplicates break

Attribution depends on one record holding a person's full path, from the first touch to the conversion. When that person exists twice, the path is split in two.

The first record holds the original source, say an organic search visit two years ago. The second record holds a webinar sign-up and the demo request that followed. Reports read the second record as a new contact, so the webinar gets credit for a lead you already had.

The effects show up in a few places:

  • Wrong original source: a returning person is counted as new, under the channel that brought them back.
  • Undercounted influence: campaigns that touched the first record lose credit for the conversion on the second.
  • Inflated new-contact numbers: each duplicate looks like growth in reports on new contacts.
  • Lower conversion rates: one person can count as one converted contact and one that never converted.

Budget decisions follow attribution. When a channel gets credit for people it didn't bring in, spend moves toward it.

The result depends on how your CRM assigns sources and calculates attribution. Check a known customer's activity history in the report before assuming a merge changes campaign credit.

The same person, more than one email

The second pain is the one customers see. When a person sits on two contact records, both records can land in the same send, and the person gets the same email twice.

It gets worse with nurture sequences. Two records can enter one sequence at different steps, so the person gets two versions of the story in one week. One record may also be marked as a customer while the other still gets prospect emails.

Subscription status needs the most care. If someone unsubscribes from one record, the other record may still be subscribed. The person then keeps hearing from you after asking you to stop.

Segments, scores and lists drift

Segments filter on fields and activity. When a person's activity is split across two records, neither record may meet the filter, so the person drops out of the segment.

Engagement-based scoring has the same problem. Clicks and visits on one record and a form fill on the other add up to two lukewarm contacts instead of one warm one.

Contact counts also grow without new people, and duplicates can raise your CRM bill long before anyone counts them.

Where marketing duplicates come from

Causes vary by team and stack, so check which of these apply to yours.

Source How it creates duplicates Where to look first
Web forms A person fills in a form with a different email, or the form tool creates a new contact on each submission Same name and company, different email
Event and webinar lists Attendee lists are imported with missing emails, merged name columns or other formats Contacts created on the import date
Purchased or partner lists Lists include people already in your CRM, often with an older email Same name and phone, different email
Marketing integrations Ad platforms, chat tools or email tools create contacts instead of updating them Contacts created by one integration in a short time
Personal and work emails The same person signs up once with each address Same first and last name, plus phone or company name

Forms and lists are common sources, and each has its own fixes. See why web forms create duplicate contacts and how event and purchased lists create CRM duplicates.

What counts as a duplicate in a marketing database

What counts as a duplicate is case by case. What one marketing team considers a duplicate, another may not.

  • Work and personal email: some teams want one record per person. Others keep both because each address gets different emails.
  • Shared inboxes: info@ or marketing@ addresses can belong to several people, so a match on email alone can join different contacts.
  • Someone who changed jobs: a new email at a new company may be the same person, or a new contact for that account.

Agree on these with sales before you merge, since both teams use the same contact records. Then start with the obvious duplicates: contacts that share the exact same email.

Which values to keep when you merge

A merge decides which value survives in each field. For marketing, a few fields matter more than the rest, and the right choice depends on how your team reports. Merging without losing data starts with these decisions.

Field A common choice Why
Original source The value from the oldest record It shows how the person first found you
Lifecycle stage The most advanced stage A customer shouldn't go back to being a lead
Subscription or opt-out status Case by case It depends on your consent rules and how your CRM stores opt-outs
Email The address with recent engagement It's the address the person reads
Campaign or list membership Keep all of them Each one is part of the person's history

Opt-out fields need a decision for each case. Check how your CRM handles subscription and consent fields when records merge. Some fields are read-only or managed by the email tool.

Keep the marketing database clean

New campaigns keep adding contacts, so a single cleanup won't hold. A few habits help:

  • Check each event or purchased list for duplicates before it goes into the CRM.
  • Look at contacts created by each integration after you connect it or change its settings.
  • Review duplicates before big sends and before attribution reports go to leadership.
  • Reject a match only when you're certain it isn't a duplicate, since rejected matches won't come back.

How often to check depends on how many contacts you add. How often to deduplicate your CRM covers that in detail.

How Dedupely helps marketing teams keep one record per person

Dedupely finds possible duplicate contacts, including people with different emails. Set merge rules for source, lifecycle stage and email, then preview the result. Supported activities and associations move to the surviving contact; check your CRM's handling of subscriptions and campaign membership before a bulk merge.

Find the duplicate contacts in your marketing database

Clean contacts make marketing numbers believable

Marketing feels duplicates first in attribution, then in the inbox. A person split across records can credit the wrong campaign, gets the same email twice and may keep hearing from you after unsubscribing.

The fix starts with agreeing on what a duplicate is, merging the obvious ones first and protecting the fields your reports depend on. With one record per person, attribution, segments and contact counts describe the people you reach.

Frequently asked questions

How do duplicate contacts affect marketing attribution?

They split one person's touchpoints across two records, with the original source on one and the conversion on the other. Reports then credit the campaign that brought the person back instead of the one that found them. New-contact numbers go up and conversion rates go down, and budget can follow the wrong channel.

Why does the same person get my marketing email twice?

Often because the person exists on two contact records, sometimes with two email addresses. Both records match the list or segment, so both get the send, and both can enter one nurture sequence. Merging the records stops the double sends and keeps engagement on one contact.

What happens to unsubscribes when duplicate contacts are merged?

It depends on the case, your CRM and how the merge handles subscription fields. Before merging, check which value survives for opt-out and consent fields, since some are managed by the email tool. Decide the rule with whoever owns consent on your team.

Should marketing merge a contact's work and personal email records?

It depends on how your team markets. Some teams want one record per person with both addresses stored, while others keep both records because each address gets different content. Decide with sales, since you share the records, and apply the same rule to every match of this kind.

How often should marketing teams deduplicate contacts?

Check whenever a large list or a new integration adds contacts, and on a regular schedule in between. If contacts arrive daily, a weekly review can be a good starting point. Also review before big sends and before attribution reports go to leadership, since mistakes there reach customers and budget decisions.

Portrait of Gaby Salinas

Behind the article

Gaby Salinas

Marketing Assistant at Dedupely

Gaby Salinas came to CRM data from marketing and advertising, so she looks at duplicates from two sides: the match and merge logic behind them, and what they do to the people using the CRM, like the rep who calls a customer twice, the admin who gets blamed and the cleanup nobody wants to start.

As Marketing Assistant at Dedupely, she follows how RevOps teams, end users, consultants and technical teams actually work with their data: the records they stop trusting, the workarounds they build and the moment they finally decide to clean up. What she finds shapes most of what Dedupely publishes.

Connect with Gaby on LinkedIn

Contact us

We’d be happy to help you get this set up.

Write us a message

We probably know the answer to your question already

Email copied to your clipboard!

Book a Zoom

Whether you’re getting started or getting intense.
Get in touch!

Get started for free

20 free trial merges and as much free support as you need to get your duplicates under control.

"Great support. They are on top of things, and answer questions very quickly."

Larry D

Pipedrive User

Pipedrive MarketplacePipedrive Marketplace

Running CRM cleanup for clients? See the Partner Program

Skip to content