ROPO: connecting online marketing to offline sales

For many retailers, most revenue still happens in-store, yet a large share of those purchases begin online. If your analytics stops at the website, you systematically under-credit the digital channels that drive offline sales — and may cut the very campaigns that grow revenue.

The measurement problem

ROPO — Research Online, Purchase Offline — is about joining two datasets that rarely share a key: website behaviour and in-store transactions. The challenge is identity. You need a durable identifier that exists in both worlds, and a place to join them at scale.

A working approach

• —Stream unsampled, raw web data to a cloud warehouse (typically via server-side GTM into BigQuery).
• —Use a stable key both sides share — most often a loyalty or discount-card ID captured online at sign-in and offline at checkout.
• —Retrospectively match shoppers who researched online and bought in store, then automate a report that credits digital channels for offline revenue.

Why it pays off

Once offline purchases are attributed to the digital touchpoints that influenced them, budget allocation changes. Channels that looked unprofitable on a web-only view are often among the strongest drivers of total revenue. In one engagement, connecting these datasets revealed that a quarter of offline purchases had prior online research — insight that reshaped the marketing budget.

If you sell across online and offline channels and your reporting can't connect them, you're optimising on half the picture. We build the pipeline and reporting to close that gap.