• Replies 3 replies
  • Subscribers 332 subscribers
  • Views 69 views
  • Users 0 members are here
Related

Extraction Suppressions

Shelly Binkley (she/her)
$organization

I am troubleshooting why a certain person has not received a particular email series for several months.

It seems like she is getting caught in one of the suppressions, but I can't tell where.

Is there any way to find out which specific constituents were caught in a suppression after the extraction is run?

Thanks,

Shelly Binkley

Parents
  • $organization

    Hi Shelly - here's a bit of code I use for a similar purpose, to quickly find which segments certain id#s were pulling into. Just update the Extraction id# and the customer id#(s).

    SELECT DISTINCT customer_no, description
    FROM V_CUST_KEYCODE CKY
                   JOIN V_KEYCODE KCD
                                  ON KCD.keycode = CKY.keycode
                                  AND KCD.ka_no = CKY.ka_no
    WHERE KCD.ka_no = 6437  --extraction id#
                   and cky.customer_no in (613432)

Reply
  • $organization

    Hi Shelly - here's a bit of code I use for a similar purpose, to quickly find which segments certain id#s were pulling into. Just update the Extraction id# and the customer id#(s).

    SELECT DISTINCT customer_no, description
    FROM V_CUST_KEYCODE CKY
                   JOIN V_KEYCODE KCD
                                  ON KCD.keycode = CKY.keycode
                                  AND KCD.ka_no = CKY.ka_no
    WHERE KCD.ka_no = 6437  --extraction id#
                   and cky.customer_no in (613432)

Children