Schema Overview

The database schema is comprised of three tables: Visitors, Sessions and Pages. They are joined via hem and session_id respectively.

Database Tables

• The Visitors Table stores comprehensive information about individuals who have visited a website with the Distilled tag installed. B2B, B2C, and PTE records are consolidated in this table view.

• The Sessions Table captures data pertaining to each visitor's session, including session duration. A session concludes when there has been no activity for 30 minutes. In the sessions table, you can find the column that provides the match type for a visitor record. This column is titled file_type and will indicate whether a visitor is a B2B, B2C, or PTE record.

• The Pages Table records details about the pages viewed by individuals during their session.

Entity Relationship Diagram

Referencing the provided Entity-Relationship Diagram (ERD) below, you can visualize how these tables can be joined together to provide a holistic view of user interactions on your website.