Anna Gieniusz
Anna Gieniusz 25 September 2020

Marketing Data: Aggregation & Segmentation

Define, operationalise and automate: Understanding marketing data is a tricky task. I could write a 5-book series about it and it would still not be enough. Plus, no marketer would read it. Data – boring stuff, right?

Nowadays marketers have too much information and consuming it is difficult. Just think about easy email campaigns that use marketing automation tools. We know who we are targeting, we know who opened or clicked a URL in the email, we know who visited a web page and if they bought a product or service we were selling. We can track every step that customers make. But, so what? What do we do with that information?

How Do you use Marketing Data?

The obvious thing would be to use the customer’s activity as a trigger for follow up communications, or next steps, as a part of a journey. Mr X received an email and opened it, so we can send him a second email that continues on from the initial communication.

So we send him another campaign, and another one, and we gather even more data. But do we take any lessons from the stored rows of information we now have in the database?

Do you know which customers are the most loyal ones?

Do you know who is reading your emails most often? Who is really interested in what you write?

Do you know that Mr X visited your website for the 5th time this week? Maybe he’s looking for something? Do you know what he was searching for?

We cannot expect marketers to be data scientists, fluent in data mining. However, the role of a marketing data analyst or marketing manager includes designing a data flow so that marketers have all the vital information available, in a very clear way. And I will tell you how to do just that.

1. Define what you need

At the global level – what would you like to know about your customers?

Let’s take as an example an engagement measure. ‘Who is reading our emails?’.

Start here and ask yourself what you would do with this information? How would you interpret it? You can for example use this information to create customer segments and use them as additional targeting and reporting dimensions. Wouldn’t it be interesting to know that only 20% of your recipients are opening and reading emails? And who they are? Or to know the 35% that never opens anything?  Customer segments can provide this insight.

As a marketer you defining what you need is important. Let’s say your need is to divide your customers into five groups:

  1. Not interested
  2. Slightly interested
  3. Sometimes interested
  4. Rather interested
  5. Waiting for your every email

2. Operationalisation

This is the tricky part of the process and it’s important to make sure it’s a team activity. You need a marketer and data analyst in the same room. Ideally you’ll have a Martecheter in the mix too. It can be the same person, but then there’s no fun team bonding, probably no meetings and no cookies and coffee. Well, we are all working from home anyway, so forget about it. The important thing is that this part of the process involves the marketing and the analyst minds coming together.

Back to your five segments – would you rather have them equally distributed in quintiles of activity? (Division Type A) Or have strict rules and see how they split between them? (Division Type B) And more interestingly – how do they flow between the groups?


And now we are talking about data.

In Option A you could define the last six months as a time frame. Search for every open event activity and every sent email for each customer. Calculate how many emails they received and how many of them they opened. Sort all customers based on that percentage and divide them in the five different groups based on that value.

In Option B you are deciding and defining activity tiers – like in my simplified example. Then for each customer consider their last four mailings and verify if they were opened or not; then calculate the value for each customer. Easy!

3. Verify your data

Don’t simply trust your data, question everything and make sure you understand what’s there. It’s important to fully understand the process and data before you draw conclusions based on one excel chart.

It’s full of traps but you can do it.

Think back to your initial needs. Did you mean only marketing emails or operational emails too? What if a customer opens the same email twice? Take the Data Analyst on this journey with you. Be as precise as possible. Question the final value and repeat until you are sure you have what you want.

4. Automation

That was easy! Now is even easier.

Speak with your DWH (data warehouse) team about maintaining the same process on a daily basis, preferably at the data servers. That’s the optimal solution.

They should keep all the calculations and run them daily/hourly to supply your marketing team with the freshest possible data. On a daily basis your marketer shouldn’t have to worry about calculating all of this from scratch. The final and up to date information should be provided for them in the marketing data mart and become one of many dimensions describing customers. Pretty useful!

5. Don’t limit yourself

All the above was just an easy example. I’m sure you can make a long list of dimensions you would be interested in. But the process is similar – define, operationalise and automate. Raw data is beautiful for data freaks like me, but painful for daily usage. That’s why reasonable aggregation and segmentation helps to get the best out of your marketing database.

To find out more about the kinds of data available in marketing automation and how to best use them, download the ebook, An Introduction to Successful Marketing Automation by Purple Square.

Please login or register to add a comment.

Contribute Now!

Loving our articles? Do you have an insightful post that you want to shout about? Well, you've come to the right place! We are always looking for fresh Doughnuts to be a part of our community.

Popular Articles

See all
7 reasons why social media marketing is important for your business

7 reasons why social media marketing is important for your business

Social media is quickly becoming one of the most important aspects of digital marketing, which provides incredible benefits that help reach millions of customers worldwide. And if you are not applying this profitable...

Sharron Nelson
Sharron Nelson 6 February 2018
Read more
Top 10 Skills to Become a Rockstar in Digital Marketing

Top 10 Skills to Become a Rockstar in Digital Marketing

Technology is continuously evolving, prompting marketers and entrepreneurs to dive into digital marketing to increase brand awareness, reach their target market, and ultimately drive sales and profit. 

Jessica Andriani
Jessica Andriani 7 September 2018
Read more
Top 10 B2B Platforms to Help your Business Grow Worldwide

Top 10 B2B Platforms to Help your Business Grow Worldwide

Although the trend of a Business to Business portal is not new but the evolution of technology has indeed changed the way they function. Additional digital trading features and branding has taken the place of...

Salman Sharif
Salman Sharif 7 July 2017
Read more
Top 7 Strategies For Improving Your Tech-Savvy Skills

Top 7 Strategies For Improving Your Tech-Savvy Skills

In today's modern world of technology it is very important to be tech-savvy. Knowing how to use technology is the key to success and great personal future developments.

Jessica Freeman
Jessica Freeman 11 May 2017
Read more
Top 7 Benefits of Chatbots for Your Business

Top 7 Benefits of Chatbots for Your Business

Chatbots have been on the rise since a couple of years and have already faced a wide adoption. They are bringing a new way for businesses to communicate with the world and most importantly with their customers by the...

Asena Atilla Saunders
Asena Atilla Saunders 8 November 2017
Read more