Multiple values for same email address | Community
Skip to main content
J
Jananim
New Participant
February 12, 2021
Solved

Multiple values for same email address

  • February 12, 2021
  • 1 reply
  • 2070 views

Hi all, 

We are currently working with an outside lead provider who does not have a direct integration with marketo, this has led to me creating a solution to importing leads by manually importing the list weekly into a static list. I have a trigger campaign set up to assign lead source and scoring as soon as they are imported.

 

My problem is that now we would like to score them based off of a column that the lead provider has in their export called "Content buyers journey". They assign leads a value of early, middle or late based off of how many times they have downloaded or viewed one of our articles on their site. However, the export contains multiple rows for the same email address, so one person may have four entries with content buyers journeys value at "early" and then one lone entry with the same email but the value is now "late".  How can I import this field into Marketo if there are multiple values for the same email address and we want Marketo to score based off of the change in value? Is this possible?

 

Any help would be appreciated, thank you!

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 SanfordWhiteman

You'd need to build a custom import process that takes the import file, splits into the largest possible parts that don't have internal duplicates, and inserts the files separately.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
February 13, 2021

You'd need to build a custom import process that takes the import file, splits into the largest possible parts that don't have internal duplicates, and inserts the files separately.

J
JananimAuthor
New Participant
February 17, 2021

Thank you! I'm not sure how that would address the problem of multiple values tied to the same email address? I need to import these into a custom field I've created called "Content buyers journey" within Marketo. However, I'd like to see the progression of these values week over week. Does that clarify a little better? Thanks again for your response! 

SanfordWhiteman
SanfordWhiteman
New Participant
February 17, 2021
By inserting each update separately, you get a Change Data Value activity. "Week over week" wouldn't be possible if you insert everything on the same day, of course, they would be different timestamps on that day.
Terms & ConditionsAccessibility statement

Loading footer...