Subscription start date

[egormsen]

Anyone have any ideas on the best way to figure out how long a customer has been a subscriber of one our subscription plans? We would like to reachout to people who have been subscribers certain amount of time (ie 6 months, 12 months) with special offers.

Thanks,

[mazhar]

How about using Order Date of subscription?

[egormsen]

I must be looking in the wrong place - I don't see an order date in the subscription table. In that table there are dates for Expiration, NextOrder, LastOrder, ExpirationAlert

Where do I find that original order date?

[mazhar]

For this you will have to use a JOIN query. Subscription is created against an order item which belong to an order. Following query will get you all subscriptions with related order date

Code: Select all

SELECT S.SubscriptionId, O.OrderDate FROM ac_Subscriptions AS S 
INNER JOIN ac_OrderItems AS OI ON S.OrderItemId = OI.OrderItemId
INNER JOIN ac_Orders AS O ON OI.OrderId = O.OrderId

[egormsen]

Thank you!