Tim Huelsmann
t.huelsmann@primeup.de
· Manager
· primeup.de
· ← all users
Active hours
0.09
real mouse/keyboard time
Active days
2
Sessions
10
Brands touched
3
Profiles touched
3
Pages touched
2
Daily
| Day | Sessions | Active min | Active hours |
|---|---|---|---|
| 2026-06-18 | 9 | 5.4 | 0.09 |
| 2026-06-22 | 1 | 0.3 | 0.00 |
Brands
| Brand | Owner | Role | Sessions | Active min |
|---|---|---|---|---|
| GSW Gäns Stahlwaren GmbH (retail) | t.huelsmann@primeup.de | Manager | 5 | 3.3 |
| gestalten | t.huelsmann@primeup.de | Manager | 3 | 1.7 |
| Die Gestalten Verlag GmbH & Co. KG - Retail | t.huelsmann@primeup.de | Manager | 2 | 0.6 |
Pages
| Page | Report | Sessions | Active min |
|---|---|---|---|
| Amazon Automated Bid Rules | rule_automation | 8 | 5.1 |
| Amazon Master Overview | master_overview | 1 | 0.3 |
| Amazon Automated Bid Rule Details | rule_automation | 1 | 0.2 |
Actions
No actions recorded.
5 queries · scanned 6.20 MB · cost $0.000037 · 7.08s
SELECT
i.email,
ANY_VALUE(i.full_name) AS full_name,
ANY_VALUE(i.email_domain) AS email_domain,
ANY_VALUE(s.role) AS role,
COUNT(DISTINCT i.day) AS active_days,
ANY_VALUE(s.brands_touched) AS brands_touched,
ANY_VALUE(s.profiles_touched) AS profiles_touched,
ANY_VALUE(s.pages_touched) AS pages_touched,
SUM(s.sessions) AS sessions,
SUM(i.sum_active_seconds) AS active_seconds,
ROUND(SUM(i.sum_active_seconds)/3600.0, 2) AS active_hours
FROM `amazoneast.customerio_data.fact_session_intervals_daily` i
LEFT JOIN (
SELECT day, email, SUM(sessions) AS sessions, ANY_VALUE(role) AS role,
COUNT(DISTINCT brand_group) AS brands_touched,
COUNT(DISTINCT profile_id) AS profiles_touched,
COUNT(DISTINCT report_page) AS pages_touched
FROM `amazoneast.customerio_data.fact_sessions_daily`
WHERE day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
AND LOWER(email) = LOWER('t.huelsmann@primeup.de')
GROUP BY day, email
) s USING (day, email)
WHERE i.day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
AND LOWER(i.email) = LOWER('t.huelsmann@primeup.de')
GROUP BY i.email
SELECT i.day,
s.sessions,
ROUND(i.sum_active_seconds/60.0, 1) AS active_min,
ROUND(i.sum_active_seconds/3600.0, 2) AS active_hours
FROM `amazoneast.customerio_data.fact_session_intervals_daily` i
LEFT JOIN (
SELECT day, SUM(sessions) AS sessions
FROM `amazoneast.customerio_data.fact_sessions_daily`
WHERE LOWER(email) = LOWER('t.huelsmann@primeup.de')
AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY day
) s USING (day)
WHERE LOWER(i.email) = LOWER('t.huelsmann@primeup.de')
AND i.day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
ORDER BY i.day
SELECT brand_group,
ANY_VALUE(profile_owner_email) AS profile_owner_email,
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(email) = LOWER('t.huelsmann@primeup.de')
AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY brand_group
ORDER BY active_min DESC
SELECT report_page,
ANY_VALUE(report) AS report,
SUM(sessions) AS sessions,
ROUND(SUM(active_seconds)/60.0, 1) AS active_min
FROM `amazoneast.customerio_data.fact_sessions_daily`
WHERE LOWER(email) = LOWER('t.huelsmann@primeup.de')
AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY report_page
ORDER BY active_min DESC
LIMIT 5000
SELECT action_category,
action_type,
SUM(action_count) AS actions,
SUM(entity_count) AS entities
FROM `amazoneast.customerio_data.fact_actions_daily`
WHERE LOWER(email) = LOWER('t.huelsmann@primeup.de')
AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY action_category, action_type
ORDER BY actions DESC