How to find which Shopify products drive repeat buyers

First-purchase to repeat-buyer funnel — identifying your best acquisition products

Definition

What it is

First-purchase repeat buyer rate is the percentage of customers whose first-ever order contained a specific product and who subsequently placed a second order. It identifies which products act as the best "entry points" into your brand — products that create loyal customers rather than one-time buyers. This metric is distinct from overall repeat purchase rate: it measures product-level acquisition quality rather than store-level retention.

Formula

First-Purchase Repeat Rate Formula

Formula

Repeat Rate (%) = (Customers with 2+ orders whose first order contained product X ÷ All customers whose first order contained product X) × 100

Calculate per product over a cohort window long enough to allow a second purchase — typically 90 days or 6 months depending on your repurchase cycle. Rank products by repeat rate descending to find your best acquisition products. Combine with volume to avoid a low-volume product with a 100% repeat rate skewing the ranking.

Business impact

Why it matters

Knowing which products drive repeat buyers fundamentally changes acquisition strategy. If customers who first buy Product A repeat at 45% vs Product B at 12%, Product A is worth a much higher acquisition cost — even if Product B has higher AOV on the first order. Brands that optimise ads and promotions to drive first purchases of their highest-repeat-rate products consistently achieve lower blended CAC over time.

The challenge

How most teams track this today

This metric requires joining three tables: orders, order line items, and a customer-level first order date calculation. It is not available in Shopify Analytics or most off-the-shelf reporting tools without a custom query. Calculating it typically requires either a BI tool or a complex multi-step spreadsheet process.

Run it on your data

Calculate this automatically with Taptic Data

Connect your Shopify account and Taptic generates this calculation from plain English against your actual data — no Excel exports, no manual joins. The SQL runs against your real schema, your real tables, your real numbers.

SQL query for Shopify products that drive repeat buyers →Connect Shopify →Try Free — $29.99/mo

FAQ

Common questions

How is this different from repeat purchase rate?

Overall repeat purchase rate measures what percentage of all your customers order more than once. First-purchase repeat rate by product measures — for customers whose first order contained a specific product — what percentage of those customers then ordered again. It is a product-level metric that reveals acquisition quality rather than store-level retention.

What cohort window should I use for this analysis?

Match the window to your typical repurchase cycle. If most repeat purchases happen within 60 days, use a 90-day window. If your products are purchased quarterly, use a 6-month window. Including customers who have only been in your database for 30 days in a 90-day repeat analysis will understate repeat rates for recent acquirers.

Can I filter this by acquisition channel in Taptic?

If your Shopify orders contain UTM data or are tagged with acquisition source, Taptic can filter the first-purchase repeat rate query by channel. This tells you not just which products drive repeats, but which channel+product combinations produce the most loyal customers.

What tables does Taptic use for this query?

The query joins orders, order_line_items, and products. It first identifies each customer's earliest order date (first purchase), then checks whether their first-order line items contained each product, then counts how many of those customers have a second order within the cohort window.

Analytics hub

All Shopify queries, use cases, and SQL examples in one place.

Shopify Analytics hub — queries, use cases, and SQL examples →

Stop calculating this in spreadsheets

Connect Shopify to Taptic Data and run this calculation automatically from plain English — against your real data, on a schedule, delivered to your team.

Start Free — $29.99/mo Try the Live Demo