Kanishk Budhia

· Admin · solinohome.com · ← all users

Active hours
1.82
real mouse/keyboard time
Active days
7
Sessions
144
Brands touched
1
Profiles touched
1
Pages touched
1

Daily

Day Sessions Active min Active hours
2026-06-17 34 26.2 0.44
2026-06-18 3 1.4 0.02
2026-06-19 1 0.2 0.00
2026-06-20 47 38.9 0.65
2026-06-22 30 19.0 0.32
2026-06-23 24 20.0 0.33
2026-06-24 5 3.6 0.06

Brands

BrandOwnerRoleSessionsActive min
Solino Home kanishk@solinohome.com Admin 106 81.4
SolinoHome kanishk@solinohome.com Admin 38 27.8

Pages

PageReportSessionsActive min
Amazon DSP Marketing Stream dsp 65 47.4
Amazon DSP Reports dsp 16 16.1
Amazon DSP Creative 591458607243364938 Update dsp 20 12.4
Billing Payments other 13 9.7
Amazon Audience Instance amc 9 7.0
Amazon DSP Snapshot snapshot 1 3.4
Logout other 3 2.5
Amazon DSP Audience dsp 1 2.4
DSP dsp 3 2.1
Addaccount other 5 2.0
AMC Amazon Audience Instance Info Amcmepe16c2 amc 3 1.1
Amazon User Management other 1 1.0
Edit Profile other 1 0.8
Thankyou AMC Register other 1 0.5
Amazon DSP Automated Rules Supplysource dsp 1 0.4
Amazon DSP Automated Rules Bid dsp 1 0.3

Actions

No actions recorded.

5 queries · scanned 6.20 MB · cost $0.000037 · 6.77s
Query 1 · 1 rows · 2.24 MB · $0.000013 · 1.35s 
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('kanishk@solinohome.com')
  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('kanishk@solinohome.com')
GROUP BY i.email
Query 2 · 7 rows · 979.3 KB · $0.000006 · 1.41s 
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('kanishk@solinohome.com')
    AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
  GROUP BY day
) s USING (day)
WHERE LOWER(i.email) = LOWER('kanishk@solinohome.com')
  AND i.day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
ORDER BY i.day
Query 3 · 2 rows · 1.57 MB · $0.000009 · 1.38s 
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('kanishk@solinohome.com')
  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.36 MB · $0.000008 · 1.38s 
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('kanishk@solinohome.com')
  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 · 0 rows · 70.7 KB · $0.000000 · 1.26s 
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('kanishk@solinohome.com')
  AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY action_category, action_type
ORDER BY actions DESC