Top Customer Report

General Discussions
Post Reply
fakhar4
Member
Member
Posts: 9
Joined: Mon May 18, 2020 12:29 pm

Top Customer Report

Post by fakhar4 »

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 .
User avatar
Scott
Site Admin
Site Admin
Posts: 2566
Joined: Wed Apr 16, 2003 5:35 pm
Location: Western PA

Re: Top Customer Report

Post by Scott »

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
Post Reply