Hammerson PLC Global GA4 Account Build and Reporting

Global GA4 build and multi-centre reporting: unified measurement across 6 centres, 18 ad accounts, 36 data sources and a Looker Studio single source of truth.

Set up of standardised conversion events
Migration of 6 UA to 6 GA4 properties
QA of GA4 and events
GTM audit of GA4 tags and triggers
Migration of Google Ads and Meta Ads accounts
Creation of TikTok Ad accounts
Setup Big Query (BQ) account
Setup API for Shoppertrak to pass data to BQ

The Engagement & Business Challenge

Hammerson PLC are an owner operator of large retail spaces across UK, IE and FR.

With the changes in retail and shopping behaviours they were seeking to digitally transform their business to enable them to shift the perception of shopping centres in their portfolio to 'Centres of Commerce & Culture'. Changing the narrative around centres like Dundrum, Bullring & Grand Central or Westquay from retail spaces to centres for events and experiences.

As these shopping malls had been acquired over decades, a standardised analytical framework across countries and centres had not been set up. The first step on this journey to digital transformation required a unified way of measuring and reporting on Hammersons assets online and offline.

This would create a solid foundation to progress through the full suite of Enterprise Marketing Services as they develop through the Google Digital Maturity Framework.

Technical Ability

Technical scope

Hammerson required a centralised dashboard to provide insight and analytics on the performance of 6 centre owned assets including website activity and store footfall which is recorded by a third party platform (Shoppertrak). This dashboard must also integrate with their current suite of marketing platforms to facilitate Media Mix Modelling.

The channels originally scoped to be included were: Google Ads, Facebook Ads and Tik Tok. These integrations must include a standardised series of conversions across all 6 websites and performance metrics including: cost, impressions, clicks, CPC and CPM.

Custom Analytics codes for events can be seen in the screenshot below

‍

‍

Custom datalayer rewrites triggered through GTM example below

‍

Technical challenges

This Analytics project encompassed 3 key challenges.

The first was the fragmented setup of the centre website's Google Analytics UA accounts needed to be migrated to GA4. We confirmed which web based events would to be tracked as conversions for each site before standardising these across GA4 properties.

This will allow us to report on key events accurately across multiple centres.

The initial events to be recorded as conversions were:

  • Newsletter sign up (user_registration)
  • View the Parking page (viewed_car_park)
  • View the Opening Times (viewed_opening_times)

Once the web data could be standardised the second challenge required PATTRNS to ingest data from 3 different channels for 18 different ad accounts.

A number of different media agencies had created, managed and owned these accounts leading to different campaign taxonomy and data processing standards. The client requested we rebuild all of these accounts to follow channel best practices while also ensuring Hammerson owned all ad accounts moving forward. Once completed we could pass all the necessary data into Big Query using a variety of API's, native integrations and third party tools (Supermetrics).

Big Query would then connect to our proposed visualisation tool (Looker Studio). The third key challenge centred around importing offline shop visitor data from a third party service. We decided to utilise SFTP as Big Query could then read this data into the necessary tables.

Scope milestones

  • Migration of 6 UA to 6 GA4 properties
  • Set up of standardised conversion events across 6 websites and GA4 properties.
  • QA of GA4 and events.
  • GTM audit of GA4 tags and triggers
  • Migration of Google Ads and Meta Ads accounts to Hammerson.
  • Creation of Tik Tok Ad accounts to be owned by Hammerson
  • Setup Big Query (BQ) account and necessary tables.
  • Setup API for Shoppertrak to pass data to BQ
  • Utilise Supermetrics to import channel metrics to BQ - Google, Meta & Tik Tok.
  • Creation of dashboard template for approval.
  • BQ connection to Looker Studio dashboard.

Analytical Ability

Initial analysis began as part of an Operational and Organisational Model review.

During the early discovery phase with stakeholders from the C Suite to the destination management, a lack of visibility across all digital touchpoints became clear.

A clear measurement framework needed to be established that could be aligned across 6 websites and 36 data sources from 5 channels. The events that were measured then needed to be available to all stakeholders alongside the ability to filter data as they needed.

The internal data team did not have the skillsets to create a centralised dashboard from multiple sources, or to standardise multiple Analytics properties across the Hammerson portfolio. Investors wanted to know the ROI of marketing budgets, Marketing Managers wanted to know the footfall at each centre for key events and the C Suite wanted to know how the database was growing over time.

Unified measurement across 6 business units with a standardised dashboard to visualise the data was required.

Our teams consulted Hammerson to prioritise events to be created and standardised across the portfolio. This was dependent on a number of factors including current revenue targets and future business objectives.

We decided to break this project into two parts, first we needed to standardise Google Analytics implementation across 6 business units. Secondly we needed to blend data from Google Analytics, Shopper Trak, Google Ads, TikTok, Salesforce & Meta into a live Looker dashboard.

Business Impact

Significant efficiencies have been achieved with the development of a single source of truth dashboard. Previous data requests that involved 3+ agencies can now be surfaced with a few clicks.

The trust the business has in this data set is also allowing them to invest heavily in marketing activity. 11 stakeholders were involved in the measurement framework which allows Google Analytics and Looker to be included in Board Reports, Quarterly Reviews, Investor Reports and Monthly Performance Reports.

With the Google Analytics deployment enabling integrations between Salesforce, Google Ads and Looker, Hammerson have progressed along the Digital Maturity framework. In 2023 Hammerson recognised significant business growth across all destinations involved in this project.

The goal for Hammerson in 2023 was to drive footfall growth across the portfolio while becoming more digitally mature.

Undertaking a digital transformation to leverage the data sets they had available. Following the deployment and visualisation of this data we were able to make a number of key recommendations to achieve this business goal.

These recommendations were acted upon and led to a heavy investment into Performance Max campaigns.

These campaigns leverage Google Analytics audiences as Audience Signals, promoting events around categories our visitors showed the most engagement with. Linked below is a Google approved case study on the business impact of our recommendation.

“
We decided to break this project into two parts, first we needed to standardise Google Analytics implementation across 6 business units. Secondly we needed to blend data from Google Analytics, Shopper Trak, Google Ads, TikTok, Salesforce & Meta into a live Looker dashboard.
Joshua Hyatt, Co-Founder & COO of PATTRNS

[ work with us ]

Want results like these?

Tell us about your brand and goals, and we'll show you how we'd drive the same kind of growth for you.