Brands

SELECT brand_group,
       ANY_VALUE(profile_owner_email) AS profile_owner_email,
       ANY_VALUE(company_name)        AS company_name,
       SUM(distinct_users)            AS distinct_users,
       SUM(sessions)                  AS sessions,
       SUM(active_seconds)            AS active_seconds,
       SUM(page_views)                AS page_views,
       SUM(action_count)              AS action_count,
       SUM(entity_count)              AS entity_count,
       ROUND(SUM(active_seconds)/3600.0, 2) AS active_hours
FROM `amazoneast.customerio_data.vw_brand_day_overview`
WHERE day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY brand_group
ORDER BY active_hours DESC
LIMIT 5000