July 30, 2015
After the webinar, we realised that there was a lot of learnings to unpack around the subject of data quality. We will be publishing a series of blog posts on this topic over the coming weeks. See part 1 here.
If you read our last post on running negative reports in Salesforce.com, you’ll know how to identify problems in your data very quickly. That will speed up the process of cleaning up your data. But that’s really only the first step.
Cleaning data is a necessity, but it’s still a chore. Speeding up that process is only going to improve the quality of your data to a certain extent — you’ll still be spending a lot of time cleaning up mistakes.
So what’s next? Tracking what is actually going wrong so you can figure out how to fix errors more permanently.
Since reading the last post, you now run automated reports to find errors.
Every week, you get the email with a list of errors at which point you can export the report as a .CSV file. You can upload these to a Google Sheet (using the relevant Salesforce IDs to make sure the data matches when you import it back into your instance) where you can edit the records quickly and easily. Read up on the Data Import Wizard here.
First of all, you fix all the errors. Every time you fix an error, copy the record to a Tracking Errors spreadsheet and add a new column – ‘Date Cleaned’.
Now, you have a list of errors related to Salesforce IDs and the date you fixed the error. This is a pretty powerful resource to take your data quality processes to the next level.
Tracking errors in a spreadsheet this way means you can investigate errors in a number of different ways. What you’re looking for now are trends that help you identify the causes of errors.
Now you can cut down errors before they happen by taking aim at the causes of errors. The data cleaning process should get faster and faster as you bring in this error tracking process. You could move this all onto Salesforce by making error objects, but using Google Sheets is simple and easy. Even better, you can share this around to your team without Salesforce licenses.
Do you track errors? Do you use it to do other things? We’d love to hear about it! Always feel free to get in touch.
Many TaroWorks customers previously used paper and spreadsheets to collect data, analyze metrics and run field operations. Let us show you how TaroWorks’ offline mobile field service app can help scale your business by digitizing sales and supply chain management, increasing agent network productivity and analyzing data in real-time for business insights.
Sign up to receive emails with TaroWorks news, industry trends and best practices.