Analytics
💎 Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
analytics
gift-cards
Report Gift Card Liability
Total outstanding gift card balances by issue date to show the store's current redemption liability.
📋 Prompt
Report the store’s current gift card liability — the total unredeemed balance owed to customers as of today. Summary: Total gift cards issued (all time, or since [DATE]) Total value issued Total value redeemed Total outstanding balance (value issued − value redeemed − any expired/voided balance) Breakdown: Outstanding balance grouped by issue month/quarter, to show how much liability is from recent vs old issuances Gift cards issued but never redeemed at all, grouped by age (0-90 days, 91-180 days, 180+ days) — the older ones are the least likely to ever be redeemed but still count as liability until they expire or the store writes them off per its policy Top 10 largest outstanding balances by individual gift card Output format: Summary block with the total outstanding liability number Table: issue period, value issued, value redeemed, outstanding balance Table: largest 10 outstanding balances Deliverables: All of the above One clear number: total outstanding gift card liability today Flag if a large share of outstanding balance is from cards older than 180 days, since that’s worth a note to whoever manages the store’s books
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