Tracking online subscriptions

We use Channel for this kind of reporting. It has worked really well.

Janna

Janna Ellis

Director, Yale Tessitura Consortium

Yale School of Drama

Yale School of Music

203-432-8822

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Susan Ashcraft
Sent: Tuesday, March 31, 2015 2:37 PM
To: Ellis, Janna
Subject: [Tessitura Ticketing Forum] Tracking online subscriptions

Hi All,

We're still on V.11 and just started selling subscriptions online this season. I want to track how many of our renewals and new subscriptions came in online and not through the ticket office. I'm hoping to do this by using the original solicitor on the ticket order, webapi. I tried running the report Package Order Listing however if one of the ticket office staff changed anything in the order, it changed the solicitor in the report. The original solicitor is still in the ticket order but not on the report. Does anyone have any suggestions how to pull a report like this? I have ideas about how to change this for next year, but I still need to have the information for these renewals.

Thanks,

Susan

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!

Hi Susan,

We’ve actually set up a report in T-Stats to help us track these kinds of orders as well as New vs. Returning Subs.

In the Package Cube

1.       Filter/Slicer by Package Season

2.       Categories

a.       Package Detail – Pkg Name

b.      Package Order Detail – Subs Summary Type

                                                               i.      This is how we track New vs. Renew

                                                             ii.      As long as you’re using this in the client

c.       Package Order – Order Category

                                                               i.      We use this to differentiate New Subs received during the renewal period, marked as Priority, from New Subs received following the renewal period, marked as (Unknown)

                                                             ii.      As long as you’re using this in the client

d.      Package Modes of Sale – Mode of Sale

3.       Series

a.       Package Seats

b.      Original Amt

c.       Paid Amt

d.      Num Orders

Cheers!
Short

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Susan Ashcraft
Sent: Tuesday, March 31, 2015 11:42 AM
To: Christopher Short
Subject: [Tessitura Ticketing Forum] Tracking online subscriptions

Hi All,

We're still on V.11 and just started selling subscriptions online this season. I want to track how many of our renewals and new subscriptions came in online and not through the ticket office. I'm hoping to do this by using the original solicitor on the ticket order, webapi. I tried running the report Package Order Listing however if one of the ticket office staff changed anything in the order, it changed the solicitor in the report. The original solicitor is still in the ticket order but not on the report. Does anyone have any suggestions how to pull a report like this? I have ideas about how to change this for next year, but I still need to have the information for these renewals.

Thanks,

Susan

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!