Sneha Agarwal

· Manager · krishyam.com · ← all users

Active hours
3.49
real mouse/keyboard time
Active days
17
Sessions
176
Brands touched
1
Profiles touched
1
Pages touched
2

Daily

Day Sessions Active min Active hours
2026-05-28 3 2.8 0.05
2026-05-29 43 28.1 0.47
2026-05-30 1 0.8 0.01
2026-06-02 10 11.1 0.19
2026-06-03 10 8.6 0.14
2026-06-05 8 5.5 0.09
2026-06-11 6 7.7 0.13
2026-06-13 5 3.2 0.05
2026-06-16 22 50.0 0.83
2026-06-17 22 25.3 0.42
2026-06-18 7 6.6 0.11
2026-06-19 11 18.2 0.30
2026-06-20 8 8.9 0.15
2026-06-22 1 1.1 0.02
2026-06-23 4 5.1 0.09
2026-06-24 14 25.1 0.42
2026-06-25 1 1.0 0.02

Brands

BrandOwnerRoleSessionsActive min
SCORPIOO casneha@krishyam.com Manager 157 194.6
KRI SHYAM casneha@krishyam.com Manager 19 14.6

Pages

PageReportSessionsActive min
Amazon Targeting 360 targeting_360 98 126.0
Amazon Master Overview master_overview 56 62.6
Flipkart Targeting 360 targeting_360 14 12.2
Amazon Text Categorization other 1 4.0
Flipkart Master Overview master_overview 5 2.4
Amazon Search Query Performance targeting_360 2 2.0

Actions

CategoryActionActionsEntities
keyword keyword_added 2 2
5 queries · scanned 23.27 MB · cost $0.000139 · 6.85s
Query 1 · 1 rows · 8.41 MB · $0.000050 · 1.47s 
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-05-26' AND DATE '2026-06-25'
    AND LOWER(email) = LOWER('casneha@krishyam.com')
  GROUP BY day, email
) s USING (day, email)
WHERE i.day BETWEEN DATE '2026-05-26' AND DATE '2026-06-25'
  AND LOWER(i.email) = LOWER('casneha@krishyam.com')
GROUP BY i.email
Query 2 · 17 rows · 3.62 MB · $0.000022 · 1.34s 
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('casneha@krishyam.com')
    AND day BETWEEN DATE '2026-05-26' AND DATE '2026-06-25'
  GROUP BY day
) s USING (day)
WHERE LOWER(i.email) = LOWER('casneha@krishyam.com')
  AND i.day BETWEEN DATE '2026-05-26' AND DATE '2026-06-25'
ORDER BY i.day
Query 3 · 2 rows · 5.94 MB · $0.000035 · 1.42s 
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('casneha@krishyam.com')
  AND day BETWEEN DATE '2026-05-26' AND DATE '2026-06-25'
GROUP BY brand_group
ORDER BY active_min DESC
Query 4 · 6 rows · 5.08 MB · $0.000030 · 1.36s 
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('casneha@krishyam.com')
  AND day BETWEEN DATE '2026-05-26' AND DATE '2026-06-25'
GROUP BY report_page
ORDER BY active_min DESC
LIMIT 5000
Query 5 · 1 rows · 225.4 KB · $0.000001 · 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('casneha@krishyam.com')
  AND day BETWEEN DATE '2026-05-26' AND DATE '2026-06-25'
GROUP BY action_category, action_type
ORDER BY actions DESC