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
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