Using Ads Data Hub to Connect Ad Exposure to Offline Purchase

Bridging the Gap Between Ad Exposure and Offline Sales

For most brands, the hardest measurement question isn't whether a campaign drove clicks — it's whether ad exposure actually moved someone toward a purchase that happened in a store, over the phone, or through a CRM-recorded transaction. Standard DV360 reporting shows impressions, clicks and pixel-based conversions, but it stops at the edge of your owned data.

Ads Data Hub (ADH) is Google's privacy-centric analytics environment that lets you close that loop. By joining event-level DV360 log data with your own first-party and offline datasets inside a secure BigQuery-backed environment, ADH makes it possible to trace the journey from a display or CTV impression all the way to an offline purchase — without exposing individual user identities.

This guide explains how ADH works, what you can realistically measure, and how to structure a project that answers the customer-journey question properly.

What Ads Data Hub Actually Does

ADH is not a dashboard. It's a query environment where you run SQL against Google's impression-, click- and conversion-level data, joined to your own tables that you upload to a linked BigQuery project.

Key characteristics worth understanding before you plan a project:

• Event-level data, aggregated output. You can query granular log data, but ADH enforces aggregation and difference checks so no individual user can be isolated in results.
• Privacy by design. Results below a minimum aggregation threshold are filtered out. This protects users and keeps your measurement compliant.
• Your data stays yours. First-party and offline data you bring remains in your Google Cloud project; joins happen inside the secure environment.
• Cross-Google-Media reach. ADH can incorporate data across DV360, Google Ads, Campaign Manager 360 and YouTube, giving a unified view of paid media exposure.

The combination of Google media logs plus your CRM or point-of-sale data is precisely what enables offline journey analysis.

The Data You Need to Connect the Journey

To measure from exposure to offline purchase, you need three ingredients aligned in ADH.

1. Media exposure data

Impression and click logs from DV360 (and optionally CM360, Google Ads and YouTube) provide the exposure layer — who saw which line item, on what device, at what time, on which inventory.

2. A durable join key

Offline purchases rarely carry a cookie or device ID. The bridge is usually hashed, consented first-party identifiers — email addresses or customer IDs collected at point of sale and matched to ad exposure through Google's matching. This is why a strong first-party data foundation matters so much for modern measurement.

3. Offline conversion data

Your transaction records — in-store purchases, call-centre sales, signed contracts — uploaded to BigQuery with the same hashed key, transaction value and timestamp.

Data source	What it contributes	Typical owner
DV360 / CM360 logs	Impression & click exposure, device, inventory	Media / agency
First-party CRM	Consented hashed IDs, customer segments	Data / CRM team
Offline / POS records	Purchase value, date, location	Retail / finance
YouTube & Google Ads	Cross-channel exposure context	Media team

When these are joined correctly, you can answer questions that pixel-based measurement simply can't.

Questions ADH Can Help You Answer

A well-scoped ADH project can move you well beyond last-click. Common customer-journey questions include:

• Exposure-to-purchase lift: Did users exposed to DV360 campaigns convert offline at a higher rate than an unexposed or control group?
• Frequency and sequencing: How many impressions — and in what order across formats — preceded an offline purchase?
• Cross-device paths: Did mobile exposure lead to an in-store purchase days later?
• Channel contribution: How do display, video and CTV each contribute to offline outcomes when viewed together rather than in silos?
• Time-to-conversion: What is the realistic window between exposure and offline purchase for your category?

These insights let you reallocate budget based on genuine offline impact rather than proxy signals.

How a Typical ADH Journey Project Works

Step 1 — Define the business question and control approach

Start with a measurable hypothesis, for example: "Users exposed to our CTV line items purchase in-store at a higher rate within 30 days." Decide whether you'll use a holdout group or exposed-versus-baseline comparison, because this shapes how campaigns are trafficked in DV360.

Step 2 — Prepare and upload first-party data

Hash and format your CRM and offline transaction data to Google's specifications, then load it into the BigQuery project linked to ADH. Data hygiene here determines match quality.

Step 3 — Build the join queries

Write SQL to join media exposure logs to hashed customer IDs and offline transactions, respecting ADH's aggregation and privacy rules. Most teams iterate several times to refine attribution windows and de-duplication logic.

Step 4 — Analyse and validate

Compare exposed and unexposed cohorts, examine frequency curves, and pressure-test results against known seasonality or promotions. Validation matters — a lift number is only useful if the methodology is defensible.

Step 5 — Activate the learnings

Feed insights back into DV360: adjust frequency caps, shift spend toward high-contributing formats, refine audience strategy and inform bidding. Measurement only pays off when it changes decisions.

Practical Considerations and Limitations

ADH is powerful, but it rewards realistic expectations:

• Match rates vary. Offline conversion measurement depends on how many purchasers can be matched via consented identifiers. Sparse first-party data limits what you can see.
• Aggregation thresholds. Very granular slices may be filtered out, so plan queries around meaningful cohort sizes.
• SQL and cloud expertise required. ADH is a technical environment; it isn't a point-and-click tool. Teams typically need analysts comfortable with SQL and BigQuery.
• Consent and governance. Uploading customer data demands clear legal basis, consent management and internal data-governance sign-off.
• Time investment. A robust journey study is a project, not a report — expect setup, iteration and validation phases.

Because of this complexity, many advertisers run ADH work with specialist support rather than building the capability from scratch. Our DV360 managed services and co-managed services teams regularly design measurement frameworks that connect media exposure to real business outcomes.

Turning Journey Insight Into Better Media Decisions

The real value of ADH isn't the analysis itself — it's what it enables downstream. Once you understand which formats, frequencies and sequences genuinely influence offline purchase, you can:

• Set frequency caps informed by diminishing returns rather than guesswork.
• Rebalance budget toward channels with proven offline contribution.
• Build smarter audience strategies grounded in your first-party data.
• Report to leadership in the language of revenue, not just impressions.

For teams running programmatic in-house, pairing ADH insight with a well-structured DV360 self-serve account keeps activation and measurement tightly aligned. For a broader view of how we support advertisers end to end, see our full range of DV360 services.

Ready to Measure the Full Journey?

Understanding the path from ad exposure to offline purchase is one of the most valuable — and most technically demanding — measurement projects a DV360 advertiser can undertake. If you'd like help scoping an Ads Data Hub project, preparing your first-party data, or turning the results into media decisions that move revenue, get in touch with our team and we'll help you build a plan that fits your data and goals.