Can someone share their recipe for a Dynamic list that we can use for triggered performance reminders in WordFly? We'd like to send these 3 days before the show and we want to specify the production (25 performances occur within a production.) Frankly, I'll take any and all recipes for performances reminders and we can cobble it together. A screenshot of the criteria should do it.
Margaret Lehtinen
Indiana Repertory Theatre
mlehtinen@irtlive.com
Heath Wilder Thank you SOO much for this! Like everyone else in this thread, I have been struggling this and really appreciate having this. I have two questions for the group:
1. We would love to include the delivery method of the ticket order in the show reminder, I know I can get the Order number in the ticket history view, but I'm not sql smart enough (yet) to join on that to get the delivery method as output, so if anyone has done that, I'd love to steal your work and give you my undying gratitude.
2. Looking at the Wordfly documentation, they say to use a suppression list based on the promotion appeal. We run in rep for part of our season, so it is very possible that a single patron could be coming to different shows on consecutive days. I think if I create a reminder list and an appeal for each prod season, they would still get picked up and sent the reminder for each prod season, but I just wanted to run this past the hive mind and see if anyone else had thoughts.
Thank you all in advance!
1. I can adjust the above to add in delivery method if you like
2. You are right. Separate scheduled campaign for each prod season will only suppress that prod season. But then again if some one has booked twice (by accident perhaps) then in my experience getting an email for each booking can pre-empt them missing sorting that issue out ahead of time.