Customer Loyalty 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick segments churn lifecycle

Tier Lapsed Customers by Days Since Last Order

Create three lapsed-customer segments across escalating day thresholds, so win-back intensity can scale with how cold each tier is.

📋 Prompt
Run in Sidekick
Create three separate customer segments that tier lapsed customers by recency, since a customer gone 65 days needs a different offer than one gone 200 days:


  [TIER_1_NAME] — last order between [TIER_1_MIN_DAYS] and [TIER_1_MAX_DAYS] days ago, at least 1 prior order
  [TIER_2_NAME] — last order between [TIER_2_MIN_DAYS] and [TIER_2_MAX_DAYS] days ago, at least 1 prior order
  [TIER_3_NAME] — last order more than [TIER_3_MIN_DAYS] days ago, at least 1 prior order


All three segments should exclude customers with an order placed in the last [TIER_1_MIN_DAYS] days, and exclude anyone who does not accept marketing.

Report the customer count and combined historical revenue for each tier.

Note which tier is largest by customer count and which is largest by historical revenue — these are often different, and I want to know which tier to prioritize for outreach budget.

Do not build any Flow or send anything yet; this is for segment creation and sizing only, so I can decide the offer per tier before we automate anything.

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 →