Profile owners

SELECT profile_owner_email,
       SUM(brands_touched)  AS brand_days,
       SUM(users_working)   AS user_days,
       SUM(sessions)        AS sessions,
       ROUND(SUM(active_hours), 2) AS active_hours,
       SUM(action_count)    AS action_count
FROM `amazoneast.customerio_data.vw_owner_day_overview`
WHERE day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY profile_owner_email
ORDER BY active_hours DESC
LIMIT 5000