Our client's media campaign data needed to be retrieved from several different sources, and in different formats. This made it inefficient and in some cases unusable - when attempting to create reports that compared the available information.

This created an inefficient and often unreliable process, bringing the need for a more consistent and robust approach to harnessing available data for use in reporting.

Our approach involved automation of data collection from source platforms, applying consistent rules to programmatically clean and classify data. We collated data from a wide range of sources including Ad Server, Innovid, social media platforms, search analytics and Adobe, to create a single robust and comprehensive data source.

This pool of data could then be harnessed by the organisation to create effective reporting, visualisations and insights.

The technology used was Azure, benefitting from its inherent robustness and the client’s familiarity in using the platform.

We delivered a global reporting dashboard with consistent, comprehensive and harmonised data from several sources, in a robust and automated solution.

This solution was rolled out smoothly across all operating markets giving both our client and their customer the ability to make real-time decisions based on accurate data.