Data Structure
Data Model
Data Structure
Data Model
Data model for server-side and cookieless analytics dashboard for Hardal SDK
Reporting Events Table Schema
All events are reported to the reporting_events table. And table is partitioned by created_at date.
You can use the server_distinct_id to build your own user profiles and event tracking as cookieless analytics.
Table Fields
| Column Name | Data Type | Description |
|---|---|---|
| created_at | DateTime | Timestamp when the event was created |
| event_name | String | Name of the event (e.g., ‘page_view’, ‘click’) |
| server_distinct_id | String | Unique identifier for the user/session |
| page_url | String | Complete URL of the page |
| page_path | String | Path component of the URL |
| page_title | String | Page title from HTML |
| page_protocol | String | Protocol used (e.g., ‘https:‘) |
| page_hostname | String | Domain name of the website |
| page_hash | String | URL hash component |
| page_referrer | String | URL of the referring page |
| screen_resolution | String | Screen resolution (e.g., ‘1920x1080’) |
| screen_color_depth | UInt8 | Color depth of the screen in bits |
| screen_pixel_depth | UInt8 | Pixel depth of the screen |
| screen_viewport_size | String | Visible area size (e.g., ‘1879x928’) |
| screen_device_pixel_ratio | Float32 | Device pixel ratio for retina displays |
| browser_name | String | Browser name (e.g., ‘Chrome’) |
| browser_version | String | Browser version number |
| browser_language | String | Browser language setting |
| browser_platform | String | Operating system platform |
| browser_vendor | String | Browser vendor name |
| browser_user_agent | String | Complete user agent string |
| device_type | String | Device type (e.g., ‘desktop’, ‘mobile’) |
| timezone | String | User’s timezone |
| utm_source | String | Traffic source identifier |
| utm_medium | String | Marketing medium (e.g., ‘cpc’, ‘email’) |
| utm_campaign | String | Campaign name |
| utm_term | String | Paid search keywords |
| utm_content | String | Ad content identifier |
| event_source | String | Source of the event |
| session_id | UInt32 | Unique identifier for user session |
| session_duration_minutes | UInt32 | Duration of the session in minutes |
| event_count_per_session | UInt32 | Number of events in the current session |
| unique_page_views_per_session | UInt32 | Number of unique pages viewed in session |
| returning_visitor | UInt8 | Boolean flag indicating if user is returning (0/1) |
| engagement_score | Float32 | Calculated engagement score based on session metrics |