• Replies 2 replies
  • Subscribers 702 subscribers
  • Views 61 views
  • Users 0 members are here
Options
Related

Suppressing cancelled performances

Kanani Reichlin
$organization

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

Parents
  • $organization

    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 te
    LEFT JOIN T_SUB_LINEITEM s ON te.order_no = s.order_no
    WHERE 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)

Reply
  • $organization

    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 te
    LEFT JOIN T_SUB_LINEITEM s ON te.order_no = s.order_no
    WHERE 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)

Children
No Data