← All Skills
Customer Loyalty 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick loyalty analytics

Repeat Customer Analytics (Loyalty Proxy Report)

Build a ShopifyQL report comparing AOV, purchase frequency, and LTV between repeat and one-time customers.

View as Markdown
📋 Prompt
Run in Sidekick 
Help me build an analytics report on repeat-customer performance for my Shopify store using ShopifyQL:

Report should show, for [REPORTING_PERIOD]:

  Average order value: repeat customers (2+ orders) vs. one-time customers
  Purchase frequency: average days between orders for repeat customers
  Customer lifetime value: repeat vs. one-time
  Number of repeat customers vs. total customers (repeat rate)


Set it up as a saved report I can re-run, and export it in [FORMAT] (CSV or Google Sheets).

Note: this uses native Shopify order/customer data only — true loyalty-program KPIs like points issued/redeemed or points liability need a third-party loyalty app’s own ledger, which Sidekick can’t read.

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
🚀

Joy Loyalty

Sidekick can tag customers and issue discount codes, but Shopify has no native points ledger. Joy runs the points, tiers, and redemption side.

Install Joy Loyalty — Free →