Platform: Enolytics DTC
Summary:
What it shows: This report displays gift cards that have been completely used up but are still valid in your system. It shows only cards that meet three specific criteria: (1) currently active in your system, (2) haven't passed their expiration date yet, and (3) have been fully redeemed by customers. This ready-made report requires no setup — just open and review.
Who should use it:
• Customer service teams handling gift card inquiries
• Finance teams reconciling gift card liabilities
• Operations managers tracking gift card performance
When to use it:
• Monthly gift card reconciliation and cleanup processes
• When customers ask about their zero-balance gift cards
• Before running promotions to understand fully-used card patterns
Questions this report answers:
• "How do I find all the gift cards that customers have completely used up?"
• "Can I get a list of fully redeemed gift cards that are still active in our system?"
• "Where can I see which gift cards have zero balance but haven't expired yet?"
• "How do I pull a report showing gift cards that were fully spent?"
• "Which active gift cards have been completely redeemed by customers?"
Tip: Check the Gift Card Age In Months column to spot patterns in how quickly customers use their gift cards — this insight can inform your expiration date policies and marketing timing.
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 Fully Redeemed Gift Cards
Quick Stats:
3 filter(s) applied
10 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
Report shows active gift cards that are fully redeemed but not expired, helping track completely used cards still valid in your system.
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: Fully Redeemed
📋 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.
Current Balance On Gift Card — The current balance 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.
ℹ️ Additional Details
Bookmark ID:
4fd79bc2-8a1e-4581-88d2-4e5784190739