Mixpanel для аналитика
Карьерник — квиз-тренажёр в Telegram с 1500+ вопросами для собесов аналитика. SQL, Python, A/B, метрики. Бесплатно.
Зачем это знать
Mixpanel — исторически один из pioneers product analytics. Startups часто начинают с Mixpanel. На собесах в startups / scale-ups Mixpanel-skill упоминают. Plus — учит thinking in events (fundamental skill).
Что такое Mixpanel
Product analytics platform, похожа на Amplitude:
- Event tracking
- Funnel / cohort / retention analyses
- Dashboards
- A/B tests
Исторически первый populariser «event-based product analytics».
Основные компоненты
Events
Как в Amplitude: event_name + properties + user_id.
mixpanel.track('subscription_purchased', {
plan: 'premium',
amount: 299,
currency: 'RUB'
});People
User profile properties:
- Signup date
- Plan
- Last active
- Demographics
Cohorts
Saved user groups для re-use в analyses.
Анализы
Insights
Query events с filters. Similar to SQL, но GUI.
Funnels
Conversion steps через events.
Retention
N-day retention, addiction curves.
Flows
User journey paths.
Mixpanel vs Amplitude
| Mixpanel | Amplitude | |
|---|---|---|
| Starter price | Cheaper | Expensive |
| UI | Simpler | More features |
| Retention | Good | Better visualization |
| Growth features | Basic | Advanced |
| Enterprise | Growing | Established |
На small startups — часто Mixpanel. Scale up → Amplitude.
Query engine
Mixpanel JQL (JavaScript Query Language) — для advanced analytics.
function main() {
return Events({
from_date: '2026-04-01',
to_date: '2026-04-23',
event_selectors: [{event: 'Purchase'}]
})
.groupBy(['properties.country'], mixpanel.reducer.count());
}Implementation
SDK
- JavaScript (web)
- iOS, Android
- Python, Node, Ruby backend
Server-side events
Для sensitive events (purchase) — backend tracking более reliable.
Tracking plan
Same discipline как с Amplitude:
- Event naming convention
- Property definitions
- Review before implementation
Use cases
Activation analysis
Funnel signup → first_purchase. Conversion rates по steps.
Retention
Cohort retention per onboarding variant.
A/B analysis
Compare funnel conversion по variants.
Feature adoption
Event segmentation: % users who did X.
Плюсы
- Исторически cheaper
- Быстрая setup
- Good for startups
Минусы
- Fewer advanced features vs Amplitude
- UX less polished (subjective)
- Pricing changes last years
- Data exports ограничены
Когда использовать
- Early-stage startup
- Simple event-based product analytics
- Budget-conscious team
Scale-up → обычно migration на Amplitude или warehouse-based.
На собесе
«Mixpanel опыт?» Setup events, funnels, cohorts — конкретные use cases.
«Mixpanel vs Amplitude?» Mixpanel cheaper simple, Amplitude feature-rich.
«Реализация tracking?» Tracking plan, SDK integration, server-side для sensitive.
Связанные темы
FAQ
Free tier?
Есть (ограниченный). Starter plan для small teams.
Mobile focused?
Web и mobile both supported.
Data export?
CSV + API. Для warehouse integration.
Тренируйте продуктовую аналитику — откройте тренажёр с 1500+ вопросами для собесов.