Tips: Cancellation Strategy (Exchange/Donation/Refund Processing and Messaging)

Starting a thread dedicated to a topic we're all likely to be devoting a lot of time to.

Shall we also try using the Tags feature within it? Then folks can use it as a filter to narrow posts to one or the other. #CancellationProcessing and/or #CancellationMessaging 

I'm thinking brilliant strategies (or hacks) or a place for questions that have you stumped.

To start, it off...

1) Cancellation email notice with web form with options about which route customer wants, exchange/donation/credit/refund. Easy for them; head start for your team.

2) If you are tokenized/don't save credit cards, pointedly call out somewhere in that messaging that your organization will calling to request the credit card number in order to process the refund.

  • Kari,

    Yes, sorry. We have been changing the dates and keeping the same set up. Make sure to change your client date, web date, default dates, price type dates, and web dates. Just an FYI. 

    In terms of finance we haven't gotten into the weeds yet, but I'm sure we will have to. We use the performance ID to tell finance and us what fiscal year we are in so I think we will have to update that moving forward.  I will update as I change more. 

  • I have done both - change the dates (luckily in same fiscal year) and done an order export, performance cancellation and order import unseated (change of venue made it necessary).

  • Former Member
    Former Member $organization in reply to Sara Broderick

    If possible i'd love a copy of your report as well - this is the process my venues are using and it would be really helpful to be able to report on it.

    kerry.britnell@nottinghamcity.gov.uk 

  • Former Member
    Former Member $organization

    HI All, Just wondered if anyone using wordfly (surveys) to collect refund responses would be kind enough to share their code for the custom stored procedure?  We are looking at implementing this and i wouldn't mind a starting block if anyone has one.

  • Hi Kari and everyone! I am curious what you are considering in terms of Tessitura configuration and financial information as you reschedule your performances. We'd love to know more so we can help develop some guidance. What is your finance department asking you to do when you move a performance to a new season or fiscal year? What is your marketing department or others asking in terms how your new season looks? 

    Thanks!

    -Michael Flaherty-Wilcox

  • Hi Michael!

    After reviewing the business continuity resources, this is what our organization has decided to do:

    • Change date of current concert that has been postponed to the new date
      • change all associated dates (price types, web, MOS, etc)
      • Patrons get to retain seats and no need to re-issue tickets.
    • Update GLs in pricing layer to reflect next fiscal year, so that all purchases from here on out post to the correct GL
    • Finance will do a mass journal entry in accounting software (we use Great Plains) to account for movement of revenue from current FY to next FY.
      • I will run Performance Transaction Detail for each affected concert to get constituents, GLs, and total revenue to be adjusted.
    • I also created a new season that we can use to report out on rescheduled concerts.  I named it 20-21 Rescheduled FY20 and added it to next fiscal year.

    Unfortunately, this type of configuration will only work for one-night only concerts.  It is possible that we will attempt to reschedule some of our subscription shows, which have two performances, into just one rescheduled performance.  Two performances means two sets of subscribers, which will guarantee seat overlap, and I'm not exactly sure how that is going to work, or the best way to handle that.

  • Tess - 

    Thank you for the info!  We have decided to go down this path so that patrons can keep their current tickets for the rescheduled dates

  • Hello Heath, 

    We have been working with our partners at Tessitura and Wordfly to do something like this but have been a bit frustrated and unsuccessful. Could you share what is happening with the data you are getting back from your Wordfly Survey. Is it populating in CSI's on records? If so, can you share your CSI structure (category, activity, origin?) 

    Thank you, 

    RhondaLeigh 

  • Former Member
    Former Member $organization in reply to RhondaLeigh Dauphinais (Past Staff Member)

    We worked with a consultant at JCA, but ours definitely is multi-step even now that it's complete. We have two additional local tables and a utility. One local table maps the CSI settings to a Page (category, activity, origin, etc), then the second table maps the questions from the Pages responses to the CSI settings from the previous table. We can also replace the full text of the question with a short descriptive title, so instead of it reading: "How many guests will be attending?", it just says "Guests: ##" and collects their answer. 

    Then we schedule a Utility to run daily or hourly that pulls the data from the responses, and creates CSIs based on the settings in the two tables. There may be a simpler way, if you always want the CSI settings to be the same and didn't want to re-name the Questions in the CSI notes for clarity's sake.

  • My presentation from last summer feels kinda trite right now, but it does walk through screenshots of our Pages integration. For anyone looking for options that aren't building their own procedures.

    Mini-Magic PDF about New Victory usage: https://www.tessituranetwork.com/en/Community-and-Events/Conference-Archive/tlcc2019archive#Magic and it's item 23.

    *We also used this for a Donate Your Tickets campaign and saw a really great response. And no phone time!

  • Hi Kerry -

    I'm so glad you asked this question. We're in development right now for some things to help with that. Our new integration code will let you use WordFly Pages capabilities to create items within Tessitura (such as CSIs), which will allow you to track and act on survey responses. We hope to release this in the next week or two. Once it’s ready, we'll post about the functionality, how to request it, and other information.

    In related news, I'm happy to let you know that we’ve created a new online group dedicated to our ecosystem partners. It’s designed as a shared space for you to connect with our ecosystem partners and fellow Tessitura members. You can ask questions, share tips, and more. The group has discussions organized by specific topics, and we’ll be adding new topics over time. We'll also use this online group to keep you up to date on the latest offerings, best practices, integration hotfixes, and upcoming roadmap items, including the WordFly Pages Integration.

    The group is brand new, and we're just now broadcasting it and inviting people to join and start the conversations. Please come join me in the Ecosystem Topic Group and specifically in the Email Marketing & Marketing Automation discussion area to talk about any specific WordFly, Mail2, Pro2 or MonkeyWrench strategies, use cases and anything else you can dream up.

    Thanks,

    Heather Laidlaw Kraft
    Product Owner, Integrations

  • Hi RhondaLeigh & Lily -

    I'm seeding relevant threads with similar information, so pardon any 'copy and paste' feel here. I'm want to let people know that we're in development right now for some things to help with WordFly Pages Integration. Our new integration code will let you use WordFly Pages capabilities to create items within Tessitura (such as CSIs), which will allow you to track and act on survey responses. We hope to release this in the next week or two. Once it’s ready, we'll post about the functionality, how to request it, and other information.

    In related news, I'm happy to let you know that we’ve created a new online group dedicated to our ecosystem partners. It’s designed as a shared space for you to connect with our ecosystem partners and fellow Tessitura members. You can ask questions, share tips, and more. The group has discussions organized by specific topics, and we’ll be adding new topics over time. We'll also use this online group to keep you up to date on the latest offerings, best practices, integration hotfixes, and upcoming roadmap items, including the WordFly Pages Integration.

    The group is brand new, and we're just now broadcasting it and inviting people to join and start the conversations. Please come join me in the Ecosystem Topic Group and specifically in the Email Marketing & Marketing Automation discussion area to talk about any specific WordFly, Mail2, Pro2 or MonkeyWrench strategies, use cases and anything else you can dream up.

    Thanks,

    Heather Laidlaw Kraft
    Product Owner, Integrations

  • Your mini-magic has been my Blueprint for getting Pages integration over the line.  Love to hear how it's progressed

  • Hey RhondaLeigh, 

    End of last year we started using Pages for Surveys and Adding that to Special Activities.

    With Surveys - I was asked by our team to put it in table format because that was way more useful to them than CSIs.  To that end I constructed a report that outputs some of the patron details and the Questions  as Column headings with the Answers below.

    We copied that table into teams and actioned.  It's really easy to filter so I can create a list of folks who have asked for Refund, Credit or Gift Voucher - Save and upload that list into Tessitura - and run the new Bulk refund (or Credit or Gift Voucher) Utility off that list.  Massive time saver. 

    I'm going to add those to CSIs at some point but it's less useful to us at the moment and is still in the WordFly tables

    Happy to share whatever you need

  • If you just need an SSRS report to pull the Questions, Answers and Customers out of the Wordfly tables in a excel table I can help you out.