Platform: Enolytics DTC

Summary:

What it is: Days Since Contact SKU Last Order shows the number of days since a customer last purchased a specific wine or product, giving you product-level recency data for every contact-SKU combination.

How to use it:
• Spot reorder opportunities by identifying customers who typically repurchase a favorite wine every 90 days but are now at 120+ days
• Create targeted campaigns for specific products, like reaching out to Cabernet lovers who haven't ordered their usual bottle in months

Tip: Compare this timeline against each customer's historical purchase patterns for that SKU—someone at 180 days might be overdue if they usually reorder every 60 days, but right on schedule if they're an annual buyer.

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:

The number of days elapsed between today and the last time a contact purchased a specific wine or product SKU. This recency metric is critical for identifying reorder opportunities and potential customer churn at the product level—for example, a customer who historically ordered a favorite Cabernet every 90 days but is now at 180 days may be at risk of disengagement. Winery managers can use this to trigger targeted outreach, restock reminders, or new vintage announcements for wines customers have previously enjoyed.

Contact SKU History

Type: int

Format: #,##0