I am performing an UPSERT import operation which pulls a CSV fle from S3 and imports it it into the lead table in Marketo.
It works great except there are a couple of rows which come up as errors saying: "Lead already exists"
The lead certainly does exist already in marketo, but so do the vast majority in the file, that's why we are using UPSERT. Yet only two rows come up with that error.
I have applied a target lookup which refers to the email address to find the ID number, and the email addresses are unique within the lead table.
Those particular leads do have a number of duplicate named leads within marekto however they are not the only ones to have multiple leads with the same name so it's unclear why there would just be those two errors.
Run ID: 41053632