📋 Summary:
This bookmark reveals all active, unexpired gift cards that have never been spent, providing a clear snapshot of potential unredeemed revenue sitting unused in the winery's system. Marketing and sales teams can use this report to craft targeted re-engagement campaigns, perhaps sending personalized emails to gift card recipients to encourage them to visit the tasting room or explore the winery's online offerings. The gift card data includes valuable details like recipient email, original purchaser information, and card balance, giving team members a strategic tool to understand dormant gift card opportunities and potentially convert these into actual wine sales. Users can easily customize this report by adjusting filters or columns to dive deeper into their specific gift card insights and tracking needs.
This summary was generated by AI.
📁 Public Bookmarks Folder: Business Reports/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
This reports lists the Gift Cards that were sold, are active, not expired, and that have a $0 spend on them.
🔻 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.
Buyer Name
Buyer Email
Gift Card From Name — The Name in the From Field when a gift card is gifted
ℹ️ Additional Details
📁 Public Bookmarks Folder: Business Reports/Gift Cards
🔑 Bookmark ID:
cad70c59-c2b4-48b9-a071-68b1b06cab49