I wonder if there is a way, for a particular series, if I could find out how many constituents went to more than one concert in the series (there are 13 individual concerts). The ideal report would have how many constituents went to one concert, two concerts, three, etc. But since that seems complicated, I could settle right now for a way of seeing how many people went to at least two of the concerts.
It's too bad in t-stats there doesn't seem to be a measure that indicates number of concerts attended...
Any help would be appreciated!
Define series. Is this a package? I am assuming yes. Also are you looking to see if they actually attended the performance or just purchased?
Marty Jones
Director of Information Services
Omaha Performing Arts1200 Douglas Street
Omaha, Nebraska 68102
P 402.661.8469
Marty.Jones@omahaperformingarts.org
www.omahaperformingarts.org
For tickets, call Ticket Omaha at 402.345.0606
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Gabriel RiveraSent: Tuesday, May 24, 2011 3:12 PMTo: Martin A. JonesSubject: [Tessitura Marketing Forum] Constituents who went to more than one show in a series?
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
If this is a package and you are looking at those that did attend, this should work.
SELECT
COUNT(customer_no) AS customer_count ,
perf_count
FROM
( SELECT
osh.customer_no ,
COUNT(DISTINCT osh.perf_no) AS Perf_count
dbo.T_ORDER_SEAT_HIST AS osh
WHERE
osh.pkg_no = @pkg_no AND
event_code = 22
GROUP BY
osh.customer_no
) AS aaa
aaa.perf_count
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Marty JonesSent: Tuesday, May 24, 2011 3:37 PMTo: Martin A. JonesSubject: RE: [Tessitura Marketing Forum] Constituents who went to more than one show in a series?
Hi Marty, I actually figured out a different way to go about getting the information. We have a list criteria that allows us to pull a performance from a pull down list for each season. I guess I’ll post what I know to help others… Here is the way it is set up in the system table:
T_KEYWORD
Data Type: Number
Edit Mask: [Blank]
Detail Tbl: LVS_TKT_HIST
Detail Col: !.perf_no
Ref Tbl: lv_perfs
Ref Idcol: perf_no
Ref Desccol: perf_date+’ ‘+perf_desc
Ref Where: season=[season Id from TR_SEASON]
Ref Sort: perf_desc
Category: Ticketing
Use For List: List Only
Multiple Value: [Unchecked]
Additional Columns: [All Blank]
We had a consultant help us with creating it, and I think you need to create a new view (whatever that means).
At any rate, when you select the concerts you are interested in using the criteria, also add the additional criteria of “Tickets – Num of Unique Perfs” and make it equal to the number of concerts you want to count attendance to.
Thanks for your help!
Gabriel RiveraMarketing CoordinatorKaufman Center129 W. 67th St.New York, NY 10023P. 212 501 3384F. 212 501 3302kaufman-center.org
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Marty JonesSent: Tuesday, May 24, 2011 5:12 PMTo: Gabriel RiveraSubject: RE: [Tessitura Marketing Forum] Constituents who went to more than one show in a series?