Trace ordered analytics events and inspect experiment context without touching production state.
How to read this
This baseline trace reconstructs the session. Device-owned install and session rows can leave product fields empty, so they are filtered before event order is assessed.
Context ClickHouse · OLAP · columnar
SELECT
created_at,
activity_kind,
event_name,
JSONExtractString(base_parameters, 'ab_group') AS ab_group
FROM analytics.realtime_events
WHERE user_id = {user_id:String}
AND toDate(created_at) = today()
AND activity_kind NOT IN ('install', 'session')
ORDER BY created_at DESC;
Query resultFictional data
These anonymized example values come from the source article and do not represent company data.
Signal ordered event trailUse reproduce & verifyGuard synthetic identifiers
View repository
