Customer lifetime sales in magento
Posted by navaneeth on Dec 29, 2013 in Magento, Php | No comments yet
![](https://i0.wp.com/navaneeth.me/wp-content/uploads/2013/12/hr-606x228.png?fit=584%2C220&ssl=1)
We speak plenty regarding customer lifetime sales in magento. It’s truly quite vital once making decisions around marketing / advertising pay and more specifically the return you get on a channel (i.e. — PPC).
Running this report in Magento may be a little bit of a pain, however as luck would have it an easy MySQL query will solve your problems. the subsequent MySQL query provides you a listing of customer emails, names, and total purchase amount over the life of the customer (since the dawn of time!).
SELECT DISTINCT customer_email, customer_firstname, customer_lastname, SUM(subtotal_invoiced) AS Total FROM `sales_flat_order` AS a GROUP BY customer_email ORDER BY SUM(subtotal_invoiced) DESC
Leave a Reply