Identifying first-time ticket buyers

Hello! Are you after a list of constituents?
I usually generate this via an extraction with two segments:

The first is "ticket performance date before xxx" and then the second is "has tickets to xx concert"

Since constituents can only be pulled into the extraction once, all those with prior ticket history are captured by the first line, and new constituents are picked by the second.

I also have an analytics dashboard which has a widget with the following formula:

Count([Constituent ID],IF(MIN(DDIFF([Days in Date],[Years in First Performance Date]))=0, MAX([Constituent ID]),NULL))

This gives you a number of new constituents, but doesn't give you a list of who those constituents are. I use this for reporting as it updates as I'm filtering my dashboard for reporting, but if I actually want a list of who (like for sending an eDM) then I pull the list with the extraction :)

Hope that maybe gives you some ideas!

Hello! Are you after a list of constituents?
I usually generate this via an extraction with two segments:

The first is "ticket performance date before xxx" and then the second is "has tickets to xx concert"

Since constituents can only be pulled into the extraction once, all those with prior ticket history are captured by the first line, and new constituents are picked by the second.

I also have an analytics dashboard which has a widget with the following formula:

Count([Constituent ID],IF(MIN(DDIFF([Days in Date],[Years in First Performance Date]))=0, MAX([Constituent ID]),NULL))

This gives you a number of new constituents, but doesn't give you a list of who those constituents are. I use this for reporting as it updates as I'm filtering my dashboard for reporting, but if I actually want a list of who (like for sending an eDM) then I pull the list with the extraction :)

Hope that maybe gives you some ideas!