Automate and schedule your data checks

Automate and schedule your data checks
Why make a human do something that a computer can do? 
Your CRM database can do the rotten task of checking for data integrity issues for you.

And you should be able to schedule it on a regular basis.
If you have an automated alert system bolted onto the side of your system, you can run all sorts of data checks each day / week / month.  Maybe Crystal Reports (  There are others, but this is a popular one.  Orbis is another good one.  Bit better if you ask me (, although I realise you didn’t.  Look into these two if you want to make your CRM database really fly.
I think I’m running at about 150 different data integrity alerts and activity alerts each month these days.  It’s allowed our team to manage many times the amount of data we did ten years ago, with less people.  Now that’s a case for a database if ever I heard one.
For instance, you could run a monthly report on how many female firstnames have ‘Mr’ as their prefix.  Illuminating I think you’ll find.  I’ll tell you an easy way of finding those female names as well soon – one for a later tip though.

Hope you found this CRM tip useful.


All the best,


Simon McNidder


PS:  I also write a regular email CRM tips, tricks and a few secrets.  Get them here

PPS:  On LinkedIn?  Like this blog?  Then you’ll like this group: “CRM databases in professional services”:


CRM Blog tags: CRM databases, CRM advice, CRM news, eMail, Direct Mail, Mailshots, eMarketing, Digital Marketing, CRM data, marketing data strategies


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s