The following table lists the fields mostly commonly used in the "Unsubscribes" activity Export.
Please note that the standard Unsubscribes export doesn’t include consumers who are un-mailable due to their email address being banned (Status ID = ‘1575’). Inclusion of these records will be sized and scoped accordingly.
This export doesn’t include consumers who are un-mailable due to their email address bouncing (Status ID = ‘1300’ or ‘1350’). Those records can be found in the Bounces extract instead.
The standard Unsubscribes export also doesn’t include records that were manually opted-out through the Record Lookup screen within Messaging. Please speak to your Account Manager for more information if you need to pull these records.
Field Name |
System Field Name |
Description |
Example Values |
Primary Key ID |
pk_id |
Unique, system generated ID for user record |
20489744 |
Message ID |
msg_id |
Unique, system generated Message ID |
896486902 |
Unsub Time |
unsub_time |
Date / Time of unsubscribe activity |
2014-02-11 13:20:40.110 |
Campaign ID |
camp_id |
Unique, system generated Campaign ID |
16381 |
Campaign Name |
camp_name |
Campaign Name from campaign set up |
120140210 Promo Mailing 1 |
Email Address |
Recipient Email Address |
firstname.lastname@cheetahdigital.com |