Platform: Enolytics DTC
Summary:
What it shows: A complete list of gift cards that are still in play but have been partially used by customers. This report shows gift cards that meet three specific criteria: (1) currently active status, (2) not past their expiration date, and (3) have some remaining balance after partial redemption. It's a ready-made report that gives you immediate visibility into gift cards that customers are likely to use again.
Who should use it:
• Customer service teams handling gift card inquiries
• Marketing teams planning gift card reminder campaigns
• Operations managers tracking gift card liability
When to use it:
• Creating targeted email campaigns to encourage customers to use remaining gift card balances
• Reviewing outstanding gift card liability for financial reporting
• Following up with customers who started using their gift cards but haven't finished
Questions this report answers:
• "How do I find gift cards that customers have used but still have money left on them?"
• "Can I get a list of active gift cards with remaining balances to follow up on?"
• "Where can I see which gift cards are partially redeemed so I can remind customers to use them?"
• "How do I pull a report showing gift cards that aren't expired but have been partially spent?"
• "Which gift cards should I include in a 'don't forget your remaining balance' email campaign?"
Tip: Use the Gift Card Age In Months column to prioritize follow-up — older partially used gift cards may need more urgent attention to encourage full redemption before customers forget about them.
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 Partially 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
Displays active gift cards with remaining balances after partial use, showing cards not expired with available credit for future purchases.
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: Partially 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.
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:
fc917add-f040-4db2-9bf9-adf401548457
