Exactly How Bad is Bad Data for You? Step-by-Step Tips to Delete Bad Data

Bad data is detrimental for any marketing program. Even worse, bad data that ranges from duplicate data, incorrect data, broken links, missing files, corrupt files, outdated and invalid data exceed the limit and burden the database and marketing budget.

According to an estimate by Sirius Decisions reveal that organizations spend about $100 for data maintenance in their database, including those bad data records. Approximately, 20% data are inaccurate with 100,000 records in a database which cost about $2M of the marketing budget. In addition to marketing costs and oversized occupancy, bad data affects a brand in many other ways – unnecessary software expenses, poor marketing performance, system slow down, and inaccurate segmentation and personalization are just a few to mention.

Bad Data hinders marketing performance

One of the areas where bad data badly affects performance is low click-through rates and engagement with the audience. Bad health of your database will deter your marketing results and degrade them below the industry standards if your marketing campaigns are based on a range of prospects who might not need your products or offerings. Also, if your data set comprises invalid data, then bounce rates will increase and your campaigns will suffer from poor email delivery and negative reputation. Thus, overall performance and results of marketing campaigns will take a downturn due to bad data range.

Bad Data increases software costs

Do you often see this message pop up in Marketo, or other platforms, stating “You are over your data limit”? If you do, then blame it on bad data which is causing your platform to exceed data space allocated to your package. You may use some SAAS platforms for diverse marketing programs and campaigns including marketing automation, CRMs, ABM, and any other which charge you based on the data range. And as the number of records and campaigns grow, requirement for a larger database increases. At that, with 20-30% of the data set containing poor data, your company is spending more on those software subscriptions than is required.

Bad Data Leads to Poor Segmentation/Personalization

Are you running your marketing segmentation and personalizing your campaigns based on poor data? Then, your campaigns are doomed to failure as your segmentation data may contain inaccurate, duplicate, outdated or invalid data which will hinder delivery of personalized experience. Thus, your campaign is performing no better than a generalized campaign.

Slow Marketo performance due to bad data

All marketing and CRM software platforms perform at its peak in the first six months. Later, these platforms start slowing down with consistent use and data addition and alteration. Each of these platforms are used for updating records, syncing data, segmenting data, creating and running campaigns, measurement and optimization and other marketing activities. And each of these activities takes power and results in addition to additional records with every campaign. Thus, the bigger your database swells, the longer your SaaS platforms take to process data and activities, leaving your system less efficient.

For example if your Salesforce platform is working with as large as one million sized database, small changes made on records will impact the entire database and all data will automate a data sync with the Marketo platform to complete the data update process. Thus, your software platform will experience sluggish performance issues.

If your bad data is ruining the results and eating up hundreds of dollars from your marketing budget, then here is what you need to know. Check out the following step-by-step instructions to delete or trash bad data to prevent loss of performance, resources and effectiveness of your Marketo campaigns.

Each step will require you to define the criteria, evaluate and identify processes, and carry out the cleanse to flush out the data.

Step 1: De-duplicate the data

Duplicate data is one major type of bad data you need to focus on – hence, first things first, you need to spot all the duplicate records in your database. If you are using Marketo, then you get a one-time offer to de-duplicate the database. Though Marketo may not let you de-duplicate the data multiple times, it lets you spot duplicate records.

To identify and access duplicate records, you need to create a Smartlist which will detect multiple duplicate records which contain the same email or other contact details. Two types of records can be duplicates within Marketo, which are leads and contact details. To prevent duplicate records in Marketo, you need to choose API or Marketo forms. Another way to prevent duplicate data is by syncing all Marketo leads with the salesforce platform, searching for leads in SFDC by first name or email address and then updating the data. You can also import all lists in Marketo by selecting ‘Normal.’

Step 2: Get rid of records which do not have email addresses

Your Marketo platform may contain some records that are devoid of email addresses. Since you cannot send them emails, you cannot include them in your campaigns. Hence, those records are unnecessary data that you need to purge from your database to prevent the likelihood of duplicates.

In SFDC, lead records that do not have email addresses are not marketable and thus, get removed after 30 days. However, contact records need complex analysis. For example, if you have an account payable contact that does not have an email address, the address cannot be deleted since the address can be used for billing. Some records you may need to remove from Marketo, but need to retain in Salesforce in order to lessen the risk of removing data crucial for the sales team, but not for marketing activities.  If you want to delete records from Marketo, but retain them in Salesforce, then you need to set the criteria in Salesforce so that that data will not get synced with Marketo unless an email address is available with those records.

Step 3: Eliminate recently removed Salesforce data

By default, records that are deleted from Salesforce do not get deleted from Marketo automatically. To remove deleted SFDC records, you need to create a campaign in Marketo which will run and detect deleted Salesforce records and will purge on spot regularly.

Users can also set up automated batch campaigns to cleanse data and repeat the process weekly. You may keep the process monthly in case you need to trace some deletion occurence in Salesforce.

Step 4: Get rid of disqualified data

In this step, Marketo users need to detect disqualified data and eliminate them to maintain good data health. For this, you need to set up a process that will identify if the disqualified data is bad data.

You can set custom criteria to avoid the risks of deleting recycled records that were mistakenly marked as ‘Disqualified’. You can also choose to delete disqualified data based on reasons of disqualification.

Step 5: Delete hard bounce data

Many marketers choose to delete contact data when the email bounces on that email address – should you? For certain reasons, you may not. Some records that had bounced you may want to retain for reporting purposes. You may need to send those addresses a few more emails to extract data from bounced emails. One way of deleting bad bounced data is to delete data when the ‘Email Invalid’ turns true.

Step 6: Get rid of Inactive records after reactivation campaigns

That’s true, marketers should not delete data if a contact has stopped activities with your emails. There are many ways you can run reactivation campaigns to encourage response and engage with  your correspondence, content, offers or products. After multiple reactivation campaigns, you need to determine the following: if those contacts are inactive over the span of 15 or more months; if you don’t find any opportunities for activities; if those inactive records are Salesforce leads only; if those records are no longer part of any lifecycle stage. You need to perform this as a one-time process to delete inactive data once you have set the criteria. You can also run this process quarterly or yearly to remove and repeat the process to get rid of inactive data as per the set criteria.

If you need to delete bad data and maintain good health of your database in Marketo by using professional assistance, you can discuss strategy with our Marketo certified experts (408) 502-6765. Check out more tips, tricks and updates on our social pages LinkedIn, Twitter (@ShowMeLeads) and Facebook. Keep in touch with our leaders Madhu Gulati on LinkedIn and Twitter (@mgulati) and Prash Shenoy on LinkedIn and Twitter (@shenoyprash) to get in know of the latest Marketo and ABM updates.