Can Marketo handle duplicate email addresses for different people? | Community
Skip to main content
Sarah_Samuels
New Participant
November 29, 2017
Question

Can Marketo handle duplicate email addresses for different people?

  • November 29, 2017
  • 3 replies
  • 15161 views

Hi all.  We have a database which includes family members who are using the same email address.

A few questions:

1. Can marketo cope with imported data for the same email address but with eg 3 different names?

2. Can marketo send separate emails to each record, e.g. the 3 different people at the same email address?

This doesn't impact us so much with newsletter comms, but for things like sending out unique discount codes it poses a problem as only one person is receiving their code.

thanks

Sarah

3 replies

New Participant
October 15, 2019

Hi Guys,

New to Marketo and apologies bringing this old thread back up.

Trying to follow @Sanford Whiteman‌ approach to send multiple emails to the same email address.

But for some reason in my Request Campaign step, no campaigns are appearing for me to assign against Request Campaign:

Am I missing a step before hand?

SanfordWhiteman
New Participant
October 15, 2019

Your campaign needs to be requestable: it needs to trigger on Campaign is Requested.

New Participant
October 15, 2019

Thanks Sanford!  Will give it another try

Veronica_Holme4
New Participant
January 21, 2018

Hi Sarah - Marketo has another workaround for both these scenarios.

a) If you want to import lists with duplicate email addresses you can ask Support to change your dedupe criteria for list import. Email address MUST be one of the criteria, but you can add one or more other criteria to it to refine the dedupe. To dedupe it must be an exact match for ALL criteria (there's not if this plus this type logic, it's not that smart)

Down side is ALL list imports from that point will use this extended criteria, so you have to be certain all your list imports follow the same scenario you've set up or you'll accidentally create a bunch of duplicate new leads. Talk to Marketo Support for more info on that since they have to set it up for you.

b) Sanford is 100% correct that the Send Email will only send to one email address. I've hit the exact same scenario as you with needing to send the unique promo codes, and instead of using the Request Campaign (which I always avoid if possible as it puts tremendous pressure on your Marketo system, plus I'm lazy and don't want to build too many campaigns!) many of us out here use this process within a single Smart Campaign flow:

Send Email

Wait Step (length depends on size of list)

Send Email (add Choice - If Not Sent Email is this email)

Wait Step

Send Email (add Choice - If Not Sent Email is this email)

Repeat as often as you need to cover all potential dupes.

However I will second Sanford's suggestion to read the post by John Mattos he linked to on the unexpected behaviour of deliberate duplicates in the system.

SanfordWhiteman
New Participant
January 22, 2018

If you want to import lists with duplicate email addresses you can ask Support to change your dedupe criteria for list import.

Yeah, that compound dedupe key option, while initially attractive, is one that I've seen fail miserably.  Working with a client right now who's wiping their entire Marketo instance and starting over because they made the misstep of having support enable this option. (What they should've done -- and will be doing going forward! -- was use API-based imports, deduping on a single custom field, their guaranteed-unique member ID.)

It's vanishingly rare for a business to have a consistently valid compound key including Email Address (as you mentioned). Usually if they think they do, they haven't thought through all the cases.

SanfordWhiteman
New Participant
November 30, 2017

Marketo, as a database, ​fully supports multiple records with the same Email Address. Email Address is not a unique identifier.

However, that is not the whole story because Email Address is still the only ​lookup key ​for most UI-based (as opposed to API-based) operations. Standard list imports, for example, will locate the target lead by its email address. (In contrast, API-based imports can be set to lookup on another key, like the built-in Lead ID or even a custom string field.) And a list import with 3 rows referring to a single email address will ​only ​ever update a single lead, continually updating its values. This post will shed more light on the logic.

Your example of sending separate emails is actually slightly different from the unique key vs. lookup key decision. It's principally to stop you from looking like a spammer. Marketo will only send to one email address per Send Email step. If you want to send to multiple qualified leads with the same address, then instead of calling Send Email directly, you can trigger a Request Campaign ​on another campaign that in turn uses ​Send Email. Such individual ​Request Campaigns ​can send to multiple leads that happen to have the same email address, since there is no batching-and-deduping.

December 4, 2017

Hi @Sanford Whiteman​ I found your suggestion of using Request Campaign really interesting. How would you manage personalization in this case? Use case I was thinking of is something like householding - where one family uses the same email address. I'm thinking you'd add filters and use custom fields, or would you pre-segment groups (e.g. mother, father, children based on age) using lists?

SanfordWhiteman
New Participant
December 4, 2017

Yep, having a Segmentation based on HouseholdRoleType is useful. One of my clients manages shared credit cards this way. You might be unlikely to send the same core email to kids (if email variants are wildly divergent, segments end up just being confusing) but you have the flexibility.