Overview

2026-06-17 → 2026-06-24 · pulled from fact_sessions_daily

Distinct users
553
in date range
Distinct brands
607
Active hours
622.1
total_active_time / 3600
Wall-clock hours
44,939.5
session_duration / 3600
Sessions
43,695
Days covered
8

Daily trend

DayDAUSessionsActive hours
2026-06-17 301 6,987 100.1
2026-06-18 320 7,188 104.1
2026-06-19 274 6,892 100.7
2026-06-20 158 2,788 34.3
2026-06-21 81 1,423 14.9
2026-06-22 295 7,149 106.1
2026-06-23 326 6,265 90.4
2026-06-24 289 5,003 71.5
2 queries · scanned 1.73 MB · cost $0.000010 · 2.91s
Query 1 · 1 rows · 1.04 MB · $0.000006 · 1.45s 
SELECT
  COUNT(DISTINCT email)               AS distinct_users,
  COUNT(DISTINCT brand_group)         AS distinct_brands,
  COUNT(DISTINCT day)                 AS days_covered,
  SUM(sessions)                       AS sessions,
  SUM(active_seconds)                 AS active_seconds,
  ROUND(SUM(active_seconds)/3600.0, 1) AS active_hours,
  ROUND(SUM(duration_seconds)/3600.0, 1) AS duration_hours
FROM `amazoneast.customerio_data.fact_sessions_daily`
WHERE day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
Query 2 · 8 rows · 706.1 KB · $0.000004 · 1.46s 
SELECT day,
       COUNT(DISTINCT email)               AS dau,
       ROUND(SUM(active_seconds)/3600.0, 1) AS active_hours,
       SUM(sessions)                       AS sessions
FROM `amazoneast.customerio_data.fact_sessions_daily`
WHERE day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY day
ORDER BY day