Skip to main content

DTC Dimensions

Dimensions for DTC (Direct-to-Consumer) wine analytics

416 articles

C

Club Shipment Order Delivery MethodClub Shipment Order Delivery Method tracks how wine club orders reach customers through shipping, pickup.
Club Shipment Days Awaiting PickupClub Shipment Days Awaiting Pickup metric shows how many days wine club shipments have been ready at your tasting room but not collected.
Club Shipment Status DetailClub Shipment Status Detail shows specific wine club shipment statuses like Payment Declined, On Hold, Will Not Process, and Pending.
Customization ActionTarget wine club members who usually customize shipments but haven't for upcoming delivery, showing customization rates to prompt outreach.
Club Shipment CustomizationTrack club member shipment customization patterns showing upgrades, downgrades, or no changes compared to default package values.
Club Package Shipment Payment StatusCheck wine club shipment payment status values like Paid, Authorized, Cancelled, or Declined for consistent reporting and filtering.
Contact Historical Allocation TierContact Historical Allocation Tier tracks which allocation tier customers were assigned to during past periods using snapshot data.
Contact Allocation Tier Change DateContact Allocation Tier Change Date tracks the exact date when a customer's allocation tier changed to their current level.
Contact Days Since Allocation Tier ChangeContact Days Since Allocation Tier Change tracks days passed since customer tier adjustments to identify recent tier moves for follow-up.
Contact Allocation Tier Status ChangeContact Allocation Tier Status Change tracks customer progression between allocation tiers.
Contact Days Since POS Prediction CreatedTracks days since a customer's current "Sell More Now" tasting room visit prediction was created to measure targeting data freshness.
Club Shipment Sales AttributeClub Shipment Sales Attribute captures the specific sales attribute that gets linked to bulk club shipment orders.
Contact Previous Allocation TierContact Previous Allocation Tier tracks a wine club member's allocation level before their most recent tier change for comparison.
Club Package Item Max QuantityClub Package Item Max Quantity shows the maximum number of bottles members can select for each wine in their club package shipments.
Contact Days Since Web Purchase Prediction CreatedContact Days Since Web Purchase Prediction Created shows days elapsed since Sell More Now generated web purchase predictions for contacts.
Club Package Item Min QuantityClub Package Item Min Quantity sets minimum bottle requirements for each wine product in club packages that members must meet.
Contact Last Cancellation CommentsCaptures free-text notes from customers' most recent wine club cancellation including reasons like financial issues or dissatisfaction.
Contact Last Communication Date TimeTrack when each customer last communicated with your winery to identify inactive contacts needing re-engagement campaigns.
Campaign Unsubscribed Date TimeCampaign Unsubscribed Date Time shows exact timestamps when contacts opt out of marketing emails to track unsubscribe patterns.
Contact Days Since Last Personal InboundContact Days Since Last Personal Inbound tracks days since customers last called your winery directly, using staff-logged phone data.
Contact Days Since Contact Type CreatedShows days elapsed since specific contact types like VIP Customer were assigned to each contact in your customer database.
Contact Marketing List NameMarketing list names from email platforms like Klaviyo, Mailchimp, and RedChirp showing which audience segments contacts belong to.
Contact Marketing Text Delivery RateContact Marketing Text Delivery Rate shows percentage of SMS messages successfully delivered to each contact for database cleanup.
Contact Marketing Text Reply RateContact Marketing Text Reply Rate shows percentage of marketing SMS messages each contact replied to for measuring engagement.
Contact Communication Frequency RiskContact Communication Frequency Risk identifies customers at risk of communication fatigue or under-communication based on engagement data.
Campaign Unsubscribed DateCampaign Unsubscribed Date tracks when contacts opted out of marketing emails to analyze unsubscribe patterns and identify campaigns.
Contact Marketing Email CountContact Marketing Email Count shows total marketing emails sent to each contact to analyze engagement patterns and purchase behavior.
Contact Note TimestampContact Note Timestamp tracks exact date and time when staff create notes about customer interactions from tastings and wine clubs.
Contact Days Between Third And Fourth OrderShows days elapsed between customer's third and fourth purchases to analyze how buying patterns change as customers enter loyal buyer phase.
Contact Sku First Order DateContact Sku First Order Date tracks when each customer first purchased a specific wine or product SKU through completed orders.
Contact Historical Attrition ScoreContact Historical Attrition Score provides 0-100 risk ratings for customers declining from high-value segments to at-risk categories.
Campaign Send DateCampaign Send Date tracks when marketing campaigns were sent to recipients, showing both scheduled and actual delivery dates.
Club Shipment Quantity IncreasedClub Shipment Quantity Increased metric tracks additional bottles members add above their default wine club package allocation.
Contact Campaign List Subscription StatusShows whether contacts are opted-in to receive marketing emails from specific campaign lists based on recent subscription actions.
Campaign Opened Date TimeCampaign Opened Date Time captures exact timestamps when customers open marketing emails to analyze engagement patterns and timing.
Campaign Created AtCampaign Created At shows when marketing campaigns were set up, helping track planning timelines by comparing creation to send dates.
Contact Dominant Wine Name PctContact Dominant Wine Name Pct shows percentage of customer's total bottle purchases from their most-bought wine SKU to identify loyalists.
Campaign StatusCampaign Status tracks marketing campaigns through lifecycle stages like Draft, Scheduled, Sent, and Cancelled for progress monitoring.
Campaign Engagement ScoreCampaign Engagement Score measures customer engagement depth on a 0-5 scale across all marketing channels.
Campaign Sales AssociateTrack sales team performance in Enolytics campaigns by filtering results by individual sales associates to see engagement metrics.
Campaign Source CodeCampaign Source Code tracks which marketing system generated outreach with codes like 'klav', 'chimp', 'chirp', and 'enolytics'.
Contact Avg Days Between OrdersShows average days between all completed orders per customer to identify natural buying patterns and purchase frequency rhythms.
Campaign Source SystemCampaign Source System shows which email platform (Klaviyo, Mailchimp, RedChirp, Enolytics) sent campaigns to compare performance.
Contact Total Communcation Count 90 DaysTrack total marketing emails, texts, and direct mail sent to each winery contact over 90 days to identify communication fatigue.
Campaign Replied DateCampaign Replied Date tracks when customers respond to marketing campaigns, helping measure response timing and engagement patterns.
Club Shipment Total QuantityClub Shipment Total Quantity tracks final bottle counts delivered in wine club shipments after member customizations to packages.
Contact Marketing Text Replied CountContact Marketing Text Replied Count tracks how many marketing SMS messages each contact responded to for measuring engagement.
Contact Most Recent RFM Attrition ScoreContact Most Recent RFM Attrition Score identifies customers most likely to stop purchasing using recency, frequency, monetary data.
Contact Marketing Email Clicked CountContact Marketing Email Clicked Count tracks how many marketing emails each contact clicked, helping segment engaged subscribers.
Contact TR Days Since Last OrderTrack days since each customer's last tasting room purchase to identify recent visitors and follow up on winery experiences.
Contact F PercentileContact F Percentile ranks customers by purchase frequency from 0.0-1.0, showing how often they buy compared to your customer base.
Campaign Was OpenedShows whether email recipients opened your campaign using tracking pixels to measure engagement and identify active subscribers.
Campaign Resulted In SaleCampaign Resulted In Sale shows TRUE/FALSE for marketing touchpoints that directly led to purchases using last-touch attribution.
Club Shipment Items Added CountClub Shipment Items Added Count tracks how many extra products wine club members select beyond their standard allocation packages.
Contact Last Communication DateContact Last Communication Date metric shows when customers were last contacted via marketing campaigns or outreach for re-engagement.
Campaign TypeCampaign Type metric shows whether marketing campaigns were delivered via email or SMS to compare engagement rates between channels.
Contact SKU Order CountContact SKU Order Count tracks how many separate orders each customer placed containing a specific wine, measuring loyalty to wines.
Club Shipment Has Decreased ProductsClub Shipment Has Decreased Products metric identifies wine club members who reduced quantities below their standard package configuration.
Contact Most Recent Rfm Status Change DateContact Most Recent Rfm Status Change Date tracks when customers last moved between RFM segments like New to Loyal or At Risk.
Campaign Date TimeCampaign Date Time captures exact timestamps when marketing messages are sent, enabling analysis of response rates and sales.
Campaign Was RepliedCampaign Was Replied metric tracks which contacts sent SMS replies to your winery's RedChirp text campaigns for measuring engagement.
Contact Last Cancellation ReasonShows the specific reason each former wine club member gave when cancelling their most recent membership to identify common churn patterns.
Contact Marketing Platform NameContact Marketing Platform Name field shows full platform names like Klaviyo, Mailchimp, or RedChirp for filtering reports.
Contact NoteContact Note field stores staff notes about customer interactions, preferences, and requests for wine club and tasting room management.
Club Shipment Default ValueClub Shipment Default Value shows the baseline dollar value of each member's standard club package before customizations or taxes.
Contact Last Personal Inbound DateContact Last Personal Inbound Date tracks when customers last called your winery to help prioritize follow-ups with engaged customers.
Contact Text Marketing Consent StatusContact Text Marketing Consent Status shows customer SMS marketing preferences with opted-in, opted-out, or pending values for filtering.
Club Shipment Skipped CountTrack how many wine club shipments members have skipped with running totals that increase when releases are missed or actively skipped.
Completed Day NumberCompleted Day Number metric shows which day of the week (1-7, Monday-Sunday) orders were completed for analyzing sales patterns.
Club Shipment Has Added ProductsShows when wine club members add extra products beyond their standard shipment package versus keeping default contents only.
Contact Marketing Email Opened CountContact Marketing Email Opened Count tracks total marketing emails each contact opened to identify engaged subscribers and segment.
Club Shipment Calculated TotalClub Shipment Calculated Total shows the final charged amount for club shipments including products, shipping, taxes, and modifications.
Contact Marketing ResponsivenessContact Marketing Responsiveness measures customer engagement across email and text channels, requiring 5+ sends per channel to assess.
Contact Phone 2Contact Phone 2 field stores customers' secondary phone numbers for backup communications like club shipment alerts and event reminders.
Contact Phone 3Contact Phone 3 field stores customer's third phone number for backup contact strategies when primary numbers fail.
Club Shipment Is DowngradeShows TRUE when club members reduce shipment value below default by removing items, changing quantities, or substituting cheaper options.
Club Shipment Item Quantity Change StatusTrack club shipment wine quantity changes with status values like unchanged, increased, decreased.
Campaign Clicked DateCampaign Clicked Date tracks the exact date customers clicked marketing campaign links to analyze engagement timing and performance.
Campaign Hours Delivered To OpenedCampaign Hours Delivered To Opened metric shows hours between email delivery and first open to identify optimal engagement timing.
Contact Days Between Second and Third OrderTracks days between a customer's second and third purchases to identify buying patterns and momentum loss in converted customers.
Contact CRM Email StatusContact CRM Email Status shows each contact's email consent status - opted in, opted out, or pending - for filtering campaigns.
Campaign Hours Clicked To RepliedMeasures time in hours between SMS campaign link clicks and customer replies in RedChirp to track response speed for engaged customers.
Contact Multiple Upcoming Reservation DatesShows all upcoming tasting room and event reservation dates for each customer in chronological order to identify engaged visitors.
Contact Total Communication Count 365 DaysShows total marketing messages sent to each contact over 365 days to identify communication fatigue and adjust preferences.
Campaign Was DeliveredShows whether email or SMS marketing messages successfully reached recipients without bouncing back for delivery tracking and analysis.
Campaign Was ClickedCampaign Was Clicked shows whether customers clicked email links with TRUE/FALSE values to filter and analyze email engagement.
Contact Last Communication MethodTrack customer touchpoints by viewing the most recent communication type sent to each contact for targeted marketing campaigns.
Contact Second Wine Name PctShows percentage of customer's total purchases from their second most-purchased wine brand and varietal to measure buying diversity.
Club Shipment Items Increased CountShows how many different wines club members added extra bottles of beyond their default package quantities in each shipment.
Contact Marketing Email Open RateContact Marketing Email Open Rate shows the percentage of marketing emails each contact opened to identify engaged subscribers.
Contact Email Status Disconnect FlagContact Email Status Disconnect Flag finds CRM contacts with mismatched email marketing status between your system and Klaviyo or Mailchimp.
Campaign Delivered Date TimeTrack exact timestamps when marketing messages reach customers to optimize delivery timing, identify peak windows, and analyze delays.
Club Shipment Value Change From DefaultShows dollar difference between actual club shipment spend versus base package price to track member upgrades and downgrades.
Contact Marketing Text Delivered CountMarketing text message delivery count metric shows total SMS messages successfully delivered to each customer for engagement analysis.
Contact Days Since Most Recent RFM Status ChangeShows days since customer's RFM segmentation status last changed, tracking how long they've been in current recency, frequency.
Contact Days Since Last CommunicationShows days since each customer's last marketing communication or outreach to identify customers needing follow-up attention.
Contact Dominant Varietal PctContact Dominant Varietal Pct tracks the percentage of a customer's wine purchases from their most-bought varietal to measure loyalty.
Campaign Requested Call BackCampaign Requested Call Back field tracks which contacts requested callbacks from marketing campaigns to identify most engaging outreach.
Campaign Clicked Date TimeCampaign Clicked Date Time captures exact timestamps when links are clicked in email, social media, and digital marketing campaigns.
Contact Days Since Last Personal OutboundTracks days since staff personally contacted each customer via email, text, call, or voicemail to help prioritize VIP outreach efforts.
Campaign NoteCampaign Note captures actual note text from outreach entries in Enolytics for marketing campaigns, customer communications, and follow-ups.
Campaign Hours Opened To ClickedCampaign Hours Opened To Clicked tracks time between email opens and clicks to measure how fast subscribers engage with campaigns.
Campaign ArchivedCampaign Archived field shows if marketing campaigns are archived in your platform and helps filter inactive campaigns from analysis.
Campaign Has UnsubscribedCampaign Has Unsubscribed metric tracks if customers unsubscribed from marketing through specific campaign messages to identify issues.
Contact Email Suppression ReasonShows why customer email addresses are suppressed from marketing campaigns due to unsubscribes, bounces, or compliance blocks.
Campaign Requested Call Back DateTrack when customers request callbacks through marketing campaigns using communications log data to measure response timing.
Club Name At Time Of ReservationShows the specific wine club a guest belonged to when making their reservation for analyzing which memberships drive the most bookings.
Contact Web Days Since Last OrderShows days since customer's last website purchase to optimize email timing and target e-commerce buyers for wineries. Character count: 127.
Contact Completed Paid OrdersContact Completed Paid Orders shows total fully completed and paid orders per customer across wine club, website, and tasting room.
Contact Email Marketing Consent StatusShows email marketing consent status for contacts to filter campaigns and target only those with permission to receive marketing emails.
Campaign Has BouncedCampaign Has Bounced shows if marketing emails or texts failed delivery due to invalid addresses or blocked numbers for filtering.
Campaign Hours Sent To OpenedCampaign Hours Sent To Opened metric tracks time between email campaign delivery and first customer open to optimize send timing.
Club Order SequenceClub Order Sequence tracks chronological numbering of wine club shipments per customer, starting from 1, to isolate club data from orders.
Contact Last Communication SourceContact Last Communication Source tracks which vendor or platform sent the most recent marketing or personal outreach to each customer.
Contact Latest Allocation TierContact Latest Allocation Tier displays each customer's current tier status in your winery's allocation program for exclusive wines access.
Campaign Email Engagement ScoreCampaign Email Engagement Score rates customer interaction with emails on 0-5 scale: 5 for clicks, 3 for opens, 2 for delivered, 1 for sent.
Contact Days Since Most Recent Membership Risk Status ChangeShows days elapsed since a club member's risk status last changed, helping track recent movement between risk categories for wine clubs.
Club Shipment Sequence NumberClub Shipment Sequence Number tracks the chronological order of each wine club shipment per member, starting from 1.
Club Shipment Item Count StatusWine club shipment item count status tracks whether shipments have more, fewer, or same items compared to default packages.
Contact Marketing Email Click RateContact Marketing Email Click Rate measures percentage of marketing emails where contacts clicked URLs to identify engaged subscribers.
Campaign Hours Sent To ClickedCampaign Hours Sent To Clicked metric measures total hours from email or SMS send time until customer first clicks a message link.
Contact Marketing Text CountContact Marketing Text Count tracks total marketing texts sent per customer to segment by engagement levels and analyze volume correlations.
Contact Marketing Email Subscription FlagContact Marketing Email Subscription Flag shows if customers are subscribed to email marketing campaigns with true or false values.
Campaign Hours Sent To RepliedRedChirp SMS campaign metric tracking elapsed hours between message sent and customer reply to identify responsive segments.
Campaign NameCampaign Name field shows which marketing campaigns, email flows, or outreach initiatives your contacts are associated with or targeted by.
Club Shipment Value Change Percent From DefaultClub Shipment Value Change Percent From Default tracks percentage difference between actual club member spending and default package price.
Contact Days Between First Last OrderContact Days Between First Last Order metric calculates total days from a customer's very first purchase to most recent order span.
Contact Second Varietal PctContact Second Varietal Pct metric shows percentage of customer wine purchases from their second most-bought varietal for cross-selling.
Contact Days Between Fourth and Fifth OrderShows days between customer's fourth and fifth purchases to identify reorder patterns and buying windows for established loyalty analysis.
Contact Subscription TimestampContact Subscription Timestamp tracks the exact date and time when someone joined a specific marketing list through signup or enrollment.
Club Shipment Has Increased ProductsShows whether wine club members added extra products beyond their standard shipment allocation to identify engaged customers.
Campaign Was SentCampaign Was Sent is a boolean field showing if marketing messages were successfully dispatched from your platform for calculations.
Contact most recent RFM Status ChangeTracks the latest RFM milestone reached by each customer, showing progression through recency, frequency, and monetary segments.
Contact M PercentileContact M Percentile ranks customers by spending compared to your entire customer base using 2-year average order value from 0.0 to 1.0.
Campaign Communication SourceTrack which platform sent each marketing communication including Klaviyo, Mailchimp, RedChirp SMS, and Personal Outreach for staff messages.
Contact Total Communication CountContact Total Communication Count tracks lifetime marketing emails, texts, and messages sent to each customer for balancing outreach.
Club Shipment Quantity DecreasedClub Shipment Quantity Decreased tracks total bottles removed by wine club members below default allocations, shown as negative values.
Contact Last Personal Outbound DateTrack when your team last made personal contact with customers through phone calls, emails, texts, or voicemails.
Contact Preferred Communication ChannelContact Preferred Communication Channel metric shows each customer's Email or Text preference based on engagement history for segmenting.
Contact Most Recent Membership Risk Status Change DateTracks when wine club members' risk level changed between categories like Low to High, helping identify when customers became at-risk.
Campaign Bounced Date TimeCampaign Bounced Date Time tracks exact timestamps when marketing emails bounce back undelivered to analyze delivery failure patterns.
Campaign Bounced DateCampaign Bounced Date tracks the exact date email marketing messages bounce back undelivered for deliverability analysis and list cleaning.
Club Shipment Items Decreased CountClub Shipment Items Decreased Count tracks products where wine club members reduced bottle quantities during customization process.
Club Shipment Item QuantityClub Shipment Item Quantity shows actual bottles of each wine shipped to club members after customizations like adding or removing bottles.
Campaign Communication RatingCampaign Communication Rating shows numerical ratings for outreach messages in campaign tracking to evaluate effectiveness.
Club Shipment Is UpgradeClub Shipment Is Upgrade shows TRUE when club members spend more than default shipment value by increasing quantities or substitutions.
Contact Personal Inbound CountContact Personal Inbound Count tracks how many times each customer has personally called your winery during their relationship.
Contact Days Between First And Second OrderContact Days Between First And Second Order metric tracks elapsed time between customer's first and second purchases to analyze conversion.
Contact Most Recent Membership Risk Status ChangeTracks the most recent change in a contact's membership risk status, showing transitions like Low Risk to High Risk or High Risk to At Risk.
Club Shipment Shipping ChargeClub Shipment Shipping Charge metric tracks total shipping and handling fees for wine club orders to calculate profitability.
Contact Email 2Contact Email 2 field captures secondary email addresses like spouse or business emails for backup order confirmations and shipping updates.
Campaign Attributed Order TotalCampaign Attributed Order Total tracks dollar value of orders from marketing campaigns using 72-hour last-touch attribution for ROI.
Campaign Replied Date TimeCampaign Replied Date Time captures exact timestamps when customers reply to marketing campaigns to measure response timing.
Contact Membership Risk Follow Up NeededContact Membership Risk Follow Up Needed flag identifies wine club members with High or Very High churn risk who need immediate retention.
Contact Marketing Text Click RateContact Marketing Text Click Rate measures the percentage of marketing text messages that resulted in clicks on links for each contact.
Campaign Is EngagedCampaign Is Engaged metric shows TRUE for contacts who opened, clicked, or replied to marketing messages, FALSE for non-engaged recipients.
Club Shipment Quantity AddedClub Shipment Quantity Added tracks extra bottles members add beyond their base wine club allocation to measure upsell success.
Campaign Customer ActionCampaign Customer Action tracks the highest engagement level per customer in marketing campaigns: Sent, Opened, Clicked, Replied, Bounced.
Campaign Hours Sent To DeliveredCampaign Hours Sent To Delivered metric tracks elapsed time between email or SMS send and confirmed delivery to identify delays.
Club Shipment Shipped CountClub Shipment Shipped Count metric tracks total successfully delivered club orders per member, excluding missed shipments for analysis.
Contact Unsubscription TimestampContact Unsubscription Timestamp tracks the exact date and time when someone unsubscribed from marketing emails and how to use it.
Contact Sku Total QuantityContact Sku Total Quantity tracks lifetime bottles purchased per wine by each customer across all orders to identify devoted fans.
Contact Marketing Text Subscription FlagContact Marketing Text Subscription Flag shows true/false values for customer SMS marketing preferences to segment opt-in subscribers.
Club Status At Time Of ReservationClub Status At Time Of Reservation shows whether tasting room guests were wine club members or non-members when booking their visit.
Contact Recommended Outreach ChannelShows the best communication method for each customer - email, phone, SMS, or direct mail - based on their response patterns.
Campaign SMS Engagement ScoreCampaign SMS Engagement Score rates text message performance on 0-5 scale: delivered messages score 3, replies score 4, clicks score 5.
Contact Email 3Analyze gift orders and customer communication preferences using Contact Email 3 data for third email addresses and recipients.
Club Shipment Item Quantity ChangeClub Shipment Item Quantity Change tracks differences between bottles members received versus default club package quantities.
Club Shipment Item Default QuantityClub Shipment Item Default Quantity displays the original wine quantities wineries planned for club shipments before member customizations.
Campaign Sent DateTrack when marketing campaigns were sent to customers and filter by specific dates to analyze timing performance and seasonal trends.
Campaign Enagement SourceCampaign Engagement Source shows whether customer interactions came from campaigns, flows, or manual outreach with three source values.
Club Shipment Is SkippedWine club shipment skip tracking shows TRUE/FALSE values to identify members skipping scheduled deliveries and analyze retention risks.
Contact SKU Last Order DateShows the most recent purchase date for each wine or product by customer, creating detailed product-level buying patterns.
Campaign Opened DateCampaign Opened Date tracks when customers opened marketing emails to analyze engagement timing and campaign performance patterns.
Contact Marketing Text Clicked CountShows total count of marketing text messages each contact clicked links in to measure text engagement and segment customers by activity.
Contact Total Communication Count 30 DaysShows how many marketing emails, texts, and promotional messages each contact received in the past 30 days to identify over-communication.
Campaign Hours Delivered To ClickedCampaign Hours Delivered To Clicked tracks time from email delivery to first click, showing response speed for engaged recipients.
Campaign Delivered DateTrack when marketing messages were successfully delivered to customers and analyze delivery timing patterns to optimize send dates.
Completed Date/Time
Completed Hour AM/PM
Channel GroupChannel Group maps sales channels into custom categories for standardized DTC reporting across multiple sub-channels and locations.
Contact Second Wine YTDIdentifies which specific wine each customer purchased second most this year to create cross-selling opportunities and targeted promotions.
Contact Risk of LeavingContact Risk of Leaving predicts wine club member cancellation likelihood with ratings from Very Low to Very High for retention analysis.
Contact Loyalty TierTrack customer loyalty tiers to segment audiences for targeted campaigns with tier-appropriate messaging and offers based on program level.
Contact Loyalty PointsView customer loyalty point balances to segment members by points earned and create targeted campaigns for high-point holders.
Contact Second Wine Last 12 MonthsTrack each customer's second most frequently purchased wine variety over the past 12 months to identify cross-selling opportunities.
Channel LocationChannel Location shows sales channel data with point-of-sale locations.
Contact Dominant Wine Last 12 MonthsShows each customer's most frequently purchased wine over the past 12 months to identify popular bottles and understand demand patterns.
Contact Dominant Wine YTDShows each customer's most-purchased wine this year to personalize recommendations, club shipments, and campaigns based on preferences.

D

Days Since ReservationTrack days between today and past tasting room reservation dates to analyze guest follow-up timing and visitor engagement patterns.
Days Till ReservationDays Till Reservation metric calculates remaining days until future reservations to help prioritize pre-visit outreach and preparation.
Days Since Previous Allocation OrderTrack timing gaps between wine club allocation orders by measuring days since a customer's previous shipment delivery.
Days Since Previous Club OrderDays Since Previous Club Order metric shows days between current and previous member orders to track shipping cycles and delays.
Days Since Previous Web OrderShows days between a customer's current and previous website orders to identify purchasing patterns and track online customer rhythm.
Days Since Previous POS OrderDays Since Previous POS Order shows the number of days between a customer's current tasting room visit and their last tasting room visit.
Days Since Previous OrderDays Since Previous Order metric tracks time gaps between customer orders, showing NULL for first-time buyers and 0 for same-day purchases.
Days Since Suggested RecommendationDays Since Suggested Recommendation tracks calendar days passed since each recommendation was generated for filtering fresh content.
Days Since Last Marketing EmailShows days since each contact's last marketing email to identify communication gaps and contacts missing recent winery outreach.
Days Since Contact SKU Last OrderThis metric calculates days since a customer last purchased each specific wine or product to identify reorder opportunities.
Days First Order To First MembershipDays First Order To First Membership metric measures how long it takes buyers to convert into wine club members after their first purchase.
30-Day Inventory ReceivedShows total bottles added to inventory in past 30 days from production, transfers, and receipts to compare against sales velocity.
Days Since Last Marketing TextDays Since Last Marketing Text tracks how many days passed since a contact received their last SMS, helping wineries optimize timing.
Days Sales InventoryDays Sales Inventory shows how many days current wine inventory will last based on sales velocity to prevent stock-outs.
Days Cancel to RejoinShows days between wine club cancellation and rejoining for returned customers to identify valuable boomerang members and patterns.
Days Since Membership Risk ChangeTrack when customer membership risk status last changed to identify recently flagged at-risk members and monitor membership health trends.
Days Since RFM Risk ChangeDays Since RFM Risk Change tracks how many days passed since a customer's RFM risk status last changed between segmentation categories.

I

Inventory 6-Month Average Daily Sales RateShows daily wine bottle sales averaged over 6 months to track velocity and smooth fluctuations for better inventory planning.
Inventory Forecast Exclusion ReasonWhy certain SKUs don't have projected runout dates, including reasons like insufficient sales history or no wine name assigned.
Inventory Tracking DaysInventory Tracking Days metric shows how many days you've tracked inventory for each product from first recorded date to yesterday.
Inventory SKU Runout UrgencyInventory SKU Runout Urgency categorizes wine SKUs by stock levels from Out of Stock to OK, showing days until runout for planning.
Inventory Period LabelInventory Period Label shows time descriptions like "30 days" or "365 days" for filtering inventory reports by specific timeframes.
Inventory Turnover RatioInventory Turnover Ratio calculates how many times inventory is sold and replaced by dividing sales by average inventory levels.
Inventory Period (Days)Inventory Period report shows how long products have been tracked in your system, grouping items into 30 to 366-day buckets.
Inventory Period Average InventoryShows mean inventory quantity maintained during tracking period for each product and inventory pool to calculate turnover rates.
Inventory Weeks of StockInventory Weeks of Stock metric shows how many weeks your current wine inventory will last based on recent average weekly sales velocity.
Inventory Units AllocatedShows quantity of wine bottles committed to customer orders but not yet fulfilled or picked up, reducing available inventory.
Inventory Average Weekly SalesInventory Average Weekly Sales metric shows typical units sold per week per product from sales history for demand forecasting and planning.
Inventory Velocity TrendInventory Velocity Trend compares 3-month wine sales patterns to 12-month baselines to identify accelerating, stable, or slowing wines.
Inventory 12-Month Average Daily Sales RateInventory 12-Month Average Daily Sales Rate shows average bottles sold per day for each wine over 12 months across all channels.
Inventory ReceivedInventory Received metric shows total units received into inventory from production runs, transfers.
Inventory Period SalesShows total units sold per product during inventory periods from paid orders to calculate sell-through rates and track customer demand.
Inventory 30-Day SalesReal-time view of bottles sold across all DTC channels in the last 30 days to calculate inventory velocity and weeks remaining.
Inventory Units DepletedInventory Units Depleted metric tracks total bottles removed from inventory through sales, tastings, breakage, staff consumption.
Is Deleted ContactIdentifies reconstructed customer records where original contact was deleted from CRM but order history remains, showing true/false values.
Inventory Previous Day Units ReservedShows bottles reserved for wine clubs, events, and special allocations as of previous day to track inventory changes and allocation timing.
Inventory Units ReservedTrack inventory units reserved for wine club shipments, events, and allocation programs held outside general sales inventory.
Inventory Previous Day Units in InventoryInventory Previous Day Units in Inventory metric shows total bottle count on hand as of yesterday's close of business before sales.
Inventory Cost of GoodsInventory Cost of Goods calculates total production costs for all units in stock by multiplying unit cost times quantity on hand.
Inventory Previous Day Units AllocatedInventory Previous Day Units Allocated shows bottles committed to unfulfilled orders yesterday for comparing allocation trends.
Inventory 3-Month Average Daily Sales RateCalculate average daily wine bottle sales over 3 months across all DTC channels including club, website, and tasting room data.
Inventory Beginning Of Month StockInventory Beginning Of Month Stock shows quantity of each product on hand at start of calendar month before sales or movements occur.
Inventory StatusInventory Status filter shows current inventory data from yesterday versus historical data for making reorder decisions.
Inventory Sell Through PercentageInventory sell through percentage calculates what portion of available wine inventory sold by dividing units sold by total available units.
Inventory ValueShows total dollar value of wine inventory by multiplying units in stock by cost per unit to track capital tied up in unsold wine.
Inventory Previous Day DepletedInventory Previous Day Depleted metric shows units sold or removed the day before inventory date to track daily sales velocity.

L

Last Marketing Email Sent DateShows the date of the most recent automated marketing email sent to each contact to identify engagement gaps and improve segmentation.
Last Marketing Text Replied Date TimeTimestamp showing when a contact last replied to marketing text messages from the winery, useful for identifying engaged subscribers.
Last Marketing Email Clicked DateShows when each contact last clicked a marketing email link to help identify engaged subscribers and segment active email audiences.
Last Marketing Text Clicked Date TimeTracks when customers most recently clicked links in SMS marketing campaigns to identify engaged customers and timing patterns.
Last Marketing Email Sent Date TimeTrack when each contact last received marketing emails to identify customers needing re-engagement and analyze email frequency patterns.
Last Marketing Email Clicked Date TimeCaptures exact timestamp when a contact last clicked a marketing email to track engagement recency and identify most active subscribers.
last marketing email Opened Date TimeTracks exact date and time when contacts last opened marketing emails to analyze engagement recency and identify inactive subscribers.
Last Marketing Text Date TimeShows when each contact last received a marketing text message to filter by recent SMS engagement and segment contacts by text activity.
Last Marketing Email Opened DateShows when contacts last opened marketing emails from your winery to segment customers by engagement and identify responsive subscribers.
Last Marketing Text Clicked DateTrack when customers last clicked links in your winery's SMS marketing messages to measure text campaign engagement and effectiveness.
Last Marketing Text DateShows the date each contact last received a marketing text message, helping wineries filter and segment customers by recent SMS engagement.
Last Marketing Text Replied DateFilter customers by last marketing text reply date to find highly engaged segments and create targeted SMS campaigns for your winery.

M

Membership Total Declined ShipmentsShows total declined shipments per wine club membership due to payment failures, available for wineries using detailed tracking systems.
Membership Primary Risk ReasonIdentifies the main factor putting wine club members at risk of churning like declining purchases or payment issues for targeted retention.
Membership Estimated Skipped ShipmentsMembership Estimated Skipped Shipments tracks how many wine club deliveries members skip to identify engagement patterns and revenue loss.
Membership Cycles OverdueWine club shipments past their expected delivery date are tracked per member to identify delays and maintain customer relationships.
Membership Typical Weeks Between ShipmentsMembership Typical Weeks Between Shipments metric shows standard intervals between wine club shipments, ranging 6-12 weeks by winery.
Membership Retention LevelMembership Retention Level prioritizes wine club customers by cancellation risk and retention value using High Priority and At Risk labels.
Mailchimp Average Open RateMailchimp Average Open Rate field shows historical email engagement data for each contact to help segment subscribers and target campaigns.
Mailchimp Member RatingMailchimp Member Rating displays subscriber engagement on a 1-5 scale to identify highly engaged customers and low-engagement contacts.
Membership Shipment Cycle PhaseTrack where wine club members are in their shipment cycle to identify who's due for deliveries, just received shipments, or between cycles.
Membership Retention Priority LevelMembership Retention Priority Level categorizes wine club members by importance for retention campaigns and targeted outreach efforts.
Marketing Flow Source SystemMarketing Flow Source System displays the full platform name (Klaviyo, Mailchimp, or RedChirp) managing your flow data instead of codes.
Marketing List Is ArchivedShows how to check if marketing lists are archived or active, filter by archive status, and understand why archived lists stay for history.
Marketing List Updated AtMarketing List Updated At shows timestamps when marketing lists were last modified, tracking changes to list properties, names.
Marketing List TypeUnderstand marketing list types to identify which campaigns use static lists requiring manual updates versus dynamic lists that auto-update.
Marketing Flow NameMarketing Flow Name shows automated campaign names like Welcome Series, Abandoned Cart Recovery, and Pre-Arrival Notifications.
Membership Acquisition ChannelMembership Acquisition Channel metric shows which channels customers used to join your wine club and helps evaluate channel effectiveness.
Membership Total ShippedShows how many wine club shipments were delivered to each member, excluding skipped orders.
Membership Last Shipment StatusMembership Last Shipment Status tracks each wine club member's most recent shipment with values like Shipped, Declined, or Skipped.
Membership Avg Value Δ% From DefaultShows percentage difference between actual membership spending and default package values to track member upgrade patterns.
Membership Total Customized ShipmentsTracks how many times wine club members customized their shipment value by upgrading to premium bottles or downgrading to spend less.
Membership Total ShipmentsMembership Total Shipments metric tracks cumulative count of all scheduled wine club package shipments including shipped and skipped.
Membership Estimated Club ShipmentsShows estimated wine club shipment counts per membership by analyzing paid orders when detailed shipment data isn't available.
Membership Total UpgradesMembership Total Upgrades metric tracks wine club shipments where members spent above their default package value through customization.
Membership Total SkippedShows total shipments skipped by each member throughout their entire membership history for identifying skip patterns and engagement.
Membership Downgrade RateMembership Downgrade Rate tracks percentage of wine club shipments where members received lower-value packages than their default selection.
Membership Upgrade RateMembership Upgrade Rate shows the percentage of shipments where members chose premium options beyond their base wine club level.
Membership Shipment ActionMembership Shipment Action identifies wine club members as upgrade or downgrade candidates based on shipment modification patterns.
Membership Customization RateMembership Customization Rate measures percentage of wine club shipments customized by members versus accepting default.
Membership Total DowngradesMembership Total Downgrades counts how many times club members received shipments worth less than their default package value.
Membership Skip RateMembership Skip Rate measures the ratio of skipped to total shipments for wine club members, ranging from 0.0 to 1.0 to identify engagement.
Membership Year Month SortMembership Year Month Sort field uses YYYYMM integer format (202401) for proper chronological sorting of wine club membership data.
Mailchimp Average Click RateMailchimp Average Click Rate metric shows historical email click rates for winery campaigns to identify most engaged subscribers.
Marketing Flow Updated AtMarketing Flow Updated At tracks when automation flows were last modified in CRM, helping identify recently optimized marketing flows.
Marketing Campaign Hours Before OrderMarketing Campaign Hours Before Order metric shows the 0-72 hour time gap between marketing messages and customer purchases.
Marketing Flow TypeMarketing Flow Type identifies whether your automation flows use email or SMS channels to compare performance and conversion rates.
Marketing List Member CountMarketing List Member Count shows total active subscribers on your marketing list, helping track reach growth trends and identify attrition.
Marketing Channel TypeMarketing Channel Type field shows whether outreach used email or SMS, helping compare campaign performance between channels.
Marketing Flow StatusMarketing Flow Status shows whether each marketing automation is in draft, manual, or live mode and helps filter active flows.
Marketing List Opt-In ProcessTrack and filter email contacts by single opt-in immediate signup versus double opt-in email verification to analyze engagement differences.
Marketing List Created AtMarketing List Created At shows timestamps when each marketing list was created in Klaviyo, Mailchimp, or RedChirp to audit list age.
Marketing Flow Trigger TypeMarketing Flow Trigger Type identifies what event starts automated marketing flows: joining lists, entering segments, purchases, or dates.
Marketing Flow Created AtTracks timestamp when marketing automation flows were originally built in your platform to analyze campaign development timelines.
Marketing Flow Is ArchivedMarketing Flow Is Archived shows if automation flows are archived or active, helping filter current campaigns from retired ones.
Marketing List Source SystemMarketing List Source System shows which platform hosts subscriber lists like Klaviyo, Mailchimp, or RedChirp for performance tracking.
Marketing List NameMarketing List Name field contains descriptive names for subscriber lists like Wine Club Members for customer segmentation and targeting.

O

Order On Club Signup DateOrder On Club Signup Date tracks whether wine club orders happened on the same day customers enrolled, measuring conversion rates.
Order Marketing Attribution Sent AtShows exact timestamp when marketing message leading to an order was sent, helping track customer journey from touchpoint to purchase.
Order URLOrder URL provides direct links from reports back to full order records in your CRM system for investigating specific order details.
Order Has Marketing AttributionShows whether orders can be traced to specific marketing touchpoints like email campaigns or flows within 72 hours before purchase.
Order Marketing Attribution Marketing SystemOrder Marketing Attribution tracks which marketing automation platform like Klaviyo, Mailchimp, or RedChirp drove each order.
Order Marketing Attribution Sent DateOrder Marketing Attribution Sent Date tracks when marketing messages that led to orders were sent to customers for analyzing effectiveness.
Order Marketing Attribution Time RangeOrder Marketing Attribution Time Range tracks customer response times to marketing campaigns within 72 hours before purchase orders.
Order Marketing Attribution Marketing ChannelOrder Marketing Attribution Marketing Channel tracks whether sales came from email or SMS campaigns to compare performance and revenue.
Orders Before First MembershipOrders Before First Membership tracks how many paid purchases a customer made as a non-member before joining their first wine club.
Orders Before RejoinOrders Before Rejoin metric tracks paid orders customers made between cancelling and rejoining their wine club membership.
Order Marketing Attribution Campaign NameShows which specific marketing campaign or automated email flow drove each order to compare revenue performance across campaigns.

R

Reservation Number linked to OrderTrack which tasting room reservation numbers convert to actual purchases by linking booking confirmation numbers to visit orders.
Reverse Club Order SequenceClub shipment order count numbered backwards from most recent (1=latest, 2=second most recent) to identify customer patterns.
Reservation Transaction TypeReservation Transaction Type categorizes tasting room bookings as Regular, Refunds, Corporate Orders, Pickup To Ship.
Reverse Website Order SequenceReverse Website Order Sequence metric assigns numbers to eCommerce orders counting backward from most recent purchase (1, 2, 3, etc).
Reservation Membership CategoryReservation Membership Category tracks wine club status for tasting room guests: current members, non-members, new signups.
Reverse Allocation Order SequenceReverse Allocation Order Sequence numbers each customer's allocation wine orders in reverse chronological order from most recent.
Reservation TimeReservation Time tracks scheduled start times for tasting room visits to analyze peak hours, optimize staffing, and boost performance.
Reservation Question AnswerCaptures guest responses to custom questions during tasting room reservations like wine preferences, celebrations, and requests.
Reservation Close Out TimeReservation Close Out Time captures when tasting room visits end and tracks visit duration by comparing departure times to start times.
Reservation Check In Time PeriodReservation Check In Time Period metric shows guest arrival patterns by morning (AM) or afternoon/evening (PM) without specific times.
Reservation TagReservation Tag tracks labels from Tock or Commerce7 booking systems to categorize guests by VIP status, wine club membership, visit type.
Reservation Tag TypeFilter reservation tags by type to organize guest characteristics, visit details, and manual staff notes for better data analysis.
Reservation TypeReservation Type metric categorizes tasting room bookings by format like private tastings, group experiences, and events to compare revenue.
Reservation Booking OwnerReservation Booking Owner tracks which staff member created each reservation to monitor performance and balance workload distribution.
Reservation End Date TimeTracks exact scheduled end times for tasting room reservations to analyze capacity, scheduling patterns, and experience duration.
Reservation Start Date TimePeak tasting room reservation patterns by day and time, optimizing staffing and capacity using exact scheduled start date time data.
Reservation Time 24HrReservation Time 24Hr shows tasting room reservation start times in 24-hour format to identify peak hours and optimize staffing.
Reservation Close Out Time PeriodReservation Close Out Time Period tracks whether tasting room guests finish visits in AM or PM to analyze spending patterns and behaviors.
Reverse Tasting Room Order SequenceReverse Tasting Room Order Sequence numbers wine club member visits in reverse chronological order with 1 as most recent visit.
Reservation Visit TagsReservation Visit Tags track descriptive labels like VIP, Anniversary, or Large Group assigned to tasting room bookings in Tock systems.
Reservation Supplements CostTracks cost of goods sold for tasting room add-ons like cheese pairings, extra pours, and merchandise to calculate gross margins.
Reservation Supplements Price Per GuestReservation Supplements Price Per Guest metric shows per-person costs for tasting room add-ons like cheese pairings and premium tastings.
Reservation NameTrack guest reservations by name to identify frequent visitors, analyze booking patterns, and filter reservation records.
Reservation Days Since Last VisitReservation Days Since Last Visit metric shows the gap between a guest's upcoming tasting room reservation and their last visit.
Reservation QuestionCaptures custom tasting room reservation questions like special occasions and wine preferences to gather guest visit information.
Reservation Last Visit DateReservation Last Visit Date tracks the most recent tasting room visit before a current reservation to identify repeat customers.
Reservation Question OrderReservation Question Order shows sequential question positions in booking forms, helping identify guest drop-off points by position.
Reservation Supplements SKUReservation Supplements SKU tracks product identifiers for add-ons like food pairings and premium tastings purchased with reservations.
Reservation Guest TagsReservation Guest Tags show descriptive labels from Tock like VIP status, wine preferences, dietary restrictions, and celebrations.
Reservation LocationReservation Location identifies which specific tasting room or venue hosted each Tock reservation for multi-location wineries.
Rejoined MembershipRejoined Membership metric identifies customers who cancelled their wine club membership, took a break, then signed up again later.

S

Suggestion Created DateSuggestion Created Date tracks when a product first appeared in a contact's top-3 recommended purchases from recommendation engine.
Shipment Is Expected To Be CustomizedShows which wine club members usually customize 50%+ of shipments but haven't customized their upcoming shipment for targeted reminders.
Suggested Recommendation CategorySuggested Recommendation Category tracks wine recommendation types like Next Vintage, Buy Again, and Similar Tastes to measure performance.
Shipping TotalShipping Total metric tracks actual shipping charges customers paid per order, including $0 for free shipping, to analyze revenue impact.
Sub TotalSub Total metric shows net sales amount per order excluding shipping, taxes, tips and deposits to analyze pure product revenue.
Suggested Recommendation Generated AtSuggested Recommendation Generated At shows timestamps when ML models created personalized product recommendations for customers.
Suggested Final Confidence ScoreMachine learning and business rules create a 0-1.0 recommendation confidence score, with 0.75 meaning 75% confidence in product suggestions.
Suggested Wine PriceShows original list prices of recommended wines before discounts to help compare against transaction amounts and analyze pricing strategies.
Suggested Next Wine VarietalShows recommended grape varietals like Cabernet Sauvignon, Pinot Noir, and Chardonnay for each wine club customer based on preferences.
Suggested Recommendation RankSuggested Recommendation Rank shows the priority order (1, 2, or 3) of product recommendations for each customer.
Suggested Wine Product NameTracks performance of specific wines and vintages using complete product names from your CRM including vintage year and wine name.
Suggested Max RevenueSuggested Max Revenue shows the full revenue ceiling for product recommendations without conversion probability factoring in pricing.
Suggested Recommendation TypeSuggested Recommendation Type shows which strategy identified a product match for customers using vintage, repurchase.
Suggested Expected BottlesShows predicted bottle quantities customers will buy based on their purchase history and recommendation type for revenue forecasting.
Suggested Revenue FactorSuggested Revenue Factor shows the realistic conversion probability for each recommendation.
Suggested Confidence LevelSuggested Confidence Level converts recommendation scores into five categories (Very High to Very Low) to identify purchase likelihood.
Suggested Next Wine SKUProvides the exact SKU code for each customer's recommended next wine purchase from your CRM for precise inventory matching.
Suggested Recommendation ReasonGet plain-language explanations for why specific wines were recommended to customers, including purchase history and repurchase timing.
Suggested Base Conversion RateSuggested Base Conversion Rate shows baseline phone outreach percentages by strategy, from 15% preference-based to 35% vintage continuation.
Submitted Week NumberShows calendar week (1-53) when orders were placed to track weekly performance, marketing campaign impact, and seasonal patterns.
Signup On Day Of TastingSignup On Day Of Tasting metric tracks whether wine club visitors joined during their tasting room visit, measuring immediate conversions.
Suggested Expected RevenueSuggested Expected Revenue shows probability-weighted revenue forecasts using product price, expected bottles sold, and conversion rates.
Suggested Next Wine VintageSuggested Next Wine Vintage displays recommended vintage year for customer's next purchase based on inventory levels and buying history.
Suggested Next Wine NameShows the specific wine the recommendation engine suggests as each customer's best next purchase based on buying patterns and preferences.

W

Wish Item Days to First GrantWish Item Days to First Grant metric tracks days between customer adding item to wish list and winery's first fulfillment of request.
Wished YearWished Year shows the year each wish list item was created to help track customer demand trends and allocation program momentum over time.
Wine Name Avg Daily Sales 6MShows average bottles sold per day for each wine over past 6 months to identify consistent performers and slow movers for inventory.
Wish Order NumberWish Order Number provides unique identifiers for customer wish lists, enabling tracking and analysis from creation to fulfillment.
Wine Name Seasonality IndexWine Name Seasonality Index reveals each wine's monthly sales multiplier to optimize inventory planning and predict demand patterns.
Wish CasesWish Cases metric converts customer wish list items to 9-liter equivalent cases for production planning and inventory allocation decisions.
Wished DateShows the calendar date when items were added to customer wish lists to track seasonal trends and measure conversion rates.
Wine Name Adjusted Daily RateWine Name Adjusted Daily Rate shows 12-month average daily sales for each wine adjusted for seasonal patterns using multipliers.
Wish Item Aggregated DepartmentWish Item Aggregated Department groups product departments like red wine, white wine, and rosé into broader reporting categories.
Wine Name Avg Daily Sales 3MShows average bottles sold per day for each wine over 3 months to identify fast-moving inventory versus slow sellers on shelves.
Wish Is Zero DollarShows whether wish list items have $0 value for complimentary products, promotional giveaways, or special allocations without pricing.
Website Order SequenceWebsite Order Sequence tracks sequential numbering of each customer's online purchases starting at 1, helping identify first-time buyers.
Wish Granted Order CountWish Granted Order Count tracks how many separate orders fulfilled items from a specific wish list for analyzing fulfillment patterns.
Wine Name Velocity TrendWine Name Velocity Trend compares 3-month recent sales to 12-month averages, showing if wines are accelerating, slowing, or stable.
Wish Item Granted CasesTracks 9-liter equivalent cases fulfilled from customer wish lists, standardized across bottle formats for volume analysis.
Wish Item Remaining CasesWish Item Remaining Cases tracks how many 9-liter equivalent cases from a customer's original wish list request are still unfulfilled.
Wish Item Granted In OrdersWish Item Granted In Orders displays specific order numbers where wish list items were fulfilled across multiple wine shipments.
Wished MonthWished Month metric shows which month (1-12) customers added items to wish lists, helping track seasonal patterns and time wine releases.
Wish Year Month NameWish Year Month Name field shows when customers added items to wish lists in "YYYY Month" format for tracking seasonal trends.
Wine Name Avg Daily Sales 12MWine Name Avg Daily Sales 12M report shows average bottles sold per day for each specific wine over the past 12 months performance.
Wish Item Days PendingWish Item Days Pending shows how many days each wish list item has been waiting to be fulfilled.
Wish TimestampWish Timestamp tracks exact date and time customers add items to wish lists for analyzing browsing patterns and purchase intent.
Wish Item Average Granted PriceWish Item Average Granted Price metric shows the average price customers actually paid for fulfilled wish list items versus original prices.
Wish Has Any GrantsShows if customers received at least one item from their wish list through orders, helping identify partially fulfilled requests.