...
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
Using the Marketo Snap Pack to Deduplicate Records by Email ID
Deduplication is a process that eliminates duplicate records and increases process efficiency.
The cost of the deduplication tool costs is $28k-$33k per year, which you can avoid using the Marketo Snap Pack.
This use case demonstrates how to deduplicate records using the Marketo Snaps.
Problem
In an enterprise ecosystem , there can be enormous data comprising with millions of records, of which several can be duplicate records; for instance, 50k duplicates out of the 600k records might be duplicates. This can lead to ambiguity concerning issues finding the records that require action. Duplicate records cause the following issues:
Skewed results during marketing campaigns and reduced accuracy as a single email ID fetches multiple records.
Unnecessary payment for duplicates due to because of Marketo’s database pricing per record.
Cleanliness is affected.
Cost overhead to avoid duplication using a Requires a costly investment in a deduplication tool.
Solution
Using the Marketo Snap Pack, you can automate the deduplication of records by merging the lead source data with that contain the same email ID. The example pipelines below demonstrate how this can be done. The deduplication of the records can be done using a Smart List, Static List, and createdAt and updatedAt filters.
...
Method
...
Pipeline
...
Smart list
...
Download this pipeline.
...
Static list
...
Download this pipeline.
...
Fetching records using createdAt and updatedAt fields.
...
.
...
...
Download this pipeline.
Understanding the Solution
A. Deduplication with a Smart List
Deduplication of records using the Smart List is a straightforward approach, where you create the Smart List in the Marketo account. Next, you must configure the Smart List filter to fetch retrieve all the required records and provide the Smart List name/ID in the pipelines.
...
Step 5: Configure the name of the Smart List in the pipeline parameters.
...
Step 6: Make use of Use the Marketo Bulk Extract Snap with the Leads entity to fetch the records.
...
The pipeline identifies the records with the Person Source field data as parent records and the duplicate records without the Person Source data as child records. The child records are then merged into the parent records.
If none of the records contain Person Source data, then the merge can occur either way.
If the Person Source data is present in all the records, then the one with the latest data is merged into the older record.
...
B. Deduplication using a Static list
The Use the Static List option is useful when you have a list of records from an external application such as Salesforce and want to import it to Marketo.
...
Step 1: Create a new list in your Marketo account.
...
Step 2: Import the existing records into the newly created list.
...
You can see Step 3: Visually verify that there are duplicates with the same email Id ID in the imported list.
...
Step 34: Configure the Mapper Snap in the deduplication pipeline with the static list name.
...
Step 45: Configure the pipeline parameters with the static list name.
...
Step 56: Make use of Use the Marketo Bulk Extract Snap with the Leads entity to fetch the records.
...
Step 57: Execute the pipeline. On executing:
The pipeline identifies the records with the Person Source data as parent records and the duplicate records without the Person Source data as child records. The child records are then merged into the parent records.
If none of the records has Person Source data, then the merge can occur either way.
If the Person Source data is present in all the records, then the one with the latest data is merged into the older record.
...
The records in the Static List are deduplicated as follows.
...
C. Fetching records using the createdAt and updatedAt fields
...
This method involves building the following three pipelines:three pipelines, a main pipeline, and two child pipelines, capable of fetching all the data from the day the data was created in the Marketo database.
Main pipeline
The main( or first) pipeline takes the start date and the end date of the period for which the deduplication must be done. The first pipeline executes the child pipeline (2nd second pipeline) to segregate the number of days into batches of 31 days (because Marketo has a limitation to fetch records for 31 days using the Bulk Extract Snap).
...
Configure the start date and end date for which the deduplication of records has to be done. Provide the start date and the end date in the pipeline parameters.
 |  |
Second Pipeline
The second pipeline executes another child pipeline (3rd third pipeline) that fetches the Marketo records for the specified date range. This pipeline identifies the duplicate records by email ID and merges the Person Source field data to form a unique record for an email IdID.
If the duplicate records do not contain the Person Source data, the records are merged seamlessly.
If the first record has Person Source data and the duplicate records do not, the latter is duplicate records are merged into the first.
If all the duplicates have the Person Source data, the latest records are merged into the older record.
...
Third Pipeline
...
The third pipeline bulk extracts the data for the specified period for the Leads entity.
...
The second pipeline matches the email Id ID and identifies all the duplicates.:
The pipeline identifies the records with the Person Source data as Master Records and the duplicate records without the Person Source data as Slave Records. The Slave Records are then merged into the Master Records.
If none of the records has Person Source data, then the merge can occur either way.
If the Person Source data is present in all the records, then the one with the latest data is merged into the older record.
...
Downloads
| Attachments | ||
|---|---|---|
|
...