Standard Exports - Opens
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 |
