Standard Exports - Unsubscribes

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

email

Recipient Email Address

firstname.lastname@cheetahdigital.com