Source number appending for links (how to add, use, and test)

Source number tracking (Tessitura integrated accounts)


In WordFly our Tessitura integrated customers can enable source number tracking for links in campaigns. This feature appends the source number from your Tessitura list to the end of the links in your campaigns. Your website will need to be able to process source number tag in order for this feature to work successfully.


Topics covered in this article:

Enabling source number tracking for your account

Enabling source number tracking for your campaign

Verify source number tracking is enabled

Test source number tracking

Email source numbers and discount codes in Tessitura

Reviewing sales data in Tessitura and WordFly



Enabling source number tracking for your account


First you'll need to able source number tracking for your WordFly account as a whole. Once this is enabled then you can turn on source number tracking on a case by case basis for each email campaign.


1. Go to Account. Select "Tessitura" from the left nav under Integrations.





2. Check the box Allow Source Number Appending for email links




If your website doesn't use source tags, set up a new name for source number tracking on this page in the open field next to Query string name.





Enabling source number tracking for your campaign


Once you have enabled source number tracking for your WordFly account you can enable it on a campaign level.


1. Go to Email > Email Campaigns




2. Click on the name of the Campaign that's In Progress.



3. On the Settings step, check the Source Number Tracking check-box.





Verify source number tracking is enabled


1. In your Email Campaign, click on the Subscriber List tab.


2. On the Testing step, click Full Review.




3. All links that have a checked box are being tracked.




All properly formatted links will be tracked by WordFly. And links that are flagged as incorrect will not be tracked.

De-Select the Track This Link boxes next to your links, save your selections to omit tracking on any links.





Test source number tracking


You won't see source numbers added to your links in test emails. Since the source is part of your list data it is added like other personalization when the email is sent. But there are two solid ways to test your source number appending on links before sending the email.


Option 1: Use Subscriber Preview to confirm the source being appending on your links


1. Go to your Campaign and click on the Testing tab. Click on Subscriber Preview.


2. Click on Preview to the right of the email address under Subscriber Preview.




3. Review the preview.


Is the source added at the end of the link?



Option 2: Update your Default Test List data with the source from your list.


1. Search for your subscriber record in WordFly. Select the Subscriber.




2. When you find it go to Lists and List data tab.


The lists should be in alphabetical order. Click through to the next pages until you find "Default test list".



3. Hover over the Default test list and select "View list data fields".



4. You can customize the data here.

Update your source data and then your test emails should pull in the test data for your subscriber record.



*Just to reiterate ... Your website needs to have functionality to capture the source number from the query string and submit it to the "Promo Code" parameter of the Tessitura API Login or Register calls. You'll need to make sure any page that you’ll be linking to in your emails has this functionality, and that the value captured is persisted so that it is available when the Login or Register call is made.




Email source numbers and discount codes in Tessitura


In Tessitura a source can be made into a promo code anytime. When Tessitura lists are imported into WordFly a unique source is given to the list (when the list is promoted properly). There are two ways to give your source a discount in Tessitura:


Option 1: Apply your discount to the appeal you will use with your Tessitura list. When the list is imported into WordFly the source generated with the list will use the discount that the appeal was given. This is the easiest way to apply a discount to your source automatically!


1. In Tessitura, go to Ticketing Setup


2. Select Production Elements


3. Select the performances tab


4. Click on any performance from the list to open it


5. Select the Modes of Sale tab


6. Select Offers from the lower right corner


7. Click Add from the Offers window


8. Select an Appeal and a Pricetype. Then click OK.


This enables a discount for the appeal you select in your list. When the list is run with this appeal the source generated by the promoted list will carry the appeal's discount. This way when WordFly appends this source on your email links the discounted source will be applied to the subscriber's web session on your website and will automatically receive the discount.


Option 2: Import your Tessitura list into WordFly. When the list is imported a promotion will be created in Tessitura which generates a source number. Add your discount to this source before the email is sent. This process takes a few extra steps, see step one for a faster method.


1. In Tessitura, go to Campaigns


2. From the navigation, select Campaigns > Appeals


3. Click on the Appeal used in the list that was imported


4. Under the Sources tab, copy the source number


5. From the navigation, select Go to > System Tables


6. Find table TR_WEB_SOURCE_NO


7. Click the insert row icon


8. Enter the source number from the list, select your MOS, and enter a friendly promo code.


Now when WordFly appends this source to the end of your links using source appending your links will use this source and the discount on this source will work on your website. Be sure to use Subscriber Preview to confirm this is the source being appended at the end of the links.




Reviewing sales data in Tessitura and WordFly


You want to know how your emails are translating into sales on your website. As long as your site is set up to interpret source numbers you should be able to make good use of them to track the behavior of your subscribers.


WordFly records the URL that was clicked with click events in Tessitura. All click events will be recorded in the T_EPROMOTION_RESPONSE_HISTORY table. Each unique URL is stored in the TR_EPROMOTION_URL table.


For any promotion you can find all the customers who clicked on a link in the email. You'll use the data in the promotion tables along with order information to get a picture of the path your ticket buyers are taking.


You can see a complete picture clicked URLs with the following query:

select * from t_epromotion_response_history a
inner join tr_epromotion_url b on a.url_no =


This will tell you which customers clicked what link and when. You can then correlate this with shopping cart data (T_WEB_ORDER) and order data (T_ORDER) either by source number or by customer number and date to analyze how your ticket buyers are interacting with your email.


You can also pull a Revenue Report in WordFly to see all the sales associated to the source in your Campaign. Review this post to pull a Revenue Report.






Have more questions? Submit a request
Powered by Zendesk