The Data Quality Issue: My boss asked me to generate a list of all our CRM On Demand Contacts in the Metro DC area for a Meet-and-Greet event. I needed to send out a formal invitation using their address data in CRM On Demand. When I pulled the list to print off the mailing labels I was horrified at the inconsistencies used for street designations and city names! Plus, those inconsistencies were not up to USPS standards and I would risk some being returned to sender. For example I have one contact at “33 W End St”, another at “33 west End street” and another at “33 End St. west”; one contact in “Sliver Spring” and quite a few more in “Silver Springs” (which city name is correct?). Also, I have one with the city listed as Washington DC and the state as VA! I could go on, but you get the point. The Solution to the Issue:
Welcome to the ActivePrime Blog
In our blog, you’ll find helpful and informative posts dedicated to improving CRM performance and usability. Our topics include deep dives on the technical aspects of CRMs like searching and data quality. You’ll also find insightful posts about user productivity and adoption.
The Data Quality Issue: I have a campaign budget of $20,000 for a fantastic glossy mailer. That budget needs to cover the cost of printing my new brochure and mailing it out First Class USPS. The number of Leads in my CRM On Demand is 5,800. So if I do a quick estimation of cost for the flyer of $2.25 each, and postage of $.85, plus another $.65 for the envelope, label and letter, that comes to over $21,750. Yikes! That’s $1,750 over budget!