Что такое продуктовая аналитика

Карьерник — квиз-тренажёр в Telegram с 1500+ вопросами для собесов аналитика. SQL, Python, A/B, метрики. Бесплатно.

Зачем это знать

Хотите продуктовым аналитиком? Или хотите понять, чем differs от BI / data analyst? Эта статья — comprehensive overview.

Плюс — полезно прочитать перед собесами в tech-focused companies.

Что такое product analytics

Использование данных для improve product. Focus на:

  • User behavior
  • Feature success
  • Funnel / activation / retention
  • A/B experimentation
  • Revenue impact

Differs от:

  • BI: reporting, dashboards
  • Data science: ML models
  • Data engineering: pipelines

Product analyst — тесно работает с PM, designers, engineers.

Responsibilities

Measure product

  • Define metrics (north star, inputs)
  • Build dashboards
  • Monitor health

Analyze

  • Feature performance
  • User segments
  • Retention, churn
  • Conversion funnels

Experiment

  • Design A/B tests
  • Analyze results
  • Make ship decisions

Research

  • User journey analysis
  • Cohort insights
  • Unit economics

Communicate

  • Reports
  • Presentations
  • Recommendations

Day-in-life

Morning

  • Check metrics dashboards
  • Slack: Q от PM

Mid-day

  • Deep dive analysis (SQL / Python)
  • Meetings с product team

Afternoon

  • A/B test results review
  • Write-up analysis

End of day

  • Plan tomorrow
  • Async updates

Typical split: 50% individual analysis, 30% communication, 20% meetings.

Skills

Technical

  • SQL: strong
  • Python / pandas: medium to strong
  • Statistics: moderate (A/B, intervals)
  • BI tool: Amplitude / Tableau / Metabase

Soft

  • Product thinking
  • Communication
  • Curiosity
  • Collaboration

Frameworks

AARRR (Pirate metrics)

Acquisition → Activation → Retention → Referral → Revenue.

Funnel thinking.

HEART (Google)

Happiness, Engagement, Adoption, Retention, Task success.

UX measurement.

JTBD (Jobs To Be Done)

Users hire products для jobs.

User-centric framing.

Growth loops

Self-sustaining growth mechanisms.

North Star

One metric reflecting value.

Metrics

See шпаргалка метрики.

Key categories:

  • Acquisition
  • Activation
  • Engagement
  • Retention
  • Monetization

A/B testing

Core competency.

  • Design experiments
  • Sample size
  • Analyze results
  • Ship decisions

Beyond just running — understand limitations, pitfalls, novelty effects.

User research

Quantitative + qualitative mix:

  • Analytics (behavior)
  • User interviews
  • Surveys
  • Session recordings

Triangulate для full picture.

Typical проекты

Feature launch

Measure adoption, impact, side effects.

Retention investigation

Why users leave? Segments, causes, interventions.

Activation optimization

How fast users reach aha moment?

Pricing analysis

Elasticity, packaging, willingness to pay.

Growth experiments

Viral loops, referrals, growth mechanics.

Tools

Product analytics

  • Amplitude (flagship)
  • Mixpanel
  • PostHog (open-source)

BI

  • Tableau
  • Metabase
  • Looker

SQL

  • Warehouse: Snowflake, BigQuery, Redshift, ClickHouse
  • IDE: DataGrip, DBeaver

Python

  • Jupyter
  • VS Code

Experimentation

  • Optimizely
  • GrowthBook (open-source)
  • Internal platforms (big tech)

Стек Russian companies

Yandex

ClickHouse, DataLens, internal

Tinkoff

PostgreSQL, ClickHouse, custom

Ozon

ClickHouse, Vertica, Tableau

Avito

ClickHouse, DataLens

Startups

Amplitude / PostHog + Metabase often

Учиться

Books

  • «Hooked» — Nir Eyal
  • «Hacking Growth» — Sean Ellis
  • «Lean Analytics» — Croll & Yoskovitz
  • «Trustworthy Online Controlled Experiments»

Blogs

  • Reforge
  • Lenny's Newsletter
  • First Round Review
  • Amplitude blog

Courses

  • Reforge (paid)
  • Product School
  • Data analytics free courses

Practice

  • Kaggle datasets
  • Public APIs
  • Personal product side-project

Career path

Junior (0-2 years)

  • Learn basics
  • Support PM requests
  • Run simple analyses

Middle (2-5 years)

  • Own metric areas
  • Run A/B independently
  • Mentor junior

Senior (5+ years)

  • Strategic projects
  • Cross-functional leadership
  • Influence roadmap

Lead / Head

  • Team management
  • Strategy
  • Budget

Product analyst vs data analyst

Product analyst

  • Specific product focus
  • Work closely с PM
  • Experimentation heavy
  • User behavior

Data analyst

  • Broader scope
  • Business metrics
  • Reporting
  • Less experimentation

Overlap, но difference in focus.

Product analyst vs data scientist

Product analyst

  • Analyze, measure, recommend
  • Less ML usually
  • Business impact

Data scientist

  • Build ML models
  • Algorithm research
  • Technical depth

Some overlap, different primary skills.

Common questions

Product sense

«Spotify wants ship autoplay. Good idea?»

Consider:

  • User behavior (how much listening)
  • Engagement impact
  • Retention impact
  • Ad revenue (autoplay = more ads?)
  • Discoverability (new music exposure)
  • Control (feature toggle?)

Structured thinking.

Metric design

«What metric для X product?»

Walk through:

  • Business goal
  • Value к user
  • Leading к revenue?
  • Actionable?
  • Measurable?

Investigation

«Metric changed unexpectedly».

RCA: verify → scope → segment → correlate → hypothesize → validate.

На собесе

«What's product analytics?» Data-driven approach к product decisions.

«Difference от BI?» PA — product focus, experimentation, user behavior. BI — broad business reporting.

«Favorite framework?» Pick one, explain с example.

«Experience?» Specific projects, tools, impact.

Связанные темы

FAQ

Product analyst зарплата?

Often slightly above general analyst. В Russia — 200-350k middle.

Ship own product?

No. Recommendations PM. Shared decision.

ML нужен?

Typically no. Plus, но не core.


Тренируйте product — откройте тренажёр с 1500+ вопросами для собесов.