Standard Exports - Clicks
The following table lists the fields mostly commonly used in the "Clicks" activity Export:
|
Field Name |
System Field Name |
Description |
Example Values |
|
Primary Key ID |
pk_id |
Unique, system generated ID for user record |
20489744 |
|
Click ID |
click_id |
Unique system-generated Click ID |
180630837 |
|
Click Time |
click_time |
Click Date / Time |
2014-02-11 13:20:40.110 |
|
Message ID |
msg_id |
Unique, system generated Message ID |
896486902 |
|
Link ID |
link_id |
Unique, system generated Link ID |
12345 |
|
Link Name |
link_name |
Friendly link name, followed by link URL |
Home page - www.cheetahdigital.com |
|
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 click |
10.24.64.180 |
|
Email Address |
|
Recipient Email Address |
firstname.lastname@cheetahdigital.com |
