Hi All,
Not exactly an analytics question but I knew this group would probably have the answer. I just realized our performance reminder email which goes off of a dynamic list manager list is pulling in folks who have tickets for canceled performances (folks we haven't had a chance to exchange to other dates yet). Has anyone here found a good fix for this?
Thanks,
Kanani
I was wondering if something like performance on-sale available in Ticketing (which is the criteria set I assume you're using to find these customers), but there isn't, and it references VS_TICKET_HISTORY, which doesn't have any information like this. Adding a separate criteria set won't help, as it won't connect the Ticketing criteria set intelligently. At best you might try a hack like adding "cancelled" to the performance name, and then screening on that.
Hi Kanani!
When we have a performance that's cancelled, I change the status on the performance to Cancelled, and our SQL list pull only looks for perfs that have a status of on sale or sold out (ids 1 or 3).
There are a lot of different ways you can build the infrastructure for a triggered reminder, how you will add perf status to your list for a suppression will depend on that build. I believe it lives primarily on T_PERF, so you could join to that table.
We have a custom view that we use for our customer reminders, so you won't have the LVS_TICKET_ELEMENTS, but this will give you the gist:
SELECT DISTINCT te.customer_no FROM LVS_TICKET_ELEMENTS teLEFT JOIN T_SUB_LINEITEM s ON te.order_no = s.order_noWHERE te.perf_dt BETWEEN dateadd(DAY, datediff(day, -3, getdate()),0) AND dateadd(DAY, datediff(day, -4, getdate()),0)AND te.perf_status IN(1,3) AND s.sli_status IN(3,2,12,6,1)