Hi Beautiful People!
We are having trouble trying to pull something as a segmentation/list and I'm hoping someone who hasn't been staring at it for weeks can help me. Support wasn't really able to provide insight.
Two scenarios, but the same principles.
Scenario A) We record part of our gala ticket as a donation to an Events Campaign so it can be tax receipted. Several people ONLY attend the gala and don't make a donation through the year, but some people, for example will attend gala and make a donation to our Individual Giving Campaign. We don't always want to include people in mailers who only attend the gala. So we need to pull a segmentation that suppresses only gala donors but includes those who attended the gala AND made another donation. We can't figure it out.
Scenario B) We want to pull a list of people who attended certain shows as single ticket buyers for the past few years to market Snow White to. We want to suppress Nutcracker buyers but NOT Nutcracker buyers who also attended one of the selected shows. So if someone attended Dracula and Nutcracker they should be included, if someone attended Dracula only they should be included, but if someone attended ONLY Nutcracker they should not be included. Same idea, but with tickets instead of donations.
I've turned to analytics to try to make this work, and we got to a point that still includes some excel clean up. Ideally I'd like to do it as a segmentation/list, so if anyone has any brilliant ideas, I'd appreciate the insight!
Cheers,
N.
Hi Nicki,
For Scenario A, there are a couple of ways you should be able to accomplish this.
Create a list:
Campaign IN FY23 Gala
Campaign Does Not Have FY23 AF Campaign(s)
Another way would be to create a list of FY23 AF donors and then use that list as a suppression in your list of Gala Donors to find who are attendees only. You can then use the Gala attendees only as a suppression segment in an extraction.
Alternately, to find those who went to the Gala AND were also AF donors you could create a list:
Campaign HAS FY23 AF Campaign(s)
You might be able to apply similar logic to Scenario B, for Nutcracker buyers who do not have other performances.
Hope that gets you on your way.
Best,
T.C.
Thank you! Will give it a try.