Overview

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

Distinct users
552
in date range
Distinct brands
606
Active hours
615.5
total_active_time / 3600
Wall-clock hours
44,260.2
session_duration / 3600
Sessions
43,286
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,888 100.7
2026-06-20 158 2,782 34.2
2026-06-21 81 1,421 14.9
2026-06-22 295 7,083 105.3
2026-06-23 326 6,265 90.4
2026-06-24 282 4,672 65.9
2 queries · scanned 1.71 MB · cost $0.000010 · 2.66s
Query 1 · 1 rows · 1.03 MB · $0.000006 · 1.29s 
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 · 699.6 KB · $0.000004 · 1.37s 
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