Top Customer Report
Top Customer Report
Hi Is there any way we can get top customer report with showing phone number so we can find the customer most are saved by the name out of area .
Re: Top Customer Report
The database query tool will allow you to do that. That would be a pretty simple query too. A simple SQL query like the one below will do that.
SELECT primary_phone, last_name, first_name, amount_spent_total FROM customers_tbl WHERE amount_spent_total > 0 ORDER BY amount_spent_total DESC;
Scott
SELECT primary_phone, last_name, first_name, amount_spent_total FROM customers_tbl WHERE amount_spent_total > 0 ORDER BY amount_spent_total DESC;
Scott