Skip to main content

Enolytics DTC Release Notes

Enolytics DTC release notes that are updated on with each release

Updated this week

v25.12.11 - December 11th 2025

New

Pitch These Wines (part of Sell More Now! Module)

Pitch These Wines uses machine learning to identify the perfect wine recommendations for each customer—turning your data into dollars.

The system analyzes purchase patterns across five intelligent strategies:

· Next Vintage – Customers ready for the latest release of wines they already love

· Buy Again – Repurchase opportunities flagged before customers lapse

· Similar Tastes – New wines matched based on what similar buyers enjoy

· In Your Price Range – Suggestions aligned to their spending comfort zone

· Your Favorite Grape – Undiscovered wines in their preferred varietals

Each recommendation comes with a confidence score so your team knows exactly which bottles to pitch first. Gift purchases are automatically excluded to ensure suggestions reflect true personal preferences.

The result: Less guessing, more closing—with data-backed recommendations that feel personal to every customer.

Who are My Prospects? (part of Contacts Module)

List you prospects (those who have never bought before)

Column Pinning

Most tables now have anchored columns, and you can pin additional columns as needed. To pin a column, hover over its header and click the pushpin icon. Pinned columns appear to the right of the default frozen columns.

A few things to note:

  • When you unpin a column, it won't return to its original position—you'll need to move it back manually.

  • Pinning is session-based and resets when you reload Enolytics.

Major Improvements to Associative Filtering

Associative Filtering Now Supports All Dimensions You can now use any dimension in Associative Filtering, making this feature even more powerful.

Associative filters let you ask advanced business questions based on relationships between different entities in your data. For example:

  • Find customers who purchased Cabernet but not Chardonnay

  • Find wines sold in the tasting room this month or through the wine club last month

  • Find members who attended an event and made a purchase within 30 days

Unlike standard filters that narrow your view to only the filtered criteria, associative filters let you see all information about the resulting population—giving you the full picture of those customers, orders, or products.

Associative filters are easy to edit and can be saved for repeated use.

New Dimensions

Contact Loyalty Tier

The contact's current tier in the CRM loyalty program. You can find this dimension in Build Beyond Limits.

Contact Loyalty Points

The contact's current point balance in the CRM loyalty program. You can find this dimension in Build Beyond Limits.

Contact Risk of Leaving

The contact's overall risk of leaving, based on their membership data. For customers with multiple memberships, this reflects the highest risk score among them. This field exists at the contact level to avoid duplicate rows in tables, since contacts and memberships have a one-to-many relationship. You can find this dimension in Build Beyond Limits.

Days Since RFM Risk Change

The number of days since the customer's RFM risk level last changed. RFM (Recency, Frequency, Monetary) risk tracks changes in purchasing behavior. A recent change may indicate a customer trending toward churn (if risk increased) or re-engagement (if risk decreased). Use this to prioritize outreach to customers whose risk level recently shifted. You can find this dimension in Build Beyond Limits.

Days Since Membership Risk Change

The number of days since the customer's membership risk level last changed. Membership risk is based on engagement signals like skipped shipments, buying behavior, purchases outside the club, and timeline within the customer journey. A recent increase may indicate a member at risk of cancellation, while a decrease suggests renewed engagement. Use this to trigger retention efforts before at-risk members cancel. You can find this dimension in Build Beyond Limits.

Channel Location

This is for Commerce7 Customers only.

The physical or logical point of sale where the order originated. For tasting room orders, this displays the specific C7 POS Profile (e.g., "Main Tasting Bar", "VIP Room", "Patio"). For non-tasting room orders (online, club, phone, etc.), this displays the sales channel name. This field is useful for tracking sales performance by location within a tasting room or by channel for remote orders.

Channel Group

An additional mapping layer that sits alongside the existing Order Type, Channel, and Channel Type hierarchy. Some wineries use Channel Group to create separate reporting structures for parent organizations while keeping their operational mappings intact in the standard hierarchy.

Both Channel Location and Channel Group can be found in Build Beyond Limits, the KPI Dashboard and How Much Did We Sell Page of the Sales Module

Rejoined Membership

Flag to indicate that the membership is for a customer who had a lapsed membership before. You can find this dimension in Build Beyond Limits.

Birthday

The birthday of the customer. This is the birth date without the month (eg. 4/13). You can find this dimension in Build Beyond Limits.

Birth Date Month

The month representation of the Birthday (e.g 4 - Apr), so you can easily select customers based on Birth Date Month. You can find this dimension in Build Beyond Limits.

Time Based Dominant and Second Wine Name

Dominant Wine Name YTD and Dominant Wine Name L12M

New fields that identify each customer's top two wines (vintage-agnostic) by purchase volume for both YTD and Last 12 Months. Wineries can use this for year-end "Spotify Wrapped"-style campaigns, personalized thank-you messages, or other targeted segmentation. You can find these dimensions in Build Beyond Limits.

New Measures

μ Rejoined Signup Rate

This measure calculates the percentage of new membership signups that came from previously lapsed members. Switches between membership levels are excluded—only true rejoins are counted. You can find this measure in Build Beyond Limits.

Σ Bundles (Incl $0)

You can now calculate the total number of bundles purchased. Previously, you could only measure individual items sold within a bundle and identify whether those items were part of a bundle. The new bundle metrics includes $0 transactions and include Current Period, Prior Period, Change, and Change %. You can find this measure in Build Beyond Limits.

Fixes

Commerce7 Memberships

Commerce7 doesn't notify Enolytics when memberships are deleted or when hold statuses change, which could cause the two systems to fall out of sync. To address this, we now pull all active and on-hold memberships daily to ensure membership counts and statuses stay aligned.

Commerce7 Customer Tags

Commerce7 doesn't always notify Enolytics when customer tags are updated. To keep both systems in sync, we now pull fresh customer records daily for all customers with at least one order.

v25.11.24 - November 24th 2025

New

Reservations Module

Enolytics now supports Reservations for Commerce7, eCellar, and Tock. The module includes three pages: Future Reservations (Who's coming?), Past Reservations (Who came?), and Analysis.

This feature is particularly valuable when combining reservation data with RFM analysis, wine preferences, and other loyalty indicators.

Updates to Sell More Now! Section

Find Your People

Identify customers within a specified radius of any zip code. Enter a zip code and distance to find nearby customers—whether targeting locals around your tasting room or reaching customers near event venues for wine dinners and tastings. Ideal for location-based campaigns and event promotion.

The Corporate Gifter definition has been updated: Corporate Gifters are customers who have either purchased 5 or more gifts in a single day on at least 2 separate occasions, OR purchased 20 or more gifts in a single day.

Public Bookmarks

Commerce7 Customer Import

The 'Commerce7 Customer Import' Bookmark allows you to export customer data from Enolytics and import it directly into Commerce7. During the import process, you can apply a customer tag to easily identify and segment the imported contacts within Commerce7.

Measures

Σ Bundles (Excl $0)

You can now calculate the total number of bundles purchased. Previously, you could only measure individual items sold within a bundle and identify whether those items were part of a bundle. The new bundle metrics exclude $0 transactions and include Current Period, Prior Period, Change, and Change %.

Dimensions

We've added contact-specific dimensions:

Days Till Contact Future Reservation

The number of days between today and the contact's next upcoming reservation. This can be found in the Build Beyond Limits 'Contact General' Category.

Contact Future Reservation Date

The date of the contact's next scheduled reservation. This can be found in the Build Beyond Limits 'Contact General' Category.

Phone2, Phone3, Email2 and Email3

We've added additional contact fields to capture alternate contact information: Phone2, Phone3, Email2, and Email3. These fields store backup phone numbers and email addresses for customers, allowing you to maintain multiple contact methods for improved communication and outreach.

Contact Notes

In "Build Beyond Limits," in the Contact Notes Group, you can now access the following note fields for CRMs that support contact notes via their API:

  • Contact Note - The content of the note

  • Contact Note Date - The date the note was created

  • Contact Note Date Time - The date and time the note was created

  • Contact Note Made By - The associate who created the note

We currently only support notes of type 'Note'. Tasks are not included yet.

Order Specific dimensions

Reverse Order Sequence

You will find this in Build Beyond Limits in the Order General Group.

The Reverse Order Sequence allows you to easily identify a contact's most recent order, second most recent order, and so on. Unlike the standard Order Sequence, which sorts orders chronologically in ascending order, the Reverse Order Sequence sorts each contact's orders in descending chronological order (newest to oldest).

Example use case: This allows you to easily identify which channel each customer's last order was placed in—whether it was in the tasting room, online, wine club, or wholesale—helping you understand current purchasing patterns and target customers based on their most recent buying behavior.

Is Last Order

You will find this in Build Beyond Limits in the Order General Group.

A flag indicating whether this is the customer's most recent order. This allows for easy filtering to analyze all customers' last orders. It functions similarly to filtering for Reverse Order Sequence = 1.

Gift Card Specific Dimensions:

These can be found in the 'Gift Card General' Group of Build Beyond Limits

Gift Card Type

Type or category of gift card (e.g., physical, digital, promotional)

Gift Card From Name

Name of the person sending or purchasing the gift card

Gift Card Recipient Email

Email address of the gift card recipient

Gift Card Notes

Custom message or notes included with the gift card

buyer_name

Full name of the person who purchased the gift card

Buyer Email

Email address of the gift card buyer

Buyer Phone

Phone number of the gift card buyer

Buyer First Signed Up Date

Date when the buyer first signed up for a club membership

Buyer Detailed Club Status

Detailed membership status of the buyer in the wine club (e.g., Active, Inactive, Pending, Cancelled)

Buyer Last Signed Up Club Sales Associate

Sales associate or representative associated with the buyer's most recent club signup

Buyer Last Signed Up Club Signup Date

Date of the buyer's most recent wine club membership signup

Buyer Last Signed Up Club Membership Status

Membership status for the buyer's most recent club signup

Buyer Last Signed Up Club Name

Name of the wine club the buyer most recently signed up for

Gifting Specific Dimensions:

These can be found in the 'Gifting General' Group of Build Beyond Limits
Recommended Outreach Channel

This field suggests the best way to contact each customer based on their purchase history and behavior patterns. The system analyzes where and how often customers buy, then recommends either "Website" (for online shoppers), "Tasting Room" (for in-person visitors), or "Multi-channel" (for customers who use both). For example, if someone always buys online and hasn't visited your tasting room in years, it would recommend "Website" outreach. This helps your marketing team send the right message through the right channel - email campaigns for web shoppers, event invitations for tasting room visitors, or both for multi-channel customers.

Gift Months By Frequency

A ranked list of calendar months showing when this customer most often sends gifts, with their busiest gift-giving months listed first. For instance, if the field shows "December, November, February, June," it means this customer sends the most gifts in December, followed by November, etc. This helps you time your gift promotions perfectly - you'd market holiday gifts to this customer in early December, Valentine's options in January, and perhaps Father's Day wines in May. The ranking is based on their actual gift order history over recent years.

Gift Months With Counts

The same monthly ranking as above, but includes the actual number of gift orders in parentheses to show volume. For example: "December (8), November (4), February (3), June (1)" tells you this customer not only gifts most in December but has sent 8 gift orders that month historically. This additional detail helps prioritize outreach - a customer with "December (15)" is a much bigger holiday gifting opportunity than one with "December (2)". It's particularly useful for identifying your VIP corporate gifters who send dozens of gifts during peak seasons.

These fields work together to help you understand each customer's gifting patterns and preferred shopping channels, enabling highly targeted and timely marketing campaigns.

Improvements

Email Check

We've updated the email validation logic to identify invalid email addresses more accurately. The validation now checks for:

  • Missing or null email addresses

  • Invalid characters (spaces, forward slashes, colons, semicolons, commas)

  • Fake or placeholder emails (containing "noemail")

  • Missing or multiple @ symbols

  • @ symbol at the start or end of the address

  • Missing domain extension (no dot after @)

  • Improperly formatted domains (dot immediately after @, nothing after the final dot, or consecutive dots)

Emails that pass all validation checks are marked as "valid," while others are flagged with specific error categories.

Phone Check

We've updated the phone validation logic to more accurately identify valid phone numbers. The validation now checks for:

  • Missing phones - Null values or '0'

  • Valid NANP format (US/Canada) - Validates 10-digit numbers with country code 1, supporting various formats like 914-757-6891, 1-914-757-6891, or +1 (914) 757-6891. Area code and exchange must start with digits 2-9.

  • Valid international format - Numbers starting with + followed by country codes 2-9 (excluding 1), with total digit count between 8-17 digits. Examples: +44 20 7123 4567, +33 1 42 86 82 00

Phone numbers that don't match these patterns are marked as "invalid."

Fixes

Club Membership Switches

We've updated the algorithm that identifies switches between clubs, improving its accuracy. As a result, you may notice small differences in your club signup, cancellation, and growth measures.

Split Payments in Offset Partners

Split payments are not supported in Offset Partners, which creates a disconnect between total order value and the sum of net sales in the API. Enolytics has now implemented logic to better interpret these transactions, providing more accurate Net Sales calculations when the second portion of a split payment is processed outside of Offset Partners.

v25.10.30 - October 30th 2025

New

Updates to Sell More Now! Section

Sell More Now! has been widely popular, particularly during the October-November-December period. We're introducing additional enhancements to make it even more powerful.

Introducing the 'Dual Date Range' selector

Filter customers based on upcoming events within a specific time window. Set a date range (such as 7-14 days from today) to identify customers with birthdays, club anniversaries, or tasting room visits occurring during that period. This enables timely, targeted marketing for milestone occasions.

Bundle definitions for CRMs that do not support bundles in their API

Shopify, Offset Partners, and Corksy do not provide bundle composition data through their API. You can now define your bundles in the Enolytics Configuration Mapping. Please contact Enolytics Support for assistance with setup.

v25.09.23 - September 23rd 2025

New

Sell More Now! Section

We've created a new module called 'Sell More Now!' that basically is your task manager for customer outreach. It uses advanced algorithms and machine learning to figure out who you should reach out to.

The module has three pages, with sub-sections:

  • Retain These Customers

    • Re-engage These Customers

    • Club Members at Risk

  • Ready-to-Buy Customers

    • Upcoming Club Anniversaries

    • Upcoming Birthdates

    • Potential Website Buyers

    • Potential Tasting Room Buyers

  • Gifting Central

    • Gifted Last Year

    • Corporate Gifters

    • Personal Gifters

    • Potential Gifters

Watch the Introduction to 'Sell More Now!' here

5 Year Historical comparison for benchmarking

Compare your winery to your cohort, not only in for the past 12 months but for the past 5 years. Choose any of the defined KPIs.

Enhanced Club Risk Factor - Simple Explanation

The system recognizes that members who cancel and rejoin are actually demonstrating brand loyalty - they choose to come back! This positive behavior is reflected in the risk factor calculation.

The key insight: When someone cancels but later rejoins, it shows they:

  • Value your brand enough to return

  • Made a deliberate choice to re-engage

  • Are likely more committed this time around

How the Club Risk Factor Multiplier works:

  • Never cancelled before: Multiplier = 1.0 (unknown loyalty pattern)

  • Cancelled once and returned: Multiplier = 0.75 (proven returner)

  • Cancelled 2-3 times and returned: Multiplier = 0.6 (strong return pattern)

  • Cancelled 4+ times and returned: Multiplier = 0.5 (highly loyal despite gaps)

What the multiplier means: A LOWER multiplier means LOWER risk of permanent loss. These members have proven they'll come back even after cancelling, making them more reliable long-term customers despite periodic breaks.

Example: Sarah has cancelled 3 times but keeps rejoining. Her risk factor multiplier of 0.6 means she's 40% LESS likely to leave permanently compared to first-time members. She's demonstrated true brand loyalty by returning multiple times.

Commerce7 Club Package Analytics

Track and analyze both active and archived wine club packages with comprehensive bottle and revenue metrics. This feature provides detailed insights into how your actual shipments compare to planned defaults.

Key capabilities include:

  • Compare actual vs. default revenue for each package and individual shipment

  • Monitor actual vs. default bottle quantities to identify variations

  • Track actual vs. default average price per bottle or item

  • Analyze performance across your entire club program or drill down to specific packages

  • View historical data from archived packages alongside current active clubs

This helps you understand where customizations, substitutions, or special pricing are impacting your club program's performance compared to the standard offerings you've configured.

Dimensions

Days Since Contact First Order

Span in days between the contacts' first order and today. This can be found in Build Beyond Limits, in the contact segmentation group.

Contact Active Status (Offset Partners Only)

Indicates whether the contact is active or not within the Offset Partners CRM.

Contact System Source

The original system or method through which this contact was created (e.g., "C7", "Tock", "Internal"). This helps track customer acquisition channels and understand where your customers come from. This field is available in Build Beyond Limits under Contact General dimensions.

Gift Related Dimensions

Years As Gifter

The number of distinct calendar years in which this customer has sent gifts. For example, if someone sent gifts in 2022, 2023, and 2024, they have "3 years as gifter." This metric helps distinguish established gift-givers from one-time gifters, showing their long-term commitment to gifting through your winery. You can find this dimension in Build Beyond Limits within the Gifting General category.

First Gift Year

The calendar year when this customer sent their very first gift order. This establishes the beginning of their gifting relationship with your winery and helps calculate how long they've been using your gifting services. This field is available in BBL under Gifting General dimensions.

Last Gift Year

The most recent calendar year in which this customer sent gifts. Combined with First Gift Year, this shows whether they're currently active in gifting or have stopped. A customer whose last gift year was 2023 but it's now 2025 may need re-engagement. Look for this in Build Beyond Limits in the Gifting General category.

Gift Consistency Ratio

A score from 0.00 to 1.00 measuring how consistently someone gifts across their years as a customer. A ratio of 1.00 means they've gifted every single year since becoming a customer; 0.50 means they've gifted in half their years. This helps identify reliable annual gifters versus sporadic ones. This metric is found in BBL's Gifting General dimensions.

Gift Years List

A comma-separated list showing all years when this customer sent gifts (e.g., "2021,2022,2024"). This reveals the complete gifting timeline including any gap years, helping you spot patterns or breaks in their gifting behavior. You'll find this in Build Beyond Limits under Gifting General.

Lifetime Gift Value

The total dollar amount of all gifts this customer has ever sent through your winery. This cumulative value helps identify your most valuable gift customers for VIP treatment and targeted retention efforts. This important metric is located in BBL's Gifting General category.

Gift Readiness Score

A 0-100 score predicting how likely a non-gifter is to become a gift customer. The score combines industry type (40% weight), customer quality metrics (30%), and recent engagement (30%). High scores (80+) indicate customers who buy frequently, have high lifetime value, and may work in gift-friendly industries like finance or consulting. This predictive score is available in Build Beyond Limits within Gifting General dimensions.

Order Timing Dimensions

Days Since First Order

The number of days between the customer's very first purchase and today. This shows how long they've been a customer overall, regardless of purchase frequency. You can access this in BBL under Contact Segmentation dimensions.

Days Between First Last Order

The span of days between their first and most recent order. A small number means they're new or haven't reordered; a large number indicates a long-term relationship with ongoing purchases. Find this metric in Build Beyond Limits within Contact Segmentation.

Completed Paid Orders

The total count of successful, paid orders from this customer across all channels. This includes everything except cancelled or unpaid orders. This fundamental metric is located in BBL's Contact Segmentation category.

Avg Days Between Orders

The average number of days between this customer's purchases. Lower numbers (e.g., 30) indicate frequent buyers; higher numbers (e.g., 365) indicate annual buyers. This helps predict when they're likely to order again. You'll find this in Build Beyond Limits under Contact Segmentation dimensions.

Channel-Specific Order Dimensions

Club Orders

  • Club First Order Date: When they received their first wine club shipment. Available in BBL's Contact Segmentation category.

  • Days Since First Club Order: How long they've been a club member in days. Found in Build Beyond Limits under Contact Segmentation.

  • Days Between First Last Club Order: The span of their club membership history. Located in BBL's Contact Segmentation dimensions.

  • Completed Paid Club Orders: Total number of club shipments they've received. This metric is in Build Beyond Limits within Contact Segmentation.

  • Avg Days Between Club Orders: Their typical club shipment frequency. You can find this in BBL under Contact Segmentation.

POS (Point of Sale/Tasting Room) Orders

  • Pos First Order Date: Their first in-person purchase date. Available in Build Beyond Limits in Contact Segmentation.

  • Days Since First Pos Order: How long since they first visited and purchased. Found in BBL's Contact Segmentation category.

  • Days Between First Last Pos Order: Span of their visiting history. This dimension is in Build Beyond Limits under Contact Segmentation.

  • Completed Paid Pos Orders: Total tasting room purchases made. Located in BBL's Contact Segmentation dimensions.

  • Avg Days Between Pos Orders: How often they typically visit and buy. Find this in Build Beyond Limits within Contact Segmentation.

Web Orders

  • Web First Order Date: First online purchase date. Available in BBL under Contact Segmentation dimensions.

  • Days Since First Web Order: How long they've been an online customer. This is found in Build Beyond Limits in Contact Segmentation.

  • Days Between First Last Web Order: Their online shopping history span. Located in BBL's Contact Segmentation category.

  • Completed Paid Web Orders: Total website purchases. You can access this in Build Beyond Limits under Contact Segmentation.

  • Avg Days Between Web Orders: Their online shopping frequency. Find this metric in BBL within Contact Segmentation dimensions.

Allocation Orders

  • Allocation First Order Date: When they first purchased allocated/special wines. Available in Build Beyond Limits in Contact Segmentation.

  • Days Since First Allocation Order: Time since joining allocation list. Found in BBL's Contact Segmentation category.

  • Days Between First Last Allocation Order: Their allocation participation span. This is in Build Beyond Limits under Contact Segmentation.

  • Completed Paid Allocation Orders: Total allocation purchases made. Located in BBL's Contact Segmentation dimensions.

  • Avg Days Between Allocation Orders: Allocation purchase frequency. You'll find this in Build Beyond Limits within Contact Segmentation.

Predictive & Analytical Fields

Web/POS Total Orders

The total number of orders placed through each specific channel (Website or Point of Sale/Tasting Room). These are fundamental metrics for channel performance analysis. You can find these in BBL's Contact Forecasting category.

Web/POS Days Since Last Order

How many days have passed since their last purchase in each channel. This helps identify which customers are overdue and may need marketing attention. These metrics are located in Build Beyond Limits within Contact Forecasting dimensions.

Web/POS Avg Days Between Orders

The typical purchase frequency for each channel. Some customers may visit the tasting room monthly but order online only annually, revealing channel preferences. Find these in BBL under Contact Forecasting.

Web/POS Predicted Next Order Date

Using purchase patterns or machine learning, the estimated date when this customer will likely make their next purchase in each channel. This helps time marketing perfectly. These predictive fields are available in Build Beyond Limits in Contact Forecasting.

Web/POS Days Until Predicted Order

How many days until their predicted next order. Negative numbers mean they're overdue; positive numbers show how long until they're expected to buy. This countdown helps prioritize outreach. Located in BBL's Contact Forecasting category.

Web/POS Likelihood Score 30 Days

A 0-100 score indicating the probability this customer will make a purchase in the next 30 days through each channel. Scores above 80 indicate "hot" prospects ready to buy. These AI-powered scores are found in Build Beyond Limits under Contact Forecasting dimensions.

Web/POS Customer Status

A classification based on purchase patterns:

  • "Very Overdue": Well past their typical purchase window

  • "Overdue": Should have ordered by now based on history

  • "Due Soon": Approaching their typical purchase time

  • "Not Due Yet": Recently purchased, not time to reorder

  • "Likely Churned": Haven't ordered in 540+ days

  • "Insufficient Data": Only one order, can't predict pattern These status fields are available in BBL within Contact Forecasting.

Web/POS Pattern Months

The specific months when this customer typically makes purchases in each channel (e.g., "Mar, Jun, Nov, Dec"). This reveals seasonal buying patterns and helps plan inventory. You can find these pattern insights in Build Beyond Limits under Contact Forecasting dimensions.

POS Visitor Classification

Special categorization for tasting room visitors combining distance from winery, club membership, and visit frequency. Examples include "Local Club Member", "Regional Regular Visitor", "Distant Repeat Customer", or "Web-Only Customer". This classification is located in BBL's Contact Forecasting category.

Marketing Priority Score

A 0-100 score that takes the highest likelihood score between web and tasting room channels. This single score helps prioritize marketing efforts across all customers, regardless of their preferred channel. Find this unified score in Build Beyond Limits within Contact Forecasting dimensions.

Purchase Readiness Segment

Temperature-based segments indicating how ready customers are to buy:

  • "Hot": Purchase imminent in one or both channels (80+ score)

  • "Warm": Approaching purchase window (60-79 score)

  • "Cool": Early in purchase cycle (40-59 score)

  • "Cold": No near-term indicators (below 40 score) This segmentation is available in BBL under Contact Forecasting.

Key Pattern Insight

A brief text summary of the most important pattern or anomaly detected for this customer, such as "Holidays-only buyer" or "Overdue by 90 days - was monthly buyer". This human-readable insight helps staff quickly understand each customer's situation. You'll find this in Build Beyond Limits within Contact Forecasting dimensions.

Measures

Website Orders (Excl $0)

Number of Website Orders, excluding $0. This is for all Orders that have a 'Channel Type' of 'Website'.

Dimensions for Wishes (Offset Partners Only)

Contact Cumulative Fully Granted Wishes

A running total of all wishes from this customer that have been completely fulfilled over time. Each wish order is counted as "fully granted" when at least 99% of the original wish value has been shipped. This helps track customer satisfaction and fulfillment success rates across their entire relationship with the winery.

Contact Cumulative Partially Granted Wishes

A running total of all wishes from this customer where some items were sent but not everything. This cumulative count increases each time a wish is partially fulfilled and helps identify customers who frequently receive incomplete shipments, which may indicate inventory challenges or other fulfillment issues.

Item Remaining Wish Quantity

The exact number of bottles or units of a specific product that the customer still wants but hasn't received yet. For example, if they wished for 12 bottles of Cabernet and only received 9, this would show 3. This helps wineries prioritize which specific items to fulfill.

Original Wish Total

The complete dollar value of the customer's wish list when they first created it, calculated by multiplying each item's quantity by its price at that time. This original amount never changes, even if prices change later, providing a baseline for measuring fulfillment performance.

Total Wish Quantity

The sum of all individual items across all products in the wish. If a customer wished for 6 bottles of red wine, 3 bottles of white wine, and 2 gift sets, this would be 11. This helps understand the scale of the wish regardless of product types or values.

Wish Aging Category

A classification showing how long unfulfilled wishes have been waiting. Categories include:

  • "Fully Granted" - Complete wishes

  • "Partially Granted (X%)" - Shows percentage fulfilled

  • "Pending 0-30 days" - Recent wishes

  • "Pending 31-60 days" - Aging wishes needing attention

  • "Pending 61-90 days" - Old wishes at risk

  • "Pending 90+ days" - Very old wishes requiring immediate action

  • "No Wish Date" - Missing timestamp

Wish Date

The calendar date (year-month-day) when the customer submitted their wish, adjusted for your winery's timezone. This date format makes it easy to sort and filter wishes by specific days for reporting and fulfillment planning.

Wish Days Pending

For wishes that haven't been completely fulfilled, this shows how many days have passed since the customer created the wish. This "age" helps prioritize older wishes and track how quickly your winery typically fulfills customer requests.

Wish Days To First Grant

The number of calendar days between when a customer created their wish and when the first item from that wish was shipped. This measures initial response time and helps track if you're meeting customer expectations for fulfillment speed.

Wish Days To Last Grant

The number of days between the original wish date and the most recent shipment for that wish. For wishes fulfilled in multiple shipments, this shows the total time span from start to finish of the fulfillment process.

Wish First Grant Date

The specific date when the first shipment was sent for this wish. This milestone date helps track fulfillment performance and can be used to measure the gap between customer expectation and actual delivery.

Wish Fulfillment % Qty

The percentage of the total wished quantity that has been delivered, regardless of price. If a customer wished for 20 items total and 15 have been sent, this shows 75%. This quantity-based metric helps ensure customers receive what they wanted, not just equivalent value.

Wish Fulfillment % value

The percentage of the original wish's dollar value that has been fulfilled. If the wish was worth $1,000 and $850 worth of products have been sent, this shows 85%. This value-based metric helps track financial fulfillment performance.

Wish Grant Velocity Category

A classification of how quickly wishes are being fulfilled. Categories include:

  • "Fully Granted within 1 week" - Excellent service

  • "Fully Granted within 1 month" - Good service

  • "Fully Granted within 3 months" - Acceptable service

  • "Fully Granted after 3 months" - Slow fulfillment

  • "Partially Granted - First grant within 1 week" - Quick start, incomplete

  • "Partially Granted - First grant within 1 month" - Moderate start, incomplete

  • "Partially Granted - First grant after 1 month" - Slow start, incomplete

  • "Ungranted" - No action taken

Wish Granted Item Count

The count of unique products (different SKUs) from the original wish that have been shipped. If a wish included 5 different wines and 3 of those wines have been sent (regardless of quantity), this would be 3.

Wish Granted Order Numbers

A comma-separated list of all order numbers that contained items fulfilling this wish. This creates an audit trail linking wishes to actual shipments and helps customer service track what was sent when.

Wish Granted Total

The sum of all dollar amounts from this wish that have been shipped to the customer. This may differ from the original wish total if prices changed or if only partial quantities were sent.

Wish Item Count

The number of distinct products (unique SKUs) in the wish, regardless of quantities. A wish for 12 bottles of Wine A, 6 bottles of Wine B, and 3 bottles of Wine C would have an item count of 3.

Wish Item Extended Price

The total dollar amount for a specific line item, calculated as quantity × unit price. If someone wished for 6 bottles at $45 each, the extended price would be $270. This helps understand the value of each product line in the wish.

Wish Item Fulfillment Category

The status for each specific product in the wish. Categories are:

  • "Ungranted" - None of this item has been sent

  • "Partially Granted (X%)" - Some quantity sent with percentage

  • "Fully Granted" - All requested quantity has been sent

Wish Item Fulfillment Quantity %

The percentage of a specific item's wished quantity that has been delivered. If 12 bottles of Chardonnay were wished and 8 were sent, this shows 66.67%. This item-level metric helps identify which specific products are challenging to fulfill.

Wish Item Name

The product description as it appeared when added to the wish list. This preserves the original product name even if it changes later in your system, maintaining an accurate historical record.

Wish Item Price

The price per bottle or unit at the time the item was added to the wish. This historical price is preserved even if current prices change, ensuring accurate fulfillment calculations.

Wish Item Product Type

The category classification of the product, such as "Wine", "Merchandise", "Food", or other product categories your winery offers. This helps analyze wish patterns by product type.

Wish Item Quantity

The number of bottles or units of this specific product that the customer wished for. This is the original requested amount for each individual SKU on their wish list.

Wish Item Remaining Value

The dollar value of the unfulfilled portion of this specific item. If 6 bottles at $50 each were wished and only 4 were sent, the remaining value would be $100 (2 × $50).

Wish Item Varietal

For wine products, this identifies the grape variety such as "Cabernet Sauvignon", "Pinot Noir", "Chardonnay", etc. Non-wine products will have this field empty. This helps analyze wine preferences in wishes.

Wish Item Wine Name

The specific wine name for wine products in your catalog. For non-wine items like merchandise or food, this field shows "Non-Wine" to clearly distinguish product types in reporting.

Wish Last Grant Date

The most recent date when any products from this wish were shipped. For wishes fulfilled over multiple shipments, this tracks the latest activity and helps identify wishes that may need follow-up.

Wish Month

The month number (1-12) when the wish was created, where 1 represents January and 12 represents December. This numeric format makes it easy to sort and analyze seasonal wish patterns.

Wish Number

The system-generated unique reference number for each wish (e.g., "Wish-292479-wo-328442"). This identifier allows customer service to quickly locate specific wishes and links all related orders and items.

Wish Quarter

The calendar quarter (1-4) when the wish was created. Q1 includes January-March, Q2 is April-June, Q3 is July-September, and Q4 is October-December. Useful for quarterly business analysis.

Wish Sequence Number

A counter showing this is the customer's 1st wish, 2nd wish, 3rd wish, etc. This helps understand customer loyalty and identify patterns in repeat wish behavior.

Wish SKU

The stock keeping unit (product code) for each wished item. This internal identifier ensures accurate product matching between wishes and inventory, even if product names change.

Wish Status

The overall fulfillment status of the entire wish. Values are:

  • "Ungranted" - Nothing from this wish has been sent

  • "Partially Granted" - Some items or quantities have been sent

  • "Fully Granted" - At least 99% of the wish value has been fulfilled

Wish Value Tier

A classification grouping wishes by their total dollar value. Tiers include:

  • "Zero Value" - $0 wishes

  • "Very Low (1-99)" - Under $100

  • "Low (100-249)" - $100 to $249

  • "Medium (250-499)" - $250 to $499

  • "High (500-999)" - $500 to $999

  • "Premium (1000+)" - $1,000 and above

Wish Year

The four-digit year when the wish was created (e.g., 2024, 2025). This allows for year-over-year comparisons and long-term trend analysis of customer wish patterns.

Measures for Wishes (Offset Partners Only)

Fully Granted Wishes

Number of fully granted wishes.

Partially Granted Wishes

Number of partially granted wishes.

Ungranted Wishes

Number of ungranted wishes.

Fixes

Net Sales for Offset Partners

We've updated the Net Sales calculations for Offset Partners to properly handle order-level discounts. Previously, these discounts were not allocated correctly at the item level. Order-level discounts are now proportionally distributed across line items, ensuring accurate Net Sales reporting.

v25.08.27 - August 27th 2025

New

Map your old Order Types to your new POS Profiles

Connect your historical tasting room data to your current Commerce7 POS Profiles for seamless year-over-year reporting. When migrating from legacy CRM systems, tasting room locations often don't align with new POS Profile structures. Our new mapping feature bridges this gap, ensuring your revenue and case sales reports maintain continuity across both old and new systems. Track performance trends for any time period without losing visibility into pre-migration data. Contact Enolytics Support to set up your tasting room to POS Profile mappings.

Sales Associates Mapping

Consolidate duplicate sales associate records for accurate performance reporting across your entire system. Whether you have multiple entries for the same person or inconsistent formatting between club signups and order records, our new mapping feature creates a unified view. Link all variations of a sales associate's name to a single primary record, ensuring historical orders, current sales, and club memberships are properly attributed. This provides clear visibility into each associate's true performance metrics without manual data reconciliation. Contact Enolytics Support to configure your sales associate mappings.

Multi-Tenant Views:

Manage multiple wineries through a single unified dashboard, whether they're all on the same CRM across different instances or spread across various supported CRM platforms. Our multi-tenant functionality seamlessly connects disparate systems, allowing you to view performance metrics, compare results, and generate reports across all properties simultaneously. Filter by individual wineries for detailed analysis or aggregate data for enterprise-wide insights. This consolidated view streamlines both business intelligence and marketing campaign management across your entire portfolio. Enolytics provides the only solution that brings all your winery data together in one comprehensive platform, regardless of your CRM configuration. Analyze overall organizational performance with comparative views, or dive into specific Club KPIs, Tasting Room KPIs, or Website KPIs—all accessible from a single interface.

Customize Your RFM

Take control of your RFM analysis with customizable thresholds. Define your own recency ranges instead of using the standard 1, 4, 9, 12, and 24-month breakpoints. Adjust frequency and monetary percentiles to match your business needs and customer behavior patterns. Whether you want tighter segmentation for fast-moving products or broader ranges for longer sales cycles, you can now tailor RFM settings to your specific requirements. Contact Support to implement custom configurations beyond the default settings.

Dimensions

Club Brand

Organize wine clubs by brand with our new Club Brand aggregation feature. For wineries managing multiple clubs tied to specific brands within their portfolio, this field provides an additional layer of organization and reporting. Access Club Brand as both a filter option and a dimension in Build Beyond Limits for custom analysis. The field integrates seamlessly into the Wine Club Module's dropdown menus, enabling brand-level performance tracking and member segmentation. This enhancement supports more granular club management for wineries with diverse brand portfolios. Contact Enolytics Support to show you how to set up your Club Brands

Members of Club Brand

Filter for current club brand membership status with the new "Members of Club Brand" option. This filter specifically captures contacts who are presently Active or On Hold members of your selected club brand, providing a real-time snapshot of current membership. In contrast, the existing "Club Brand" filter includes all contacts who have ever belonged to that brand's club, regardless of current status. This distinction enables more precise segmentation for targeted communications to active members versus historical analysis of all past and present brand club participants.

Days Since Contact Created

Track customer acquisition timing with "Days Since Contact Created," a dimension that shows the number of days between when a contact was first added to your system and yesterday. This metric helps identify new versus established customers, measure the effectiveness of recent acquisition campaigns, and segment communications based on customer tenure. Use it to trigger welcome series for recent additions, anniversary messages for long-standing customers, or analyze purchasing patterns relative to account age.

Gifting Dimensions

Corporate Industry

Identifies the industry sector of a contact based on their email domain through pattern matching and a comprehensive list of known company domains. Industries include Financial Services, Technology, Healthcare, Legal Services, and others, helping segment contacts for targeted B2B marketing and understanding corporate purchasing patterns.

Corporate Gift Score

A numerical rating from 0-100 that predicts a contact's corporate gifting potential based on their identified industry. Financial services companies receive the highest scores (95), followed by legal services (90) and consulting firms (85), while education and government entities receive lower scores due to typical budget constraints and compliance requirements.

Corporate Gift Tier

Groups contacts into strategic segments like "Premium Corporate Gifters," "High-Value Corporate Gifters," or "Budget-Conscious Corporate" based on their gift score. This tiering system helps sales teams prioritize outreach efforts and customize their approach based on the expected gifting budget and behavior of each segment.

Gifting Purpose Segment

Categorizes contacts by their most likely gifting use case, such as "Deal Closing Gifts," "Employee Recognition," "Holiday Programs," or "Customer Loyalty." This segmentation enables marketing teams to create targeted campaigns with relevant messaging and product recommendations that align with each segment's typical purchasing occasions.

Gifting Account Priority Notes

Provides simple, actionable guidance for sales teams with labels like "High-value account - Prioritize for outreach" or "Standard corporate - Monitor for opportunities." These notes help sales representatives quickly understand which accounts deserve immediate attention versus those requiring periodic check-ins.

Gifting Segment

Classifies contacts based on their observed gifting behavior into categories like "Corporate Gifter - Confirmed," "Personal Gifter," or "Potential Corporate Gifter - Never Gifted." This segmentation identifies both active gifters and untapped opportunities, helping teams focus on converting high-potential non-gifters while maintaining relationships with existing gifters.

Gifting Type

Provides detailed classification of gifting patterns such as "High-Volume Corporate," "Frequent Personal," or "Occasional Personal" based on the frequency and volume of gift purchases. This granular view helps understand whether a contact typically sends many gifts at once (corporate behavior) or individual gifts throughout the year (personal behavior).

Gift Order Percentage

This is the percentage of a customer's non-club orders, from the past 5 years, identified as gifts, providing insight into their purchasing behavior. A high percentage indicates someone who primarily uses your service for gifting, while a low percentage might represent an opportunity to introduce them to gifting options.

Total Gift Orders

A dimension that shows all orders identified as gifts over the past 5 years based on our algorithm that compares billing and shipping information. This metric helps identify your most active gifters and provides a baseline for measuring the success of gifting-focused marketing campaigns.

Days with 5+ Gifts

Tracks the number of distinct dates when a customer sent five or more gifts on the same day, which is our threshold for identifying corporate bulk-gifting behavior. This metric is crucial for distinguishing between personal gifters who send individual gifts and corporate accounts managing large-scale gifting programs.

Days with 3+ Gifts

Tracks the number of distinct dates when a customer sent three or more gifts on the same day, which is our threshold for identifying corporate bulk-gifting behavior. This metric is crucial for distinguishing between personal gifters who send individual gifts and corporate accounts managing large-scale gifting programs.

Max Gifts Single Day

Records the highest number of gifts a customer has ever sent on a single day within the past 5 years. This peak capacity metric helps identify customers with established bulk-gifting capabilities who might be good candidates for corporate gifting programs or volume discounts.

Days Since Last Gift

Shows the time elapsed since a customer's most recent gift order, helping identify active versus lapsed gifters. This recency metric is essential for triggering re-engagement campaigns or recognizing when a previously active corporate gifter may need attention to maintain the relationship.

Recommended Action

Provides specific, actionable marketing or sales strategies for each contact, such as "Introduce corporate gifting program" for frequent buyers who've never gifted, or "Re-engage with gift promotions" for lapsed gifters. These recommendations help teams take immediate, relevant action rather than requiring manual analysis of each account.

High Volume Gift Dates

Lists up to 10 specific dates when a customer placed 3 or more gift orders, showing the date and quantity like "2024-12-15 (8 gifts)." This detailed history helps sales teams reference specific bulk orders in conversations and identify seasonal patterns in corporate gifting behavior.

v25.08.20 - August 20th 2025

New

Dimensions

POS Profile

POS Profile added as a Dimension and Filter. POS Profile (and Sales Attribute) also has been added to many dropdowns in the application. It is also available in Build Beyond Limits in the 'Order General' Category

v25.08.13 - August 13th 2025

New

Center Zip and distance from Center Zip

Easily identify customers within a specific distance of any zip code or postal code—perfect for planning road shows, off-site tasting events, or targeted local marketing campaigns.

How to use this feature in Enolytics:

  • Use the 'Center Zip' filter to set your target location

  • By default, this selects all customers within 100 miles of your chosen zip code

  • Customize the search radius using:

    • 'Distance to Center Zip' for preset distance ranges (similar to the distance-to-winery feature)

    • 'Distance in Miles to Center Zip' for precise distance selection

For Build Beyond Limits reports: You can add these distance fields to your custom reports. Find them in the Contact Distance to Zip category:

  • Distance to Center Zip

  • Distance in Miles to Center Zip

improved "Order As Gift"

Our system automatically identifies potential gift orders by comparing the buyer's information with the recipient's information. This helps us provide appropriate handling for gift purchases.

An order is marked as a "likely gift" when:

1. Names Don't Match

The system checks if any part of the buyer's name appears in the recipient's name:

  • Compares both billing name AND account holder name against shipping name

  • Looks for partial matches to handle name variations

  • If either the first name OR last name matches, it's considered the same person

Examples of names that MATCH (not a gift):

  • "John Smith" shipping to "John C. Smith"

  • "Robert Johnson" shipping to "Bob Johnson"

  • "J. Williams" shipping to "Jennifer Williams"

  • "Mary Smith" shipping to "John Smith" (shared last name)

Examples of names that DON'T MATCH (potential gift):

  • "John Smith" shipping to "Mary Johnson"

  • "David Brown" shipping to "Sarah Williams"

2. AND Different ZIP Codes

  • Billing ZIP and shipping ZIP must be different

  • Account holder ZIP and shipping ZIP must be different

  • This prevents false positives when family members share an address

3. Complete Information Available

The system only makes a determination when all required data is present:

  • Billing name and ZIP

  • Shipping name and ZIP

  • Account holder name and ZIP

Result Values:

  • "likely" = All conditions met (different names AND different locations)

  • "unlikely" = Names match OR same ZIP code OR missing information

improved gender identification

We've enhanced our gender identification logic. Previously, first names with multiple words or initials (like "Michael T.") were classified as unknown gender. Now, when a multi-word first name returns no gender match, we attempt to classify it based on the first word alone. This improves accuracy in cases where middle initials or additional name components prevented initial gender identification.

Update to Email Marketing Status for Offset Partners

This now represents a summary of a customer's communication preferences that shows whether they've agreed to receive different types of marketing messages.

It displays four preferences in a single line:

  • Mkt: Whether they want marketing emails

  • Phone: Whether they're okay with phone calls

  • Text: Whether they want text messages

  • Mail: Whether they want physical mail

For each preference, it shows:

  • The actual value (like "Yes" or "No") if it exists

  • A question mark (?) if the information is missing

Example output would look like: "Mkt: Yes -- Phone: No -- Text: Yes -- Mail: ?"

This means:

  • ✓ They DO want marketing emails

  • ✗ They DON'T want phone calls

  • ✓ They DO want texts

  • ? We don't know about physical mail

The result is labeled as "email_marketing_status" (though it actually shows all communication preferences, not just email).

New Preset Reports

Unused Gift Cards

A list of gift cards that meet all three criteria: currently active, not past their expiration date, and have never been redeemed. This preset report can be found under Public Bookmarks | Business Reports | Gift Cards

Partially Redeemed Gift Cards

A list of gift cards that meet three criteria: currently active, not past their expiration date, and have been partially (but not fully) redeemed. This preset report can be found under Public Bookmarks | Business Reports | Gift Cards

Fully Redeemed Gift Cards

A list of gift cards that meet three criteria: currently active, not past their expiration date, and have been fully redeemed. This preset report can be found under Public Bookmarks | Business Reports | Gift Cards

Dimensions and Filters

Contact Referral Code, Contact Referral Source, and Contact Referral Note

These are Offset Partners fields that are now available for filtering and in Build Beyond Limits, in the Contact Segmentation category

Bill To First Name, Bill To Last Name, Bill To Zip Code, Bill To Address, Bill To City, Bill To State, and Bill To Company

These dimensions have been added to Build Beyond Limits and can be found in the Order Bill Info category.

Refund Order Number

The CRM field that identifies which order number was used to process a refund can be found in Build Beyond Limits under the Order General Category. This field links refunded orders to their corresponding refund order numbers.

Gift Card Balance Status

Indicates whether a Gift Card is 'Never Used','Partially Used' or 'Fully Redeemed'

Gift Card Sold Date

Date the gift card was sold. Can be found in Build Beyond Limits in the Gift Card General category

Sales Associate Main Channel and Sales Associate Main Order Type (Filters Only)

These two fields help you group sales associates based on their primary activity. We analyze which Channel/Order Type each associate works in most frequently and assign them to the corresponding filter group. This makes it easy to filter for all associates who primarily work in a specific channel or order type.

These groupings are particularly useful when:

  • Reviewing the Tasting Room Module

  • Creating custom reports in Build Beyond Limits where you need to filter associates by their activity group

Note: Associate groups are only created for the Channel Types 'Tasting Room' and 'Outbound Other'.

Measures

Σ Raw Measures

We've created four unfiltered raw measures to provide flexibility in reporting beyond just completed and paid orders. These measures capture data for both the Current Period (CP) and All Time without any pre-applied filters:

  • Raw Subtotal: Calculated as quantity × sold price

  • Raw Orders: Count of unique order numbers

  • Raw Items: Total quantity

  • Raw AOV: Subtotal ÷ (number of orders - number of refunds)

By applying your own filters to these raw measures, you can analyze any type of order based on your specific reporting needs.

Σ Order Dates

You can now access the maximum and minimum order dates for both the Current Period and All Time. We've expanded these date measures beyond the previous 'Excl $0' (excluding zero-dollar orders) to now include 'Incl $0' (including zero-dollar orders), giving you a complete view of your order date ranges.

v25.07.30 - July 30th 2025

New

Club Packages and Shipment Analysis (Commerce7 only)

Track and analyze your wine club shipment performance with our enhanced reporting features. You can now monitor:

  • Edit rates: See what percentage of shipments were modified

  • Bottle count changes: Track shipments with increased or decreased quantities

  • Payment issues: Identify customers with declined card transactions

  • Wine performance: Compare which wines excel in club shipments versus those that underperform

To access these insights, navigate to the Wine Club Module and explore the 'Club Releases' and 'Club Shipments' pages.

Support for Fiscal Year

If your winery operates on a fiscal year that differs from the calendar year, we can now accommodate your needs. Contact us to set up your custom fiscal year configuration.

How it works:

  • Fiscal years are defined by their starting month

  • Once configured with a start month other than January, fiscal year mode becomes your default view

  • Your default date range will be Fiscal Year To Date

  • You can easily toggle between fiscal year and calendar year views using the date picker switch

This feature ensures your reporting aligns with your organization's financial calendar.

Updated Calculations for Member Tasters and Wine Club Conversion!!!

We've introduced a new taster category called 'New Taster' to better align with the intent behind our taster classifications. Under the previous definition, customers who became members on the same day as their tasting—but before the tasting was processed—were technically correct to be labeled as 'member tasters.' However, this violated the spirit of the classification, since these customers weren't members when they booked or attended their tasting. For wine club conversion purposes, they should be treated as non-member tasters. The 'New Taster' category now captures these customers separately, ensuring our metrics reflect the true conversion journey from non-member to member.

Please review the updated definitions below, as they have been revised to incorporate this new classification:

  • Member Tasters

  • Non-Member Tasters

  • New Tasters

  • Wine Club Conversion Rate

Additionally, this change affects the 'Detailed Club Status at Time of Order' field. We've added a new value: 'Day of Signup WC Membership' to identify orders placed on the same day as wine club signup, providing more granular insight into same-day conversion behavior.

Bundles for systems that do not support bundles natively or in their API

You can now configure your bundles directly in Enolytics for accurate bottle-level tracking in two scenarios:

  1. For Shopify, Offset Partners, and OrderPort users: These systems require bundle configuration within Enolytics to ensure every bottle is tracked accurately.

  2. For CRM migrations: If you've migrated to a new CRM system, you can configure your old bundles directly in Enolytics instead of importing them into your new CRM.

Please contact Enolytics Support for assistance with bundle configuration.

Large and Small Metro Areas

We refreshed the metro areas based on the latest 2025 census data.

New Pages in the Tasting Room Module

The Tasting Room Module now has 2 new pages. 'What Wines Did They Sell?' and 'What Non-Wines Did They Sell?' This shows, using Ranking, bottles/items sold and net sales the performance of your sales associates both for Wines and Non Wines.

Pivot Table Optimization

Pivot tables in Build Beyond Limits and elsewhere no longer show rows and columns that are empty or only have 0 values.

Support for OrderPort

Enolytics now supports the OrderPort CRM. The current list of supported CRMs is now: WineDirect Classic, Commerce7, vinSUITE, eCellar, Shopify/Awtomic, Shopify/Winehub, Shopify/Bloom, Offset Partners and OrderPort.

Sales Attribute for eCellar

eCellar customers can now emulate a more detailed channel using the Order Tag. Make sure to configure the order tag as 'Single' and name it 'Order Type'. Enolytics will ingest the data as a Sales Attribute and you will be able to have detailed Order Type reporting.

CashierName for vinSUITE

Now, next to the sales associate name, we will also report on the Cashier Name for vinSuite. Both parameters will be reported through the 'Sales Associate' field.

Optimized Order Completed Date for Offset Partners

Now, the logic to identify the actual order completed date is based on the payment date (per Offset's recommendation). When the status of the order is paid and there is a payment date, we will set the order to the payment date, otherwise we will revert back to the datestamp of the order.

Inventory now supported for Offset Partners

Enolytics's Inventory modules are now fully compatible with Offset Partners.

Dimensions and Filters

Order Membership Category.

This field classifies orders into three categories based on the customer's membership status at the time of purchase:

  • New Member: Orders placed by customers who signed up for membership on the same day as their order. These customers became members and made a purchase on the same day.

  • Current Member: Orders placed by customers who had an active club membership at the time of purchase (excluding same-day signups, which are captured separately as 'New Member').

  • Non-Member: Orders placed by customers who did not have an active club membership at the time of purchase.

This classification helps distinguish between purchases made by established members versus those who joined and purchased on the same day, providing better insight into member purchasing behavior and conversion patterns. It can be found in Build Beyond Limits in the Order Segmentation Category and as a filter.

Days Until Contact Next Club Anniversary

A new contact-level dimension is available in Build Beyond Limits under the Contact General Category. This dimension calculates the number of days until a contact's next club anniversary.

Key details:

  • Only applies to current members with active or on-hold status

  • For contacts with multiple memberships, it displays days until the nearest anniversary

  • Helps you proactively manage member anniversaries and plan targeted communications

Gift Card Name

This is the gift card name (aka title) linked to the order. It can be found in Tender General Category of Build Beyond Limits.

Gift Card Number

This is the gift card number linked to the order. It can be found in Tender General Category of Build Beyond Limits.

Initial Signed Up Month and Initial Signed Up Month Name

These fields can be found in Build Beyond Limits under the Membership General category. It tracks the original start date for members who have switched between memberships.

How it works:

  • For members who have never switched: Initial signed up month equals their regular signed up month

  • For members who have switched: Initial signed up month reflects when they first joined, before any membership changes

  • Provides visibility into a member's complete history by identifying their original join date across all membership transitions

This helps you understand true member tenure, regardless of how many times they've changed membership types.

Last Day of Membership Month

This boolean (true/false) indicates whether the date is the last day of a month. This is linked to the membership activity/counts. It will help you create fast reports showing membership count for the last day of each month.

Last Day of Membership Quarter

This boolean (true/false) indicates whether the date is the last day of a calendar quarter. This is linked to the membership activity/counts. It will help you create fast reports showing membership count for the last day of each calendar quarter.

Last Day of Membership Year

This boolean (true/false) indicates whether the date is the last day of a calendar year. This is linked to the membership activity/counts. It will help you create fast reports showing membership count for the last day of each calendar year.

New Preset Reports (Public Bookmarks)

Accounting Reports: Accounting Order Details.

Can be used by the accounting department for month-end reporting.

It provides a detailed view of the entire order-to-delivery process, with extensive product, customer, and financial analytics capabilities.

Key components of the report include:

  • Order management data - Order tracking with comprehensive status fields for orders, payments, and shipping, plus fulfillment dates and order types

  • Sales channel information - Channel type and sales attributes to track performance across different sales platforms or methods

  • Customer information - Basic customer details (first/last name) and shipping destination (state)

  • Product details - Specific item information, including names, SKUs, product types, quantities fulfilled, and inventory pool tracking

  • Pricing analytics - Multiple price points tracked (sold price vs. original price) for discount and pricing strategy analysis

  • Financial breakdown - Detailed cost components, including:

    • Net sales

    • Shipping costs

    • Various tax categories (including CRV - Container Recycling Value taxes)

    • Tips

    • Total amounts before and after tips

  • Product-specific metrics - Special tracking for items and bottle quantities (750ml bottles), suggesting this may be from a beverage/alcohol retailer

Accounting Reports: Order Tender Report

The report contains comprehensive payment and order fulfillment data.. It tracks the complete lifecycle of customer orders from submission through payment processing and completion.

Key components of the report include:

  • Order tracking information - Order numbers and critical dates throughout the order lifecycle (submission, completion, and payment dates)

  • Payment processing details - Status indicators for payments, orders, and charges, along with the payment gateway and charge type information

  • Payment method data - Detailed credit card information including card brand, masked card numbers, cardholder names, authorization codes, and expiration dates

  • Financial transaction data - Monetary amounts including the base amount tendered and any tips

  • Customer loyalty integration - Tracking of loyalty points redeemed as part of transactions

Club Reports: Club Memberships at the end of each month

Club Reports: Club Memberships at the end of each month

Club Reports: Club Memberships at the end of each month

These are Membership Status Summary Reports

This is a much simpler, time-series report (by month, quarter or year) focused specifically on tracking membership program metrics over time.

Key components of the report include:

  • Time dimension - Membership dates to track trends and patterns over time

  • Membership status metrics:

    • Active memberships - Count of currently active members

    • On-hold memberships - Count of paused or suspended memberships

    • Total memberships - Overall membership count (likely active + on-hold + any other statuses)

Business Reports| Tasting Room: Visited 13-24 Months Ago, Not Since

List visitors to the Tasting room who visited between 366 and 730 days ago but not in the past year.

ENO Preset Campaigns | Routine Campaigns: Club Members with an anniversary in the next 30 days

This lists all members and their next anniversary within the next 30 days.

Fixes

Monthly and Weekly Run Rates in Build Beyond Limits are now responsive to the date picker.

v25.07.01 - July 1st 2025

New

ENO Preset Campaigns

We have created numerous preset campaigns for you that will help you grow your business if you run them as part of a regular routine. The 3 Folders are 'Customer Loyalty', 'Routine Campaigns', and 'Club Processes'. Please watch the following tutorial on how to use these campaigns.

Customer Loyalty

This folder contains campaigns aimed at reducing attrition by engaging with customers at various stages of disengagement with the winery. It also includes campaigns to strengthen acquisition by providing you with a list of customers whose behavior indicates increased engagement with the winery. Additionally, it provides reports on sales velocity, identifying customers whose sales velocity is decreasing significantly and those whose sales velocity is increasing significantly.

Routine Campaigns

This folder includes reports that will help you identify people who gifted in a certain period in the past. Now you can see who, for instance, gifted in May of last year, and contact those customers again near the end of April to see if they would like to gift again this year.

It also includes a report showing your customers (based on billing contact info) who have a birthday in the next 30 days.

Club Processes

These reports identify customers who were never club members, but would be great candidates to join your club. It also includes a report on past club members who have remained active after their membership was cancelled and are worth reaching out to.

Dimensions and Filters

Contact Initial Sales Associate

This is available in Build Beyond Limits, under the Contact Segmentation Category, and indicates the contact's initial Sales Associate. This is derived from the first Paid order that is not a Reservation Order Type, or where the external vendor is Tock.

Contact Initial Order Type

This is available in Build Beyond Limits, under the Contact Segmentation Category, and indicates the contact's initial Order Type. This is derived from the first Paid order that is not a Reservation Order Type, or where the external vendor is Tock.

Allocation Name

The Enolytics-created name for the allocation is based on the month in which the Allocation happened. This is only for orders with a Channel Type of Allocation. An example of the format is "Jan-Allocation". The advantage is that you can now easily compare allocations across different years. The limitation is currently that allocations that span several months cannot be tracked in this manner. The dimension is available in Build Beyond Limits in the Allocation General Category.

Allocation Group Name

This is an Offset Partners-generated name at the time of the order. The dimension is available in Build Beyond Limits in the Allocation General Category.

Days Since Contact Last Allocation Order

This is an additional Days Since counter, now for the channel type 'Allocation'. It is part of a group of 'Days Since' dimensions, like Days Since Contact Last POS Order, Days Since Contact Last Club Order, Days Since Contact Last Website Order, and Days Since Contact Last Order. It can be found in Build Beyond Limits in the Contact Segmentation Category.

Allocation Last Order Date

This is the actual date of the Contact's last order with channel Type 'Allocation'. It can be found in Build Beyond Limits in the Contact General Category.

Days Until Contact Birthdate

This is the days between today and when the contact has their birthdate (billing contact birthdate). It can be found in Build Beyond Limits in the Contact Segmentation Category.

Measures

% of Membership Total YDAY

Measure to calculate the YDAY share of memberships, with YDAY being the last date in the CP period of your date picker. This measure is available in Build Beyond Limits and has been added to the Club Summary in the 'How Many Members Do We Have?' section of the Wine Club Module.

Σ Net Sales Allocation

This measure calculates the Net Sales for the Channel Type Allocation. This is part of a similar group of measures covering the other major channel types Σ Net Sales Club, Σ Net Sales TR (Tasting Room), Σ Net Sales Website, and Σ Net Sales Events. It can be found in Build Beyond Limits.

Σ Net Sales Allocation Ratio

These measures calculate the ratio between Allocation and the total net sales across all channels in the winery. This is part of a similar group of measures covering the other major channel types Σ Net Sales Club Ratio, Σ Net Sales TR Ratio (Tasting Room), Σ Net Sales Website Ratio, and Σ Net Sales Events Ratio. It can be found in Build Beyond Limits.

Σ Allocation Orders (Excl $0)

This measure calculates the Orders (Excluding $0 Orders) for the Channel Type Allocation. This is part of a similar group of measures covering the other major channel types Σ Orders (Excl $0) Club, Σ Orders (Excl $0) TR (Tasting Room), Σ Orders (Excl $0) Website, and Σ Orders (Excl $0) Events. It can be found in Build Beyond Limits.

Σ Net Sales Rank

This is our initial introduction to ranking in Build Beyond Limits. We are making the following measures available Net Sales Rank CP, Net Sales Rank PP, and Net Sales Rank All Time. The ranking is sorted as descending with the highest net sales being ranked 1, 2nd highest net sales ranked 2, etc. You can apply measure filters to these measures to limit your data set to your top n (10, 20, etc).

Fixes

Export of Pivot Tables

Export of Pivot Tables is now fixed.

Sales Associate for Offset Partners CRM

Previously, we used the Sales Agent to define the Sales Associate. Now we are using the 'Sales Credit' field, and only if it is empty, will we fall back on the 'Sales Agent' field to populate the Sales Associate for our customers who use the Offset Partners CRM.

Non Alcoholic Wine Type for Shopify CRM

This type was previously unknown and therefore would not count the cases sold or bottles sold. We are now assigning the Non Alcoholic Wine in Shopify to the product Type 'Wine'.

Contact Address for Offset Partners CRM

Initially, we used the mailing address provided by Offset. However, to align with our other CRM implementations and to follow the standard use of the Offset Partners CRM, we changed the address to the billing address.

v25.06.10 - June 10th 2025

New

Budget General

Now officially available to everyone. You can provide Enolytics with a template of your budget (see How to upload your budget using a template), or you can manually upload your goals/budget.

Dimensions and Filters

Switched To Date

Added to Build Beyond Limits in the Membership Activity Category

Order Sequence

This is the sequential order number (excluding $0 orders) per customer. This will now make it easy to see the fall-off between orders. Added to the Order General Category of BBL

Wine Last Ordered Date

Last Ordered Date for a specific Wine Name (as opposed to SKU level). Added to the Product General Category of BBL.

Days Since Wine Last Ordered

Number of days since a wine name was last ordered. Great for segmentation. Added to the Product General Category of BBL.

Wine First Ordered Date

First Ordered Date for a specific Wine Name (as opposed to SKU level). Added to the Product General Category of BBL.

Wine Tenure in Years

Tenure of the wine name (as opposed to SKU level) in years. Meaning the difference between the first ordered date and last ordered date. Added to the Product General Category of BBL.

Length of release in days

Tenure of a SKU in days. Meaning the difference between the first ordered date and last ordered date. Added to the Product General Category of BBL.

Duplicate Address Check

Verifies if an address likely may be duplicate to help you find duplicate customers. Added to the Contact Quality category of BBL.

Duplicate Phone Check

Verifies if a phone number likely may be duplicate to help you find duplicate customers. Added to the Contact Quality category of BBL.

Last Cancelled Club Name

This identifies the last cancelled club for the contact.

Last Cancelled Club Sales Associate

This identifies the sales associate who did the sign up for the last cancelled club.

Measures

Σ Loyalty Analysis

Velocity Scores

This will help you identify the buying behavior of customers through a velocity score. There are three velocity scores: Net Sales Velocity ScoreOrders (Excl $0) velocity score, and the 750ml Bottles (Excl $0) velocity score.

If the score is less than 100%, then the customer has spent less in the past 365 days (to exclude seasonality) compared to the previous 365 days. Customers can have a loyalty score indicating they are a top or loyal customer, yet their velocity score may suggest that they are likely to become at-risk customers.

This measure indicates the all time spend of the customer calculated as the ratio of all time Wine Spend divided by the Wine AOV outside of the club channel in the past 365 days. This will help you identify your top buyers easily.

Σ Order Dates

This will provide you with the Max and Min Order dates, either for the Current Period or all time.

μ Growth Ratio

Added this measure to Build Beyond Limits

Net Sales Last 2 years Ratios

These are a series of calculations that should assist you in reviewing performance and velocity over the past 2 years.

The ratio will show you the ratio of the specific period compared to the full 2 years. These measures can be used with filters and for both contacts and order dimensions.

1 YAGO is the period of today, a year ago, through yesterday.

2 YAGO is the period of today, two years ago, through yesterday a year ago.

750ml Bottles (Excl $0) Last 2 years Ratios

These are a series of calculations that should assist you in reviewing performance and velocity over the past 2 years.

The ratio will show you the ratio of the specific period compared to the full 2 years. These measures can be used with filters and for both contacts and order dimensions.

1 YAGO is the period of today, a year ago, through yesterday.

2 YAGO is the period of today, two years ago, through yesterday a year ago.

Orders (Excl $0) Last 2 years Ratios

These are a series of calculations that should assist you in reviewing performance and velocity over the past 2 years.

The ratio will show you the ratio of the specific period compared to the full 2 years. These measures can be used with filters and for both contacts and order dimensions.

1 YAGO is the period of today, a year ago, through yesterday.

2 YAGO is the period of today, two years ago, through yesterday a year ago.

Orders (Excl $0) Last 5 years Ratios

These are a series of calculations that should assist you in reviewing performance and velocity over the past 2 years.

The ratio will show you the ratio of the specific period compared to the full 5 years. These measures can be used with filters and for both contacts and order dimensions.

1 YAGO is the period of today, a year ago, through yesterday.

2 YAGO is the period of today, two years ago, through yesterday a year ago.

etc.

Σ Weekly Run Rates Items (Incl $0)/Σ Weekly Run Rates Items (Excl $0)

Will help you forecast the run rate of non-wine items

Fixes

Tenure in Months

This has been fixed. There was an issue when a customers switched clubs and their current club was not cancelled yet.

v25.05.13 - May 13th 2025

New

Bookmark improvement!

Measure Filters are now saved with bookmarks. If you create a report that has a measure filter applied, and bookmark it. The measure filter will now be saved as part of the bookmark!

Dimensions and Filters

Campaign List and Campaign List Created Date

Both are now part of Build Beyond Limits in the Campaign Lists Category.

Second, Third, Fourth and Fifth Order Type

In Build Beyond Limits, in addition to the initial order type you can now also find the second, third, forth and fifth order type. This works in combination with the days between first and second order, etc...

Measures

Average Days between first and second order

Days between first and second order where the orders are 'Paid' or 'External', do not originate from Tock or from C7 Reservation and are not $0 orders. This will help you understand the customer flow between order types and the average days it takes between orders.

Average Days between second and third order

Days between second and third order where the orders are 'Paid' or 'External', do not originate from Tock or from C7 Reservation and are not $0 orders. This will help you understand the customer flow between order types and the average days it takes between orders.

Average Days between third and fourth order

Days between third and fourth order where the orders are 'Paid' or 'External', do not originate from Tock or from C7 Reservation and are not $0 orders. This will help you understand the customer flow between order types and the average days it takes between orders.

Average Days between fourth and fifth order

Days between fourth and fifth order where the orders are 'Paid' or 'External', do not originate from Tock or from C7 Reservation and are not $0 orders. This will help you understand the customer flow between order types and the average days it takes between orders.

Fixes

The projected attrition, signup and growth ratios were not calculating correctly. This is now fixed.

v25.04.24 - April 24th 2025

New

Updated Date Picker

We changed the User Experience of the date picker to make it more intuitive. All Presets are now on the initial page of the date picker. If you want to select your own date range, you can click on 'Pick Your Dates' and then easily select your date range. The moment you select your start date in 'Pick Your Dates', the start date will be populated in the Start date -> End date visualization.

Dimension

Migration Order Number. This is a new field that will allow us to compare WD and C7 orders next to each other during the C7 migration process. This is available as a filter and in Build Beyond Limits.

v25.04.15 - April 15th 2025

New

Tasting Room - Guest Account Trends

Actively track the use of the guest account over time. For the entire tasting room and for your individual sales associates. Go to the Tasting Room Module and Click on Guest Account Trends

Campaign Lists

Campaign Lists allow you to track the success of your campaigns over time or to exclude specific contacts from future campaigns. Unlike bookmarks, which are typically dynamic and update based on buying behavior or timelines, Campaign Lists are static. They consist of a fixed set of customer numbers you define up front. This makes them ideal for measuring the impact of a campaign later on and for ensuring, in real time, that contacts aren’t targeted again—such as excluding someone who already received a previous campaign.

Dimensions and Filters

Club Name At Time Of Order and Aggregate Club Name At Time Of Order

This provides you with the club name the customer was in at the time of the order. A great use case for this would be to review your tasting SKUs or experiences and see what clubs your members were part of during the tasting.
It is both a dimension that can be filtered by and available in Build Beyond Limits in the Club General Category.

Last Signed up Club Sales Associate

This shows the sales associate who signed up for the last club membership for the contact. This will only be populated if the contact still has a "current" club membership. It is both a dimension that can be filtered by and available in Build Beyond Limits in the Contact General Category.

Last Signed up Club Name

This shows the Club Name of the last club membership for the contact. This will only be populated if the contact still has a "current" club membership. It is both a dimension that can be filtered by and available in Build Beyond Limits in the Contact General Category.

Last Signed up Club Signup Date

This shows the signup date for the last club membership for the contact. This will only be populated if the contact still has a "current" club membership. It is both a dimension that can be filtered by and available in Build Beyond Limits in the Contact General Category.

Last Signed up Club Membership Status

This shows the club membership status ('Active' or 'On Hold') for the last club membership for the contact. This will only be populated if the contact still has a "current" club membership. It is both a dimension that can be filtered by and available in Build Beyond Limits in the Contact General Category.

Measures

Σ Club Orders and Σ Club Order Presets

This calculates the number of orders for the Channel Type = 'Club'. This is available in Build Beyond Limits as both regular and preset calculations.

Fixes

Avg Bottles Per Order in the Tasting Room Secondary KPIs is fixed.

v25.04.07 - April 7th 2025

New

Preset Reports

This is a new preset report that will allow you to analyze your shipping revenue by ship to state and by the number of bottles in the order. This will help you analyze your shipping profitability and help you create shipping discount and pricing strategies.

Dimensions and Filters

indicates the number of bottles in order. It does not distinguish between bottles based on value. It is the sum of the quantity of items in the orders that have a product type = 'Wine'. The Dimension can be found in Build Beyond Limits.

Ship To Address

This is an important part of financial reporting. This can be found in Build Beyond Limits.

Ship to County

This is an essential part of financial reporting. This can also be used as the Tax County. This can be found in Build Beyond Limits.

Club Pickup Location

The Default Pickup Location where the member picks up their club orders. The Dimension can be found in Build Beyond Limits.

Is Shipped

Indicates whether an item was shipped. This uses the Shipping Status and will be interpreted differently for each CRM.

Calculations

Calculates the average age of your contacts in the context you'd like to use it. A use case could be to know the average age of members of each of your different clubs to see if there is a significant age discrepancy. The Measure can be found in Build Beyond Limits.

Days with Orders

Number of Days with Orders. Counts the number of distinct days that had orders. The use case is to easily be a able to count the days that sales associates have been working (processing orders) or days a product has been sold on. The Measure can be found in Build Beyond Limits.

Net Sales/Days with Orders

Calculates the net sales to Days with Orders ratio. This can be used to compare the performance of Sales Associates based on a daily ratio rather than a date range. The Measure can be found in Build Beyond Limits.

Days with TR Orders

Number of Days with Orders in channel type Tasting Room. Counts the number of distinct days that had orders. The use case is to easily be a able to count the days that sales associates have been working (processing orders) or days a product has been sold on. The Measure can be found in Build Beyond Limits and in the Tasting Room | Who Sold It module.

Net Sales TR/Days with Orders

Calculates the net sales in channel type tasting room to Days with Orders in channel type tasting room ratio. This can be used to compare the performance of Sales Associates based on a daily ratio rather than a date range and in the Tasting Room | Who Sold It module.

Shipped Sales

Calculates the Sales for the Items that are shipped based on the Shipped Date (not the completed date).

v25.03.21 - March 21st 2025

New

Calculations

Calculates the average tenure (in months, without clubs excluded from reporting) for cancelled memberships. Use this in combination with filters like Last Cancelled Date or Days Since Last Cancellation. It can be found in Build Beyond Limits and in 'How Many Members Do We Have | Club Summary)

Avg Combined Membership (Excl)

Calculates the average tenure (in months, without clubs excluded from reporting) for both active and cancelled memberships. It can be found in Build Beyond Limits and in 'How Many Members Do We Have | Club Summary).

Discounts in $ (Including $0 orders). For $0 orders, this means that the Discounts $ (Incl 40) is equivalent to the Gross Sales amount. For non $0 orders, it is equivalent the difference between the Gross Sales amount and the actual sold price/net sales.

v25.03.18 - March 18th 2025

New

Dimensions and Filters

Contact Created Year Month

The Year and Month the contact was created in. It can be found in the Contact General Category of Build Beyond Limits

Represents the "Month-Day Format", "Yearless Date", or simply "Day of Year without Year" for the Order Completed Date. It can be found in the Order General section of Build Beyond Limits.

This field is created to help sort the Week Day of Month field. The week day of month field represents days as follows: 1st Monday of January, 4th Thursday of November, etc. Prior to the sortkey, this field would be sorted alphabetically. Using the sortkey, you can sort it chronologically.

v25.03.11 - March 11th 2025

New

Calculations

Avg Days Between Orders

The Average Price Per Item measure set has been added to Build Beyond Limits. This calculates the average days between orders in the period. For instance if date picker is set to 1/1/25 - 3/31/25 and the first order in the period is on 1/15/25 and the last order is on 3/15/25. The difference between the first and last date was 60 days. If the contact had 5 orders, the average days. between orders would be 12 (=60/5).

Dimensions and Filters

This is the part of the email address after the "@"-symbol. (eg. wellsfargo.com). Use cases for this are to see which company may have the most contacts in your database (use in combination with email type).

You can also exclude it to easily remove winery email addresses.

Varietal and Wine Name Preferences.

Enolytics now helps you identify varietal preference and wine name preference

The wine name and varietal preference algorithms analyzes a customer's purchase history to identify their preferred specific varietals or wines and classify them into meaningful segments. This classification provides insights on varietals or wine names that customers repeatedly purchase.

Examples

Customer

Purchase Pattern

Classification

Explanation

A

80% Estate Pinot Noir, 20% other wines

Estate Pinot Noir Lover

One wine ≥70%

B

55% Reserve Cabernet, 30% Rosé, 15% other

Reserve Cabernet Lover

Dominant wine (≥50% and 1.5× next)

C

48% Estate Syrah, 47% Vineyard Select Grenache, 5% other

Estate Syrah & Vineyard Select Grenache Dual Lover

Two wines between 45-55%

D

40% Signature Zinfandel, 35% Sparkling Brut, 25% other + 12 Signature Zinfandel purchases

Signature Zinfandel Enthusiast

Frequent purchases (≥10)

E

30% Limited Release Malbec, 25% Barrel Select Merlot, 45% various

Mixed Product Drinker (Limited Release Malbec, Barrel Select Merlot)

No dominant pattern

Last Order Dates

You can now find the last order dates for the following channels: all channels combined, club, website and tasting room.

The channel designation is based on the channel type you have configured in the configuration mapping.

Days Since Last Order

In the same context of 'Last Order Date', you can now find the days since last order for the following channels: All Channels, Club, Web and Tasting Room.

The channel designation is based on the channel type you have configured in the configuration mapping.

Tax Sale Type

Order Level: C7 Only

Order Item Level: C7 Only

Order Item Level: C7 Only

Order Level: C7 Only

Order Level: C7 Only

Order Level: C7 Only

Improvements

C7 reservations

When the 'Delay Reservations' setting is enable in Enolytics and when using C7 for reservations the following rules will be applied:

When the reservation date is in the future, the revenue will be delayed till the reservation date (order completed date will be set to the reservation date). Pending Reservation Dates can be found in Build Beyond Limits.

v25.03.04 - March 4th 2025

New

Dimensions and Filters

Commerce7 Sales Attribute

We added support for the Sales Attribute field in Commerce7. For those using Custom Fields/Metadata in Commerce7 to track Order Types, you can now use Sales Attribute to identify your order types and channels. Contact [email protected] for more information.

Calculations

Net Sales Last 5 Years and Net Sales Last 5 years Ratios

These are a series of calculations that should assist you in reviewing performance and velocity over the past 5 years.

The ratio will show you the ratio of the specific period compared to the full 5 years. These measures can be used with filters and for both contacts and order dimensions.

1 YAGO is the period of today, a year ago, through yesterday.

2 YAGO is the period of today, two years ago, through yesterday a year ago.

etc.

YAGO stands for Year(s) Ago.

The measures are available in Build Beyond Limits.

Net Sales Non-Club

The Net Sales Non-Club measure set has been added to Build Beyond Limits.

Net Sales Channels and Net Sales Channel Ratios

You can now easily report filter on the channel net sales and channel ratios. For example, you can now run a report on someone who spent at least 20% of their net Sales in the tasting room and over $300 online.

v25.02.23 - February 23rd 2025

New

C7 Migration Status

We've added a section in Data Quality to help you with pro-actively cleaning your customer data prior to migrating to Commerce7. More info can be found in this knowledge base article and this Customer Round Table Recording.

There is also a Ω C7 Data Check section in Build Beyond Limits if you want to create your own reports on the topic.

Measures

Avg Price Per Item

The Average Price Per Item measure set has been added to Build Beyond Limits.

Improvements

Contact Phone Number

The Contact List in Who Are My Contacts now includes a phone number.

Bug Fixes

Anniversary Month

Club Anniversaries can now be filtered by Anniversary Month. This can be done in Wine Club | Other Interesting Things | Club Anniversaries.

v25.02.11 - February 11th 2025

New

Measures

Net Sales Non-Wine

We created a set of new measures for Net Sales Non-Wine and added them to Build Beyond Limits.

Wine Order Conversion Rate

We created a set of new measures for Wine Order Conversion Rate and added them to Build Beyond Limits, the secondary KPIs in the Tasting Room Highlights page and the Associate Performance table on the 'Who Sold It?' page of the Tasting Room Module.

Club Lifetime Value

Member Lifetime Value has been added as a KPI to the Wine Club Highlights secondary KPIs. We also added it to the Performance table of 'How Many Members Do We Have?' and in Build Beyond Limits.

Margin in $

The Margin in $ (Excl $0) measure set has been added to Build Beyond Limits.

Gross Sales (Incl $0)

The Gross Sales (Incl $0) measure set has been added to Build Beyond Limits.

Improvements

Dimension Active Club removed

Active Club has been removed. It has been replaced by 'Members Of'.

Who is at Risk of leaving

Added Tenure in Months to the Wine Members at Risk Table

What to Know about my Contacts

  1. We added total # of records to the "Recent Risk Status Changes" table.

  2. We updated the filters for the RFM Status Change to only the ones that mattered.

Bug Fixes

Inventory

Fixed issues with Inventory export and we added the additional tab for historical inventory information that will display inventory by date, inventory pool and SKU for the past 365 days).

Export of Images

There was an issue where, often, when exporting images, the saved image would be blank. This is now fixed.

v25.02.04 - February 4th 2025

New

Compare to 2 and 3 years ago

Prior Period can now be set to 2 years ago and 3 years ago. Use the "Compare Years Back"-slider in the date picker, to set your Prior Period. All Δ and Δ% values will be updated to compare the Current Period to the updated Prior Period.

v25.01.17 - January 17th 2025

New

Shopify Integration

Enolytics is now compatible with Shopify (using the Bloom or Awtomic subscription modules)

Benchmarking

We now have 'Benchmarking' available in Enolytics! 🎉 You can find this feature in the Benchmarking section of the navigation bar. This section includes three pages:

  1. Order KPI Overview: Displays the main Order KPIs.

  2. Club KPI Overview: Covers membership attrition, signups, and growth.

  3. Historical View: This shows your monthly, quarterly, and yearly performance compared to your cohort.

You can use specific benchmark filters to narrow your cohort based on geography, business size, average price per bottle, and wine club size.

Benchmarking is entirely anonymous!

Click on the expand button in the top right of the vimeo section below to view full screen

Associative Filtering

The Associative filter is a powerful new type of filter. Unlike regular filters, it links to a specific entity. For example, in marketing or customer lists, it might use a unique customer number. In Wine Analysis, it could be the SKU or wine name.

This allows for filters like: all customers who have purchased in the tasting room but not on the website. Regular filters can't do this because they don't link specifically to a customer number.

The associative filter is excellent for exclusions where a customer can belong to multiple groups, such as contact types. For instance, you can exclude all contact types that are Employees, Media, and Industry.

Click on the expand button in the top right of the vimeo section below to view full screen

Improvements

UI Improvement: Export to Excel from Tables

All tables in the application now have an Excel icon

in the top right corner, making it easy to export to Excel. You can still use the right-click and select the Export option.

Build Beyond Limits New Measures:

μ Projected Full Year Ratios. This will calculate your projected attrition, signup, and club growth ratios. To do this, divide your year-to-date (YTD) ratio by the current day of the year, then multiply it by 365. This will give you an idea of your club's performance by the end of the year if you maintain your current pace.

Non Wine

Dimensions and Filters:

CRM Internal IDs. These are the internal unique IDs used by your CRM. This can come in handy when you are going through a data migration.

Last Cancellation Reason: added to the Contact Segmentation category

Wine Club | How Many Members Do We Have?

We included the Club Lifetime Value in both the Highlights and Performance sections. Here's how we calculate it:

  1. The sum of Net Sales: Add up all net sales from the past 12 months for orders where the contact was a club member at the time of the order (across all channels).

  2. Average Monthly Spend: Divide the total net sales by 12 to get the average monthly spend.

  3. Average Number of Members: Divide the average monthly spending by the average number of club members in the past 12 months

  4. Multiply by Average Tenure: Multiply the result by the club(s) average tenure.

Wine Club | Who's at Risk Of Leaving | Recent Risk Status Changes

We added the Contact Last Order Date to the table.

Bug Fixes

Margin and Cost of Goods Sold

Improvements have been made to these measures.

Tasting Room Highlights

The 'Tasters' KPI was mistakenly showing the 'Member Tasters' value.

v24.12.17 - December 17th 2024

New

Number of records

The number of rows in tables has been removed and been replaced by the '# of records ' in the top right corner of the applicable tables. This will ensure an accurate record count at any time.

This functionality is also enabled by default in Advanced Reporting | Build Beyond Limits. It is no longer necessary to select row count as a separate measure. The row count has been removed from all public bookmarks. As soon as you start generating a (table) report in Build Beyond Limits, the record count will be displayed.

v24.12.16 - December 16th 2024

New

Ask me Anything

In Build Beyond Limits you can now write out the report you would like. We then use AI to create your report.

Integration with eCellar

Enolytics is now compatible with eCellar (and also Classic WineDirect, Commerce7, and VinSuite)

View your Active and Inactive Users

In the Data Quality module, you will now find the option to view your active and inactive users. Just go to Data Quality | Users.

Please contact [email protected] if you want to disable a user.

Inventory

Inventory, including specific inventory KPIs (Weeks of Stock, Inventory Turnover, etc.), has been added.

Weekday of the Month

We have added a field called Week Day of Month. You can now compare Year-over-year days of the month to the same days each year. E.g., the Fourth Friday of November, the Third Sunday of April, etc. You can also filter by this to do a more extensive analysis in the dashboard. Build Beyond Limits has been updated with the 'Week Day of Month' dimension. It can be found in the Order General Category.

Members of Club / Members of Aggregate Club

This is a new filter (and field). When you select Members of Club, you can choose between all the available clubs. When you select a club, all data will be filtered to only active and on-hold members of that club or aggregate club.

Wine Club Secondary KPIs

We have added several additional KPIs to Wine Club. Amongst them are average Tenure, Club Lifetime Value, and End-Of-Year projected attrition, sign-up, and club growth rates.

You can also view the breakout of tenure and club lifetime value by going to How Many Members Do We Have? | Performance

Improvements

Brand added to dropdowns

'Brand' has been added to the main dropdown options in the KPI dashboard

Added Sales Associate to Who's at Risk of Leaving | Recent Risk Status Changes

We added the sales associate that signed up the club member to the table of Changes in Risk Status.

Bug Fixes

Wine Club | How Many Members Do We Have? | Club Summary.

The dropdown was set by default to aggregate club name but initially showed all club names.

Wine Club | Who Changed Status

'View in CRM' links are now working.

Sales | What did we Sell

Fixed an issue where Cases Sold CP was incorrect.

v24.12.02 - December 2nd 2024

New

Preset Reports

  • A new public club report has been created. It provides data by Aggregate Club and Club Name. The KPIs covered are: Active Members, On Hold Members, Total Members, Sign Ups, Cancellations, Growth, Attrition Ratio and Signup Ratio.

Recent RFM Status Changes.

  • This lists the Changes in RFM who moved up in risk. Like the Recent Risk Status Changes for Clubs, you can select the period you want to review by changing the slider.

Additional Club KPIs

We added the following Club KPIs to the Wine Club | Highlights Page, as secondary KPIs: Average Tenure in Months, Net Sales (Club) - this is the net sales attributed to a specific club (Order has to be linked to a club name), AOV (Club), Projected Annual Attrition (We forecast the annual attrition rate by dividing the current attrition rate by the day of the year number and multiplying it by 365. Projected Annual Sign Up Ratio and Projected Annual Growth Ratio. You can find many of these KPIs in more detail in the How Many Members Do We Have? | Performance tab.

What is my Membership Churn? | Club Details

We are now allowing you to analyse the churn over time for your individual clubs (that are not excluded from reporting). This provides you with valuable data on which clubs are churning faster/slower than others.

Data Quality | Mapping Configuration

You can now review your mapping within the Enolytics DTC Platform without having to go to your spreadsheet. You can use the 'Open the Config Sheet' button to open your configuration sheet.

Improvements

  • Who is at Risk of Leaving | Recent Risk Status Changes: There were instances where the customer may have dropped back to Low, Very Low, or Average in the period since going to High and, therefore, should not show up on the Recent Risk Change list. This has now been implemented.

  • Advanced Reporting. Cost of Goods - changed the format to be two decimals.

  • Wine Club | Who are my Best Customers : We added last cancellation reason to the 'Past Customers' table.

  • Wine Club | Who at Risk of Leaving | Recent Risk Status Changes : We added the individual risk factors to provide you with more information as to why the membership is considered at risk.

  • Advanced Reporting. Taxes - changed the format to be two decimals.

  • Sales | Other Interesting Things | Orders in Period : Added several additional columns to this table.

Bug Fixes

  • Vintage: fixed format of the Vintage dimension to reflect the actual vintage year.

  • How Many Members Do We Have? | Excluded Clubs. Now shows actual data instead of just zero values.

  • fixed issues with some KPIs for VinSuite (tips, taxes, shipping)

  • fixed issue with 'refunds' for VinSuite

v24.11.20 - November 20th 2024

New

Measures

  • Submitted Sales: This is the revenue (quantity * sold price) for all orders with an order status of 'Completed' or 'Quarantine' and a Payment Status of 'Paid,' 'Refunded', or 'External.' The measure uses the Order Submitted Date. This measure is available in Build Beyond Limits.

  • Gross Sales (Excl. $0): This is the gross sales (quantity * list price) for all orders (excluding $0) with an order status of 'Completed' and a Payment Status of 'Paid,' 'Refunded', or 'External.' The measure uses the Completed Date. This measure is available in Build Beyond Limits.

  • Discounts $ (Excl $0): This is the difference between the Gross Sales (Excl $0) and the Net Sales (Excl $0) in dollars. The Discounts % (Excl $0) already existed.

Dimensions and Filters

  • Reporting Group: This mapped dimension (column M in the Wine Mapping configuration) allows you to aggregate Wines into a reporting group. (For example, 2012 Cabernet Sauvignon Howell Mountain (item name) aggregates into Cabernet Sauvignon Howell Mountain (wine name) and aggregates into Library Wines (Reporting Group). Contact our support team at [email protected] to help with the configuration.

Improvements

  • Tips and Net Sales in Build Beyond Limits now show with 2 decimals

  • Sales | How Much Did We Sell? | Performance: We added Distinct Purchasers to the Performance Table

  • CRV Taxes are available in Build Beyond Limits.

    • We added a new public bookmark with a CRV report

  • KPI Dashboard: Switching between Net Sales and Cases Sold. You can now easily switch between both measures while maintaining the proper format of the measures.

  • Sales | What Did We Sell? : Product Type is now one of the choices to view.

  • Coupons: Coupon Details can be found in Sales | Other Interesting Things

  • Gift Cards: Gift Card Details and Gift Card Activity can be tracked in Sales | Other Interesting Things

  • $0 orders: Zero dollar orders (promotions, pour write-offs, etc) can be easily tracked in Sales | Other Interesting Things.

Bug Fixes

  • CRV Taxes were not always calculated correctly.

  • The first Order Date and Last Order Date were not always displayed correctly.

  • Club Shipment Names were not working correctly.

Did this answer your question?