Ecommerce
use case
Grow revenue

Online to offline customers, by first-purchase cohort

Last updated
October 14, 2026
Of customers whose first purchase was online, what share have since bought in a store?
Copy question

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?

Online-first crossover rate, worked through

Online-to-store crossover rate = online-first customers who later bought in a store ÷ all online-first customers × 100

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.

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.

Bring your own question to a demo

Book a demo