How can I set up an RSVP email? (Tessitura integration)

WordFly supports using your Tessitura integration to manage RSVP’s. You can set up your event RSVP's as links in your email template. One link is 'yes' confirming the RSVP and the other link is 'no' declining it. Your organization will need to host the pages that redirect for both the yes and no links in the WordFly email template.


Example of RSVP 'yes' / 'no' in email template.



Collecting RSVP responses in Tessitura


WordFly sends all event responses from your sent email to Tessitura's T_EPROMOTION_RESPONSE_HISTORY table for every constituent that was promoted in your list import. The actual URL a subscriber clicks will be sent back as well with response code 4.


For each click response the history table (T_EPROMOTION_RESPONSE_HISTORY) will provide a number for the URL. This number is the ID in the TR_EPROMOTION_URL table. The TR_EPROMOTION_URL table is populated when a unique link in the email is clicked by the subscriber.


Tessitura users have a couple options for collecting RSVP responses:


Option 1:


Add logic to the LP_UPDATE_EMAIL_PROMOTION stored procedure for click responses to check what URL was clicked and create a CSI to inform Box Office or Marketing staff of the response.


*Download the sample logic attached directly from this support post!


Option 2:


All of the data you need to generate an RSVP report will be stored automatically in Tessitura, without making any changes to your LP_UPDATE_EMAIL_PROMOTION stored procedure. The following query shows all of the clicks with urls:


select * from [impresario].dbo.[t_epromotion_response_history] a
inner join [impresario].dbo.[tr_epromotion_url] b on a.url_no =


You could use this query to easily find all of the customers who clicked on each of the RSVP links.




Is it possible to set up an RSVP confirmation page for my email?


Talk with your web developers about this part. Your web team should set up different pages for each RSVP response with static content. Each link would go to the corresponding confirmation page. For example, when a subscriber clicks on 'yes, I will attend' the page that the user is redirected to is hosted by your organization.





Have more questions? Submit a request
Powered by Zendesk