Aakash Gulati

· Admin · xergy.in · ← all users

Active hours
1.37
real mouse/keyboard time
Active days
6
Sessions
81
Brands touched
2
Profiles touched
2
Pages touched
16

Daily

Day Sessions Active min Active hours
2026-06-17 37 49.9 0.83
2026-06-18 3 1.5 0.03
2026-06-19 24 14.2 0.24
2026-06-20 2 2.6 0.04
2026-06-21 2 1.7 0.03
2026-06-24 13 12.2 0.20

Brands

BrandOwnerRoleSessionsActive min
SRGGINC. aakash@xergy.in Admin 77 80.1
xergy - seller aakash@xergy.in Admin 4 2.0

Pages

PageReportSessionsActive min
Amazon Automated Search Term Negation Rules rule_automation 11 11.2
Amazon Campaign Drafts Manual Keyword Create other 5 8.9
Amazon Automated Bid Rules rule_automation 6 8.7
Amazon Master Overview master_overview 7 6.8
Amazon Dayparting Performance dayparting 8 6.5
Amazon Automated Status Rules rule_automation 4 5.4
Amazon Dayparting Scheduler dayparting 8 4.8
Amazon Ranking Dashboard ranking_360 1 4.7
Amazon Automated Search Term Harvesting Rules rule_automation 2 3.8
Amazon Targeting 360 targeting_360 8 3.5
Amazon Dayparting Schedule Log Budget dayparting 1 3.2
Amazon Automated Bid Rule Details rule_automation 3 3.1
Amazon Marketing Stream targeting_360 2 2.6
Amazon Automated Budget Rules rule_automation 3 2.4
Amazon Automated Searchterm-negation Rule Details rule_automation 1 1.4
Amazon Smart Campaigns List other 1 1.1
Flipkart Targeting 360 targeting_360 2 1.0
Flipkart Snapshot snapshot 2 0.9
Amazon Automated Placement Rules rule_automation 1 0.8
Amazon Search Query Performance targeting_360 2 0.6
Amazon CPC Jobs other 1 0.3
Logout other 1 0.2
Amazon Automated Budget Rule Logs rule_automation 1 0.2

Actions

CategoryActionActionsEntities
rule rule_based_updated 7 7
scheduler dayparting_scheduler_updated 4 4
keyword keyword_added 4 4
scheduler dayparting_scheduler_status_switched 2 2
scheduler dayparting_scheduler_created 1 1
5 queries · scanned 6.05 MB · cost $0.000036 · 6.35s
Query 1 · 1 rows · 2.18 MB · $0.000013 · 1.23s 
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('aakash@xergy.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('aakash@xergy.in')
GROUP BY i.email
Query 2 · 6 rows · 953.8 KB · $0.000006 · 1.35s 
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('aakash@xergy.in')
    AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
  GROUP BY day
) s USING (day)
WHERE LOWER(i.email) = LOWER('aakash@xergy.in')
  AND i.day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
ORDER BY i.day
Query 3 · 2 rows · 1.54 MB · $0.000009 · 1.34s 
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('aakash@xergy.in')
  AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY brand_group
ORDER BY active_min DESC
Query 4 · 23 rows · 1.33 MB · $0.000008 · 1.20s 
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('aakash@xergy.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 · 5 rows · 70.7 KB · $0.000000 · 1.23s 
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('aakash@xergy.in')
  AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY action_category, action_type
ORDER BY actions DESC