Hi all,
I'm investigating the Revenue by Source and Appeal report to see if it meets our needs.
How is a 'response' classed? Anyone in the source who made a purchase?
Might the response be different if the source is an email- would it be those who opened or clicked through AND made a purchase?
Thanks,
Sam
It is just tracking whatever Source was entered on the order.
You could always take a list of those who were sent a promotion and then run T-Stats based upon that list to see how orders were sourced.
From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Sam Carelse Sent: Thursday, June 20, 2013 7:22 AM To: Nicole Keating Subject: [Tessitura Shared Reports Forum] Revenue by Source and Appeal
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Shared Reports Forum. You may reply to this message to post to the 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 Sam,
Just to be clear, when you talk about people being "in" the source, I'm assuming you're talking about an inhouse source, which is promoted onto a list or extraction of people within Tessitura? (As opposed to an Outside source which can be used, but has no list of people attached to it.)
With Inhouse sources, when you run the promotion, it puts that source on all the promoted records in the Promotion section (under Connections > Promotions) with a default Response of (none). If someone with that inhouse source purchases something AND that source is used during the order, then the Response changes to TransProcessed, and the income will be counted against that source in the Revenue by Source and Appeal report.
This is relatively straightforward for orders over the phone or by mail, because box office staff can pick the inhouse source which will pop up in front of them.
It's more difficult on the web. Normally, a purchase on the web uses a default Web source (which is an outside source), so if you just send someone to the web page, that's the source that will be used, and you won't be able to see which email or communication sent them there.
There's currently two ways around it, depending on how your website is coded:
a) You can embed a promo code in a URL which will get triggered when they click through and show up as the source on the order. This is good for showing you who responded to a particular link. However, if someone were to go away from the email and go to the web page by themselves, the default source would get used instead.
b) You can offer some sort of special deal (10% off, $10 off, something like that) that requires a promo code to be entered to access it. When you do this, the customer HAS to enter the right promo code, and this makes sure the right source gets used, and thus flows through to the revenue report correctly.
Hope this helps.
Cheers,
Matt
Hi Matt,
Thanks for your response. Could you clarify what you mean by promo code in part a)- is it different to the promo code entered by the user in part b) or is it the source code?If you are referring to source codes, currently we're not able to track these through to the website but we're working on it. If tracking is enabled then I guess the response would have to be someone who clicked through, and ordered.
Thanks for your response, Nicole. As I mentioned just now to Matt, we don't have source code tracking enabled at present.
We have been using the T-stats solution by running reports against those in the promotion, but we're looking for a report that can handle all of our email activity for a week at once.
Just to clarify a bit further. Assuming your website talks to Tessitura using the Web API, it will be using a default source code for all orders processed via the web. However, you have the ability to change that source code to a specific one by using a function called an offer. You can read the documentation for more details but the rough steps are:
1) You set up the source code that you want to use to be tracked.
2) You get your box office to set up an offer for particular performances tied to that source code. (So, for instance, the offer might be for 20% off tickets, only available to people via that source code.) This source code becomes known as the specific offer code.
3) Some websites allow you to enter a promo word instead of just a source number. (Ours website isn't one of them - in our case, customers need to enter the particular source number in the promo box on the site). But if your site can take the text-based offer codes (which are easier to remember), you set them up in TR_WEB_SOURCE_NO.
4) Then your customer enters the appropriate code on the site, and the site changes the source from the default one to the source code associated with the offer
The other way this can be done is some sites (like TNEW) allow you to pass the source code through in a URL, so that you don't actually have to give the customer a special discount offer. You can just give them a custom link.
To read up more on offers on the web, check out this link:
http://www.tessituranetwork.com/Help_System/Default_Left.htm#CSHID=Promotions|StartTopic=Content%2FConnections%20Tab%2FPromotions%20Screen.htm|SkinName=TN%20Skin
For how to set up offers in Tessitura, see here: