Tracking ticket buyers from previous year who have not yet bought tickets.

HI Katie, Yes! This can be done. You'll want to add the Ticket History Performance twice (or whichever field you use to select the perf -- I like this one because it uses the Perf code). For the first one you will select IN Perf Code. For the second instance, you will select DOES NOT HAVE Second Perf Code. This is one where I wanted everyone who had regsitered for previous years, but not this year.

Hope that helps.

Anne Robichaux
CRM Administrator
The Historic New Orleans Collection

HI Katie, Yes! This can be done. You'll want to add the Ticket History Performance twice (or whichever field you use to select the perf -- I like this one because it uses the Perf code). For the first one you will select IN Perf Code. For the second instance, you will select DOES NOT HAVE Second Perf Code. This is one where I wanted everyone who had regsitered for previous years, but not this year.

Hope that helps.

Anne Robichaux
CRM Administrator
The Historic New Orleans Collection

Thank you so much! 

Hi! I keep getting an error message, "String or binary data would be truncated."  

Hi Katie,

The message about data being truncated might be because there are a lot of shows selected from the Performance drop down window.

If that is the case then maybe switch from using "Ticket History Performance" and use "Ticket History Season" instead.  The idea is the same; add Season to the criteria window with an operator of In and then a vale of the 2022 season.  Then add Season again to the criteria window but this time use an operator of Does Not Have with a value of the 2023 season.

Extraction Manager is a good option for making lists when things get more complicated.

Jared

That worked! Thank you so so much for your help!!