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
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, descriptionFROM V_CUST_KEYCODE CKY JOIN V_KEYCODE KCD ON KCD.keycode = CKY.keycode AND KCD.ka_no = CKY.ka_noWHERE KCD.ka_no = 6437 --extraction id# and cky.customer_no in (613432)
That's helpful-- thanks, Jim