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 name | Example value | Description |
---|---|---|
date | 2019-09-05 | Date of the record |
timestamp | 2019-09-05 13:45:18 | Seconds timestamp of the record |
is new visit | 1 | Specifies whether a record is a visit |
event_type | page_impression | Type of record (for more information, see Event Types section) |
user-id | 10020628959530835773 | Value assigned to a visitor |
session-id | 3771245427251635319 | Value assigned to a visit |
For the other columns, these attributes can be freely selected:
Column name | Example value |
---|---|
domain | customerwebsite.com |
seitenname | index |
area_level_1 | shop |
area_level_2 | clothes |
area_level_3 | women |
area_level_4 | bottoms |
area_level_5 | trousers |
area_level_6 | jeans |
area_level_7 | shorts |
area_level_8 | |
area_level_9 | |
area_level_10 | |
device_type | STR_CC_ATTR_VALUE_DEVICE_TYPE_MOBILE_PHONE |
device_manufacturer | Apple |
device_os | iOS |
device_os_version | 12.4.1 |
device_model | iPhone |
device_browser | Mobile Safari |
device_browser_version | 12 |
device_type_detail | STR_CC_ATTR_VALUE_DEVICE_TYPE_DETAIL_SMARTPHONE |
geo_country | Germany |
visitor_attraction | STC_CC_ATTR_VALUE_NEW_VISITOR |
visitor_status | STC_CC_ATTR_VALUE_NO_CUSTOMER |
et_seg1 | |
et_seg2 | |
et_seg3 | |
et_seg4 | |
et_seg5 | |
order_number | 2465897 |
product_name | Jeansshorts |
product_id | 5986 |
1. Kategorie | women |
2. Kategorie | bottoms |
3. Kategorie | jeans |
4.Kategorie | shorts |
url | www.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_impression | Page view |
---|---|
redirect | Redirection (eg campaign redirect link) |
view | View tracking event for capturing campaign views and opening rates |
order | Order |
syntheticProductOfOrder | Line item of an order (generated from the order) |
syntheticProductOfOrderDifference | Difference item, if the sum of all line items does not correspond to the order value |
viewProduct | Product seen (eCommerce API event) |
insertToBasket | Added product to cart (eCommerce API event) |
removeFromBasket | Product removed from cart (eCommerce API event) |
insertToWatchlist | Product added to watch list (eCommerce API event) |
removeFromWatchlist | Product removed from watchlist (eCommerce API event) |
Examples event_type from the event report:
3010 | smartMessageView | Smart-Messaging (Optimiser view event) |
---|---|---|
3011 | testView | A/B-Testing (Optimiser view event) |
3012 | smartMessageClick | Smart Messaging (Optimiser click event) |
3101 | userDefined | User defined events |
3102 | download | Download event |
3103 | click | Click event |
3104 | link | Link event |
3110 | videoPlaytime | Playback time of a video player |
3111 | videoStart | Start function of a video player |
3112 | videoStop | Stop function of a video player |
3113 | videoPause | Pause function of a video player |
3114 | videoMute | Mute function of a video player |
3115 | videoSeek | Play position of a video player |
3116 | videoNext | Further function of a video player |
3117 | videoPrevious | Back function of a video player |
3118 | videoFullsize | Full screen function of a video player |
3119 | videoRestore | Normal picture function of a video player |
3120 | audioPlaytime | Playing time of a music player |
3121 | audioStart | Start function of a music player |
3122 | audioStop | Stop function of a music player |
3123 | audioPause | Pause function of a music player |
3124 | audioMute | Mute function of a music player |
3125 | audioSeek | Seek function of a music player |
3126 | audioNext | Further function of a music player |
3127 | audioPrevious | Back function of a music player |
3131 | galleryView | Views from a gallery |
3132 | galleryZoom | Zoom function of a gallery |
3133 | galleryNext | Further function of a gallery |
3134 | galleryPrevious | Back function of a gallery |
3141 | authenticationSuccess | Successful login of a visitor |
3142 | authenticationFailure | Error login of a visitor |
3143 | authenticationLogout | Logout of a visitor |
6000 | cssSelectorClick | Clicks 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.