Skip to main content

Contact SKU Last Order Date

Shows the most recent purchase date for each wine or product by customer, creating detailed product-level buying patterns.

Updated over 3 weeks ago

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

Did this answer your question?