How do I generate a list of everyone who has purchased more than 3 shows in the last season?

(Last updated on: March 16, 2021)


Note:
This is an older help file. This particular feature can be accessed by going to
Reports | Other reports | Count of performances attended.

The built-in report is much easier for this .


 

There is no specific report to answer this question. Therefore, you need to use the Mailing list | Generate a mailing list | Export email function. This allows you to paste.

You have opened up an interesting world: the world of extracting data. In its basic form, the query you want to paste into Wintix is:

select count( mainsale_id ) as salecount,
customer.first, customer.last, customer.title, customer.company, customer.address, customer.city, customer.state, customer.zip, customer.phone
from mainsale
left join customer on customer.customer_id=mainsale.customer_id
group by customer.customer_id
having salecount > 50
order by salecount

It looks like this:

You can roll your own queries

Exporting email from your own query

Notes:

  1. Send output to a dbf when testing – it’s faster.
  2. The query is intended to give only a few results to make it easier to see the results. For more realistic results, change the line having salecount > 50
    to a more reasonable number.
  3. There is a bunch more stuff you can do here. Entire books have been written about this subject. The key is to start simply with a clear idea in mind of what you want to do.
This entry was posted in Reports. Bookmark the permalink.