# Raw Data Structured

​Here's how the data is structured on the SFTP server:

1. **Folder Structure**: Navigate through the folders to find daily data.
2. **File Types**: Each day contains two files - `<filename>_json.zip` and `<filename>_csv.zip`.
3. **Data Extraction**:
   * Unzip these files to access daily tracked data.
   * Files are split into smaller chunks if there is high traffic, e.g., user1.json, user2.json, etc.

## Folder Structure <a href="#datastructure-folderstructure" id="datastructure-folderstructure"></a>

<figure><img src="https://2315305008-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fy15ncufYr341K5U8q6Of%2Fuploads%2FIZgjB5hPfQUzJ11jh1si%2Fimage.png?alt=media&#x26;token=e4f0683c-35b0-48e5-a5bb-8eea517294c1" alt=""><figcaption></figcaption></figure>

## Data Structure <a href="#datastructure-datastructure" id="datastructure-datastructure"></a>

The raw data includes various objects and fields. Each document, submitted via the `_jts.push track` command, is stored in its own file when decompressed. Every JENTIS Raw Data output contains the essential documents: user, session, and event. Additionally, there are optional documents such as pageview, product, and order.

### Documents <a href="#datastructure-documents" id="datastructure-documents"></a>

A document within the JENTIS internal data model denotes a tracked object. The system automatically creates two essential documents for every activity: "user" and "session." Additionally, any object sent to the JENTIS Data Layer, such as "pageview," "event," "product," or custom-defined documents, is treated as a document. This functionality is based on the "track" command, further detailed in the JENTIS Data Layer Fundamentals.

Each document contains the following fields:

## Mandatory Fields <a href="#datastructure-mandatoryfields" id="datastructure-mandatoryfields"></a>

| Name               | Type    | Description                                                                                                                                                                           | Example             |
| ------------------ | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------- |
| \_id               | String  | This is the JENTIS internal identifier for this document. The \_id is unique across the whole system and always has the type string.                                                  | “11111111111111111“ |
| account            | String  | The account is the container name, as configured in the JTM plus the environment name. If you unsure what your environment is, expect “live“. Both values are concatenated via a dot. | “mycompany.live“    |
| triggerReason      | String  | Trigger Reason is the reason why this document was created. The value is the Tag Name that is configured in your JTM                                                                  | “productView“       |
| timestampClient    | Integer | The unix timestamp of when this document was created on your visitors browser.                                                                                                        | 1649842308000       |
| timestampLastTouch | Integer | The unix timestamp of when the complete processing of this document was finished. TimestampClient - timestampLastTouch = total processing time                                        | 1649842309000       |

&#x20;

## Optional Fields <a href="#datastructure-additionalfields" id="datastructure-additionalfields"></a>

### **User**

Per default the user document doesn’t have any additional fields.

### **Session**

| Name                                        | Type   | Description                                                                                                                                                                                                                                                                                                                                    | Example             |
| ------------------------------------------- | ------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------- |
| property.window\_navigator\_\<variableName> | -      | Under this name you can find every[ navigator-variable](https://developer.mozilla.org/en-US/docs/Web/API/Navigator) that was available on your visitors browser. The properties can be accessed by adding “property.window\_navigator\_“ to whatever variable you are interested in as a prefix. Example: property.window\_navigator\_language |                     |
| property.window\_screen\_\<variableName>    | -      | These variables are all the[ window-screen](https://developer.mozilla.org/en-US/docs/Web/API/Screen) variables that were available on your visitors browser. The properties can be accessed by adding “property.window\_screen\_“ to whatever variable you are interested in as a prefix. Example: window\_screen\_width                       |                     |
| parent.user                                 | String | This is the \_id of the user document of the user responsible for this session.                                                                                                                                                                                                                                                                | “11111111111111111“ |

### &#x20;**Pageview**

| Name               | Type   | Description                                                                            | Example                                          |
| ------------------ | ------ | -------------------------------------------------------------------------------------- | ------------------------------------------------ |
| property.href      | String | The url of the site where the pageview was triggered.                                  | “[www.mycompany.com“](http://www.mycompany.com“) |
| property.pageTitle | String | The pagetitle of the site where the pageview was triggered.                            | “Welcome to mycompany!“                          |
| parent.user        | String | This is the \_id of the user document of the user responsible for this pageview.       | “11111111111111111”                              |
| parent.session     | String | This is the \_id of the session document of the session responsible for this pageview. | “22222222222222222”                              |

### &#x20;**Event**

| Name           | Type   | Description                                                                         | Example                                          |
| -------------- | ------ | ----------------------------------------------------------------------------------- | ------------------------------------------------ |
| property.href  | String | The url of the site where the pageview was triggered.                               | “[www.mycompany.com](http://www.mycompany.com/)“ |
| property.group | String | The value of this variable will be the name of the group this event belongs to.     | “Visitor Interaction“                            |
| property.name  | String | The value of this variable will be the name the event that got triggered.           | “Scroll Depth“                                   |
| property.value | String | Here you will find the value of the event.                                          | “25%“                                            |
| parent.user    | String | This is the \_id of the user document of the user responsible for this event.       | “11111111111111111”                              |
| parent.session | String | This is the \_id of the session document of the session responsible for this event. | “22222222222222222”                              |

### **Productview**

| Name                     | Type   | Description                                                                                                                                                                       | Example              |
| ------------------------ | ------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------- |
| property.productId       | String | The product id of the product that was viewed.                                                                                                                                    | “e23dj45kjh“         |
| property.productName     | String | The name of the product that was viewed.                                                                                                                                          | “My beautiful table“ |
| property.productPrice    | Float  | The price of the product that was viewed.                                                                                                                                         | 19.99                |
| property.productDiscount | Float  | If there was a discount for the product, it will be shown here. Example: The product that was viewed is on sale and is 20% cheaper than usual → 0.2 will be stored in this field. | 0.2                  |
| parent.user              | String | This is the \_id of the user document of the user responsible for this event.                                                                                                     | “11111111111111111”  |
| parent.session           | String | This is the \_id of the session document of the session responsible for this event.                                                                                               | “22222222222222222”  |

### &#x20;**AddToCart**

| Name                     | Type    | Description                                                                                                                                                                       | Example              |
| ------------------------ | ------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------- |
| property.productId       | String  | The product id of the product that was added to the cart.                                                                                                                         | “e23dj45kjh“         |
| property.productName     | String  | The name of the product that was added to the cart.                                                                                                                               | “My beautiful table“ |
| property.productPrice    | Float   | The price of the product that was added to the cart.                                                                                                                              | 19.99                |
| property.productDiscount | Float   | If there was a discount for the product, it will be shown here. Example: The product that was viewed is on sale and is 20% cheaper than usual → 0.2 will be stored in this field. | 0.2                  |
| property.productQuantity | Integer | How many times was this specific product added.                                                                                                                                   | 2                    |
| parent.user              | String  | This is the \_id of the user document of the user responsible for this event.                                                                                                     | “11111111111111111”  |
| parent.session           | String  | This is the \_id of the session document of the session responsible for this event.                                                                                               | “22222222222222222”  |

### **Sale**

| Name                     | Type              | Description                                                                                                                                                                       | Example                               |
| ------------------------ | ----------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------- |
| property.productId       | Array of strings  | The product ids of all the products that were bought in this purchase.                                                                                                            | \[“e23dj45kjh“, “a3fd5klas“]          |
| property.productName     | Array of strings  | The name of the products that were bought in this purchase.                                                                                                                       | \[“My beautiful table“, “Nice Chair“] |
| property.productPrice    | Array of floats   | The price of the products that were bought in this purchase.                                                                                                                      | \[19.99, 5.99]                        |
| property.productDiscount | Array of floats   | If there was a discount for the product, it will be shown here. Example: The product that was viewed is on sale and is 20% cheaper than usual → 0.2 will be stored in this field. | \[0.2, 0]                             |
| property.productQuantity | Array of integers | The quantity for every bought product.                                                                                                                                            | \[1,2]                                |
| property.orderId         | String            | The order of this purchase.                                                                                                                                                       | “asdf3f3ad“                           |
| property.orderTotal      | Float             | The total cost of the items bought, excluding shipping.                                                                                                                           | 31.97                                 |
| property.shipping        | Float             | The total shipping costs for this purchase.                                                                                                                                       | 5                                     |
| parent.user              | String            | This is the \_id of the user document of the user responsible for this event.                                                                                                     | “11111111111111111”                   |
| parent.session           | String            | This is the \_id of the session document of the session responsible for this event.                                                                                               | “22222222222222222”                   |

### Search <a href="#datastructure-search" id="datastructure-search"></a>

| Name                   | Type             | Description                                                                         | Example                       |
| ---------------------- | ---------------- | ----------------------------------------------------------------------------------- | ----------------------------- |
| property.searchTerm    | String           | The term used in the search bar.                                                    | “brown chair“                 |
| property.amountResults | Integer          | The amount of results the search resulted in.                                       | 3                             |
| property.foundIds      | Array of strings | All the product ids that were shown for this search                                 | \[“a3a33r“,”k8k8s2”, “g5g55“] |
| parent.user            | String           | This is the \_id of the user document of the user responsible for this event.       | “11111111111111111”           |
| parent.session         | String           | This is the \_id of the session document of the session responsible for this event. | “22222222222222222”           |

<br>
