Episoft

SELECT brand_group,
       ANY_VALUE(profile_owner_email) AS profile_owner_email,
       ANY_VALUE(company_name)        AS company_name,
       SUM(distinct_users)            AS user_day_rows,
       COUNT(DISTINCT day)            AS active_days,
       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,
       SUM(bid_actions)               AS bid_actions,
       SUM(budget_actions)            AS budget_actions,
       SUM(status_actions)            AS status_actions,
       SUM(rule_actions)              AS rule_actions,
       SUM(scheduler_actions)         AS scheduler_actions
FROM `amazoneast.customerio_data.vw_brand_day_overview`
WHERE LOWER(brand_group) = LOWER('Episoft')
  AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY brand_group

SELECT email,
       ANY_VALUE(full_name) AS full_name,
       ANY_VALUE(role)      AS role,
       SUM(sessions)        AS sessions,
       ROUND(SUM(active_seconds)/60.0, 1) AS active_min
FROM `amazoneast.customerio_data.fact_sessions_daily`
WHERE LOWER(brand_group) = LOWER('Episoft')
  AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY email
ORDER BY active_min DESC
LIMIT 5000

SELECT day,
       distinct_users,
       sessions,
       ROUND(active_hours, 2) AS active_hours,
       page_views, action_count, entity_count
FROM `amazoneast.customerio_data.vw_brand_day_overview`
WHERE LOWER(brand_group) = LOWER('Episoft')
  AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
ORDER BY day

SELECT *
FROM `amazoneast.customerio_data.vw_brand_state`
WHERE LOWER(brand_group) = LOWER('Episoft')
LIMIT 5