📋 Summary:
This bookmark reveals all gift cards that have been completely used up while remaining active and not expired, providing a clear snapshot of gift card redemption patterns across the winery's sales channels. For the marketing and finance teams, this report offers valuable insights into customer gift card behavior, helping track how effectively these promotional instruments are being utilized and potentially identifying opportunities for future gift card strategies or customer engagement campaigns. The Fully Redeemed Gift Cards report gives wine club managers and tasting room staff a precise view of which gift cards have been entirely spent, which could inform targeted follow-up communications or special offers to those customers. Users can easily customize this bookmark by adjusting filters or columns to drill deeper into their specific gift card analytics and create a personalized version that best serves their business intelligence needs.
This summary was generated by AI.
📁 Public Bookmarks Folder: Business Reports/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
A list of gift cards that meet three criteria: currently active, not past their expiration date, and have been fully redeemed.
🔻 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
📁 Public Bookmarks Folder: Business Reports/Gift Cards
🔑 Bookmark ID:
4fd79bc2-8a1e-4581-88d2-4e5784190739