The following table lists the fields mostly commonly used in the "Opens" activity Export:
Field Name |
System Field Name |
Description |
Example Values |
Primary Key ID |
pk_id |
Unique, system generated ID for user record |
20489744 |
Open ID |
open_id |
Unique system-generated Open ID |
180630837 |
Open Time |
open_time |
Open Date / Time |
2014-02-11 13:20:40.110 |
Message ID |
msg_id |
Unique, system generated Message ID |
896486902 |
Campaign ID |
camp_id |
Unique, system generated Campaign ID |
16381 |
Campaign Name |
camp_name |
Campaign Name from campaign set up |
120140210 Promo Mailing 1 |
IP Address |
ip_address |
IP address of open |
10.24.64.180 |
Email Address |
Recipient Email Address |
firstname.lastname@cheetahdigital.com |