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
You can see the list of constituents selected by each segment by going to Segment Contents in the Extraction Manager menu. That always feels a bit clunky to me, though. You might create an extraction set with all your suppression segments and only one include segment which specifically selects the one customer_no you're concerned about. Then you could just look at the Suppression Report to see where they're getting caught up.
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