Liveclicker's Campaign data export (CDX) allows you to automatically export your campaign data into an FTP folder on a daily basis. Liveclicker will pass all user-level impression data once per day containing the previous day's data. To download an example of this report click here. If you are interested in a CDX integration, please reach out to your Customer Success Manager.
Note: CDX files use UTF-8 encoding
| Key | Type | Max. Character Length |
|---|---|---|
| sub_id | text | 2,048 |
| full_date | date | 19 |
| campaign_id | integer | 10 |
| campaign_name | text |
64 |
| element_type | text | 16 |
| element_name | text | 128 |
| version_name | text | 128 |
| question_value | text | 256 |
| user_selection_code | text | variable |
| has_been_revealed | integer | 5 |
| clip_version_friendly | text | 64 |
| clicks | integer | variable |
| clickthroughurl | URL | variable |
| clickthrough_date | date |
variable |
| geo_predicted | integer | 32 |
| engagement | text | 32 |
| duration | integer | variable |
| impression_device | text | 16 |
| emailclient | text | 64 |
| mobile_carrier | text | 16 |
| os | text | 64 |
| browser | text | 64 |
| city | text | 64 |
| region | text | 128 |
| county | text | 32 |
| zip_code | integer | 5 |
| country | text | 64 |
| language | text | 16 |
| opener_timezone | integer | 10 |
| order_id | integer | variable |
| orders | integer | variable |
| revenue | integer | variable |
| order_date | date | variable |
| esp_dim1...esp_dim19 | text | 8192 |
| esp_destinationcity | text | 128 |
| esp_arrivaldate | date | 64 |
| esp_timerexpirationdate | date | 64 |
| esp_maplocation | text | 128 |
| esp_trackingnumber | text | 512 |
| esp_shippingprovider | text | 64 |
| rule_id | text | 10 |
Variable Fields
Some fields have a variable character length, please see examples below and our advice for how best to approach this when setting a maximum character length for these fields:
Aggregator fields e.g. duration where we are performing a calculation such as sum, count or average to get the result. Because of this the end result could be a number of any length required. Typically, these fields do not exceed 8 characters.
In other cases, such as the clickthroughurl, Liveclicker is unable to provide a maximum character length as the length of this field is determined by the length of the clickthrough url used in Liveclicker campaigns so this cannot be preempted in advance.
| Key | Description | Example |
|---|---|---|
| sub_id |
The subscriber ID value for the impression as passed by your account's Subscriber ID field |
name@domain.com |
| full_date | 02/12/2019 11:44:36 | |
| campaign_id | Campaign ID the impression belongs to | 1677583200 |
| campaign_name | Friendly name of campaign | Weather Promotion |
| element_type | Name of the element type for the impression | feed |
| element_name | Friendly name of the element | Desktop version |
| version_name | Friendly name of the version | Sunny version |
| question_value | Name provided of the poll question in the campaign wizard | What's your favorite color? |
| user_selection_code | If the user has voted in a LivePoll or has clicked a slide from an iOS optimized slide show, the poll_link_status value is 1 - and user_selection_code will indicate the answer or slide that has been selected. If a friendly name is given for the poll answer or slide, that will be shown instead of the poll answer number or slide number. | answer #2, slide #2 |
| has_been_revealed | Applicable to LiveReveal element only, value is 1 if revealed by the user and 0 if not. | 1 |
| clip_version_friendly | For LiveVideo elements only, which version type was delivered: Inline video, iOS Video, Animated GIF, Static are the possible values | iOS Video |
| clicks | Shows if there was a clickthrough for the impression, will always be 1 or 0 | 1 |
| clickthroughurl | Clickthrough URL for an impression when a clickthrough has happened. (URL is encoded for security and data handling) | http%3A%2F%2Fwww.liveclicker.com |
| clickthrough_date | A comma separated list of dates for the clickthrough | 10/6/2014 6:00:30 AM |
| geo_predicted | Applicable if your account is set up to use Predictive Geo-Targeting. Value is 1 if the location was predicted and 0 if not. | 1 |
| engagement |
Classifies duration of open for the impression into 3 categories:
|
Read |
| duration | When available, duration of open in seconds for the impression | 10 |
| impression_device | The device category, such as desktop, mobile, or tablet | Desktop (all) |
| emailclient | Email client of the impression | Gmail |
| mobile_carrier | When available, name of the mobile carrier for mobile openers (Spring, ATT, Verizon, TMobile, or empty) | Verizon |
| os | Operating System value of the impression | Windows 7 |
| browser | Browser of the impression. | Chrome (All) |
| city | City name value of the impression | San Diego |
| region | The geographic region of the impression | England |
| county | County of the impression | King |
| zip_code | US zip code of the impression | 92107 |
| country | Country of the impression | France |
| language | When available, language preference of the opener for the impression | French |
| opener_timezone | Timezone offset from GMT of the impression | -7.0 |
| order_id | Identifies the order's ID | order123 |
| orders | Order count generated for this content impression. This requires the tracking code to be deployed | 1 |
| revenue | Revenue amount generated for this content impression. Also requires the proper tracking code | $19.99 |
| order_date | Date of the order | 2022-06-10 |
| esp_dim1...esp_dim19 | Custom campaign ESP tags passed via the embed code | John |
| esp_destinationcity | Preset custom destination city location fed through an ESP field used for personalized LiveForecast elements | Los Angeles, California |
| esp_arrivaldate | Preset custom arrival date fed through an ESP field used for personalized LiveForecast elements | 12/25/20 |
| esp_timerexpirationdate | Preset custom timer expiration fed through an ESP field used for personalized LiveTimer elements | 2022-07-10 18:00:00 |
| esp_maplocation | Preset custom map location fed through an ESP field used for personalized LiveMap elements | 10001 |
| esp_trackingnumber | Tracking number fed through an ESP field used for LiveTracker elements | 1Z9999999999999999 |
| esp_shippingprovider | Shipping provider fed through an ESP field used for LiveTracker elements | UPS |
| rule_id | Identifies the ID of the targeting rule applied to this impression (if applicable). If there is a friendly name given to the ruleset, it will show in this column instead. | ruleset #1 |
Export to an AWS S3 bucket
Liveclicker's CDX supports automatic, daily exports to your AWS S3 bucket. This is accomplished with temporary credentials and no access keys stored in the Liveclicker system. Setting this up requires a few steps to be completed:
-
Create or select an S3 bucket
-
Add an access policy that gives Liveclicker write access
-
Give Liveclicker a few details about your S3 bucket
You must have access to both a Liveclicker account and the AWS console to complete setup.
Contact Support for help in setting up your export.
