The Spektrix Ticket Converter For Non-Spektrix Users: dotdigital

In this article we’re going to be looking at how you can set up and use the Spektrix Ticket Converter tool with your dotdigital account. For more information on the Ticket Converter tool - what it is, why we’ve built it - please see our Converting Refunds Into Donations With the Spektrix Ticket Converter article. Otherwise, here’s what we’re going to cover in this article:

NOTE: if you are a Spektrix user, please see our Ticket Converter article instead.

Overview of the Ticket Converter process

The Ticket Converter is designed to help you to encourage your customers to exchange some or all of their ticket refunds, either into donations or account credit, and works by combining an output of the relevant customer email addresses from your ticketing system and your dotdigital email tool.

  • Upload an export of customer emails to dotdigital and use this as an address book for a new email campaign based on a standard template you create
    • This export needs to include a very specific range of fields, which we’ll detail later
  • This campaign includes a unique, automatically generated link for each customer who receives it
  • When each customer clicks on their link they will arrive at the Ticket Converter and see information and options that are relevant to them
  • You are then given an output of the form responses to process in your system

NOTE: if your organisation is not a charity and therefore can’t accept donations, make sure you read through all of this article but pay particular attention to the Non-charitable organisation section for information about what you need to do slightly differently.

The Ticket Converter will first ask customers if they want their tickets refunded or if they would like to convert their tickets - or part of their tickets - into a donation. Once the customer has made their decision, if there is a refund to be made they will be asked if this should be to account credit or to their original payment type. See this article for a visual example of how this looks.

We have tried to make this tool as easy as possible to use, but there will be a few steps you need to take in order to get everything set up and ready to use.

Preparing your dotdigital account 

Before you can upload any information to dotdigital and start using the Ticket Converter, you’ll need to first prepare your dotdigital account by creating some new contact data fields. These data fields will then be used to create the unique link that’s sent to each customer. See our article on Personalisation in dotdigital for full details of how to add new contact data fields, but in the meantime here’s a quick run-down of the basics.

NOTE: you will need to be able to set up contact data fields and add new address books in dotdigital in order to complete the following tasks. If you don’t have the correct access permissions, speak to whoever in your organisation administers your dotdigital account.

  • In your dotdigital account go to Contacts > Contact data fields and navigate to the My data fields tab
  • Click on the New Data Field button to open the Create new field box

  • Create the following contact data fields:

Name

Data Type

Default Value

Access

Folder

EVENTNAME

Text

 

Private

Data fields

EVENTDATETIME

Date

 

Private

Data fields

TICKETVALUE

Text

 

Private

Data fields

CUSTOMERID

Text

 

Private

Data fields

These will be in addition to the standard dotdigital contact data fields, which will also be used:

  • FIRSTNAME
  • LASTNAME
  • FULLNAME
  • EMAIL

NOTE: if you go to My Contacts > Contact Data Fields > Default Data Fields you won't see EMAIL in the list, because it is actually a core concept in dotdigital. Don't worry, though - you'll see it any time you want to add contact fields into a campaign, or you can add it just by including @EMAIL@ in any text.

In addition, you should prepare a short message (no more than 1,000 characters) that your customers will see in the Ticket Converter.

  • You’ll need to run this text through a URL encoder (like this one) ready for use later - this just makes sure that the URL correctly handles any spacing and punctuation in your text
  • You should also run your venue name through this encoder as you’ll need it later as well

Both of these are used when completing your unique link:

  • Short message: use this in place of INSERTENCODEDTEXTHERE in your link
  • Venue name: use this in place of ENCODEDVENUENAMEHERE in your link

Building your Campaign Template

You’re now ready to build your campaign template in dotdigital. We’ve put together an example campaign template as part of our All in This Together guide which you can use as a starting point for what to say, how to lay things out and where to use your contact data fields.

NOTE: you can use the contact data fields to include Event-specific information in your template - you just need to insert @EVENTNAME@ and @EVENTDATETIME@ to include information about the performance in question.

TCT_email_template_new.png

Inserting the unique link
The most important element to include in your template is the unique link that will take customers to the Ticket Converter and display their options. Make sure you add this into the template either by including it in the main body of the email, or by linking out to it via a button or another item inserted as a Building Block.

We’ve provided you with the basic details you need to use for this link, however there are two things to be aware of:

  • Make sure you check the Do not track this link option when setting the link. Without doing this, customers with multiple bookings may not see the corresponding Event when clicking through
  • Make sure you add in the encoded message and venue name that you set up earlier in place of INSERTENCODEDTEXTHERE and ENCODEDVENUENAMEHERE
  • Please make sure you use the correct version of the link, depending on where your organisation is based
  • Do not try to use a link shortener (such as bit.ly) as this will cause the link to break

United Kingdom
For organisations in the UK, you’ll need to use the following base link:

https://refunds.arts-venues.com/donateRefund?currency=GBP&customerid=@CUSTOMERID@&eventname=@EVENTNAME@&eventdatetime=@EVENTDATETIME@&ticketvalue=@TICKETVALUE@&client=ENCODEDVENUENAMEHERE&clienttext=INSERTENCODEDTEXTHERE

Republic of Ireland
For organisations in the Republic of Ireland, you’ll need to use the following base link: 

https://refunds.arts-venues.com/donateRefund?currency=EUR&customerid=@CUSTOMERID@&eventname=@EVENTNAME@&eventdatetime=@EVENTDATETIME@&ticketvalue=@TICKETVALUE@&client=ENCODEDVENUENAMEHERE&clienttext=INSERTENCODEDTEXTHERE

United States
For organisations in the US, you’ll need to use the following link:

https://refunds.arts-venues.com/donateRefund?currency=USD&customerid=@CUSTOMERID@&eventname=@EVENTNAME@&eventdatetime=@EVENTDATETIME@&ticketvalue=@TICKETVALUE@&client=ENCODEDVENUENAMEHERE&clienttext=INSERTENCODEDTEXTHERE

Canada
For organisations in Canada, you’ll need to use the following base link

https://refunds.arts-venues.com/donateRefund?currency=CAD&customerid=@CUSTOMERID@&eventname=@EVENTNAME@&eventdatetime=@EVENTDATETIME@&ticketvalue=@TICKETVALUE@&client=ENCODEDVENUENAMEHERE&clienttext=INSERTENCODEDTEXTHERE

Non-charitable organisations

If you’re not a charitable organisation and therefore can’t accept donations, you can still use the Ticket Converter to ask customers to refund their tickets to account credit with you rather than their original payment method. This way you can encourage customers to return and book another performance with you in future.

To do this, follow the same steps as above, but use one of the following links instead of what’s listed above (remember, do not try to use a link shortener as this will cause the link to break).

NOTE: you can’t currently include a custom message on the Ticket Converter page if you’re using the non-charitable links. The standard message of “Please select how you would like the remaining value to be returned” will display:

mceclip9.png

United Kingdom
For organisations in the UK, you’ll need to use the following base link: 

https://refunds.arts-venues.com/refundoptions?currency=GBP&customerid=@CUSTOMERID@&eventname=@EVENTNAME@&eventdatetime=@EVENTDATETIME@&ticketvalue=@TICKETVALUE@&remainingvalue=@TICKETVALUE@&client=ENCODEDVENUENAMEHERE&clienttext=INSERTENCODEDTEXTHERE

Republic of Ireland
For organisations in the Republic of Ireland, you’ll need to use the following base link:

https://refunds.arts-venues.com/refundoptions?currency=EUR&customerid=@CUSTOMERID@&eventname=@EVENTNAME@&eventdatetime=@EVENTDATETIME@&ticketvalue=@TICKETVALUE@&remainingvalue=@TICKETVALUE@&client=ENCODEDVENUENAMEHERE

United States
For organisations in the US, you’ll need to use the following link:

https://refunds.arts-venues.com/refundoptions?currency=USD&customerid=@CUSTOMERID@&eventname=@EVENTNAME@&eventdatetime=@EVENTDATETIME@&ticketvalue=@TICKETVALUE@&remainingvalue=@TICKETVALUE@&client=ENCODEDVENUENAMEHERE

Canada
For organisations in Canada, you’ll need to use the following base link

https://refunds.arts-venues.com/refundoptions?currency=CAD&customerid=@CUSTOMERID@&eventname=@EVENTNAME@&eventdatetime=@EVENTDATETIME@&ticketvalue=@TICKETVALUE@&remainingvalue=@TICKETVALUE@&client=ENCODEDVENUENAMEHERE 

Ticket Converter configuration

The Ticket Converter tool is configurable, allowing you to customise which options you would like to offer your customers.

mceclip0.png

The options you choose here will determine what’s presented to your customers in the Ticket Converter, as well as the flow of the tool online. We’ll take you through what each option means and how it impacts on your customers.

Refund options
This section allows you to disable one of the options that customers see when they use the Ticket Converter, if you want to only offer one method of refund.

NOTE: you always need at least one refund method to be available, so you can only ever disable one of these options at any time.

Disable the ‘Refund to my original payment method’ option
With this checkbox selected (i.e. you’re choosing to disable the original method of payment), the option to Donate a portion of... will show additional text to reflect the fact that the remaining value will be refunded as account credit. 

The Refund option will also change, to reflect the fact that this is a refund to account credit. 

mceclip6.png

Customers will then be taken directly to the confirmation page and the appropriate responses will be recorded.

Disable the ‘Refund to account credit’ option
With this checkbox selected (i.e. you’re disabling the option for customers to have their refund as account credit) the option to Donate a portion of... will show additional text to reflect the fact that the remaining value will be refunded to the original payment method.

The Refund option will also change, to reflect the fact that this is a refund to the original payment method.

mceclip7.png

Customers will then be taken directly to the confirmation page and the appropriate responses will be recorded.

‘Keep my ticket’ options
You can configure the Ticket Converter to allow customers who don’t want a refund to keep hold of their tickets instead, and use them for future performances. There are two ways of doing this - you can set it up in these configuration options, in which case it will apply globally to all Events, or you can enable it on an Event-by-Event basis by amending the unique link you send out.

Enable the ‘Keep my ticket for a future date’ option (global)
With this selected, a new global (i.e. for all Events) Keep my tickets for a future date option will be available in the drop-down list - selecting this will take customers directly to the confirmation page.

mceclip8.png

This will display in the data you output from the Ticket Converter as Keep Tickets

Enabling the ‘Keep my ticket for a future date’ option per Event
You can enable this option on a per-Event basis by using the &keeptickets parameter at the end of the unique link that you use in your mailing campaign. For example, for UK charitable organisations:

https://refunds.arts-venues.com/donateRefund?currency=GBP&customerid=@CUSTOMERID@&eventname=@EVENTNAME@&eventdatetime=@EVENTDATETIME@&ticketvalue=@TICKETVALUE@&client=ENCODEDVENUENAMEHERE&clienttext=INSERTENCODEDTEXTHERE&keeptickets

  • If this parameter is present, the Keep my ticket for a future date option will be available to customers on that link
  • HOWEVER, if the Enable the Keep my ticket for a future date option is selected in the Ticket Converter configuration, this will override what’s in the unique link and enable the option globally

Configuring options
You can choose which - if any - of these options you want to use at the following webpage:

mceclip3.png

To access the options, first you’ll need to tell us who should have access to the Ticket Converter (for both configuration and accessing customer responses) by completing this form. Please make sure you provide us with the following information:

  • Your venue’s name: please make sure that this:
  • Your name: your full name, or the name of who you would like to grant access
  • Your email address: your work email address (or the best email address to use)

Once we receive these details via the form we will securely provide you with a token which you can use to access the Ticket ConverterYou only need to request this token one time - once you've logged in using it, your access is fully set up so you don't need a new one each time you want to access the tool.

NOTE: please ensure you keep this token safe and secure, as it provides you with access to your customers’ personal details.

Preparing and sending campaigns

The process of sending your campaign involves outputting information from your ticketing system, uploading this information to dotdigital and then sending your emails. We’ll talk you through what you need to bear in mind when getting that information out of your ticketing system, then how to upload it to Mailchimp and use it to send your campaign.

Outputting information from your ticketing system
To make use of the Ticket Converter you will need to be able to output certain information from your ticketing system. The specifics of what to include will depend on how you want to use the data to contact customers, based on these options:

  • One performance at a time
  • All performances for a single show (we’ll refer to shows - entire runs - as events)
  • Multiple events

NOTE: regardless of which option you choose, each upload to dotdigital can only contain one combination of CustomerID, Event and Instance (as the Ticket Converter will not allow duplicates).

Here’s an overview of the various pieces of information you might need to include - we’ll go through each of the three options below, and point out specifics of what each one should and/or shouldn’t include:

  • Customer ID: the unique customer number or identifier within your ticketing system (for example 237585 or I-MC22-3WHD)
  • Email address: the email address stored against this customer. It will be worth excluding all customers who have no email address in the criteria of the report as you will not be able to contact these customers via email
  • Event name: the name of each event as outputted from your ticketing system
    • NOTE: if the Event name contains an ampersand (&) you’ll need to replace & with and in the output of this information
  • The total value of tickets in the order for the relevant event/performance
    • For example, if a customer had bought four tickets at £20 each, this column would display 80
  • The time and date of the performance in your desired format (for example 20/03/20 19:00 or 20th March 2020 at 7pm)
  • First name: the first name of the customer
  • Surname/Last name: the last name of the customer

NOTE: we would recommend that the easiest format is to extract this as a .CSV file,  however mailing platforms often support other formats as well.

Here is an example, displayed in Excel:

One performance at a time
If you want to send Ticket Converter emails for an individual performance (e.g. Hamlet on 1st April) then make sure your ticketing system outputs as follows:

  • Provide a single line per customer per performance
  • Ensure the total value of tickets is looking at tickets for that performance only

All performances for a single show
If you want to send Ticket Converter emails per event, (e.g the entire run of Hamlet) then make sure your ticketing system outputs as follows:

  • Provide a single line per customer per event
  • Exclude event date and time information
  • Make sure the total value of tickets column shows the total booking for all performances of that event

Multiple shows
If you want to send Ticket Converter emails for multiple events (e.g. an entire Shakespeare Festival OR all your events in April) then make sure your ticketing system outputs as follows:

  • Provide a single line per customer 
  • Include the total value of tickets for the range of events
  • Still include a column called Event Name but manually fill in this column with a descriptive title for the range of events that you're cancelling 
    • This is what your customers will see online in the Ticket Converter

Uploading your list of customers
Once you have extracted the above information from your ticketing system you can now upload your report output to dotdigital.

In your dotdigital account, click the New address book button and you’ll be given the option to create a new address book as follows:

We recommend naming this with information about the Instance you selected to generate the report in Spektrix, so that you have a clear record of what each address book is used for.

Upon clicking the save button you’ll be prompted to add contacts to the address book - select the Excel/CSV option:

Then click the Choose file button and browse to the downloaded report. Once selected, click the Upload button on the right hand side:

You’ll then be prompted to ‘map’ the report columns to the corresponding dotdigital values:

These should be completed as follows:

Dotdigital ‘Map to’ Value

Report ‘Contact 1’ value

firstname

Owner First Name

lastname

Owner Last Name

customerid

Owner Id

email

Email Address

fullname

Owner Name

eventname

Event Name

eventdatetime

Event Date/Time

ticketvalue

Sum of Total Charged

Once that’s done, dotdigital will import the customers into your address book and provide you with a breakdown of what has been imported. Here’s an example of how that looks:

Before you do anything else, make sure you click the Download unimported addresses button, so that you can download a list of any customers who weren’t successfully added to the address book. See the following section on Customers on the suppression list for more details of what to do with this information.

Customers on the suppression list
When you upload an address book to dotdigital, be aware that dotdigital will run it through a suppression list to identify any customers who have previously been blocked, unsubscribed or bounced.

NOTE: you can, if you choose, run your address book through the second suppression list that’s referenced in the screenshot above, but we’ll work on the assumption that you’re only using the mandatory suppression list.

What this means is that there’s a chance some of the customers that you’ve uploaded to dotdigital won’t be included in the address book - and therefore won’t receive your email.

Testing your campaign
Before sending your campaign, we would recommend you run a quick test to make sure everything in the email looks right, and the unique link is generating correctly.

The best way to test this is to create an address book in dotdigital - as described early, making sure the Event name is listed as Test Event - with just a small number of test email addresses (i.e. yourself and any colleagues who are working on this).

Use this small list to send your test campaign - everyone in that address book should receive a unique link that takes them to the Ticket Converter, where they will see their options for an example cancelled Event called Test Event.

Sending your campaign
Once you’ve done your test sends, everything should be built in dotdigital and ready for you to schedule or send your campaign. See this article from dotdigital for how to send a campaign; just make sure you select the appropriate address book to send to.

We recommend you use the ImportFaults spreadsheet that’s generated when you click Download unimported addresses as a separate list to use for manually contacting these customers who are on the suppression list.

Customer responses

Once you've sent that email, customers will be able to click the link you include and make their choices for what they would like to do. Here's an example of how that looks:

If you’re a charitable organisation, the information you encoded in your unique link earlier (i.e. the information you included in place of INSERTENCODEDTEXTHERE) will show up on this page underneath the Event name and date/time details.

If not, the standard message of “Please select how you would like the remaining value to be returned” will display instead.

Accessing your customers’ responses
Once you’ve sent your campaign, you can securely retrieve your customers’ responses as a .CSV download from a dedicated site that we’ve set up.

You can get into this site using the same key as you used to set up your Ticket Converter configuration earlier on. If you haven’t already done that, check back to this part of the article and make sure you fill in the form there.

Here’s the link for downloading the customer responses you’ve received from the Ticket Converter:

Fill in the following fields:

  • Key: enter the unique key that we provided you with
  • Date from/to: select a date/time range for responses.

Click the Download button to generate a .CSV file of Ticket Converter responses within your given date range.

***

If you have any questions about the Ticket Converter or would like to discuss any of the stages of using it in more detail, please don’t hesitate to get in touch via support@spektrix.com to talk things through.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk