Customer Loyalty
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
segments
seasonal
lifecycle
Segment Seasonal Buyers Who Only Order in Specific Months
Identify customers whose order history clusters in specific months, for timed reminder campaigns ahead of their usual buying window.
📋 Prompt
Pull a ShopifyQL report of orders grouped by customer and order month over the last [LOOKBACK_MONTHS] months. Identify customers with at least [MIN_ORDERS] orders where [MIN_PERCENT]% or more of their orders fall within [SEASON_MONTHS] (e.g. November-December, or June-August), and few or no orders outside that window. Create a customer segment named [SEGMENT_NAME] from that list, filtered as closely as segment conditions allow (e.g. last order date within [SEASON_MONTHS] of the most recent occurrence, number of orders >= [MIN_ORDERS]). Report the segment size and their combined revenue from their seasonal orders. Draft — do not send — a Shopify Messaging email timed for [DAYS_BEFORE] days before the start of their usual buying window ([SEASON_MONTHS]), reminding them the season is coming and highlighting [FEATURED_PRODUCT_OR_COLLECTION]. Tell me the calendar date I should schedule this send for, since I want it to land before the window opens, not during it.
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
🚀
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 →