I have a list with approximately 10,000 records. I exported this list and cleansed some of the data, i now want to import the data back in to the list and update the existing rows. Can this be achieved accurately without an email address field but with an ID field to uniquely represent each row when the update query occurs, or is the email address required to update each record successfully?
got it...now since the emails have been updated on some of the records this will create NEW recordsin Marketo not update the existing ones when you upload the list into Marketo. This is due to the fact that the primary key in Marketo is email address.
The problem with the email address as the primary key and not an actual unique ID is that an update to the email address results in a new record being created. With a dataset of thousands of records this can be very problematic!