This is our first year working with AMS for our telemarketing campaign and they require more detailed data than we've had to compile in years past. I have the base of constituent and subscription data (name & address info, plus series purchased and # of seats), but they want the specific seating and pricing data for single ticket buyers and subscribers as well.
Thus far, I've been unable to get that information out of Tessitura. I don't see a report with that information and I've tried every output set combination I can think of. Has anyone else worked with AMS (or similar company) and found a solution that does not require knowledge of SQL? Any suggestions would be appreciated!
Thank you,
MarcyKate Connolly
Audience Development Manager
The Phoenix Symphony