Rahul

· Manager · yourseller.in · ← all users

Active hours
3.04
real mouse/keyboard time
Active days
6
Sessions
320
Brands touched
3
Profiles touched
3
Pages touched
12

Daily

Day Sessions Active min Active hours
2026-06-17 35 26.8 0.45
2026-06-18 18 11.8 0.20
2026-06-19 44 24.2 0.40
2026-06-22 114 52.9 0.88
2026-06-23 92 57.9 0.96
2026-06-24 17 9.1 0.15

Brands

BrandOwnerRoleSessionsActive min
Modern Sprout rahul@yourseller.in Manager 241 129.2
SELTERM rahul@yourseller.in Manager 78 53.2
TinyTyke rahul@yourseller.in Manager 1 0.2

Pages

PageReportSessionsActive min
DSP dsp 105 69.0
Amazon DSP Marketing Stream dsp 33 18.8
Amazon DSP Adgroup dsp 34 15.2
Amazon DSP Adgroup Create dsp 26 14.0
Amazon DSP Audience dsp 19 13.0
Create Amazon Audience amc 21 12.6
Amazon Audience Report amc 22 11.6
Amazon DSP Dayparting Scheduler dayparting 16 8.8
Amazon DSP Audience Create dsp 10 5.3
Amazon DSP Dayparting Performance dayparting 9 5.0
Amazon DSP Creative Create dsp 10 3.9
Amazon DSP Reports dsp 5 2.2
Amazon DSP Adgroup 590635229171867733 Update dsp 4 1.4
Amazon DSP Adgroup 594061611263205285 Update dsp 2 1.0
Amazon Audience Instance amc 3 0.7
Amazon DSP Creative dsp 1 0.4

Actions

CategoryActionActionsEntities
audience audience_created 5 5
5 queries · scanned 5.48 MB · cost $0.000033 · 6.58s
Query 1 · 1 rows · 1.96 MB · $0.000012 · 1.31s 
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('rahul@yourseller.in')
  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('rahul@yourseller.in')
GROUP BY i.email
Query 2 · 6 rows · 852.8 KB · $0.000005 · 1.37s 
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('rahul@yourseller.in')
    AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
  GROUP BY day
) s USING (day)
WHERE LOWER(i.email) = LOWER('rahul@yourseller.in')
  AND i.day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
ORDER BY i.day
Query 3 · 3 rows · 1.40 MB · $0.000008 · 1.36s 
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('rahul@yourseller.in')
  AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY brand_group
ORDER BY active_min DESC
Query 4 · 16 rows · 1.22 MB · $0.000007 · 1.30s 
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('rahul@yourseller.in')
  AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY report_page
ORDER BY active_min DESC
LIMIT 5000
Query 5 · 1 rows · 70.1 KB · $0.000000 · 1.24s 
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('rahul@yourseller.in')
  AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY action_category, action_type
ORDER BY actions DESC