Campaign data export values
This following list shows the data values that can be exported using the campaign data export tool.
Tip: The column headings in the exported file are always in alphabetical order. Empty values are shown as N/A, (Blank), NULL, or Unknown.
| Display name (UI) | Column name | Data type | Description |
|---|---|---|---|
| Action Attribute | Action Attribute | Alphanumeric | An action attribute is an optional setting that allows advanced tracking of actions. For example: Login, Registration etc. |
| Action External Visitor Id | Action External Visitor Id 1 to 5 | Alphanumeric | The external visitor identifiers assigned to the action. External identifiers are used for high cardinality data like - visitor ids, order ids, etc. For example, to store ids which can be used to relate Maxymiser data to your own data in reporting. This column is only available for campaigns created after the Maxymiser UI 16.3 June release.
Note: Only available for campaigns created after the Maxymiser June 2016 release. |
| Action Name | Action Name | Alphanumeric | The name of the metric used to measure the effectiveness of the campaign |
| Action Page | Action Page | Alphanumeric | Website URL where the visitor’s action was performed. |
| Action Referrer URL | Action Referrer URL | Alphanumeric | Website URL from which the visitor navigated to the action page
External referrer: This value is displayed:
Empty referrer: This value is displayed:
Note: A shortened version of the refer domain address is shown in the exported file. The query string part of the address is trimmed out. |
| Action Time and Date | Action Time and Date | Date and Time |
UTC Time - The time and date that the user performs the action.
Date format: |
| Action Value | Action Value | Integer | This defaults to 1 for Page View and On-Click actions, but may also be used to store revenue amounts. |
| Local Action Time and Date | Local Action Time and Date | Alphanumeric |
Local Time Zone - The time and date that the user performs the action.
Date format: Note: Only available for campaigns created after the Maxymiser June 2016 release. |
| Generation Columns: | Generation of campaign content is counted when a particular experience is first displayed to a visitor. When a visitor returns to the campaign, they are always served the same experience. Exceptions to this can occur if the Visitor enters the campaign from another browser application (different laptop, hand-held device, etc.) or clears all cookies. | ||
| Technology - Browser | Browser | Alphanumeric | Internet browser name. For example: Internet Explorer, Firefox, Safari. |
| Technology - Browser Version | Browser Version | Integer | Internet browser version. For example: 8.0, 10.0.648.204, 5.0.5 |
| Technology - Device Type | Device Type | Character |
Visitor's device type, such as Desktop, Phone, Tablet
A device with a screen diagonal greater than 6 inches (15.24 cm) is considered a tablet, a screen diagonal less than 6 inches is a phone. A desktop device is one that runs on a desktop operating system; this includes laptops. |
| Generation Time and Date | Generation Time and Date | Date and Time |
UTC Time - The time and date that the experience is first displayed to a visitor
Date format: |
| Time Frame - Day of the Week | Day of Week | Alphanumeric | UTC Time - Day of the week that the generation occurred (UTC time). For example: Monday, Wednesday, Sunday |
| Generation - External Visitor ID | Generation External Id 1 to 5 | Alphanumeric | The external visitor identifiers assigned to the generation
Note: External identifiers are used for high cardinality data such as visitor IDs, order IDs, and so on. For example, to store IDs which can be used to relate Maxymiser data to your own data in reporting. |
| Time Frame - Hour | Hour | Time | UTC Time - Hour of the day that the generation occurred (UTC time). 24-hour format, for example, 00:00, 01:00, .. ,23:00. |
| Generation ID | Generation ID | Integer | The unique Generation ID assigned by Maxymiser UI. |
| Page URL | Page URL | Alphanumeric |
The page that generates the experience that places a visitor into a campaign.
Note: A shortened version of the page URL is shown in the exported file - the query string part of the address is trimmed out. |
| Time Frame - Part of Day | Part Of Day | Character | UTC Time - Part of the day that the generation occurred in the format, Night, Morning, Lunch, Afternoon or Evening.
|
| Location City | City | Alphanumeric | City that the visitor is connecting from. Enter IP address of the city that the visitor is connecting from. For example: Japan-Tokyo-Tokyo, Australia-Victoria-Melbourne. |
| Country | County | Character | Country that the visitor is connecting from. For example: United States, Japan, Ireland. |
| Local Generation Time and Date | Local Generation Time and Date | Alphanumeric | Local Time Zone - Time and date that the experience is first displayed to a visitor.
Date format: Note: Only available for campaigns created after the Maxymiser UI June 2016 release. |
| Local Day of the Week | Local Day of the Week | Character | Local Time Zone - Day of the week that the generation occurred (UTC time). For example: Monday, Wednesday, Sunday
Note:Only available for campaigns created after the Maxymiser June 2016 release. |
| Local Hour | Local Hour | Alphanumeric | Local Time Zone - Hour of the day that the generation occurred. Uses 24-hour format, for example, 00:00, 01:00, ... ,23:00. |
| Local Part of the Day | Local Part of the Day | Alphanumeric |
Local Time Zone - Part of the day that the generation occurred in the format, Night, Morning, Lunch, Afternoon or Evening.
Night: 21:00 - 05:59 Morning: 06:00 - 11:59 Lunch: 12:00 - 13:59 Afternoon: 14:00 - 17:59 Evening: 18:00 - 20:59 Note:Only available for campaigns created after the Maxymiser June 2016 release. |
| Metro Area | Metro Code | Character |
US Metro area that the visitor is connecting from. Enter at least the first three characters to display a list of valid entries. For example: Columbus, GA and New York, NY.
Note:This applies only to US Sites. |
| Region | Geo Region | Character |
Region that the visitor is connecting from.
For example: United States - California, Australia - New South Wales, United Kingdom - Cornwall.
Note: The attribute uses the IP address of the administrative and territorial units inside the country that the visitor is connecting from. |
| ZIP Code | ZIP Code (US) | Alphanumeric |
Location in ZIP Code format.
Maxymiser UI matches the first 5 digits only. Example: When defining segment rules, select the 'MATCHES' condition and type 100 to target all visitors with matching ZIP code from 10001 to 10099, or 10 to target an even wider area. Multiple entries are separated with a comma, for example 10,20,30. |
| Technology - Internet Service Provider | Internet Service Provider | Character | Internet Service Provider (ISP). For example: Virgin Media, Verizon Wireless Service. See ISP List for a full list of ISP values. The data provider shortens ISP values to the first 50 characters only the first 50 characters are displayed. |
| Technology - OS | OS | Operating System. For example: Windows 7, Windows 8, Windows Vista, Mac OS. | |
| Experiences | Campaign Elements shown as: Element: <name> | Alphanumeric | Mapped campaign elements. This is the campaign content created at campaign level. |
| Custom Attributes |
Preset Custom Attributes - Shown as: Custom Attribute: <Custom Attribute Name1> Free Text Custom Attributes - Shown as PersonalizationCriterion1 to PersonalizationCriterion20. |
Alphanumeric | Visitor's Custom Attributes. These are the personalization criterion created at Site level . |
| Technology - Screen Resolution | Screen Resolution | Integer | Screen resolution. For example: 1280x800, 1920x1080, 1600x900 |
| Other - Segmentation Rule | Segmentation Rule | Alphanumeric |
Segmentation rules that the visitor satisfied. Any manual segmentation rules
created for a campaign are displayed as filters.
Unsegmented Traffic: The visitor did not satisfy any of the segmentation rules. |
| Traffic Source - Referrer Domain | Referrer Domain | Alphanumeric |
Referrer site from which the visitor arrived at the site (referrer domains are counted once for each visitor unless the user changes their Custom Attribute, browser or clears their cookies). For example: www.google.com.
Note:A shortened version of the refer domain address is shown in the exported file - the query string part of the address is trimmed out. The Referrer attribute is updated when a visitor's session starts - the first time the visitor visits the test page, or if the visitor returns after 30 minutes of inactivity on the site. For example, if a new visitor comes fromhttp://bing.com/somedata to a site page http://site.com/page1 where Campaign1 element is mapped, the value for Referrer would be 'bing.com'.
If the visitor goes to another site page http://site.com/page2 in less than 30 minutes where Campaign2 element is mapped, the value for Referrer would still be 'bing.com'.
If after 30 minutes of inactivity, the visitor comes from http://google.com/somedata to a site page http://site.com/page1, the value for Referrer would be 'google.com'.
Note:The referrer can be empty if the visitor enters the site URL manually or loads the page from a bookmark. |
| Traffic Source - Traffic Source | Traffic Source | Character |
Traffic source through which the visitor arrived on the site. For example, directly or through a Pay-Per-Click campaign.
Direct: The visitor entered the page URL into the address bar of the browser or clicked a browser bookmark that contained the URL. External Referrer: The visitor used an external link to the website from another website. For example, user comes to Internal Referrer: The visitor came from a page on the same website as the tested page. Note:If there are sites that you want Maxymiser to process as internal, use the Company Sites page to specify their URL. Social Network: The visitor accessed the test website using a domain that belongs to a supported social media network. For example, Facebook, LinkedIn, Pinterest. |
| Other- Targeted Group | Targeted Group | Alphanumeric | URLs of the pages where visitors view the test Element. |
| Other - Test Method | Test Method | Alphanumeric | Test Methods used to generate the content For example: Full Factorial, Dynamic Optimization, Visitor Affinity. |
| Visitor Activity - Visitor Age to Site | Visitor Age to Site | Alphanumeric |
Number of days since the visitor first visited the site. 'Visitor age is calculated as the difference between the date of the visitor’s current generation and the date of the visitor’s first entry to the site.
New Visitor - 'Visitor Age' is less than a day 2 days - 'Visitor Age' is between 1 and 2 days 7 days - 'Visitor Age' is between 3 and 7 days 30 days - 'Visitor Age' is between 8 and 30 days 365 days - 'Visitor Age' is between 31 and 365 days More than 365 days – 'Visitor Age' is more than 365 days For example, if a visitor enters a site today at 1:30 PM and enters a campaign tomorrow at 1:29:59 PM they would be recognized in the reports as a new visitor. |
| Visitor ID | Visitor Id | Numeric | The unique Visitor ID. |
| Weather Conditions | Weather Conditions | Character | Weather condition at the visitor's location when they arrive at the site. The following conditions are available: Sunny, Cloudy, Raining, Snowing. If weather condition cannot be confirmed, the condition is recorded as Unknown. |
| Temperature Range | Temperature Range | Alphanumeric | Temperature (range) at the visitor's location when they arrive at the site.
The following temperature ranges are available:
|