Primary Key to Change | Community
Skip to main content
J
Jay00031987-2
New Participant
March 2, 2022
Solved

Primary Key to Change

  • March 2, 2022
  • 1 reply
  • 3826 views

In Marketo, currently "Email" is the default primary key field, however is there a way to swap that along with another field to define a new primary key? Does Adobe Marketo support help here?

 

Can it also be done for new as well as old both type Marketo Account?

 

Also, will there any issue happen like native integration for Facebook, LinkedIn lead generation where user fill out form and email address match merge happened with email primary key? 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Darshil_Shah1

Not essentially, I mean you can request support team to enable the secondary custom dedupe criteria for the particular source type say list import/form fill, etc. Whatever you choose, it then applies to all leads that come in through that method. Also, It must be an EXACT match. (For instance, if I chose email address and first name as my criteria, it looks at the EXACT name and email for deduping. If that first name was ever missing, a new lead would be created for that record), Lastly, one of the secondary dedupe criteria must be the email address. The other (or multiple) can be anything you want, a standard or custom field. Your primary dedupe criteria then will apply to all the other source types, i.e., for the source types for which you do not have the secondary dedupe set. While at first this may seem solution most of your problems, if not all, but trust me this when enabled w/o proper strategy and plan to organize/maintain your DB would eventually turn in a headache down the line.

1 reply

Darshil_Shah1
Darshil_Shah1
Community Manager
March 2, 2022

Email Address is not the Primary key, rather it is the default dedupe field set in Marketo (FYR, Lead id is the primary key of the Marketo's db). You can change the dedupe field in Marketo by requesting support as this isn't something you can change on the front end of Marketo. IMO having people with same email address in Marketo's db is something I feel like will be a constant headache to manage. Hope this helps.

    J
    Jay00031987-2Author
    New Participant
    March 3, 2022

    So, if dedupe key is changed from email address then will it also affect fills out form, Facebook and LinkedIn integration for dedupe data based on email address?

    Jay
    Darshil_Shah1
    Darshil_Shah1Accepted solution
    Community Manager
    March 3, 2022

    Not essentially, I mean you can request support team to enable the secondary custom dedupe criteria for the particular source type say list import/form fill, etc. Whatever you choose, it then applies to all leads that come in through that method. Also, It must be an EXACT match. (For instance, if I chose email address and first name as my criteria, it looks at the EXACT name and email for deduping. If that first name was ever missing, a new lead would be created for that record), Lastly, one of the secondary dedupe criteria must be the email address. The other (or multiple) can be anything you want, a standard or custom field. Your primary dedupe criteria then will apply to all the other source types, i.e., for the source types for which you do not have the secondary dedupe set. While at first this may seem solution most of your problems, if not all, but trust me this when enabled w/o proper strategy and plan to organize/maintain your DB would eventually turn in a headache down the line.

      Terms & ConditionsAccessibility statement

      Loading footer...