Hello!
Our organisation will be soon implementing automated performance reminder emails through Mail2. We have done extensive research to explore what the content of these emails should be but would love to hear from other organisations that have seen success in sending these emails.
Are you doing something cool and funky with your emails? Something a bit outside the square? What has worked super effectively for you? What hasn't?
Any and all ideas are very much appreciated!
BV
That would be awesome. Thank you.
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Kevin Madeira Sent: Thursday, December 03, 2015 4:41 PM To: Dot Krebs Subject: Re: [Tessitura Ticketing Forum] performance reminder email success stories
Another thing, I noticed you have the customer_no and season specified in a different order to that of the select statement in your CTE, i.e. The first CTE column is customer_no but the season is the first in the select statement.
I'll email you one an example so you can tinker with it.
From: Dot Krebs <bounce-dotkrebs9366@tessituranetwork.com> Sent: 12/3/2015 3:54:58 PM
This is what I have built out for the post-show Thank you for Attending campaign using the Mail2 instructions. The view is created with only the field name address and no data, so I have done something wrong somewhere. What do you make of it?
USE impresario
GO
/** OBJECT: VIEW [dbo].[LV_M2_ATTENDED_PERF] Script date: 10/21/2015 10:51 **/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE VIEW [dbo].[LV_M2_ATTENDED_PERF]
AS
WITH attendedCTE (customer_no,expr_dt, perf_dt, prod_season_desc)
(
SELECT c.season, c.perf_dt, b.prod_season_desc, a.customer_no
FROM dbo.VS_PERF AS c WITH (NOLOCK) INNER JOIN dbo.LVS_PROD_SEASON_BULK AS b WITH (NOLOCK) ON c.prod_season_no = b.prod_season_no
INNER JOIN dbo.T_ORDER_SEAT_HIST AS a ON c.perf_no = a.perf_no
WHERE (a.user_location = 'NSCAN')AND (a.customer_no > 0) AND (a.id IN (SELECT MAX(ID) AS maxID FROM dbo.T_ORDER_SEAT_HIST GROUP BY order_no, perf_no))
GROUP BY c.season, b.prod_season_desc, c.perf_dt, a.customer_no
)
SELECT
distinct ee.address
From dbo.LTX_M2_ELISTS_EADDRESS AS ee WITH (NOLOCK) INNER JOIN
dbo.T_EADDRESS AS te on ee.address = te.address INNER JOIN
dbo.VRS_EADDRESS_TYPE AS et ON te.eaddress_type = et.id INNER JOIN
attendedCTE cte ON te.customer_no = cte.customer_no
GRANT SELECT ON [dbo].[LV_M2_ATTENDED_PERF] TO [ImpUsers] AS [dbo]
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!