Tuesday, July 26, 2011

11 Ways to Rejuvenate Your Marketing Database

Posted by Sundeep Kapur | Tuesday, July 26, 2011


A visit to so many marketers shows people poring over paper reports, having meetings about the validity of the reports, and decisions being made without all the data. Here are eleven things to consider doing to rejuvenate your marketing database.

1 - Create a Roadmap - You know where you are and what you can do today. Start by listing where you would like to be and start coming up with small steps in between.

2 - Focus on the Business Needs - Put forth a list of those who use your database and ask them about what information they need and how they want to use the information. In the world of use cases, this means you are listing the actors (users) and asking them to list their use cases (tasks) on how they would use the marketing database.

3 - Find the Gaps - You will find that you are missing information, have duplicate information, take too long to update information, or it is really hard to find the information. Additionally, users may not be able to find the information in different places compatible with each other. You consequently need to highlight these gaps and start improving the quality of data (or put it on the roadmap).

4 - Design the Reports - Do this first as people will want to see the information in a particular format. Once you start getting people sold on the look and feel of what the reports are, you will find them much more amenable to changes that might be required later.

5 - Educate the Users - Teach them how to use the database. I usually recommend a three step approach. I ask the users to write down specific use cases on what information they need from the system. Next I ask them to point it out in the reports (step 4). Once they have done that, I encourage them to click through to find the appropriate data. These three steps can now be captured as part of the user manual and should be kept available for online support as well.

6 - Make the Database Accessible - If people can access your database to get the reports that they desire - they are more likely to use it. From a performance perspective, limit the number of power users (users who can run any query) so as to not reduce the performance of your system. Pre-run popular reports so that the information is available to those that need it. Also, work with the power users to add to the repository of reports and keep evaluating (and removing) reports that are not used.

7 - Make Reports Mobile - Allow your key users to have access to summary reports on their mobile devices. This is power messaging at its best and it really helps to rejuvenate the utility of information and your marketing database.

8 - Create a Control Group - You should create and track a control group to see how the control group performs versus the rest of your campaigns. You do this to see if your efforts are making a difference. If you do this correctly, you can make a big difference.

9 - Keep Your List Current - Remove those that have dropped off the list. This will help you to focus on those that are active and come up wtih actual strategies that will make a difference. The cost of dead weight adds up to all your campaigns - you waste money on postage, you waste money on emailing, and you add to your deliverability woes by targeting people that aren't really there.

10 - Add Social to Your CRM - You have to add two aspects of social contacts to your marketing database. First, maintain a list of social contacts of your consumers. Second, score your consumers for social activity. This way you can target those who are more active with viral campaigns.

11 - Know How Your Information is Organized - Contrary to marketing propaganda, it is tough to store all your information in one database. So be aware of where what information is stored - for two reasons - you know where to look for it and you know where to update the information.

Your database is your black book, invest in it, as it has all the information you need to drive successful interaction.

0 Responses to “11 Ways to Rejuvenate Your Marketing Database”