5 Part Blog Series: Part 2 – KISS (Keep It Simple Stupid)
It’s a very old principle, but one which works fairly well! In other words, don’t try and do too much with your marketing database. It is very easy to become enamored with the elegant, complex database solution. However, when building your first database, it is better to start small, support a single marketing program and work to guarantee success with achievable goals.
Large complex databases take longer to complete and increase the likelihood of missed deadlines and lost opportunities. By simplifying the database as much as possible, you increase your chances for a successful implementation.
It is important to set realistic timeline expectations for building the database. Most relational databases will take from 10-12 weeks to complete. This longer timeframe is because, by design, relational databases deal with more complex issues in maintaining data. The structure and processing for maintaining the complex linkages must be thought through completely!
All too often, people expect a relational database to be built in 4-6 weeks and to get the business, many vendors will agree to the quick turn-around. Cutting yourself short on time is a quick path to disaster! The vendor will be forced to take short-cuts to deliver the database on time, which will result in you not receiving the best possible results.
When working with the database designer during the initial database build, remain skeptical about the need for all the requested data. Make sure there is a proven marketing requirement for the data allowing it to be incorporated into the database.
As an example, consider product related information. In a database intended to support acquisition efforts, it is not likely that you would need to incorporate product data into the marketing database. However, for a loyalty program, product purchase history and data about the product may be very useful in executing the marketing campaign. Not all databases support only a single marketing program, so keep in mind your objectives, as well as the marketing requirement when evaluating data for inclusion in the marketing database.
KEEP IT SIMPLE!
Read Blog Series: Critical Factors in Building a Marketing Database
Part 1 – Begin at the End! Define Your Objectives
Part 2 – KISS (Keep It Simple Stupid)
Part 3 – Standardize/Normalize Your Data
Part 4 – Create An Accurate Budget
Part 5 – Set Measurable Objectives
Summary