Analytics 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick analytics aov gift-cards

Report AOV Impact of Gift Card Redemption

Compare average order value between orders that redeem a gift card and orders that don't, to see whether gift card use is linked to bigger baskets.

📋 Prompt
Run in Sidekick
Compare average order value (AOV) between orders where a gift card was applied as full or partial payment and orders with no gift card involved, for orders placed in [LAST 90 DAYS].

Before you produce the table, tell me whether my analytics can actually link gift-card redemption back to individual orders. If it can only report gift-card activity on its own — balances issued and redeemed over time — without tying that to order value, say so plainly and show me what it can report instead. Do not estimate the split or fill the gap with assumptions.

If the link is available, then for each group (gift card applied / no gift card):

  Order count and % of total orders
  Total revenue and AOV
  % difference in AOV between the two groups, and each group vs the store-wide AOV for the period


Output:

  The table
  2-3 sentence summary on whether gift-card redemption correlates with a bigger or smaller basket
  One recommendation grounded in the data — for example, if gift-card orders run below store AOV, suggest a checkout nudge for when a card balance falls short of a popular price point; if gift-card AOV already runs higher, say that plainly instead of forcing a fix
  The date range and the order count the comparison covers, so I know the sample size


If I will want to re-check this after a gift-card promotion, tell me to save it as a Sidekick skill.

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