Not all online funnels end up with online purchases on your website. The users can choose a product online, then buy it at your brick-and-mortar store.

ROPO (research online, purchase offline) reports in Smart Data connect online visitors with offline purchases through common IDs and help you understand how online ads and site visits really influence offline purchases. Based on this data, you can effectively redistribute your ad budget.

What data you need to get ROPO reports in Smart Data

  1. Google Analytics Real-Time Data→Google BigQuery pipeline with session data collection enabled OR the BigQuery Export data for Google Analytics 360.
  2. Transactions data from your CRM system as a BigQuery table or view with this data schema

Questions for ROPO reports

Show the <transactions share>, <revenue share> and <customers share> from the first/last <source/medium> before ROPO purchases for <timeframe> within the <30 days> conversion window.

Thanks to this report, you can define online mediums, sources, and ad campaigns lead to offline purchases.

You can evaluate how each medium, source, and ad campaign contributes to your offline revenue, transactions, and number of customers. The report by the first <dimension> lets you evaluate these efforts while engaging users at the first online interaction, the report by the last <dimension> — the efforts at the last online interaction, right before the offline purchase.

Here are the <metrics> and the <dimensions> you can use in this report:

Metrics

  • number of customers
  • customers share
  • number of transactions
  • transactions share
  • revenue
  • revenue share

Dimensions

  • channel grouping
  • source
  • medium
  • source/medium
  • campaign
  • keyword

You can use any combination of metrics in one Smart Data question.

How does the <metric> is distributed by days between the first/last online session and the ROPO purchase for <timeframe> within the <30 days> conversion window?

This report is similar to the Time lag report in Google Analytics. The only difference is that it shows how online actions correlate with offline conversions. The report visualizes what share or number of transactions, customers, and revenue happen within each day within the conversion window.

The first report shows the correlation between the first or the last online interaction and offline purchases.

Thanks to this report, you will understand the real conversion window for ROPO purchases and track how the transaction value depends on the number of days your customer needs to make a purchase decision.

Here are the <metrics> you can use in this report:

  • number of customers
  • customers share
  • number of transactions
  • transactions share
  • revenue
  • revenue share

You can use any combination of metrics in one Smart Data question.

How did the ROPO <revenue> change by <days/weeks/months> over <timeframe> within <30 days> conversion window?

This report shows how the share/number of transactions, customers, revenue, or the average transaction value are distributed between online, offline, and ROPO purchases.

The report lets you separate ROPO from the regular offline purchases and understand the real role of this shopping method across your sales channels.

Here are the <metrics> you can use in this report:

  • number of customers
  • customers share
  • number of transactions
  • transactions share
  • revenue
  • revenue share
  • average transaction value

You can use only one metric and compare it between the sales mediums.

How different is the <revenue share> by <device categories> in ROPO transactions the <timeframe> within <X days> conversion window in the <Last online click> attribution model as compared to online transactions?

This report lets you compare the performance of ROPO and online transactions for a certain time period based on one of two attribution models: Last online click or Funnel-Based.

Comparing the metrics by device categories helps you define which devices are the most used for online purchases, and which devices the customers use to find a product to purchase offline.

The <metrics> and <dimensions> you can base the report on:

Metrics

  • number of customers
  • customers share
  • number of transactions
  • transactions share
  • revenue
  • revenue share
  • average transaction value

Dimensions

  • channel grouping
  • source
  • medium
  • source/medium
  • campaign
  • city
  • country
  • region
  • keyword

Attribution models:

  • Last online click
  • Funnel-Based

All ROPO reports are available in the ROPO tab on the Smart Data main page: ROPO__1_.png

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.