Description
- Auxiliary table containing additional parameters captured on each event tracked by the Rockerbox on-site pixel.
- Includes ecommerce context (e.g., product, revenue, order_id) and marketing parameters parsed from landing page URLs (e.g., gclid, UTM values), passed through exactly as received from the pixel without additional processing.
Table Creation
- This table is automatically created upon activation of the clickstream feature.
- Once the Clickstream dataset has been enabled by Rockerbox, the table will appear in your data warehouse as
ON_SITE_EVENTS_ALL_PAGES.
Partition Keys
date
Logical Primary Key
While data warehouses do not enforce primary key constraints, the combination ofevent_id and query_param_name functions as the logical primary key for the table.
Field Reference
| # | Name | Description | Type |
|---|---|---|---|
| 1 | event_id | A unique identifier for each action. Each event_id from the Clickstream dataset will have multiple corresponding records in the Event Parameters table. | str |
| 2 | timestamp_action | Timestamp of when the action occurred | timestamp |
| 3 | action | Name of the raw pixel event. This includes events for all conversion segments configured in Rockerbox + a page view. | str |
| 4 | category | Categorization of query_param_name based on common variables required for Rockerbox implementation. Possible Values: conversion, marketing, tracking | str |
| 5 | query_param_name | The name of the parameter passed on the Rockerbox pixel (ex product, utm_medium). Each event_id will have multiple rows with query_param_names and values | str |
| 6 | value | The specific value passed on the query_param_name. For example, the query_param_name = order_id will have values = each specific order_id. | str |
| 7 | advertiser | Rockerbox Account ID | str |
| 8 | date | Date when the action occurred | date |
| 9 | identifier | Advertiser-specific identifier | str |
| 10 | report | The name of the report | str |
| 11 | rb_sync_id | Identifier used by Rockerbox to sync dataset to your warehouse | int |
| 12 | updated_at | Time the cache record was updated most recently | timestamp |
Event categorization
Rockerbox categorizes query parameters based on common variables required for your Rockerbox implementation. This looks for an exact match of the query_param_name passed on your event to the below. Further customization of categories is not supported.- conversion: action, email, external_id, hash_email, hash_phone_number, order_id, phone_number, referrer, revenue, script_version, sessionid, source, uid, url
- marketing: contains ‘utm’, contains ‘clid’, query string parameter used for Rockerbox’s standard integrations
- tracking: all other