Platform: Enolytics DTC

Summary:

What it is: Days between Order and Club Signup Date shows the number of days between when an order was placed and when that customer originally joined the wine club, with NULL values for non-club members at the time of order.

How to use it:
• Track customer journey patterns by analyzing how purchasing behavior changes over time after club signup - do new members order frequently at first then taper off, or do they gradually increase their non-club purchases?
• Identify the optimal timing for targeted campaigns by finding when club members are most likely to make additional purchases beyond their club shipments.

Tip: Negative values indicate orders placed before club signup, which can help you spot customers who might be good club prospects since they were already purchasing before joining.

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:

Number of days between the order date and the customer's initial club signup date. NULL if the customer is not an active club member at the time of the order. For club level switches, uses the original signup date before the first switch.

Order General

Type: int

Format: #,##0