Customer Loyalty 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick shopifyql segments reporting

Report Segment Growth and Shrinkage Over Time via ShopifyQL

Pull a ShopifyQL report tracking how a named customer segment's size and value has changed over recent periods, to catch growth or churn early.

📋 Prompt
Run in Sidekick
I want to track the segment [SEGMENT_NAME] over time, not just see a current snapshot.

Run a ShopifyQL query showing, for each of the last [NUMBER_OF_PERIODS] [WEEKS_OR_MONTHS]:

  How many customers matched this segment’s filter conditions at that point in time (recreate the segment’s logic as a query rather than relying on live segment membership, since segment membership only reflects today)
  Combined revenue from that period’s matching customers
  Net change in matching customer count versus the prior period


Present it as a simple table, oldest period first.

Tell me whether the segment is growing, shrinking, or flat, and whether revenue is moving in the same direction as customer count or diverging — for example, a shrinking segment with growing revenue means the remaining customers are spending more, a different story than a shrinking segment with falling revenue.

If this is a report I’ll want repeatedly, tell me whether to save it as a Sidekick skill so I can re-run it as /[SKILL_SHORTCUT_NAME] on a [FREQUENCY] cadence instead of re-typing the full query each time.

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 →