Analytics
π Built for Sidekick
β‘ Sidekick does this for you
shopify
sidekick
analytics
retention
Report Repeat Purchase Rate
Calculate what share of customers buy again within a set window and how that rate is trending.
π Prompt
Calculate my storeβs repeat purchase rate for customers who placed their first order in [DATE RANGE, e.g. LAST 6 MONTHS]. Definition: Repeat purchase rate = % of first-time customers in the cohort who placed a 2nd order within [90 DAYS / 180 DAYS] of their first order Breakdowns to include: Overall repeat rate for the cohort Repeat rate by acquisition month (did customers acquired in [MONTH] repeat more than others?) Repeat rate by first-order product or collection β which first purchase leads to the most repeat business? Repeat rate for discounted first orders vs full-price first orders Average days between 1st and 2nd order Output format: Summary line: overall repeat rate and how it compares to the trailing period Table: acquisition month, cohort size, repeat rate, avg days to 2nd order Ranked list of first-purchase products by resulting repeat rate Deliverables: The full breakdown above Flag whether repeat rate is improving or declining over the window Name the single first-purchase product or discount pattern most correlated with higher repeat rate, so it can be leaned into for acquisition
How to Use
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions