With etracker you have full control over your data and can access them in various forms of processing for the respective purposes:
- Analysis data available via
- Report interface
- Manual or automated report data export
- Web Service API (REST)
- Remarketing feed with eCommerce event data (view lists, view product details, put into cart, put on wish list, order, abandoned shopping cart) after session end at recipient level for Email Marketing Automation.
- Targeting API provides real-time user profile information from the entire visit history for website personalization and for individualized marketing campaigns (Recency-Frequency-Monetary, content based on interests and products).
- Google Ads Upload automatically converts non-personal conversion data to Google Ads to improve your bid and ad strategy.
- Raw data contains the most comprehensive data for each measurement point with timestamp for further processing in data warehouses, statistics solutions and BI systems.
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.
If a recurring raw data export has been specified, the raw data tables are automatically transferred to an FTPS server in CSV format. 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
By requesting the service, you will receive an initial consultation on the configuration of the raw data tables required for your purposes, and we will provide access data to our FTPS server with which you can retrieve the exports. You set the export time yourself (usually between 6 and 10 o’clock in the morning for the previous day to ensure complete processing).
Activation usually takes place within five working days. There are one time activation costs and ongoing deployment costs.
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.