Hi Everyone - I'd like to pull a list of subscribers who are new to file and purchased a specific subscription package, but can't figure out the criteria. Could anyone share how to pull this? Thanks!
Hey Nicole!
I think everyone may have a different way of doing this, but here is how we would run it.
In list manager create a new list
Add the following in the primary criteria:
Constituent Create Date ---> Between ---> The date range of when the packages were available
Ticketing -----> Subscription Season or Subscription Series (depending on what you are looking for)
I took a screen shot to help make it a little clearer!
Hope this helps!!
And if anyone has another way, please share - I am always interested in how others run their reports!
-Ashley
Here's the SQL I use in Extraction Manager...
SELECT DISTINCT cust.customer_noFROM V_CUSTOMER_WITH_PRIMARY_GROUP AS custJOIN T_TICKET_HISTORY AS th ON cust.expanded_customer_no = th.customer_no AND th.season IN (8,9,10,11,12,13,14,15,16,17,18,19,20,2,5,27,31) --all performance seasonsJOIN TR_PRICE_TYPE AS pt ON th.price_type = pt.id AND pt.price_type_category <> 4 --exclude compsWHERE cust.inactive = 1GROUP BY cust.customer_noHAVING MIN(th.prod_season_no) = 1166 AND MAX(th.prod_season_no) = 1166 AND COUNT(th.season) = 1ORDER BY cust.customer_no