Contents of Raw Data Tables
Below you can find descriptions and technical details of the individual tables, which is available to you via Mapp's raw data export.
Information on the overview tables
- Primary key fields are highlighted in bold (if several fields are highlighted in bold, this is a composite primary key).
- Fields that serve as foreign keys are indicated by underlining (the tables that can be linked using foreign keys will be discussed later in this documentation).
- In the Data type column overviews you will find the underlying data type as well as the size limitation of the fields.
- Rows or sections marked with * are new updates, which will be available starting later in March 2021. Full Rollout of these changes will be completed in May 2021, please reach out to your Customer Success Manager if you have any questions.
Example
(20.0) for the data type Number means, for example, that the corresponding field contains numbers with a maximum of 20 digits and 0 decimal places. Unused decimal places are always filled with 0 (for example, 123456789,987000).
The following format always exists in fields with the data type Timestamp: 'YYYY-MM-DD HH:MM:SS.000000'.
Available Raw Data Tables
getFullVisitors – Data in the Context of Visits
The "getFullVisitors" table contains all data recorded in the context of visits. These include technical parameters, such as the name of the device that was used, as well geography data such as the country where the visit came from or the time zone in which the visit took place.
| Field Name | Data Type | Description |
|---|---|---|
SID | Number (20,0) | Session ID for the unique identification of a session (visit). |
EID | Number (20,0) | Ever ID used to identify a visitor using a Mapp Intelligence cookie. |
VISIT_TIME | Timestamp | The Time when the visit started. |
NEW_VISITOR | Number (1,0) | Is this a new visitor? 1 = yes 0 = no 2 = unknown |
OS | Text (100) | The operating system of the visitor's device. |
BROWSER | Text (100) | The user's browser. |
JAVASCRIPT | Number (1,0) | Has the visitor activated JavaScript? 1 = yes 0 = no |
RESOLUTION | Text (255) | Screen resolution on the device. |
COLORDEPTH | Text (255) | Screen color depth on the device. |
COOKIE | Number (1,0) | Indicates whether cookies are activated on the user's device/browser. 1 = yes 0 = no |
INNER_RESOLUTION | Text (10) | The resolution used internally (in the browser). This may differ from the screen resolution due to operating system settings or scaling of the browser window. |
JAVA | Number (1,0) | Indicates whether the Java runtime environment and the corresponding browser plugin are installed and active. 1 = yes 0 = no |
BROWSER_LANG | Text (50) | The language used in the browser. |
CITY | Text (255) | The city where the visitor is located during the visit. |
REGION | Text (255) | The region where the visitor is located during the visit. |
COUNTRY | Text (255) | The country where the visitor is located during the visit. |
ISP | Text (255) | The visitor's Internet service provider. |
ORGANISATION | Text (255) | The organization from which the visit took place. |
NETSPEED | Number (1,0) | The speed category of the visitor's Internet connection. 1 = unknown 2 = Modem/ISDN 3 = Cable/DSL 4 = Corporate 5 = Mobile 6 = Satellite 7 = Wireless |
TIMEZONE | Number (18,0) | The visitor's time zone. |
MOBILE_CLIENT | Text (255) | The name of the visitor's device. The device name can only be determined for smartphones and tablets. If a PC or laptop is used, this field contains the character string "Miscellaneous PC/Laptop." |
VISIT_TIME_END | Timestamp | The end time of the visit. |
GLOBAL_END_DEVICE_VISITOR_ID | Text (255) | Device-specific, global cookie ID of the mobile device. This column is optional and will only be exported if the corresponding feature is enabled for your Mapp account. |
URM_VISITOR_ID | Number (20,0) | Unique visitor ID. This ID is account specific and cross-device and is used for user-centered tracking. This column is optional and will only be exported if the corresponding feature is enabled for your Mapp account. |
| * BROWSER_NAME | Text (255) | Browser Name |
| * BROWSER_VENDOR | Text (255) | Browser Vendor |
| * BROWSER_VERSION | Text (255) | Browser Version |
| * BROWSER_MAJOR_VERSION | Number (18,0) | Browser Version (major) |
| * BROWSER_MINOR_VERSION | Number (18,0) | Browser Version (minor) |
| * OS_NAME | Text (255) | Operating System Name |
| * OS_VENDOR | Text (255) | Operating System Vendor |
| * OS_VERSION | Text (255) | Operating System Version |
| * OS_MAJOR_VERSION | Number (18,0) | Operating System Version (major) |
| * OS_MINOR_VERSION | Number (18,0) | Operating System Version (minor) |
| * DEVICE | Text (255) | Device |
| * DEVICE_NAME | Text (255) | Device Name |
| * DEVICE_VENDOR | Text (255) | Device Vendor |
| * DEVICE_FAMILY | Text (255) | Device Family |
| * DEVICE_MODEL | Text (255) | Device Model |
| * DEVICE_CLASS | Number (18,0) | Device Class 0 = PC / Laptop |
getContents – Page Calls
This table contains the data for all page calls. For instance, this table lets you follow the sequence and duration of visits by visitors to your website.
| Field Name | Data Type | Description |
|---|---|---|
REQUEST_ID | Number (20,0) | ID for unique identification of a page call. |
SID | Number (20,0) | Session ID used to assign the page call to a visit. |
TIMES | Timestamp | Time of the page call. |
CONTENT | Text (255) | Name of the page that was called. |
PAGE_DURATION | Number (18,0) | The time spent on the page in seconds. |
PAGE_ORDER | Number (18,0) | This is used to classify the page impressions in the order of all page impressions related to the visit. |
getFullReferrer – Access via Referrers
This table contains referrer information for access to your website.
| Field Name | Data Type | Description |
|---|---|---|
REQUEST_ID | Number (20,0) | ID for unique identification of referrer access. |
SID | Number (20,0) | Session ID used for assignment to a visit. |
TIMES | Timestamp | Time of access. |
REFERRER | Text (255) | Name of the referrer. |
URL | Text (255) | Referrer URL. |
SEARCH_ENGINE | Number (1,0) | Is the referrer a search engine? 0 = Other Referrer 1 = Search Engine 2 = Social Media |
getFullSearchPhrase/ getFullSearchPhraseIntern – Search Phrases
These two tables respectively contain external and internal search phrases.
| Field Name | Data Type | Description |
|---|---|---|
REQUEST_ID | Number (20,0) | ID for unique identification of a search phrase entry. |
SID | Number (20,0) | Session ID used for assignment to a visit. |
TIMES | Timestamp | Time of the search. |
SEARCH_PHRASE | Text (255) | The entered search phrase (if the search phrase is not transmitted in an external search, for example, if the search page is using https, "not provided" is displayed). |
getFullClicks – Clicks to Page Navigation
This table contains all clicks on navigation elements on your website.
| Field Name | Data Type | Description |
|---|---|---|
CLICK_REQUEST_ID | Number (20,0) | ID for unique identification of a click. |
SID | Number (20,0) | Session ID used for assignment to a visit. |
REQUEST_ID | Number (20,0) | The ID of the corresponding page call. 0 = the initial click of a session |
TIMES | Timestamp | Time of the click. |
CLICK | Text (255) | Name of the click element. |
| CLICK_REQUEST_ID | Number (20,0) | Click-Request-ID |
getFullCampaigns – Campaign Calls
This table contains all clicks on ad media.
| Field Name | Data Type | Description |
|---|---|---|
REQUEST_ID | Number (20,0) | ID for unique identification of a campaign click. |
SID | Number (20,0) | Session ID used for assignment to a visit. |
CAMPAIGN | Text (255) | Media code of the ad media. |
TIMES | Timestamp | Time of the click. |
KEYWORD | Text (255) | SEM keyword if available. |
getFullBasket – Products in the Shopping Basket
This table contains shopping baskets along with their products. The composite primary key is used to identify a product in a specific position in a shopping basket.
| Field Name | Data Type | Description |
|---|---|---|
REQUEST_ID | Number (20,0) | ID for unique identification of a shopping basket state via action or page request. |
BAS_POS | Number (18,0) | The position of the product in the shopping basket. |
SID | Number (20,0) | Session ID used for assignment to a visit. |
PRODUCT | Text (255) | Name of the product. |
TIMES | Timestamp | Time of the click that changed the product status. |
QUANTITY | Number (18,0) | The number of product units in the shopping basket. |
PRICE | Number (12,2) | Price of the product. |
STATE | Number (1,0) | Product status 0 = Added to the shopping basket 1 = Bought 2 = Product view 3 = Product list position |
| LIST_POS | Number (18,0) | The position of the product in the product list. |
getFullOrders – Orders
This table contains all orders.
| Field Name | Data Type | Description |
|---|---|---|
REQUEST_ID | Number (20,0) | ID for unique identification of an order. |
SID | Number (20,0) | Session ID used for assignment to a visit. |
ORDER_ID | Text (255) | ID for the order. |
TIMES | Timestamp | Time of the order. |
TOTAL_PRICE | Number (12,2) | Total order value. |
getFullForms – Forms
This table contains all form tracking data.
| Field Name | Data Type | Description |
|---|---|---|
FORM_REQUEST_ID | Number (20,0) | ID for unique identification of a form request. |
SID | Number (20,0) | Session ID used for assignment to a visit. |
REQUEST_ID | Number (20,0) | Used to assign a page call. |
TIMES | Timestamp | Time of the request. |
FORM | Text (255) | Name of the form. |
SUBMITTED | Number (1,0) | Did the contents of the form get sent? 0 = no 1 = yes |
getFormFields – Form Fields
This table contains detailed information on individual form fields of form tracking. Since a field of the original, composite primary key of the original table is not exported, the FORM_REQUEST_ID here only functions as a foreign key for the table "getFullForms." Thus, all fields of the table together form a good primary key.
| Field Name | Data Type | Description |
|---|---|---|
FORM_REQUEST_ID | Number (20,0) | ID for unique identification of a form field. |
SID | Number (20,0) | Session ID used for assignment to a visit. |
REQUEST_ID | Number (20,0) | Used to assign a page call. |
TIMES | Timestamp | Time of the request. |
FORM | Text (255) | Name of the form. |
FORM_FIELD | Text (255) | Form ID |
FIELD_VALUE | Text (255) | Value of the form field. |
CANCELED | Number (1,0) | Was the form canceled? 0 = no 1 = yes |
getFullMedia – Media
This table contains information about media requests.
| Field Name | Data Type | Description |
|---|---|---|
MEDIA_REQUEST | Number (20,0) | ID for unique identification of a media request. |
SID | Number (20,0) | Session ID used for assignment to a visit. |
REQUEST_ID | Number (20,0) | Used to assign a page call. |
TIMES | Timestamp | Time of the request. |
MEDIA | Text (255) | Designation of the medium. |
DURATION | Number (18,0) | The actual playing time with reverse coils etc. in seconds. (Can, therefore, be longer than the total length of the medium you have transmitted). This corresponds to the front end metric Play Duration. |
MAX_DURATION | Number (18,0) | The maximum media playback time in seconds, without backward movements. This corresponds to the front end metric Run Time. |
BANDWITH | Number (18,0) | The media bandwidth (in kbit/s). |
VOLUME | Number (3,0) | The volume during media consumption (in %, from 0 to 100). |
MUTE | Number (1,0) | Was the medium muted? 0 = no 1 = yes |
MEDIA_TIME | Number (18,0) | This corresponds to the front end metric Media Run Time. |
getFullMediaAction – Media Actions
This table contains information on individual actions performed on media. Here, the MEDIA_ACTION_REQUEST_ID denotes the ID of the media call as a whole. However, this ID is not unique, since the same ID is used for all further actions on a medium that are assigned to a media call.
| Form Field | Data Type | Description |
|---|---|---|
MEDIA_ACTION_REQUEST_ID | Number (20,0) | ID for identification of a media action. |
SID | Number (20,0) | Session ID used for assignment to a visit. |
REQUEST_ID | Number (20,0) | Used to assign a page call. |
TIMES | Timestamp | Time of the request. |
MEDIA_ACTION | Text (255) | Designation of the media action. |
_A_START_ | Number (5,0) | The media position where the action was started. |
_A_STOP_ | Number (5,0) | The media position where the action was stopped. |
MEDIA | Text (255) | Designation of the medium. |
MEDIA_TIME | Number (18,0) | Media time. |
getFullCustomer – Customer Identification
This table contains information on the customer ID, internal Ever ID, and the customer's sessions.
| Field Name | Data Type | Description |
|---|---|---|
SID | Number (20,0) | Session ID used for assignment to a visit. |
EID | Number (20,0) | The Ever ID is the internal Mapp ID for each visitor. This ID is unique. |
CUSTOMER_ID | Text (255) | Customer ID transferred by you to Mapp. |
TIMES | Timestamp | Timestamp for the start of the session. |
getFullCustomerJourney – Customer Journey
This table contains click actions that are relevant to customer journeys. These are supplemented with additional information relevant for the customer journey. For example, the value and time of the corresponding conversion.
| Field Name | Data Type | Description |
|---|---|---|
REQUEST_ID | Number (20,0) | ID for the identification of a customer journey event (such as a click) that led to conversion and therefore ended the customer micro-journey |
CJ_ORDER | Number (18,0) | The position of the event in the customer journey |
SID | Number (20,0) | Session ID used for assignment to the visit during which the target was reached, or the conversion took place. |
CAMPAIGN | Text (255) | The ad media belonging to the event (media code) |
KEYWORD | Text (255) | The advertisement name of the ad media |
SEARCH_PHRASE | Text (100) | The campaign search phrase |
| CUST_PARA_STRING_[1..3] | Text (255) | The values of the custom parameters that belong to the ad media. The number of these columns (from 1 to 3) and their meaning depend on your account configuration. |
CJ_TIME | Timestamp | The position of the event in the customer journey |
TIME | Timestamp | Time of the conversion in the corresponding customer journey. |
CONVERSION_VALUE | Number (12,2) | Value of the conversion belonging to the customer journey. |
Custom Parameter in getFullCustPara Tables
The tables listed below contain data for the custom parameters configured in your account. The tables are very similar but differ in the request types for which they include parameters.
The number of tables available per parameter type and the number of columns available per table depend on the number of custom parameters available in your Mapp account. Each export table for custom parameters contains a maximum of 10 different parameters.
Changes to Custom Tables
Since January 2023, custom tables have been merged into a single table based on parameter type and aren't limited to 10 parameters. Therefore, the table names don't contain an index.
The parameters are also now ordered by Parameter-ID (cust_pixel_id). This is represented in the tables below by _Y.
getFullCustParaSession – Session Parameter
This table contains custom parameters at the visit level.
| Field Name | Data Type | Description |
|---|---|---|
SID | Number (20,0) | The session ID for which one or more additional customer values are transferred is used to assign the session to the corresponding visit. |
TIMES | Timestamp | The time within the session at which the custom parameter is transmitted. |
ITEM_ID | Number (20,0) | An ascending number starting with "1" to distinguish multi-value parameter values. This field is never empty or less than "1." |
CUST_PARA_STRING_Y | Text (255) | The value of the corresponding custom parameter with the string data type (optional, depending on the custom parameter configuration). |
CUST_PARA_NUMBER_Y | Number (12,2) | The value of the corresponding custom parameter with the numeric data type (optional, depending on the custom parameter configuration). |
CUST_PARA_GENERIC_Y | Text (510) | The value of the corresponding generic custom parameter, represented as a string (optional, depending on the custom parameter configuration). |
getFullCustParaTimes – Time-related Parameter
This table contains time-related custom parameters.
| Field Name | Data Type | Description |
|---|---|---|
REQUEST_ID | Number (20,0) | Unique ID for the timestamp entry, which is not used for further assignments. |
TIMES | Timestamp | Time of the request. |
ITEM_ID | Number (20,0) | An ascending number starting with "1" to distinguish multi-value parameter values. This field is never empty or less than "1." |
CUST_PARA_STRING_Y | Text (255) | The value of the corresponding custom parameter with the string data type (optional, depending on the custom parameter configuration). |
CUST_PARA_NUMBER_Y | Number (12,2) | The value of the corresponding custom parameter with the numeric data type (optional, depending on the custom parameter configuration). |
CUST_PARA_GENERIC_Y | Text (510) | The value of the corresponding generic custom parameter, represented as a string (optional, depending on the custom parameter configuration). |
getFullCustParaPage – Page Parameter
This table contains custom parameters at the page level.
| Field Name | Data Type | Description |
|---|---|---|
REQUEST_ID | Number (20,0) | Used to assign a data set of page parameters to the page request with which the parameter values were measured. |
SID | Number (20,0) | Session ID used for assignment to a visit. |
TIMES | Timestamp | Time of the request. |
ITEM_ID | Number (20,0) | An ascending number starting with "1" to distinguish multi-value parameter values. This field is never empty or less than "1." |
CUST_PARA_STRING_Y | Text (255) | The value of the corresponding custom parameter with the string data type (optional, depending on the custom parameter configuration). |
CUST_PARA_NUMBER_Y | Number (12,2) | The value of the corresponding custom parameter with the numeric data type (optional, depending on the custom parameter configuration). |
CUST_PARA_GENERIC_Y | Text (510) | The value of the corresponding generic custom parameter, represented as a string (optional, depending on the custom parameter configuration). |
getFullCustParaProduct – Product Parameter
This table contains custom parameters at the product level.
| Field Name | Data Type | Description |
|---|---|---|
REQUEST_ID | Number (20,0) | Used to uniquely map a data set of product parameters to the product call or page contained in "getFullBasket" with which this data set was measured. The combination of REQUEST_ID and BAS_POS can be linked to the same "getFullBasket" columns. |
BAS_POS | Number (18,0) | Position in the shopping basket. |
SID | Number (20,0) | Session ID of the product call, used for assignment to the corresponding visit. |
TIMES | Timestamp | Time of the request. |
CUST_PARA_STRING_Y | Text (255) | The value of the corresponding custom parameter with the string data type (optional, depending on the custom parameter configuration). |
CUST_PARA_NUMBER_Y | Number (12,2) | The value of the corresponding custom parameter with the numeric data type (optional, depending on the custom parameter configuration). |
CUST_PARA_GENERIC_Y | Text (510) | The value of the corresponding generic custom parameter, represented as a string (optional, depending on the custom parameter configuration). |
getFullCustParaClick – Click Parameter
This table contains custom parameters at the click level.
| Field Name | Data Type | Description |
|---|---|---|
REQUEST_ID | Number (20,0) | Used to assign a data set of click parameters to the click request with which the parameter characteristics were measured. |
SID | Number (20,0) | The session ID of the click request is used to assign the session to the corresponding visit. |
TIMES | Timestamp | Time of the request. |
ITEM_ID | Number (20,0) | An ascending number starting with "1" to distinguish multi-value parameter values. This field is never empty or less than "1." |
CUST_PARA_STRING_Y | Text (255) | The value of the corresponding custom parameter with the string data type (optional, depending on the custom parameter configuration). |
CUST_PARA_NUMBER_Y | Number (12,2) | The value of the corresponding custom parameter with the numeric data type (optional, depending on the custom parameter configuration). |
CUST_PARA_GENERIC_Y | Text (510) | The value of the corresponding generic custom parameter, represented as a string (optional, depending on the custom parameter configuration). |
getFullCustParaCampaign – Campaign Parameter
This table contains custom parameters for ad media.
| Field Name | Data Type | Description |
|---|---|---|
REQUEST_ID | Number (20,0) | Used to uniquely assign a data record of campaign parameters to the campaign click with which the parameter values were measured. |
SID | Number (20,0) | The session ID of the campaign call is used to assign the corresponding visit. |
TIMES | Timestamp | Time of the request. |
ITEM_ID | Number (20,0) | An ascending number starting with "1" to distinguish multi-value parameter values. This field is never empty or less than "1." |
CUST_PARA_STRING_Y | Text (255) | The value of the corresponding custom parameter with the string data type (optional, depending on the custom parameter configuration). |
CUST_PARA_NUMBER_Y | Number (12,2) | The value of the corresponding custom parameter with the numeric data type (optional, depending on the custom parameter configuration). |
CUST_PARA_GENERIC_Y | Text (510) | The value of the corresponding generic custom parameter, represented as a string (optional, depending on the custom parameter configuration). |