Coupons & Dormant Customers

[ksoup]

Thank you :) Interesting thing to note....

***Note: I have not changed the query in the database :) ...The following info is from using the query seperately in mysql ***

With the date clause taken out of this query, we have 4,168 customers that are subscribed to our newsletter and have a matching customer id on the customers table and orders table.

Adding the Date back and only changing the greater than/less than yields the following results....

Using the query with the Dormant Customers
o.date_purchased < subdate... gives a figure of 3,296

Change the date clause to o.date_purchased > subdate gives a figure of 1,868.

If you add those two together you get a total of 5164 not 4168.
That is a difference of 996 customers that seem to be doubled up.


Thoughts? This could account for the reason active customers got the coupon for dormant customers.

The physical query on this is in the query_builder table ... if this is of help to you ...