Online to offline customers, by first-purchase cohort
The short answer
Divide online-first customers who later bought in a store by all online-first customers, and you have the crossover rate for online to offline customers. Measure it by first-purchase cohort, since older cohorts have had more time to visit, and compare spend before and after each customer's first store purchase.
Online-first crossover rate, worked through
Why it matters
Customers who shop in both channels can spend more than single-channel customers, so every online buyer who visits a store is a chance to grow value. Knowing the crossover rate, and what moves it, tells you whether stores and digital teams are working together or competing.
The question to ask
Copy this into Lexi as written.
How to work it out
1. Find online-first customers. Take customers whose first purchase was online, with store and online records matched to one person.
2. Build cohorts. Group them by the quarter of their first purchase, so each cohort has the same time to visit a store.
3. Calculate and compare. Count who later bought in a store, and compare their spend in the 12 months before and after that first store purchase.
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for a furniture retailer. It follows online-first customers by acquisition date and counts who later bought in a store.
- Acquired 24 to 36 months ago: 23% have bought in store
- 12 to 24 months ago: 17%
- Past 12 months: 8%
What the data shows
About one in four online-first customers visits a store within three years.
What it means
Those who cross over spend $1,450 in the year after their first store purchase, against $620 the year before. Many first visits follow a delivery question or a fabric swatch request.
What to do
Invite recent online buyers to a store for swatches and delivery help within 30 days of their order.
The spend lift is a before-and-after comparison, so part of it may have happened anyway. Want me to build the recent online buyers as a segment?
Frequently asked questions
What does online to offline mean in retail?
Online to offline describes customers who start with an online purchase and later buy in a physical store. The reverse path, store first and then online, also matters in most categories. Tracking both directions shows how the channels feed each other and where each one starts customer relationships.
Why compare spend before and after a customer's first store visit?
Customers who visit a store may already be your bigger spenders, so comparing them with online-only customers overstates the effect. Comparing the same customers before and after their first store purchase shows how much their spend changes once they shop in both channels.
Why measure crossover by cohort?
Older customers have had more time to visit a store, so a single rate across all online customers mixes very different time windows. Cohorts by first-purchase quarter give each group the same window, which shows whether crossover is speeding up or slowing down for newer customers.