The following is an overview of the files contained in the ZIP-file. Please note the following information about the file format:

  • Line delimiter: \n (Unix)
  • Field separator: \t (tab)
  • UTF8 encoding
  • No quoting

Files within the exported ZIP-file

users.csv

This file contains information about the user:

ColumnDescriptionData TypeExample
Internal user IDInternal user identifierNumber32908490837489
Customer IDUser identifier created by the Mapp Intelligence customerStringabcxyz123
First visit timeTime of the first visit on the websiteString2015-11-29 14:46:48.347
Last conversion timeTime of the last conversion (for example, order) on this siteString2015-11-29 14:46:48.347
Last contact timeTime of the last visit on the websiteString2015-11-29 14:46:48.347
Gender0=undefined, 1=male, 2=femaleNumber0
Lifetime valueTotal conversion valueNumber100.0
Lifetime conversionsTotal number of conversionsNumber1
Lifetime visitsTotal number of sessionsNumber4
Lifetime page impressionsTotal number of page impressionsNumber20

sessions.csv

This file contains information about each particular session (visit) on your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
OSOperating systemStringWindows 10
BrowserBrowserStringFirefox 50
JavaScriptJavaScript enabled=1, disabled=0Number1
Screen resolutionScreen resolutionString1024x768
Color depthColor depthNumber24
CookieCookie accepted=1, not accepted=0Number1
Windows resolutionWindows resolutionString1000x600
JavaJava detected=1, not detected=0Number0
Browser languageBrowser languageStringde
CityCityStringBerlin
RegionRegionStringBerlin
CountryCountryStringGermany
ProviderProviderStringDeutsche Telekom
OrganizationOrganizationStringDeutsche Telekom
Connection speedConnection speed detected via connection (unknown=1, modem=2, cable/dsl=3, coorporate=4, mobile=5, satellite=6, wireless=7)Number1
DeviceDetected deviceStringAny Desktop & Laptop

session_parameters_X.csv

This file contains additional information about each particular session (visit) on your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
XXXCustomer specific parameterString or Number

pages.csv

This file contains information about each particular page request on your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
Page nameName of the page (defined by the Mapp Intelligence customer)Stringstartpage
Page URLURL of the pageStringhttp://www.example.com
DurationVisit duration of this page in secondsNumber20

referrers.csv

This file contains information of the referrers to your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
ReferrerReferrer domainStringwww.google.com
URLURL of the referrerStringwww.google.com/

search_phrases.csv

This file contains information about the search phrases on search engines which lead to your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
Search phraseSearch phrase used on the search engineStringnot provided

search_phrases_intern.csv

This file contains information about the search phrases entered on your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
Search phraseSearch phrase used on your websiteStringbook

page_parameters_X.csv

This file contains additional information about each particular page request on your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
XXXCustomer specific parameterString or Number

orders.csv

This file contains information about the order on your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
Order valueOrder valueNumber100.0
Order IDOrder IDStringAX343434

baskets.csv

This file contains information about the basket on your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
Product nameName or ID of the productStringXYZ2348
QuantityQuantityNumber1
PricePrice of the productNumber100.0

product_parameters_X.csv

This file coantains additional information about the products on your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
XXXCustomer specific parameterString or Number

clicks.csv

This file contains additional information about the clicks (event) on particular pages on your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
Click nameName of the click (event)Stringbutton_click

clicks_parameters.csv

This file contains additional information about the clicks on particular pages on your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
XXXCustomer specific parameterString or Number

forms.csv

This file contains information about forms filled in on your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
Form nameName of the formStringorder_form
SubmittedForm was submitted=1, not submitted=0Number1

form_fields.csv

This file contains information about form fields filled in on your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
Form nameName of the formStringorder_form
Form field nameName of the fieldStringamount
Form field valueValue of the fieldStringnot provided
CanceledLast filled in form field (1=true, 0=false)Number0

heatmaps.csv

This file contains information about form fields filled in on your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
Form nameName of the formStringorder_form
Form field nameName of the fieldStringamount
Form field valueValue of the fieldStringnot provided
CanceledLast filled in form field (1=true, 0=false)Number0

media.csv

This file contains information about media (for example,  video, audio) consumed on your website.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
Media nameName of the mediaStringvideo1
DurationTotal duration in secondsNumber60
BandwidthBandwidthNumber10
VolumeVolumeNumber100
MuteMute (1=true, 0=false)Number0

media_actions.csv

This file contains information about media actions (for example, video, audio) performed on the Mapp Intelligence customer site.

ColumnDescriptionData TypeExample
Session IDUnique ID per sessionNumber5000003423748927899
TimeTimeString2015-11-29 14:46:48.347
Media nameName of the mediaStringvideo1
Media actionName of the media action, for example, playNumberplay
Media action startBegin of the media action in secondsNumber0
Media action endEnd of the media action in secondsNumber60