Sales by Channel reporting

For those of you tracking sales results by channel, can you point me to a good report for showing this detail? We've recently begun using this and I want to make sure I'm looking at good response info.

Thanks!

Clint

Parents
  • Hi Clint,

    Good day.

    We have a customized report for channel and MOS sales.

    Channel and MOS are based on t_order level, so the sales records only can be separated by order date(not paid date).

    If you are interested in this report, I will do some modifications then send you the copy.

    (we have a different customized sale table.  so I have to do some changes.)

    have fun

    Ben

  • Hi Ben,
     
    I'd be interested in this report if you end modifying it for Clint,
     
    Regards
     
    Brenda Fehlberg
    Box Office Coordinator
    Tasmanian Symphony Orchestra
     
    +61 3 62324450
    +61 418320792
     
    GPO Box 1450
    Hobart 7000
    -----Original Message-----
    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Ben Gu
    Sent: Wednesday, 28 October 2009 3:23 PM
    To: Brenda Fehlberg
    Subject: Re: [Tessitura Ticketing Forum] Sales by Channel reporting

    Hi Clint,

    Good day.

    We have a customized report for channel and MOS sales.

    Channel and MOS are based on t_order level, so the sales records only can be separated by order date(not paid date).

    If you are interested in this report, I will do some modifications then send you the copy.

    (we have a different customized sale table.  so I have to do some changes.)

    have fun

    Ben

    From: Clint Riley <bounce-clintriley8484@tessituranetwork.com>
    Sent: 10/26/2009 12:15:41 PM

    For those of you tracking sales results by channel, can you point me to a good report for showing this detail? We've recently begun using this and I want to make sure I'm looking at good response info.

    Thanks!

    Clint




    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!
Reply
  • Hi Ben,
     
    I'd be interested in this report if you end modifying it for Clint,
     
    Regards
     
    Brenda Fehlberg
    Box Office Coordinator
    Tasmanian Symphony Orchestra
     
    +61 3 62324450
    +61 418320792
     
    GPO Box 1450
    Hobart 7000
    -----Original Message-----
    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Ben Gu
    Sent: Wednesday, 28 October 2009 3:23 PM
    To: Brenda Fehlberg
    Subject: Re: [Tessitura Ticketing Forum] Sales by Channel reporting

    Hi Clint,

    Good day.

    We have a customized report for channel and MOS sales.

    Channel and MOS are based on t_order level, so the sales records only can be separated by order date(not paid date).

    If you are interested in this report, I will do some modifications then send you the copy.

    (we have a different customized sale table.  so I have to do some changes.)

    have fun

    Ben

    From: Clint Riley <bounce-clintriley8484@tessituranetwork.com>
    Sent: 10/26/2009 12:15:41 PM

    For those of you tracking sales results by channel, can you point me to a good report for showing this detail? We've recently begun using this and I want to make sure I'm looking at good response info.

    Thanks!

    Clint




    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!
Children
  • Hi Brenda,

    Good day.

    The full report files are in the attached zip file.

    1, As the sales records are picking up at run time, this report will be a bit slow (10 seconds on my screen). (because of no index) --- you can set it as a scheduled report.

    2, If you run report with "full detail" in group type, you can open the order by click the order_no, then you can verify this report with the order.

    3, You can do any kind of modification on the codes.

    any questions, you can send me an email or just post here.

    have fun.

    Ben

    MOS_Channel_Sales_Report.zip