Hi guys,I'm basically trying to create an extraction removing all constituents that have booked to only 1 show in the last 18 months.
I've pulled extractions in the past giving all those constituents that have booked in the last 18 months, either using "Ticket Production - IN - X" to list all constituents that brought tickets to shows in the given time period, or "Ticket Order Date - BETWEEN - X and Y" to list all orders in the time period depending on what data I need, but I'm not sure how to specify that the customers will need to have booked to more than 1 show or placed more than 1 order.
Does anyone know what segment criteria I'd need to use to get this information? Thanks in advance!
Sam
Hi Sam
I think we have a custom element within list manager (and extractions) which is used to count the number of unique performances the customer has. Here is the SQL from list manager to do this (although it may need some tweaking for your organisation):
Select Distinct a.customer_no From t_customer a (NOLOCK) Where IsNull(a.inactive, 1) = 1 AND Exists (select 1 from lvs_tkt_hist (NOLOCK) Where lvs_tkt_hist.customer_no = a.customer_no Having count(distinct perf_no) = 1)
Hope this helps
Mark
You could first suppress everyone who has an order in the date range and who has Tickets-Number of Unique Perfs = 1.
______________________________
Lucie SpielerIT Development and Training Manager
Editor, Season ProgramFLORIDA GRAND opera8390 NW 25th StreetMiami, FL 33122305.854.1643 x. 1521Box Office: 800.741.1010To Give a Gift: 305.403.3315www.FGO.org2011-2012 • 71ST SEASON • LOVE FORBIDDEN, NOT FORGOTTENLuisa Fernanda • La rondine • Rigoletto • Roméo et Juliette