In China’s competitive media landscape, developing an in-depth understanding of data will allow us to improve our overall media performance. Reliance on just Media Data would not suffice. We needed a way to organise the data we have internally, create a way to read this data that can help to drive our media effectiveness and guide us on future campaigns.
Our data journey starts with us detailing what our initial requirements to guide our understanding of what data is required:
We worked with a vendor and used their existing SASS system as a base.
I then detailed the required changes through wireframes to communicate our needs and drive the project forward. This included managing the vendor, developing wireframes and getting stakeholders buy-in to ensuring quality deployment of the system.
As the 1st version of the DMP, we needed to identify the necessary data required to generate the bare minimum data required for analysis. As we currently use a third party vendor to help with tracking and serving, we are able to obtain basic impression and click data for different platforms and channels.
This is transferred to the system via daily, which is then processed and cleaned to each different campaign based on pre-defined campaign IDs.
There is a lot of data that goes into each media campaign, especially on the output.
What data is absolutely important? This had to be arranged so that it can easily be read yet flexible enough to offer power users the ability to do in-depth analysis.
We had to ensure that the campaign landing page had the necessary information required to show a summary of all the media campaigns that we run. One of the challenges we ran into was prioritising what exactly should be shown in the landing page.
This is the filter selection to allow us to look at campaigns over time period, by brands or by types of campaigns.
Because this acts as a dashboard, we want to understand quickly what is happening. One important feature is the “View Problem Campaign” so that we can immediately identify which campaigns are not meeting their goals.
One of the things that we wanted to look at how media and sales are correlated. This allow us to correlate our sales vs our spent and savings.
As a snapshot of what is happening, this gives us a clear understanding of how much has been spent, the savings and the status of the campaign. For more details on the campaign performance, users can click to go into each individual campaign.
The campaign details page was the biggest challenge as there are so many data points that we usually look at. How can this be presented in a way that helps us understand the data quickly yet offer the flexibility to allow us to slice and dice the data as we see fit?
Showcase the campaign details, including the ability to quickly turn an existing campaign into an audience profile.
We need to immediately know how much has been spent, what is the savings and what is remaining.
We showcase some of the media channels that we run our ads on. These essentially summarises our overall impression and TA% performance.
To quickly understand whether we are meeting our targets, we can look at our overall results and how they compare against our benchmarks.
In chart form, how are we forming in terms of impressions, clicks, CTR, reach and TA%.
We can filter by platform how our frequency is after we include some frequency control in our campaigns.
This section allows the user to detail down what kinds of data is needed. They can select multiple options or just a single option, offering them the flexibility they need. They can also create a template so that they do not need to reselect options every time. Finally, they are able to export it out for further analysis.
The platform was launched in September 2018 and resulted in a 30% increase in Media Efficiency and Effectiveness. There are continuous works done to improve the overall user experience of the system as well as a detailed product roadmap to help us achieve our goals. Couple of learnings: