Platform: Enolytics DTC
Summary:
Contact SKU Last Order Date shows the most recent date when each customer purchased a specific wine or product through a completed, paid order. This creates a detailed timeline of product-level purchasing patterns for every customer-wine combination.
How to use it:
β’ Identify which wines your customers are actively reordering versus one-time purchases by comparing last order dates across different SKUs for the same customer
β’ Target reactivation campaigns for customers whose last purchase date for a specific wine was over a certain threshold, especially for wines they previously bought multiple times
Tip: Use this alongside order frequency data to distinguish between customers who tried a wine once months ago versus those who regularly reorder it β the reordering customers are prime candidates for case discounts on their favorite bottles.
Note: Parts of this article were generated with AI and may not be perfect. If something looks off or could be better, click the π below β it opens a quick chat so you can let us know.
Quick Stats:
Type: date
Build Beyond Limits Group: Contact SKU History
π Description
The most recent date when a contact purchased a specific wine or product SKU through a completed and paid order. This date is essential for recency analysis and identifying which wines individual customers are actively purchasing versus those they may have tried once but not reordered. Combined with order frequency data, this helps winery managers understand product-level repurchase behavior and customer preferences.
π Build Beyond Limits Group
Contact SKU History
π Other Dimensions in this Group
βοΈ Technical Details
Type: date
Format: mm/dd/yyyy
βΉοΈ Additional Details
Created: 2026-02-14T18:56:35Z
Key:
[dimension].[Contact SKU Last Order Date]ID:
75bda69f-faa2-541d-9ed1-c6fbbc71536c
π·οΈ Tags
Age
Contact SKU History
Contact SKU Last Order Date
SKU
