Posted by
brain in
Success Stories on
11 2nd, 2009 |
no responses Challenge
It was suspected that roughly 40% of over 100,000 lead records in Salesforce.com were duplicates.
To build effective campaigns in Silverpop (Vtrenz), various records of data needed to be normalized, rendering the data consistent. For instance, to make all accounts of “California, CA, Cali” to “California”.
ForceBrain had to achieve this without requiring iRise to license any expensive tools, such as DemandTools.
ForceBrain had to complete the job in 1 week.
Solution
iRise hired ForceBrain Data Services.
ForceBrain defined duplicate vs. survivor criteria and fields to copy to survivor.
ForceBrain acquired limited read-only API access to export a copy of over 100,000 lead records.
ForceBrain normalized all data to an ISO2 standard.
ForceBrain utilized the merge API to remove duplicate records.
ForceBrain worked with iRise on an iterative approval process to review the dataset.
Results
In 1 week, ForceBrain cleansed and normalized over 100,000 lead records for iRise.
Challenge:
- It was suspected that roughly 40% of over 100,000 lead records in Salesforce.com were duplicates.
- To build effective campaigns in Silverpop (Vtrenz), various records of data needed to be normalized, rendering the data consistent. For instance, to make all accounts of “California, CA, Cali” to “California”.
- ForceBrain.com had to achieve this without requiring iRise to license any expensive tools, such as DemandTools.
- ForceBrain.com had to complete the job in 1 week.
Solution:
- iRise hired ForceBrain.com Data Services.
- ForceBrain.com defined duplicate vs. survivor criteria and fields to copy to survivor.
- ForceBrain.com acquired limited read-only API access to export a copy of over 100,000 lead records.
- ForceBrain.com normalized all data to an ISO2 standard.
- ForceBrain.com utilized the merge API to remove duplicate records.
- ForceBrain.com worked with iRise on an iterative approval process to review the dataset.
Results:
- In 1 week, ForceBrain.com cleansed and normalized over 100,000 lead records for iRise.
