Skip to main content

Sessions

Design & Features​

  • One row per session
  • Incremental build (delete + insert)
  • Partitioned by session_date
  • Clustered by session_id
  • User Stitching
  • Aggregated metrics: events, page view, purchase revenue, transactions, select items etc...
  • Traffic source logic (including last non-direct attribution)
  • Session properties like: Session duration, is_direct_session, is_engaged_session, is_debug_session, is_cross_domain
  • Unique session_id
  • Click IDs from event_params or page_location, such as gbraid, wbraid, gclid, dclid, srsltid, and more.
  • Source / Medium / Campaign for at least three standard attributions:
    • Last click
    • Last non-direct click (with a particular lookback window, default 90 days)
    • First click
  • For each attribution, Default Channel Groups — following the same rules as in Google Analytics 4.

Config options​

  • GA4_START_DATE – baseline start date if the table is empty.

  • USER_STITCHING - See User Stitching

  • LAST_NON_DIRECT_LOOKBACK_DAYS