Hi!
I've had such good luck on the forums...but this one might be a little hard for me to explain, so bear with me. I apologize in advance if this too broad or if I'm not providing enough info to help troubleshoot.
We send a daily email to all patrons who attended the performance the night before (perf_code from a local view which joins T_ORDER_SEAT_HIST and T_SUB_LINEITEM) . These lists are dynamic and are automatically re-generated every day through wordfly (or email application). The problem is, I'm not sure how to identify patrons whose tickets were NOT scanned (assumedly because they did not attend the show). We'd like to send them a different message and give them the opportunity to exchange their tickets into something else.
Do any other organizations ever send messages to patrons who did not have their tickets scanned and therefore, are assumed to have missed a performance?
Any help would be great. Otherwise, I'll have to begin training carrier pigeons. :-3
Thanks,
Tiffany
Hi Tiffany,
There is also a report called "Attendance By Performance" in the Ticketing Box Office folder that I used when I was at KC Symphony for this very reason. I would run the report for "Attended" then "Not Attended" save each of them as a list. Then send each list an email from Wordfly. Only downfall it wasn't a triggered email, I had to manually do it each time.
Melissa Champ