demo@hectorai.live
Profile owner · ← all owners
Brands owned
15
Distinct users
1
Active days
30
Sessions
2,676
Active hours
92.29
Brands
| Brand | Users | Sessions | Active hours |
|---|---|---|---|
| Campus Activewear Limited | 1 | 1,830 | 66.67 |
| Tampa | 1 | 327 | 13.08 |
| Homespun Global | 1 | 223 | 5.93 |
| Beauty by Earth | 1 | 157 | 4.76 |
| COOPER`s - seller | 1 | 51 | 0.94 |
| TAMPA ACTIVEWEAR LIMITED_self-serve_brand | 1 | 36 | 0.41 |
| haus & kinder | 1 | 41 | 0.32 |
| Dot & Key | 1 | 4 | 0.05 |
| Altec Direct | 1 | 1 | 0.02 |
| TRENDnet | 1 | 1 | 0.02 |
| Pure Nutrition | 1 | 1 | 0.02 |
| Wonder Care | 1 | 1 | 0.02 |
| Gulika Apparel | 1 | 1 | 0.02 |
| Regalia Knives | 1 | 1 | 0.01 |
| Maggy London Women's Dresses | 1 | 1 | 0.01 |
2 queries · scanned 10.78 MB · cost $0.000064 · 3.12s
SELECT
profile_owner_email,
COUNT(DISTINCT brand_group) AS brands_owned,
COUNT(DISTINCT email) AS distinct_users,
SUM(sessions) AS sessions,
ROUND(SUM(active_seconds)/3600.0, 2) AS active_hours,
COUNT(DISTINCT day) AS active_days
FROM `amazoneast.customerio_data.fact_sessions_daily`
WHERE LOWER(profile_owner_email) = LOWER('demo@hectorai.live')
AND day BETWEEN DATE '2026-05-26' AND DATE '2026-06-25'
GROUP BY profile_owner_email
SELECT brand_group,
COUNT(DISTINCT email) AS distinct_users,
SUM(sessions) AS sessions,
ROUND(SUM(active_seconds)/3600.0, 2) AS active_hours
FROM `amazoneast.customerio_data.fact_sessions_daily`
WHERE LOWER(profile_owner_email) = LOWER('demo@hectorai.live')
AND day BETWEEN DATE '2026-05-26' AND DATE '2026-06-25'
GROUP BY brand_group
ORDER BY active_hours DESC