Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Any way to extract blacklisted

EggBoy
Level 3
Level 3

Hello,

Is there any way to (fairly easily) extract from Campaign 6.11 Leads a table of blacklisted email addresses, and the date they were set to that? Or, a list of emails/recipients and the date of their unsubscription event?

I've done the easy way of extracting from the undeliverables folder the email, update status, last error...and that gives me large clusters of dates...apparently when an agent or workflow updated (most addresses have dates that fall into 3-4 exact same dates times.

I've also tried using the generic query editor...but cannot seem to find a table with a date of an unsubscription event.

Is this data available in Campaign?

Thanks,

Eugene

1 Accepted Solution
florentlb
Correct answer by
Level 10
Level 10

Hi Eugene,

If you're talking about the date corresponding to the moment a recipient clicked a "no longer contact" link in a delivery, then no, the date information is not stored. There is just a boolean value indicating "No longer contact".

When selected, the recipient data is modified, thus the "Modification date" field is updated but this field is not specific to the unsubscription action.

So you can easily extract recipients/addresses but no corresponding date. To do that, a few fields are available from the nmsRecipient table. Look for "No longer contact by...".

By default, the "No longer contact (by any channel)" is used.

Hope this helps,

Florent.

View solution in original post

2 Replies
florentlb
Correct answer by
Level 10
Level 10

Hi Eugene,

If you're talking about the date corresponding to the moment a recipient clicked a "no longer contact" link in a delivery, then no, the date information is not stored. There is just a boolean value indicating "No longer contact".

When selected, the recipient data is modified, thus the "Modification date" field is updated but this field is not specific to the unsubscription action.

So you can easily extract recipients/addresses but no corresponding date. To do that, a few fields are available from the nmsRecipient table. Look for "No longer contact by...".

By default, the "No longer contact (by any channel)" is used.

Hope this helps,

Florent.

View solution in original post

EggBoy
Level 3
Level 3

Hi Laurent,

Thanks...we will work on our end to develop a report that might track this daily.

Thanks again,

Eugene