WordFly supports using your Tessitura integration to manage RSVP’s. Set up your RSVP landing pages on your website and add the links to your email design. 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.
Example of RSVP 'yes' / 'no' in email template.
Collecting RSVP responses in Tessitura
WordFly sends all email responses to Tessitura's T_EPROMOTION_RESPONSE_HISTORY table when your Tessitura list has promotion data (source number and download number). The actual URL a subscriber clicks will be sent back as @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 in the database:
Add logic to the LP_UPDATE_EMAIL_PROMOTION stored procedure for click responses to check what URL was clicked. This could then create a CSI to inform Box Office or Marketing staff of the response or flip an attribute on the constituent record.
*Sample logic for the CSI option is attached to this support post!
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 = b.id
You could use this query to easily find all of the customers who clicked on each of the RSVP links.
Who creates the RSVP confirmation landing pages?
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.