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 |