deduplication by a field item other than email address | Community
Skip to main content
A
Anonymous
December 17, 2014
Solved

deduplication by a field item other than email address

  • December 17, 2014
  • 4 replies
  • 2097 views
Hi

I'm thinking to automatically transfer lead data of Wordpress to Marketo. The point is the data of Wordpress is managed by ID name, not by email address, which I understand, is the only unique in Marketo. I want to put in some function that can automatically deduplicate ID names in Marketo when the lead data goes to Marketo. That is to say, I want to make Marketo judge whether or not there is duplicated data in Marketo every time the lead data goes from Wordpress to Marketo. Pls advise me how I can do this.

Tad  
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

Hi Hiroshi, 

Not having all the details, here are some quick thoughts: 

Do you collect the email address currently in WP or no? 

If you do collect the email 
In Marketo, you could store the Wordpress Id in a custom field and contact support to setup a custom dedup rule that uses 'Email + Wordpress Id'

If you do not collect the email at time of insert
you could store the Wordpress Id in a custom field and use the REST API's 'Get Multiple Leads by filter type' using the custom field to determine if the record is in your system. 
http://developers.marketo.com/documentation/rest/get-multiple-leads-by-filter-type/

Your API calls to insert/update records into Marketo would be something like: 
Get Multiple Leads by Filter Type using Wordpress Id
   - if empty response : Insert new lead into Marketo
   - if Id is returned : update record 

I would suggest storing email on the record at somepoint and setting up a custom dedup rule that uses Email + Wordpress Id. 

Hope it helps!
 

4 replies

Kenny_Elkington
Adobe Employee
Kenny_ElkingtonAdobe Employee
Adobe Employee
December 17, 2014
Hi Hiroshi,

If you have a Wordpress ID field, you can use the Rest API to designate this as your lookUpfield for updates.  However, you will first need to populate this field into Marketo, before you can use it as a key, otherwise it can potentially generate duplicates: http://developers.marketo.com/documentation/rest/createupdate-leads/
A
Anonymous
Accepted solution
December 17, 2014

Hi Hiroshi, 

Not having all the details, here are some quick thoughts: 

Do you collect the email address currently in WP or no? 

If you do collect the email 
In Marketo, you could store the Wordpress Id in a custom field and contact support to setup a custom dedup rule that uses 'Email + Wordpress Id'

If you do not collect the email at time of insert
you could store the Wordpress Id in a custom field and use the REST API's 'Get Multiple Leads by filter type' using the custom field to determine if the record is in your system. 
http://developers.marketo.com/documentation/rest/get-multiple-leads-by-filter-type/

Your API calls to insert/update records into Marketo would be something like: 
Get Multiple Leads by Filter Type using Wordpress Id
   - if empty response : Insert new lead into Marketo
   - if Id is returned : update record 

I would suggest storing email on the record at somepoint and setting up a custom dedup rule that uses Email + Wordpress Id. 

Hope it helps!
 

    A
    Anonymous
    December 17, 2014
    As Mark mentioned, I would recommend checking out the Get Multiple Leads by Filter Type REST API. 

    Here's a blog post that walks through an example of using this API:
    http://developers.marketo.com/blog/get-a-visitors-cookie-id-and-then-query-associated-lead-data/
    A
    Anonymous
    December 18, 2014
    Hi, Kenny, Mark and Murtza

    Thanks for your useful information!
    I will follow your advice!

    Tad
    Terms & ConditionsAccessibility statement

    Loading footer...