You can migrate your ECID mapping from your Marketo Engage Person dataset to your Activity dataset to provide a more stable behavior of data ingestion and identity management. Additionally, this migration addresses the following:
Problem | Solution |
---|---|
When your Marketo Person dataset has links to multiple ECIDs, data ingestion fails when the total number of identities in an Experience Data Model (XDM) record exceeds 20. | By migrating the ECID field mapping to Activity, you can ensure that the number of identities from the Marketo Person dataflow stays within the limit and thus allow for data ingestion to succeed. |
Every time the Marketo Person dataset is ingested with ECIDs, the timestamp on all of the ECIDs from the Marketo Person dataset are updated with the last updated timestamp of the Person record. This could result in the incorrect deletion of more recent identities from the identity graph. | By migrating the ECID field mappings to Activity, Identity Service can correctly reflect the timestamp of ECID’s and the “first-in, first-out” mechanism of Identity Service will provide a more stable behavior. |
When ECIDs are ingested through Marketo Person dataflow, newly added ECIDs do not get ingested into Experience Platform unless there are updates to the Person record in Marketo. | When a new ECID is linked to the Person record in Marketo, you can ingest that ECID data through a Marketo Activity dataflow and immediately prompt an identity graph update on Experience Platform. |
Essentially, you must:
Follow the steps below to update your Marketo Activity dataflow:
...
) beside the dataflow name and then select Update dataflow.Source dataset | XDM target field |
---|---|
iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null) |
identityMap |
If your update to an existing Marketo dataflow consists of only adding or removing the ECID mapping field, then the dataflow automatically skips the historical backfill job. New data ingestion will only occur when activity types such as “visit webpage” and “click webpage” happens.
Follow the steps below to update your Marketo Person dataflow:
...
) beside the dataflow name and then select Update dataflow.identityMap
and then select Next and Save & Ingest.If your update to an existing Marketo dataflow consists of only adding or removing the ECID mapping field, then the dataflow automatically skips the historical backfill job. The timestamp of ECIDs that have been previously ingested will remain the same. They will only be updated when new data that corresponds to the existing ECIDs are ingested.
By reading this document, you now know how to migrate your ECID mapping from your Marketo Person dataset to Marketo Activity dataset. For more information, read the following Marketo documents: