Hi all,
I'm trying to pull together a list that contains all active members who've attended more than 5 times this year. I'd need this to be automated and run daily, otherwise I could draw something up in Analytics manually, and pull that into a list.
I'm able to get a list of Members who've attended 5 or more times across every year, but I can't figure out how to refine the list only to look at this year for the attendance.
The only way I can see would be to write out some custom SQL, but I don't have any experience drawing up something that complex.
Hi Nathanael
Tricky one. You could try adding an additional line of criteria to your list for Perf date and enter first and last date of your season/year, or use Ticket History Season. However, I think this would still bring back people who have attended 5+ times, but not necessarily all in this year. It's easier to do in Extraction Manager, where I would put the Membership, 5+ times and current year/ticket season into one segment, but if you want it to be dynamic, you'll have to use List Manager as you say. In Extraction manager you'd have to manually regenerate the count and save to list each time - depends how you want to use the result. A custom report using a dynamic list of active Members might be the way.