Cala were already leveraging our Media capabilities; managing a high volume of always-on biddable campaigns (as well as providing offline and broadcast activity). That, coupled with our Performance Directors working closely on the ground with Sales and Marketing teams around England and Scotland, means we have a detailed understanding of Cala’s focuses, their audiences and a passion for constantly helping to develop on a successful marketing ecosystem.
S&T’s Client Experience teams, channel specialists and Data Analysts collaborated closely together to plan the ideal reporting solution; bringing together the various data elements which would give the wider team a detailed understanding of performance, but also direction and insight into what to do next and how to improve at both the group, regional and development level.
This was then followed by the integrations process from our Solutions Engineers of using ETL (Extract, Transform, Load) tools to connect data sources to our Cloud Data Warehouse, BigQuery. With raw disparate data stored and historically backfilled for the couple of years’ worth of reporting necessary for some campaign trends, a bespoke reporting layer would be built. In essence, this would be the product of cleansing and aggregating across multiple data sets to bring everything together into a single data source for use in data visualisation platforms.
A dashboard was designed in Data Studio connected to the BigQuery reporting layer and processes were put in place to ensure continued monitoring of data connections in the data warehouse and to identify when new developments were live on the website or property portals that required mapping into the database for surfacing in reports.
