Seven Ways to Rejuvenate Your Marketing Database

April 8, 2010
135 Views


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 seven 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…



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 seven 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.

Link to original post