October 7, 2018

Six Steps to Hone a Sharp and Steady Marketing Database

A proper marketing database needs to be honed and sharpened regularly. But what’s the best methodology to follow? Just note these six steps!
Marketing Technology

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:

  1. Establish a Mission
  2. Taking a Look at the Current Data Lists and Tools
  3. Generating the Data Structures
  4. Defining and Creating Table Relationships
  5. Finding and Establishing Business Rules
  6. 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.

  1. The first group includes the organization leaders responsible for outlining the mission statement.
  2. The second group includes line managers and end users who will be using it on a daily basis.
  3. 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.

Macro is a natural extension of your B2B global marketing team. As an agency with team members and resources located around the world, we know exactly what your challenges are and how to tackle them.

Global marketing teams that work with us see the following benefits

✅ Agile resources to operationalize GTM strategy

✅ Faster execution of projects with flexibility

✅ More value from your marketing tech investments

✅ Better engagement and more qualified leads 

Don’t just take our word for it — check out the case studies of clients who have benefitted from our services.

Simplify and optimize your digital marketing tools. We stay on top of the latest trends and updates to help you make the most out of your stack.

Let our experts handle the ins-and-outs of your MarTech tools. Book a free consultation with us at any time (after all, we’re stationed around the world!).