Platform: Enolytics DTC
Summary:
What it shows: A ready-made report displaying every gift card that customers purchased but haven't touched yet — completely unused and still waiting to be redeemed. The report filters down to show only gift cards that are: (1) currently active, (2) haven't expired yet, and (3) have never been used (zero dollars spent). No setup needed — just open and review your untapped gift card revenue.
Who should use it:
• Marketing managers looking to re-engage gift card holders
• Customer service teams handling gift card inquiries
• General managers tracking unredeemed gift card liability
When to use it:
• Planning reminder campaigns to encourage gift card redemption
• Conducting quarterly reviews of outstanding gift card balances
• Following up on recent gift card sales that haven't converted to purchases yet
Questions this report answers:
• "How can I see which gift cards customers bought but never used?"
• "Can I get a list of all the unused gift cards we've sold?"
• "Where do I find gift cards that are just sitting there unredeemed?"
• "How do I pull a report showing gift cards with full balances that haven't expired?"
• "Which gift card recipients haven't made their first purchase yet?"
Tip: Use the Gift Card Age In Months column to prioritize your outreach — older unused gift cards might need more urgent attention than recent purchases.
Note: Parts of this article were generated with AI and may not be perfect. If something looks off or could be better, click the 😞 below — it opens a quick chat so you can let us know.
📂 How to Access This Report
This is a public bookmark — a pre-built report ready for you to use. You don't need to create it from scratch.
To open it:
Click the Bookmarks icon in the left sidebar
Look under Public Bookmarks
Open the folder: Business Reports/Gift Cards
Click Unused Gift Cards
Quick Stats:
3 filter(s) applied
15 dimension(s) displayed
0 measure(s) displayed
Report Page: Build Beyond Limits | Advanced Reporting
Filter Behavior: When you select this bookmark, your existing filters will be replaced with the bookmark's saved filters.
📝 Original Description
View all active, unexpired gift cards that customers bought but never used or redeemed to track outstanding gift card liability.
Filters Applied
The following filters narrow down the data in this bookmark:
Dimension Filters:
Gift Card Status is one of: Active
Expiration Status is one of: Not Expired
Gift Card Balance Status is one of: Never Used
📋 Columns Displayed
Dimensions:
Gift Card Name — Name of the gift card (eg. $100 gift card)
Gift Card Code — The code on the gift card
Starting Balance On Gift Card — The starting balance on the gift card
Spent Balance On Gift Card — The used amount on the gift card.
Gift Card Balance Status — Indicates the redemption level of the gift card: ""Never Used", "Partially Used" ,"Fully Redeemed"
Gift Card Sold Date — The date the gift card was sold by the winery or bought by the consumer.
Gift Card Age In Months — Age in months since the gift card was sold.
Gift Card Status — The status of the gift card (eg. active or not active)
Expiration Status — Indicates whether the gift card has expired or not.
Gift Card Type — Indicates the type of gift card (eg. virtual vs. physical)
Gift Card Recipient Email — Email of the person receiving the gift card
Gift Card Number — The unique number of the gift card. Often those numbers are sequential. This is a way to identify the giftcard.
Gift Card From Name — The Name in the From Field when a gift card is gifted
ℹ️ Additional Details
Bookmark ID:
cad70c59-c2b4-48b9-a071-68b1b06cab49