Clickstream Event Parameters - Rockerbox Data Foundation Docs

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

💡 Note: Leverage partition keys when querying the table to improve query efficiency.

Logical Primary Key

While data warehouses do not enforce primary key constraints, the combination of event_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

​Description

​Table Creation

​Partition Keys

​Logical Primary Key

​Field Reference

​Event categorization