Hello everyone!
Does anyone have a formula for getting the ticket history of only people who are affiliated with businesses? I feel like this is one of those things that is probably pretty easy and I'm overthinking it -- usually turns out to be the case most times. When I try using list manager, I get what I feel is way too low a number. I've tried w/ SQL but my query must not be right because I'm getting a lot of repeated rows.
Our development team wants to know who has purchased tickets of their own accord that are affiliated with corporate sponsors or businesses that may want to consider sponsorship in the future.
Any insight is appreciated, as always!
Thanks,
Michael
It's not as elegant as what you're after, but I have similar systems where I pull a dynamic List into Analytics (in this case, of corporate-affiliated folks) and then use it as a filter for other ticketing data.
But will be curious to see if someone has a cleaner solution.