Connect with us

People 'n' Issues

The power of data profiling



Having an updated database that contains the names and contact details of both existing customers and prospective clients is one of the most vital marketing tools for a company of any size, no matter what type of industry you’re in says Louise Robinson, Managing Director of CG Consulting.

‚”You can have the most amazing product or service, but if no one is buying it, your business will go under. Once you have a database consisting of contacts in your target market, you’ll be able to get the message about your company out there and start making sales.‚”

Robinson says after you have identified your target market and built up a client database, it is crucial to maintain it. ‚”US-based business-to-business marketing research and analysis firm SiriusDecisions estimates that 2 to 3% of a marketing database goes bad every month. This can be due to any number of reasons the person you had on there as a prospective or existing lead could have left their job, relocated, or may have been promoted or moved to a different division. SiriusDecisions also estimates that it costs about $1 to clean a record before it enters the database, but if the incorrect information is entered into the database and remains there over the course of a year, it can cost as much as $100 to fix it.‚”

Data profiling is a fast and efficient way to weed out any potential ‚”bad‚”, duplicate, incomplete, or outdated information on your database. ‚”Data profiling is, to simplify and summarise, a method in which database information and statistics are analysed in order to identify any discrepancies or problems, such as how complete the fields are, how many entries are null, how many are missing, duplicate, and so on.‚”

An article published by cited a real-life example to illustrate some of the problems in a database that can be identified by way of data profiling. An independent data quality consultant was performing data profiling for an insurance company and stumbled upon some strange trends on the date of birth field. He noticed that the customers in the database tended to be born on January 1, February 2, March 3, April 4, May 5 and so on. Upon further investigation, it was found that the date of birth was a required field on an insurance application, but many applicants didn’t feel the need to provide it. However, since the data entry clerks were being paid based on how many applications they could process per hour, they simply made up information whenever they found required fields that had been left blank.

‚”When you have too much incorrect information cluttering up the space in your database, it equates to a lack of enough good data,‚” Robinson says. ‚”Productivity also suffers, because it means that your telemarketers and sales team’s time is wasted when they are faced with incorrect information on the database while trying to make their appointment setting calls.‚”

To ensure that your database remains up to date, Robinson advises outsourcing the creation and maintenance of it to a reputable consultancy. ‚”At CG Consulting, we have a division dedicated especially to database building and maintenance. Called Database 360, we provide our clients with accurate, up-to-date corporate databases, B2B direct marketing lists and databases throughout the entire African continent and into the Middle East. These lists span all vertical industry sectors and company sizes, ranging from large enterprises through the mid-market and small to medium-sized enterprise sectors. The data includes direct e-mail addresses and up-to-date contact details.‚”

* Client details images courtesy of