π 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
