Data Schema

Our schema is fully based on events, e.g. a common page view is an event with the entity =page and the action = view. To learn more about how flexible you can define your entities, actions and triggers with elbwalker please check out the walker basics.

Out of the box elbwalker collects the following data points in three different tables: sessions, events and entities.

Sessions Table

Data Point

Description

Example

Default/

optional

id

Random ID to identify a session

508g6su9zz849m7q4su09legkeb

default

timestamp

Time stamp at the beginning of a session

2020-11-14 05:56:15.462 UTC

default

user.hash

Encrypted temporary user ID

834f073f527bf1f8709798cd41e5dd322

e369dbadb460eb5711ee4c42d5be09f

default

user.ip

Anonymized IP address (IPv4 or IPv6)

2001:1600::

default

marketing.medium

Marketing type of a session

cpc

default

marketing.source

Name of the source of a session

google

default

marketing.campaign

Name of a marketing campaign

cookieless

default

marketing.content

Name of an ad or content ID

blau

default

marketing.term

Associated keywords

webanalytics

default

marketing.clickID

Corresponding click ID from marketing parameters, e.g. gclid

Cj0KCQiA-rj9BRCaARIsAB_4ACNt6VYV5T70sG-24wBv8FAdck0PmaLfn41YTqv076MaPyyCl

Era0IaAr5MEALw_vH4

default

referrer.medium

Type of referrer

internal

default

referrer.source

Name of referrer

Google

default

referrer.hostname

Host- or domain name of referrer

startupdock.de

default

referrer.url

Full referrer URL

https://startupdock.de/

default

deviceCategory

Device grouping

desktop

default

os.name

Operating System

Mac OS

default

os.version

Version of operating system

10.15.3

default

browser.name

Browser name

Chrome

default

browser.version

Browser version

87.0.4280.88

default

browser.userAgent

User agent of the browser

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/537.36 (KHTML, like Geko) Chrome/87.0.4280.88 Safari/537.36

default

language

First accepted language preference

de

default

location.country

Country of the visitor

DE

default

location.region

Region of the visitor

Hamburg

optional

location.regionCode

Region code of the visitor

20249

optional

location.city

City of the visitor

Hamburg

optional

location.latitude

Latitude of the visitor

53.5625

optional

location.longitude

Longitude of the visitor

9.9573

optional

isBot

Basic distinction between real and spam events

false

default

source.type

Type of source of origin

event

default

source.id

Source ID

iiqts3i6y4b079j7dz4cy221e62

default

createdAt

Time stamp from the moment of ingestion

2020-11-14 05:56:15.462 UTC

default

elbwalker autotracks pageview events. All other events like clicks, form submits, transactions etc. need to be implemented via our walker.

Events Table

Data Point

Description

Example

Default/

Optional

id

Random ID to identify an event

bc8xgfa7t63r8mxhxdqt0t782if

default

timestamp

Timestamp from the moment the event occurred

2020-11-04 00:00:00.077 UTC

default

sessionID

Foreign key to the related session.id

8j7p4an1hyi8z4i616z72jd3b4k

default

trigger

Name of the trigger that fired an event

load

default

entity

Name of the entity

page

default

action

Action of the entity

view

default

entityID

Foreign key to the related entity.id

gj213ip6rtztwx21259vvp1pfe5

default

timing

Seconds that has passed since initialization

4.12

default

source.type

Origin of the event

web

default

source.id

Type of source of origin

https://www.elbwalker.com/ueber-uns

default

source.referrer

Corresponding id of the source

https://www.elbwalker.com/

default

source.version

Root/previous cause of the event

1-1

default

createdAt

Timestamp from the moment of ingestion

2020-11-07 11:07:08.923 UTC

default

Entities Table

Data Point

Description

Example

Default/

Optional

id

Random ID to identify an entity

pe25l70r2kg1i2jninn2h4vl9wz

default

timestamp

Timestamp from the moment the entity is created

2020-11-06 21:26:38.901 UTC

default

type

Name of the entity type

page

default

entityID

Primary key used to group entity data

/

default

data

All entity properties

page

default

data.key

Key of the entity property

id

title

default

data.value

Value of the entity property

/

Cookieless Tracking. Das neue Web Analytics.

default

source.type

Kind of origin source

event

default

source.id

ID of the origin source

zgumx9oibnfp9rcihfredl2s821

default

createdAt

Time stamp from the moment of ingestion

2020-11-07 11:07:08.923 UTC

default

Notes on our data collection

Our database offers maximum flexibility and is built on the principle of "privacy by design", i.e. all fields can be blocked and will not be collected at the request of the website owner.

Depending on the data point, this can have an impact on your analysis possibilities.

By default data points are measured that are classified as “default”. “Optional” fields can be activated after an internal data protection check.

In addition, elbwalker prohibits the misuse of the system to collect personal data and load it into the system. The website owner is not allowed to load any personal data (e.g. email address) into the system without the permission of the owner/end user. Learn more in our terms of service (German only atm)