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
Run in Sidekick
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

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions