Customer Loyalty
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
segments
acquisition
channel
Segment New vs. Returning Customers by Acquisition Channel
Build segments comparing new and returning customers by referring channel, to see which acquisition source produces repeat buyers.
📋 Prompt
Run a ShopifyQL report grouping customers by their first-order referring channel ([CHANNEL_LIST], e.g. direct, organic search, paid social, email, referral) over the last [PERIOD_MONTHS] months. For each channel, show: number of new customers acquired, and what percentage of them placed a second order within [REPEAT_WINDOW_DAYS] days. Then create a customer segment named [SEGMENT_NAME] for customers acquired via [BEST_PERFORMING_CHANNEL] (the channel with the highest repeat rate from the report) who have only ordered once so far — these are the customers most likely to convert to repeat buyers based on their channel’s typical behavior, and worth a nudge. Draft — do not send — a Shopify Messaging email to this segment encouraging a second purchase, referencing [CROSS_SELL_CATEGORY]. Tell me which channel had the lowest repeat rate too, since that’s useful for the marketing team even though it’s not the segment I asked you to build — a channel that acquires but doesn’t retain is worth flagging.
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 →