• Replies 3 replies
  • Subscribers 332 subscribers
  • Views 94 views
  • Users 0 members are here
Related

Constituents who went to more than one show in a series?

Gabe Rivera
$organization

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!

Parents
  • $organization

    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 Rivera
    Marketing Coordinator
    Kaufman Center
    129 W. 67th St.
    New York, NY 10023
    P. 212 501 3384
    F. 212 501 3302
    kaufman-center.org

    cid:image001.gif@01CBB989.95C51390

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Marty Jones
    Sent: Tuesday, May 24, 2011 5:12 PM
    To: Gabriel Rivera
    Subject: RE: [Tessitura Marketing Forum] Constituents who went to more than one show in a series?

     

    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

          FROM

            dbo.T_ORDER_SEAT_HIST AS osh

          WHERE

            osh.pkg_no = @pkg_no AND

            event_code = 22

          GROUP BY

            osh.customer_no

        ) AS aaa

    GROUP BY

        aaa.perf_count

     

     

    Marty Jones

    Director of Information Services

     

    Omaha Performing Arts
    1200 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 Marty Jones
    Sent: Tuesday, May 24, 2011 3:37 PM
    To: Martin A. Jones
    Subject: RE: [Tessitura Marketing Forum] Constituents who went to more than one show in a series?

     

    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 Arts
    1200 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 Rivera
    Sent: Tuesday, May 24, 2011 3:12 PM
    To: Martin A. Jones
    Subject: [Tessitura Marketing Forum] Constituents who went to more than one show in a series?

     

    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!




    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!




    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!




    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!

Reply
  • $organization

    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 Rivera
    Marketing Coordinator
    Kaufman Center
    129 W. 67th St.
    New York, NY 10023
    P. 212 501 3384
    F. 212 501 3302
    kaufman-center.org

    cid:image001.gif@01CBB989.95C51390

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Marty Jones
    Sent: Tuesday, May 24, 2011 5:12 PM
    To: Gabriel Rivera
    Subject: RE: [Tessitura Marketing Forum] Constituents who went to more than one show in a series?

     

    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

          FROM

            dbo.T_ORDER_SEAT_HIST AS osh

          WHERE

            osh.pkg_no = @pkg_no AND

            event_code = 22

          GROUP BY

            osh.customer_no

        ) AS aaa

    GROUP BY

        aaa.perf_count

     

     

    Marty Jones

    Director of Information Services

     

    Omaha Performing Arts
    1200 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 Marty Jones
    Sent: Tuesday, May 24, 2011 3:37 PM
    To: Martin A. Jones
    Subject: RE: [Tessitura Marketing Forum] Constituents who went to more than one show in a series?

     

    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 Arts
    1200 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 Rivera
    Sent: Tuesday, May 24, 2011 3:12 PM
    To: Martin A. Jones
    Subject: [Tessitura Marketing Forum] Constituents who went to more than one show in a series?

     

    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!




    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!




    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!




    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!

Children
No Data