1. Home
  2. Docs
  3. Data Services
  4. Raw data

Raw data

With the raw data service, you receive daily an export of the etracker Analytics data with individual, clearly recorded interactions with timestamp and selected dimensions.

Raw data exports are ideal for data analysts to combine different data sources, perform advanced statistical analysis, or create custom visualizations.

The exported raw data are not completely unprocessed, but already contain the resolved geolocation, device or technology attributes as well as the assignment to external or internal campaigns.

Requirement

etracker Analytics Enterprise Edition

Activation

Navigate to Settings → Raw Data. There you can download a sample file with your own data for evaluation. By clicking on the slider you can activate the automatic export or – if not yet included in the license – order it.

Once activated, you will find the daily files here. The automatic retrieval via curl call is convenient. To do this, you only need to add an export token to the link shown, which can be created under Settings → Account → Integration → Access tokens. Please make sure that you select the type Exports for this.

Data

Tables

A table with the format “export-accountID-yyyy-mm-dd” is created for each day.

The following raw data tables are available:

  • External page report: Page impressions and eCommerce events in the context of external campaigns
  • Site report attributed onsite: Page impressions and eCommerce events in the context of internal campaigns
  • Event Report
  • Report on form fields

Row

Each line contains a record. The records are sorted by session ID and timestamp.

Columns

Attributes

The following six columns are included in all exports:

Column nameExample valueDescription
date2019-09-05Date of the record
timestamp2019-09-05 13:45:18Seconds timestamp of the record
is new visit1Specifies whether a record is a visit
event_typepage_impressionType of record (for more information, see Event Types section)
user-id10020628959530835773Value assigned to a visitor
session-id3771245427251635319Value assigned to a visit

For the other columns, these attributes can be freely selected:

Column nameExample value
domaincustomerwebsite.com
seitennameindex
area_level_1shop
area_level_2clothes
area_level_3women
area_level_4bottoms
area_level_5trousers
area_level_6jeans
area_level_7shorts
area_level_8
area_level_9
area_level_10
device_typeSTR_CC_ATTR_VALUE_DEVICE_TYPE_MOBILE_PHONE
device_manufacturerApple
device_osiOS
device_os_version12.4.1
device_modeliPhone
device_browserMobile Safari
device_browser_version12
device_type_detailSTR_CC_ATTR_VALUE_DEVICE_TYPE_DETAIL_SMARTPHONE
geo_countryGermany
visitor_attractionSTC_CC_ATTR_VALUE_NEW_VISITOR
visitor_statusSTC_CC_ATTR_VALUE_NO_CUSTOMER
et_seg1
et_seg2
et_seg3
et_seg4
et_seg5
order_number2465897
product_nameJeansshorts
product_id5986
1. Kategoriewomen
2. Kategoriebottoms
3. Kategoriejeans
4.Kategorieshorts
urlwww.customerwebsite.com/shop/women/clothes
Additional dimensions for external attribution
medium (etcc_med)STC_CC_ATTR_VALUE_LINK
campaign (etcc_cmp)summer_2019
partner (etcc_par)affilinet
advertiser (etcc_adv)customername
agency (etcc_acy)exampleagency
group (etcc_grp)summer
target (etcc_tar)sales
variant (etcc_var)banner
placement (etcc_plc)top
keyword (etcc_key)shorts
origin (etcc_ori)www.blog.de
origin/path/index.php
Additional dimensions for onsite attribution
etcc_cmp_onsite
etcc_med_onsite
etcc_st_onsite
Key figures

In addition to the attributes, the exports contain at least one key figure as a column. By default, the key figure “clicks” is used.

Event types

The event_type identifies the type of record being collected. Differences are for example eCommerce Events, ScrollDepth Events and Form Events.

Examples of event types from the page report:

page_impressionPage view
redirectRedirection (eg campaign redirect link)
viewView tracking event for capturing campaign views and opening rates
orderOrder
syntheticProductOfOrderLine item of an order (generated from the order)
syntheticProductOfOrderDifferenceDifference item, if the sum of all line items does not correspond to the order value
viewProductProduct seen (eCommerce API event)
insertToBasketAdded product to cart (eCommerce API event)
removeFromBasketProduct removed from cart (eCommerce API event)
insertToWatchlistProduct added to watch list (eCommerce API event)
removeFromWatchlistProduct removed from watchlist (eCommerce API event)

Examples event_type from the event report:

3010smartMessageViewSmart-Messaging (Optimiser view event)
3011testViewA/B-Testing (Optimiser view event)
3012smartMessageClickSmart Messaging (Optimiser click event)
3101userDefinedUser defined events
3102downloadDownload event
3103clickClick event
3104linkLink event
3110videoPlaytimePlayback time of a video player
3111videoStartStart function of a video player
3112videoStopStop function of a video player
3113videoPausePause function of a video player
3114videoMuteMute function of a video player
3115videoSeekPlay position of a video player
3116videoNextFurther function of a video player
3117videoPreviousBack function of a video player
3118videoFullsizeFull screen function of a video player
3119videoRestoreNormal picture function of a video player
3120audioPlaytimePlaying time of a music player
3121audioStartStart function of a music player
3122audioStopStop function of a music player
3123audioPausePause function of a music player
3124audioMuteMute function of a music player
3125audioSeekSeek function of a music player
3126audioNextFurther function of a music player
3127audioPreviousBack function of a music player
3131galleryViewViews from a gallery
3132galleryZoomZoom function of a gallery
3133galleryNextFurther function of a gallery
3134galleryPreviousBack function of a gallery
3141authenticationSuccessSuccessful login of a visitor
3142authenticationFailureError login of a visitor
3143authenticationLogoutLogout of a visitor
6000cssSelectorClickClicks captured by CSS selector

Sample data record

470939_2019-09-03_2019-09-03 (1)
470939_2019-09-03_2019-09-03_events (1)

Watch out:
Please ensure that the columns are formatted as text before opening so as not to lose any information due to the Excel conversion.