How to cleanse a database
 
 

How to cleanse a database

by jezwalker 19. May 2010 15:31

Depending on the nature of your business there are a number of ways to value your data. Whether you measure this on the level of revenue, number of referrals, average retention per customer, or in another way, one thing is clear, the data you hold is extremely important to your business.


By having multiple users entering information on your database, over time the information in the CRM system often becomes less accurate and therefore of less worth. Tidying up this data can be a challenging proposition.

Firstly, you should consider data cleansing to ensure that any old or invalid data is identified and removed.


Once this process is complete you should ensure that any new data you add to the system is accurate, whether captured from the web or typed in internally. At the very least you should perform a postcode lookup which can auto-complete pre-defined fields with full, accurate addresses. Once you add in email validation and telephone validation you can rest assured that future data you collect will be accurate and current, increasing the value of the data you add.

Comments

5/19/2010 10:40:57 PM #

pingback

Pingback from turkmenistantoday.co.cc

How to cleanse a database | Breaking News 24/7

turkmenistantoday.co.cc

5/31/2010 12:56:49 AM #

pingback

Pingback from 478.ja3ra.com

2009 - 2008 @ Canon Lide 600 F Driver, Cls500 Parts Accessories Mercedes Benz Cl600 - 478.ja3ra.com

478.ja3ra.com

Comments are closed

RecentComments

Comment RSS
Skip Navigation Links
Request handled by server S1 for client 38.107.179.218 at 5/18/2012 8:21:20 AM