Product Analytics for Data Analysts India 2026

Insight: the biggest drop is Product Page → Add to Cart (58% drop). This is where to investigate — pricing, product images, reviews, page load speed.

SELECT
  COUNT(DISTINCT user_id)                                           AS product_views,
  COUNT(DISTINCT CASE WHEN step >= 'add_to_cart'   THEN user_id END) AS add_to_cart,
  COUNT(DISTINCT CASE WHEN step >= 'begin_checkout' THEN user_id END) AS begin_checkout,
  COUNT(DISTINCT CASE WHEN step >= 'enter_address'  THEN user_id END) AS enter_address,
  COUNT(DISTINCT CASE WHEN step  = 'payment_done'   THEN user_id END) AS payment_complete
FROM events
WHERE event_date >= CURRENT_DATE - INTERVAL 30 DAY
  AND step IN ('product_view','add_to_cart','begin_checkout',
               'enter_address','payment_done');

WITH cohorts AS (
  -- Each user's first activity week
  SELECT
    user_id,
    DATE_TRUNC('week', MIN(event_date)) AS cohort_week
  FROM events
  GROUP BY user_id
),
activity AS (
  -- All activity with cohort assignment
  SELECT
    e.user_id,
    c.cohort_week,
    DATE_TRUNC('week', e.event_date) AS activity_week,
    DATEDIFF('week', c.cohort_week, DATE_TRUNC('week', e.event_date)) AS weeks_since_first
  FROM events e
  JOIN cohorts c USING (user_id)
)
SELECT
  cohort_week,
  weeks_since_first,
  COUNT(DISTINCT user_id)                                     AS active_users,
  ROUND(
    100.0 * COUNT(DISTINCT user_id) /
    FIRST_VALUE(COUNT(DISTINCT user_id)) OVER (
      PARTITION BY cohort_week ORDER BY weeks_since_first
    ), 1
  )                                                           AS retention_pct
FROM activity
GROUP BY cohort_week, weeks_since_first
ORDER BY cohort_week, weeks_since_first;

What is product analytics and how is it different from data analytics?

Product analytics is a specialisation of data analytics focused on understanding how users interact with a product — an app, a website, or a software platform. While a general data analyst might work on sales reports, MIS dashboards, or financial analysis, a product analyst focuses specifically on user behaviour: how users find the product, which features they use, where they drop off, and how to improve retention and growth. Product analytics roles are common at Indian startups, D2C brands, and tech companies in Noida, Gurugram, and Bengaluru.

What is a north star metric and how do Indian startups use it?

A north star metric (NSM) is the single metric that best captures the core value a product delivers to users. It aligns the entire company around one number. Examples from Indian companies: for a food delivery app — "orders delivered per week"; for an edtech platform — "course completion rate"; for a fintech app — "active borrowers per month"; for an e-commerce D2C brand — "repeat purchase rate in 90 days". The NSM should grow when the business is healthy. Revenue is usually NOT the best NSM because it is a lagging indicator — user value metrics are leading.

What is funnel analysis in product analytics?

Funnel analysis tracks how users progress through a defined sequence of steps — like Visit → Sign Up → Add to Cart → Purchase — and measures the drop-off at each step. For an Indian D2C brand, a typical checkout funnel might show: 10,000 users visit product page → 4,000 add to cart (60% drop) → 2,500 reach checkout (37.5% drop) → 1,800 complete payment (28% drop). Funnel analysis tells you where to focus optimisation effort. It is done in SQL (with window functions), Python, or tools like Mixpanel, Amplitude, or Google Analytics 4.

How do I do cohort retention analysis in SQL?

Cohort retention in SQL: group users by their first activity date (acquisition cohort), then calculate the percentage who return in subsequent weeks/months. The key steps are: (1) identify each user's first_date using MIN(event_date); (2) join this back to the events table; (3) calculate the difference in weeks/months between first_date and each subsequent event_date; (4) aggregate to get retention rate per cohort per period. The result is a retention matrix showing, for example, "Week 1 cohort retained 45% by Week 4". This is a standard advanced SQL question in data analyst interviews at Indian product companies.

What tools do product analysts use at Indian startups in 2026?

Product analysts at Indian startups and tech companies typically use: Mixpanel or Amplitude for event-based product analytics; Google Analytics 4 for web and app traffic; SQL (on BigQuery, Snowflake, or Redshift) for custom queries on raw event data; Python with Pandas for deeper analysis and cohort modelling; Looker or Metabase for internal dashboards; and A/B testing tools like Optimizely, Firebase A/B Testing, or custom frameworks. Entry-level product analyst roles in Noida and Gurugram often start with GA4 + SQL + Excel before moving to more advanced tools.

What is the salary of a product analyst in Noida and Delhi NCR in 2026?

Product analyst salaries in Delhi NCR in 2026: entry-level (0-1 year) at Indian startups — ₹5-8 LPA; mid-level (2-4 years) — ₹9-16 LPA; senior product analyst (4+ years) — ₹15-25 LPA. Companies in Gurugram (Swiggy, Zomato, Paytm operations, OYO, MakeMyTrip, consulting firms) pay 20-30% higher than Noida for equivalent roles. Product analytics skills command a 15-25% premium over general data analyst roles because of the specialised domain knowledge required.

How do I transition from data analyst to product analyst in India?

To move from data analyst to product analyst in India: build SQL skills for event data (funnel queries, cohort retention, session analysis); learn at least one product analytics tool (GA4 is free and widely used; Mixpanel has a free tier); do a portfolio project analysing a real app or website (use publicly available data or build a small app to generate event data); target startups and D2C companies in Noida and Gurugram where product analytics teams are growing fastest; and apply for "Data Analyst — Product" or "Growth Analyst" roles as stepping stones. The transition typically takes 6-12 months of deliberate skill-building.