AMS Media Group Case Study

The quality and speed of data integration across customers and sources, reporting and visual analysis has been vastly improved

A platform to allow analysts to focus on delivering real insight not just reporting metrics

The challenges faced at AMS Media Group

The services offered by AMS need to be highly flexible to cover a vast array of data points, mix-ing and transforming many data sources, injecting analysis models and reporting in different formats.

AMS delivers these services through their analytics business allowing clients to warehouse data, manage data, inject media data, analyse and report performance as well as forecasting.

Operationalising the ingestion of multiple data sources and maintaining the integrity of data for continuous reporting alone can take days and when delivering reports across a reporting cycle; daily, weekly, monthly, quarterly and so on, stretches resources. This has been a huge challenge in time and effort resulting in analysts spending too much time on data integrity and producing reports.

Developing a platform to allow analysts to focus on delivering real insight not just reporting metrics was the overall objective of the project.

AMS Media Group (AMS) is one of the UK’s longest established media agencies. Founded in 1975 and remaining 100% independent, AMS is a specialist media planning and buying agency.


Working together with Layer 9, AMS have developed a solution that delivers end to end, data to visualisation and insight for clients.

The solution is based on a pluggable, open platform that creates a flexible analytics solution to support existing infrastructures and make best use of the current evolving data technologies.

Pentaho was selected as it allowed AMS to produce consistent high quality ready-to-analyse data. In addition the parallel processing engine in Pentaho was a perfect fit for the time to analysis required by AMS.

While the platform is feature rich in function it is also highly customisable and can be extended to meet a diverse number of needs from simple data ingestion, cleaning, analysis to sophisticated statistical or predictive analysis.

A significant benefit is the ability to blend data and gain insight into the relationships and impacts across the business within the data. Many AMS clients have access to data across businesses and from different systems, Analysts can develop multi-dimensional models and analyse data from several perspectives.

The value

AMS now deliver a simplified on boarding process for their clients

Analytics are tailored to specific business requirements

A robust and configurable set of processes and practices provides greater data govern-ance

Analysis and insight can be delivered in various forms from dashboards, interactive reports and pixel perfect PDF reports

Today AMS can combine several different data sources and visualise the insight on a dashboard in hours rather than days

A typical benefit to their client base has been the ability to see integrated views of a campaign and the customer journey. So when a client is advertising on TV, they can see an increase in website traffic and an increase in calls to the call centre