# Sessions Table

The Sessions Table captures data on each visitor's session, including session duration. A session concludes when there has been no activity by the user for 30 minutes. See table structure below.

{% hint style="info" %}
\*For users who want to parse results by match type—similar to how they’re displayed in the front-end application—use the `File Type` column values as your delimiters.
{% endhint %}

## Table Structure

| Column                   | Description                                                                                                                  |
| ------------------------ | ---------------------------------------------------------------------------------------------------------------------------- |
| hem                      | Hashed email (SHA256) associated with a tag fire                                                                             |
| tag\_id                  | The ID associated with the tag                                                                                               |
| \***file\_type**         | File type associated with the tag fire (B2B, B2C, PTE)                                                                       |
| session\_id              | The ID associated with a session. The session ends when there has been no activity for 30 minutes                            |
| session\_start           | Timestamp (YYYY-MM-DD HH:MM:SS.sss) of when the session started                                                              |
| session\_end             | Timestamp (YYYY-MM-DD HH:MM:SS.sss) of when the session ended                                                                |
| est\_session\_duration   | The estimated session duration in seconds. This is estimated because we don’t know how long someone was on the last page for |
| entry\_url               | The first URL someone visited in a session                                                                                   |
| exit\_url                | The last URL someone visited in a session                                                                                    |
| total\_pages\_visited    | The total number of pages someone visited in a session                                                                       |
| unique\_pages\_visited   | The unique number of pages someone visited in a session                                                                      |
| un\_processed\_timestamp | Unix timestamp of when the record was processed                                                                              |
| un\_updated\_timestamp   | Unix timestamp of when the record was last updated                                                                           |