Raw data export
With the raw data service, you receive a daily 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, carry out further statistical analyses or create individual visualizations.
The exported raw data is not completely unprocessed, but already contains the resolved geolocation, device and technology attributes as well as the assignment to external or internal campaigns.
The structure of the exported data has been changed in the past. The raw data export therefore exists in two different versions. V1 and V2. Anyone who activates the raw data export for the first time will automatically receive version 2. However, for compatibility reasons, customers who already use version 1 of the export will retain this version. You can tell which version is being used by the name of the files. In V2, the CSV files end with “…-v2.csv”.
This documentation is based on the raw data export in V2. If you are using V1, there may be slight deviations in the structure.
If you would like to switch from V1 to V2, simply send an e-mail to service@etracker.com.
The prerequisite for booking the raw data export is an etracker analytics license in the Enterprise Edition.
Activation
Go to Exports → Raw data export. There you can also download a sample file with your own data for evaluation in advance using the “Sample” button.
If you want to activate the raw data export, you can access the corresponding order form via the “Book access to raw data” button.
Once activated, you will find the daily export files here. The automatic retrieval via curl call, i.e. a standardized data transfer via command line, is practical.
To do this, you only need to add an export token to the specified link, which can be created under Integration → Access token. Make sure that you select the “Exports” type for this.
Data
Files
Two CSV files with the naming scheme “export-accountID-jjjj-mm-dd-onsite-v2” and “export-accountID-jjjj-mm-dd-offsite-v2” are created for each day.
Both tables contain page views, events and e-commerce events. A distinction is made between external attribution (visits in the context of external campaigns) and onsite attribution (visits in the context of onsite campaigns).
Each line contains one data record. The data records are sorted by session ID and timestamp.
Basic data
The following columns are always included:
| Column designation | Description |
|---|---|
| date | Date of the data record |
| timestamp | Time stamp of the data record to the second |
| is new visit | Indication of whether a data record is the start of a visit |
| event_type | Type of data record (for more information, see section Event types) |
| user-id | ID that is assigned to a visitor |
| session-id | ID that is assigned to a visit |
Attributes
The following attributes may be present:
| Column designation | Description | Special feature |
|---|---|---|
| medium onsite | Medium | Onsite only |
| medium | Medium | Offsite only |
| campaign onsite | Campaign | Onsite only |
| campaign | Campaign | Offsite only |
| search term onsite | Search term on your own page | Onsite only |
| origin | Origin | |
| origin/path | URL path of the origin | |
| order_number | Order number | |
| order_status | Order status | |
| product_name | Product name | |
| product_id | Product ID | |
| 1st category | 1st product category | |
| 2. category | 2. product category | |
| 3rd category | 3. product category | |
| 4th category | 4. product category | |
| page_name | Page name | |
| geo_country | Country | |
| geo_region | Region | |
| geo_city | City | |
| device_type | Device type | |
| device_os | Operating system | |
| device_os_version | Version number of the operating system | |
| device_model | Device model | |
| device_manufacturer | Device manufacturer | |
| device_browser | Browser | |
| device_browser_version | Browser version | |
| browser_language | Browser language | |
| device_type_detail | Type of device | |
| screen_size | Resolution | |
| area_level_1 | Area 1 | |
| area_level_2 | Area 2 | |
| area_level_3 | Area 3 | |
| area_level_4 | Area 4 | |
| area_level_5 | Area 5 | |
| area_level_6 | Area 6 | |
| area_level_7 | Area 7 | |
| area_level_8 | Area 8 | |
| area_level_9 | Area 9 | |
| area_level_10 | Range 10 | |
| url | Called URL | |
| et_channel | deprecated | |
| et_sub_channel | deprecated | |
| etcc_dom | Domain of the URL | |
| etcc_par | Partner | |
| etcc_adv | Advertiser | |
| etcc_acy | Agency | |
| etcc_tar | Target | |
| etcc_ctv | Display | |
| etcc_var | Variant | |
| etcc_grp | Group | |
| etcc_key | Keyword | |
| etcc_plc | Placement | |
| etcc_pos | Search position | |
| etcc_mty | Match type | |
| etcc_bky | Booked keyword | |
| seg1 | URL Segment 1 | |
| seg2 | URL Segment 2 | |
| seg3 | URL Segment 3 | |
| seg4 | URL Segment 4 | |
| seg5 | URL Segment 5 | |
| seg6 | URL Segment 6 | |
| seg7 | URL Segment 7 | |
| seg8 | URL Segment 8 | |
| seg9 | URL Segment 9 | |
| seg10 | URL Segment 10 | |
| view_product_in_list_position | Position in which a product was displayed in a list | |
| view_product_in_list_size | Size of the list in which a product was displayed | |
| cookie_approval | Permission to set cookies | |
| visitor_attraction | Besuchergewinnung | |
| conversion_name | Name of the conversion | |
| conversion_type | Type of conversion | |
| object | Event object | |
| action | Event action | |
| event_sub_type | Event subtype | |
| category | Event category | |
| scroll_depth | Scroll depth |
Key figures
| Column designation | Description | Special feature |
|---|---|---|
| clicks | Clicks | |
| pi | Page view (Yes/No) | |
| views | Views | |
| lead_revenue | Order turnover | |
| sales_revenue | Purchase turnover | |
| product_count_ordered | Number of products ordered | |
| product_quantity_ordered | Product quantity ordered | |
| product_value_ordered | Value of goods ordered | |
| product_count_sold | Number of products purchased | |
| product_quantity_sold | Product quantity purchased | |
| product_value_sold | Value of goods purchased | |
| product_quantity_cancellation | Number of products canceled | |
| product_value_lead_to_cancel | Value of canceled orders | |
| product_value_sale_to_cancel | Value of canceled purchases | |
| conversion_count | Number of conversions | |
| conversion_value | Conversion value | |
| staytime | Dwell time | |
| product_view_in_list | Product seen in list | |
| custom_event_click | Custom Event Number of clicks | Offsite only |
| custom_event_media_start | Custom Event Number of starts | Offsite only |
| custom_event_media_stop | Custom event number of stops | Offsite only |
| custom_events_media_playtime_sum | Custom Event Total playback time | Offsite only |
Event types
The “event_type” column contains the type of data record recorded. A distinction is made, for example, between e-commerce events, scroll depth events and form events.
| Event | Description |
|---|---|
| General | |
| page_impression | Page view |
| redirect | Redirection (e.g. campaign redirect link) |
| pageexit | Page exit beacon, which is fired when leaving the page |
| E-Commerce | |
| Product events | |
| viewProduct | Product seen |
| viewProductList | Product list seen |
| syntheticViewProductInList | Product seen in product list |
| syntheticProductOfOrder | Synthetic event that contains the data of a product of an order event. The order_flags are set according to the triggering event(order, orderCancellation, orderPartialCancellation). |
| Shopping cart and watch list events | |
| insertToBasket | Product added to shopping cart |
| removeFromBasket | Product removed from the shopping cart |
| insertToWatchlist | Product added to watch list |
| removeFromWatchlist | Product removed from watch list |
| order | |
| order | Order sent |
| orderCancellation | Order canceled |
| orderConfirmation | Order purchased |
| WA custom events in CC | |
| userDefined | User-defined events |
| download | Download Event |
| click | Click Event |
| link | Link Event |
| view | View Event |
| Video events | |
| videoPlaytime | Playing time of a video player |
| videoStart | Start function of a video player |
| videoStop | Stuffing function of a video player |
| videoPause | Pause function of a video player |
| videoMute | Mute function of a video player |
| videoSeek | Playback position of a video player |
| videoNext | Further function of a video player |
| videoPrevious | Back function of a video player |
| videoFullsize | Full screen function of a video player |
| videoRestore | Normal picture function of a video player |
| Audio events | |
| audioPlaytime | Playback time of a music player |
| audioStart | Start function of a music player |
| audioStop | Stuffing function of a music player |
| audioPause | Pause function of a music player |
| audioMute | Mute function of a music player |
| audioSeek | Playback position of a music player |
| audioNext | Further function of a music player |
| audioPrevious | Back function of a music player |
| Gallery events | |
| galleryView | Calls from a gallery |
| galleryZoom | Zoom function of a gallery |
| galleryNext | Further function of a gallery |
| galleryPrevious | Back function of a gallery |
| Authentication Events | |
| authenticationSuccess | Successful login of a visitor |
| authenticationFailure | Error when a visitor logs in |
| authenticationLogout | Logout of a visitor |
| FormEvents | |
| formEvent | Event form |
| Page Exit Beacon | |
| pageExitBeacon | Page exit beacons for staytime calculation |
| Scroll depth in CC | |
| scrollDepth | View time of the individual areas for the scroll depth of a page |
| CookieApproval events | |
| cookieApproval | Consent in the Consent Manager |
| CSS selector events | |
| cssSelectorClick | Clicks that were recorded via CSS selector |
| cssSelectorView | View, which were captured via CSS selector |
| Data Enrichtment Events | |
| onsiteCampaign | This triggers an onsite campaign |
| customSegment | This can be used to assign to a separate segment |
| Conversion events | |
| conversion | Conversion event |