ADSX
NOVEMBER 16, 2026

Compare Shopify Repeat Purchases at the Same Cohort Age

Use an AI worksheet to compare first-time buyer cohorts without mistaking a partially observed month for a retention drop.

AUTHOR
AT
AdsX Team
ECOMMERCE EDITORIAL
READ TIME
3 MIN
SUMMARY

Use an AI worksheet to compare first-time buyer cohorts without mistaking a partially observed month for a retention drop.

October customers appear to be coming back half as often as September customers. If today is November 10, October’s buyers still have most of their next calendar month ahead of them. Start with the observation window before changing a replenishment offer.

August cohort — 100 first buyers — 18 in September. September cohort — 80 first buyers — 16 in October. October cohort — November incomplete — Hold comparison
AUGUST COHORT — 100 FIRST BUYERS — 18 IN SEPTEMBER. SEPTEMBER COHORT — 80 FIRST BUYERS — 16 IN OCTOBER. OCTOBER COHORT — NOVEMBER INCOMPLETE — HOLD COMPARISON

Original AdsX illustration.

Read the row label and column together

Shopify’s default customer cohort analysis groups customers by when they first ordered. In the monthly view a second purchase in that same month can count in Month 0. Month 1 refers to the next calendar month. A buyer acquired on September 30 who returns October 1 and a buyer acquired September 1 who returns October 31 can both contribute to September’s Month 1. For a precise question about returning within 30 days, use dated purchase intervals. Shopify customer cohort report

Record your selected metric and cohort definition. For this worksheet use distinct returning buyers in the column divided by the original cohort size. One buyer who places three repeat orders contributes one buyer. Buyers who appear in different month columns can overlap, so adding those columns will overcount unique people.

Use the numerator before interpreting the percentage

In the example, August has 18 returning buyers from 100 and September has 16 from 80. The repeat rate improves by two percentage points while the number of returning buyers falls by two. Across both cohorts the comparable rate is 34 divided by 180, about 18.9%. Averaging the two percentages gives disproportionate weight to the smaller row.

Give an assistant the cohort month, first-buyer count, observed repeat-buyer count, reporting cutoff and filters. Have it mark incomplete cells before doing any division. A blank future cell means the interval is unobserved. A completed cell with zero repeat buyers is a valid zero. Review subscription mix and acquisition source before attributing a change to a campaign. If a segment is small, report the counts alongside the rate. Shopify analytics field reference

Try the worksheet prompt

Illustrative prompt, not execution-tested.

Compare these fictional monthly first-purchase cohorts at Month 1. Use the cutoff to flag incomplete calendar months. Calculate rates from unique repeat buyers and original cohort sizes, show percentage-point changes and a weighted combined rate. Flag missing or inconsistent counts.

Copy the prompt from the merchant library. For related work, see Why Is My AOV Falling on Shopify? Fixes Inside.

ABOUT THE AUTHOR
AT
AdsX Team
ECOMMERCE EDITORIAL

AdsX Team is the shared editorial byline for our Shopify and ecommerce publication. Guides combine primary sources with practical decision frameworks and clearly labeled examples. See our editorial policy for sourcing and corrections.

MORE BY ADSX TEAM →