📋 Summary:
This bookmark reveals a nuanced snapshot of partially redeemed gift cards that are still active and not expired, providing valuable insights into unrealized sales potential and customer engagement. For the marketing and sales teams, this report offers a strategic opportunity to create targeted communications that might encourage gift card holders to complete their redemption, potentially driving additional tasting room visits, website purchases, or wine club conversions. The gift card manager or marketing coordinator could use this data to design personalized re-engagement campaigns, send reminder emails, or develop special incentives that motivate customers to utilize their remaining gift card balance, ultimately converting dormant gift card value into actual wine sales. Users can easily customize this bookmark by adjusting filters or columns to drill deeper into specific gift card segments or timeframes, making it a flexible starting point for more detailed gift card performance analysis.
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 partially (but not 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: 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
📁 Public Bookmarks Folder: Business Reports/Gift Cards
🔑 Bookmark ID:
fc917add-f040-4db2-9bf9-adf401548457