Helping commercial teams see the value they create.

Problem

SoPost wanted to move beyond campaign-level metrics. Existing reporting focused on delivery and short-term results, which were useful but incomplete. It didn’t show what happens after the first purchase, or how trust and intent turn into future demand.

• · Brands judged campaigns on immediate results, without seeing how they build future demand
• · CSMs lacked a clear, consistent story for uplift
• · Commercial teams were spending time defending value instead of demonstrating it

A model with two pillars

Working from a methodology developed by our Head of Product, I defined the product interpretation of the model and designed the first interactive version. It rests on two complementary pillars of value:

• · Incremental revenue (modelled)
• · Purchase intent and trust uplift (measured)

Each is benchmarked, shown with confidence ranges, and positioned as an early indicator of lifetime value.

Building the pilot

I designed the pilot in Looker and tested it with the Commercial team. Looker let us:

• · Prototype live with production data
• · Iterate quickly as the calculations evolved
• · Test real interactions and filters with CSMs and Commercial teams
• · Reuse existing data models for future integration into Campaign Manager reporting

That took us from concept to a validated prototype in weeks, with real user feedback captured before any engineering investment.

Pilot scope

• · Incremental revenue: attribution against a control, at campaign and aggregate level
• · Purchase intent and trust uplift: benchmarks, confidence ranges and a clear visual hierarchy
• · Context: category and network baselines for faster interpretation
• · Storytelling: roll-ups, drill-downs and exportable summaries
• · Quality gates: thresholds, exclusions and shared definitions

The pilot wasn’t about dashboards for their own sake. It tested whether the methodology could be understood, trusted and scaled.

Testing and validation

The dashboard went live with the CSM and Commercial teams, where we validated:

• · How useful the thresholds and ranges felt in real campaigns
• · Whether the visuals made uplift easier to explain
• · Where terminology and labelling needed refinement

Impact

Incremental revenue and trust uplift became early, defensible indicators: a bridge between immediate results and sustained growth.

It changed the conversation internally. We stopped asking “did it work?” and started asking what value it would create.

Problem

Comparison reporting, the large summary and benchmark tables, lived across Looker dashboards, slides and ad-hoc exports. That fragmentation made it hard to spot performance patterns across campaigns or markets, and Commercial teams had to build these tables by hand, collating data from each source.

Why it mattered

The Commercial team asked for this. They and the CSMs were rebuilding the same story for every campaign, and needed a quick, standard way to answer questions that kept coming up:

• · How did this campaign perform compared to others in the same market?
• · Which product or activation delivered the strongest intent to purchase?
• · How does this brand compare against its own benchmarks over time?

Design approach

I defined the structure and logic for a comparison view that could sit directly inside Campaign Manager, removing the need to export data or, for some brands, to maintain external decks. It supports flexible comparison across brands, territories and campaign types, using shared indicators such as opt-in rate, response rate, recommendation and purchase intent.

Every table follows one visual pattern that prioritises speed, legibility and clarity. Lightweight filters sit directly above the table, so people can explore without visual clutter:

• · Brand and territory, for regional context
• · Benchmarks, to show category or network averages
• · Campaign type, to compare like with like
• · Date range, to track performance over time

I designed these in high fidelity in Figma and reviewed them internally to shape hierarchy, grouping logic and interaction patterns.

Example use cases

• · Aveda: product and market benchmarks
• · Puig: year-to-date fragrance performance
• · e.l.f. Cosmetics: Meta versus TikTok comparison
• · Coty UK: brand-level campaign summaries

The focus was a scalable component, not a one-off visualisation. By aligning layout, filters and terminology early, the design showed how one consistent pattern could unify several data views, and cut the friction between having the data and getting to an insight.

Expected impact

The framework was designed to cut the time spent on comparison reporting sharply, by taking most of the manual work out of it. Tables that Commercial teams built by hand, collating data from Looker, slides and exports, would come from one view in one consistent format, and the same question could be answered for every campaign without rebuilding the story each time.

Status

The designs were complete and reviewed internally, with a clear path defined for building the framework into Campaign Manager. The next steps were to refine naming, grouping and thresholds based on internal feedback, and to extend coverage beyond beauty and fragrance.