By Team Hypomnema · Data
Turn timestamped events into sessions and engagement summaries.
Use the guide alongside the working tool.
Open Event Session Analyzer →Explicit working sample
user,event,time
A,Visit,2026-10-01T09:00:00Z
A,Cart,2026-10-01T09:02:00Z
A,Purchase,2026-10-01T09:05:00Z
B,Visit,2026-10-01T10:00:00Z
B,Cart,2026-10-01T10:05:00Z
B,Visit,2026-10-02T10:00:00Z
C,Visit,2026-10-01T11:00:00ZTurn timestamped events into sessions and engagement summaries. Requires nonempty user IDs/events and valid timezone-explicit ISO timestamps. Input order breaks equal-time ties. Session boundaries use a strictly greater inactivity gap. Funnels count users, use the first eligible entry and ordered later events within the conversion window; repeated entry events do not restart the window. Journeys are observed paths, not causal attribution.
Prepare the input
Turn timestamped events into sessions and engagement summaries.
CSV, TSV and arrays of scalar JSON objects are supported. Identifiers stay text. Empty cells are missing by default; add special missing tokens only if their meaning is certain. Use the sample to inspect the exact workflow.
Review the method
Requires nonempty user IDs/events and valid timezone-explicit ISO timestamps. Input order breaks equal-time ties. Session boundaries use a strictly greater inactivity gap. Funnels count users, use the first eligible entry and ordered later events within the conversion window; repeated entry events do not restart the window. Journeys are observed paths, not causal attribution.
Keep the useful output
Review the summary and result records. Transformation tools retain separate change, rejected-record or diagnostics datasets where relevant. Choose the dataset before exporting; a report and a cleaned dataset serve different purposes.
CSV exports protect formula-like text. JSON keeps data portable without making an Excel workbook. Reports and editable backups may contain private source values; download only what you intend to share. No automatic account storage or server processing is used.
Ready to apply this workflow?
Try Event Session Analyzer →Explore a related workflow
- Event Funnel Analyzer: methods and data limits
Measure ordered conversion steps from raw user events.
- User Journey Explorer: methods and data limits
Discover observed paths, repeated actions and exits.
- SQL Data Explorer: methods and data limits
Query local records with joins, CTEs and window functions.
- Parquet Viewer & Converter: methods and data limits
Inspect local Parquet metadata and export selected records.
Keep your original files and review the result. Found unclear instructions? Contact Team Hypomnema.