Hey all,
I need to pull numbers to show number of New Ticket Buyers or First Time Buyers for a public on sale that happened yesterday, as well as the on sales from the past two years. I've tried using both T-Stats and List Manager to do this, but haven't figured out a way to do it yet. Is there a way to get these numbers for First Time Buyers on a specific date?
Whatever way you decide to tackle this, know that duplicate records will mess your numbers up unless you run your merge routine first (AND catch all the dupes). Here's SQL I use to find similar info...
SELECT DISTINCT th.customer_no
FROM T_TICKET_HISTORY AS thJOIN T_CUSTOMER AS c ON th.customer_no = c.customer_no AND th.role IN (1,3,5,7)
WHERE c.inactive = 1
GROUP BY th.customer_no
HAVING MIN(th.perf_dt) BETWEEN '2018/04/06' AND '2018/04/09' --th.perf_dt should range should be inclusive of all dates of the performance AND MIN(c.create_dt) >= '2017/08/01' --c.create_dt is your new to file date
AND EXISTS (select * from t_list_contents WITH (NOLOCK) where t_list_contents.customer_no in (select customer_no from V_CUSTOMER_WITH_PRIMARY_GROUP where customer_no = th.customer_no) and t_list_contents.list_no IN (4770)) --Create list of people who had tickets for production and put that list number here