How to get a customer count by zip code report

(Last updated on: October 2, 2015)

• Go to Mailing list | Generate a mailing list | Export email
• Click the Edit the query tab

COPY AND PASTE THE QUERY BELOW into the Edit the query field:

select sum(total_tix) as tickets, sum(total_sale) as sales, left(zip,5) as zip, count(customer.customer_id) as customers
from mainsale
          left join customer using(customer_id)                                                                                      group by left(zip,3)
order by zip

Here is an example of the report: