Most marketers have a list of contacts that constantly gets updated. The list usually exists in an email tool, which most likely doesn't enforce any data integrity and has limitations such as number of fields, records, and size.
As a result, marketers may find that their campaigns are underperforming thanks to poor database design and poor list maintenance practices.
Databases shouldn’t be wielded like a blunt object. By following best practices, you can turn your database into a strong, sharp model, holding clean and integral data.
The Importance of Maintaining a Proper Database
Without a proper database, you cannot understand the simple things such as the relationships between Companies and Contacts. If you throw different Sales Reps and Event Registrations in there – well, you got a mix from hell!
We believe that marketers must work with proper databases in order to gain the insights they need. Designing a database without the benefit of a good design method leads to poor campaign results and lots of manual work. A marketing database design process should be implemented and followed from beginning to end.
The Six Steps for Developing a Proper Database
So how does that get done? With our database development methodology, you only need to follow these six steps:
- Establish a Mission
- Taking a Look at the Current Data Lists and Tools
- Generating the Data Structures
- Defining and Creating Table Relationships
- Finding and Establishing Business Rules
- Determining and Building Views
1. Establish a Mission
The mission statement is the purpose of the marketing database. Every marketing database must be designed with a well-defined purpose.
- What kind of purpose? Here are a few examples:Deploy emails to existing customers,
- Maintain relationships with business partners,
- Track online behaviour of visitors to their website, or
- Reach out to media channels.
Then, you’ll want to set up interviews with three separate groups.
- The first group includes the organization leaders responsible for outlining the mission statement.
- The second group includes line managers and end users who will be using it on a daily basis.
- Finally, the third group is the data-savvy employees who set up the original system.
2. Taking a Look at the Current Data Lists and Tools
If no real database exists, then the data most likely lives in various client lists, email tools, address books, and loose spreadsheets. The purpose of all these different sources must be outlined. Reviewing the way data is currently collected, presented and how often it changes, is also an important part of the analysis.
Understanding how both Marketing Coordinators and Marketing Directors interact with their database on a daily basis is crucial, because everything must be built to serve the users.
Once the analysis is complete, you can compile a preliminary list of fields. We then work with management to take into consideration additional fields which could prove valuable if they are well-supported.
3. Generating the Data Structures
Based on the analysis performed, we will define the tables and fields. Each table represents a subject determined by the mission and the current marketing lists.
Once subjects are identified, we transform them into tables and outline their properties as fields.
- For example, Contacts and Campaigns are two subjects. Each table must also have a unique identifier, or a key.
- A proper review must be performed to ensure each table represents only one subject.
- A field that does not represent a characteristic of the subject of the table has to be moved to a more appropriate table, or deleted entirely.
- An Email Date is an appropriate characteristic of the Campaign table, while an Email Address is a characteristic of a Contact.
4. Defining and Creating Table Relationships
We work with both users and management to identify relationships between the subjects.
We found that most people have a good viewpoint of the data they work with and can easily identify relationships among the subjects.
For example, an Account has multiple Contacts, but a Contact has only one Account. This would be a one-too-many relationship between the two.
5. Finding and Establishing Business Rules
Specific limitations must be imposed on the data and these are based on documented business rules. For example, the fact that a Sales Rep can cover a maximum of five states must be enforced.
As the organization evolves, its use of the data will change, which means that the business rules must change as well. Establishing and keeping these business rules up to date is an ongoing process.
6. Determining and Building Views
Users do not need to look at all fields of a table at once and that is why Views must be established.
For example, an email campaign coordinator would like to see the names, companies and email addresses of your contacts, while a marketing manager needs to see the engagement of each contact. By interviewing all users, we can establish the relevant views for each user.
Conclusion
The benefits of building a proper marketing database are endless. It will empower you with higher quality of information and ability to create additional marketing programs. You will be able to better target your message and understand the behaviour of the people you are marketing to.