I would like to set up a weekly report that automatically pulls the email addresses of those who purchased tickets. It seems like this should be possible out of the box, but I'm struggling to get from ticket purchase to email address without manual work. Does anyone have any suggestions?
Thank you.
Hi Marie,
If you've got your dynamic list of ticket buyers for the week and an output set that selects the primary email (and whatever else you need), I think scheduling the "Execute an Output Set" report off that list should do it. You can email or to whomever.
Similar to triggered email process just using tha report instead of your email service.
Hi Heath,
That sounds like my missing link. I've used lists largely for contributions. What fields would you recommend? I realize our set ups may be different, but that would give me a good jumping off point.
Thanks you!
It really depends on what you want to use it for. Output set elements out of the box should be enough for email address, first and last name etc. If you want something like next performance etc then I'd recommend looking at the Output set cookbook. Some of the more tricky things (like next perf) might require someone setting up a view in the database for pulling all the data field you need. I did this for our wordfly 'triggered' emails and it works a treat. Let me know if you need more
We are moving toward triggered emails. Is that working well for you?
I'm using pretty basic output set; so I think that is working well. However, I am not sure that I am using the best criteria to build my lists in list manager.
Thank you for all your advise!
To be honest with you it's more Daily Scheduled Emails with a Dynamic List but wordfly call it triggered emails. Yep it's working great. Marketing seem happy and it gives an hour of our lives back a day back to us in season. We could be servicing more areas of the business with this and that's future me's problem.The list manager Criteria should be OK with relative days (and any Suppression list you want to put in). It's gets a bit tricky if you want to pull more data into your email from your output set (like performance dates and times). Even so the output set cookbook is a good place to start.
Thank you!
No probs. Holler if you get stuck or need a sense check on something