With 400 offices in 81 countries around the world and global staff strength of over 18,000, GroupM’s success and track record continues to grow as one of the world’s leading media investment management group. A truly global business operation, GroupM’s principal challenge was in the collaboration and consolidation of information and data across its many offices around the world. Existing processes to generate and collate global client reports were inefficient and could take up to a month to create the reports, thus hindering operations and speed-to-market.
Avanade developed an automated solution that would help GroupM extract, transform, and load (ETL) data to a global data warehouse to help track and capture complex data on ‘the state of advertising’. Leveraging Microsoft technologies, the first phase of the global project was implemented across three key markets in the UK, Mexico and Thailand. The solution deployed by Avanade automatically collects and consolidates data from each country’s local source systems into a local data warehouse, and from there it is automatically replicated into the global data warehouse without user intervention.
GroupM is now empowered with an automated global solution which helps capture multiple data sources from its agencies worldwide. Client account teams can easily generate local and global cross-market reports via a streamlined and simplified process, thus reducing the long hours needed to manually complete the task. GroupM now has the ability to drive collaboration with its global offices and derive insights to make more informed decisions.