Categories
Case Studies

Maximising ROI on automated marketing campaigns through data cleansing: Racing Victoria

How Unico helped Racing Victoria regain trust in their customer data by building a custom data extension.

SFMC-deduplification

Maximising ROI on automated marketing campaigns through data cleansing: Racing Victoria

How we helped Racing Victoria regain trust in their customer data by building a custom data extension to extract and cleanse duplicated Salesforce Marketing Cloud contacts.


Customer

  • Racing Victoria

Project

  • Salesforce Marketing Cloud (SFMC) campaigns and data cleansing services

Objectives

  • Identify and remove duplicate SFMC contacts in Racing Victoria’s database 
  • Ensure all Racing Victoria’s contacts and leads are listed with 100% accuracy 
  • Reduce salesforce contract renewal fees    

Approach

  • 2-week consulting engagement with Racing Victoria 
  • Identify, extract and remove duplicate contacts with automated queries 
  • Run comparative tests to ensure data is duplicated before removal

Outcome

  • Removed 400,000 corrupted / duplicate contacts from database of over 1,000,000 
  • Saved Racing Victoria $100,000 in costs over a 2-year contract renewal period  

A major part to conducting an effective automated messaging campaign is whether you can trust your data. Campaign results can vary drastically return in investment (ROI) based on how accurate the Salesforce database of contacts is. Racing Victoria had a database of over 1,000,000 contacts which contained a significant number of duplicates and corrupted data. In a 2-week engagement Unico cleansed their database of any duplicate contacts or outdated contacts that were no longer being targeted by email or SMS content. 

The data was extracted to a data extension where comparative testing was conducted to verify that contacts were classified as duplicates before deletion. Ensuring that a contact database is rid of all non-validated contacts means messaging automation platforms like SFMC charge users based on the true size of their contact list. 


“Contact database authentication was a major focus for Racing Victoria as our number of contacts continued to grow. Unico was able to enable us to have complete trust in our data within just two weeks and provided immediate ROI through this engagement”

– Marcia Allan, GM Customer Strategy & Engagement, Racing Victoria.


Following the data cleanse of Racing Victoria’s contact database, over 400,000 entries were removed resulting in over $100,000 of saved contract renewal costs. This was 4 times the cost of the Unico engagement, resulting in significant ROI for Racing Victoria and clear value add.


Evan-Harridge

Evan Harridge

Director of Innovation and Enterprise Sales