Hi everyone,
We are in the situation where we had to go onsale with 4 digital events before knowing which platform the events would be streaming on. Since we didn't have specific access instructions at the time of sale, in the order confirmation emails we said that they would get an email before the premiere date with instructions on how to access content.
For those of you who have done this already, and are using the gated content feature, how did you communicate access instructions to your patrons? Did you put the link to the TNEW gated content page in the order confirmation email?
My concern is that if we use the gated content feature, I will have to pull a list of those patrons who have already purchased to send access instructions to, but I do not have a way to pull the specific e-mails associated with the orders, and in the case of households, I think it would be confusing to send an email to the household, but tell them to use the web login they used to make the purchase to access their tickets. Will all primary members of the household have access to the content, or only the initiator?
Any ideas or experience you've had that can help give me some ideas?
Many thanks in advance.
Charlotte
If you need to find only the initiator email, SQL in a list will get this (handy if this is the only SQL access you have, otherwise you could use straight up SQL).
If accessing from a list then you can get their email in a standard output set.
Try updating the values in bold below and give it go - you can easily find the perf_no from your ticketing set up.
When you have the values for your org, create a new list, go to the show query option in the top right hand of the list pane (near add criteria) and paste the below SQL into your list (CTRL + V). Make sure that the query starts on line 1. or you will get an error saying the provided list has no criteria. (see screen show example for how it should look in lists).
Select distinct initiator_no as customer_no
From T_ORDER a with (nolock)
where a. initiator_no is not NULL
and a.order_dt between '11-06-2020' and '11-09-2020' --- date filters in american format
and a.order_no in --- sub query to only find orders with an initiator in them linked to the performance) (Select distinct order_no from T_TICKET_HISTORY b where b.perf_no in (2456))
--- The perf_no value (ID) can be found in ticketing setup under the performances tab of production elements. 2456 in this example. Beware of deleting closing brackets )) or ' when updating values.