Hi guys,
I've recently started getting to grips with Triggered Emails and putting together the lists to run them. I want to create a list of every constituent that booked to a certain show 3 days ago, with the ticket purchase acting as the trigger.
So far, I've managed to successfully pull a list of everyone who booked within 3 days using the criteria;Ticket Production IN Ticket Production SeasonTicket Order Date >= DayRunDate -3
However when I use the Ticket Order Date criteria with a different operator to get only constituents who booked 3 days ago;TicketOrderDate = DayRunDate -3
the count returns 0 constituents.I thought from reading the documentation and my previous experience with Extractions and List Builder that this criteria would have given me the data I need, especially as Tessitura won't let me select any other operators such as Like or Has that may give an exact date. From checking the original list using the operator >= there are customers who booked exactly 3 days ago, I can see that there is data there, it just doesn't appear when I use the operator =. Has anyone else had this problem?
Sam
You should reach out to Jamie O'Brien at New 42nd Street. She is a whiz at setting up triggered emails :)