Analytics
494 bites tagged Analytics — interview questions with model answers, and 60-second explainers.
Build vs. Buy: Third-Party Analytics SDK or In-House Pipeline?
This tests your grasp of the time vs. control trade-off. A great answer weighs the speed of buying against the total control of building, focusing on the hidden, long-term maintenance costs of an in-house solution.
Sudden metric drop, no recent deployments. What's the cause?
This tests your ability to debug data discrepancies beyond code, focusing on the analytics pipeline. First, distinguish data loss from misattribution. Then, check processing delays and hidden data sources. A red flag is not segmenting data first.
How do you track page views in a Single Page Application?
Tests your grasp of SPA navigation vs. traditional page loads. A great answer explains how SPA routers use the History API (`pushState`) and how to listen for changes to send analytics events. A red flag is suggesting polling the URL.
How would you measure the ROI of a data analytics platform?
This tests your ability to connect platform metrics to business value. A good answer defines KPIs for adoption, performance, and cost, then links them to business impact.
Design a KPI Strategy for a Two-Sided Marketplace
Tests your ability to balance a complex ecosystem. A great answer defines KPIs for liquidity (search-to-fill), transaction economics (take rate), and true health (net revenue over GMV).
Explain the North Star Metric and propose one for a product
Tests your ability to connect user value to business outcomes. A great answer defines the NSM, proposes one for a product (e.g., Spotify), and justifies how it links customer value to business success. A red flag is picking a vanity metric like DAU or revenue.
How would you diagnose why a new feature isn't being adopted?
This tests your ability to diagnose a flat KPI. A great answer outlines a funnel (awareness, activation, usage) and combines quantitative data with qualitative insights from session replays. A red flag is proposing solutions without a diagnostic plan.
Pitfalls of 'Conversion Rate' as a North Star Metric
Tests your ability to see beyond a single metric. A good answer identifies how optimizing conversion can hurt revenue or UX, and proposes guardrails like Average Order Value, support tickets, and return rates.
Translate 'increase engagement' into a technical measurement plan
This tests your ability to translate a vague business goal into a structured, measurable technical plan. Clarify the goal with the PM, define a primary metric and supporting metrics, then create an instrumentation spec.
Design a Privacy-Compliant Analytics Architecture
This tests your ability to balance data utility with strict privacy controls. A great answer outlines a central governance layer, dynamic masking, and purpose-based access tied to auditable logs.
A key metric dropped 15%. How do you investigate?
This tests systematic debugging of business metrics. A great answer first validates the data itself, then checks for recent changes (deploys, features), and finally segments the drop to isolate the cause. A red flag is immediately assuming a product bug.
Visualize two continuous and one categorical variable?
Tests your ability to map data to visual encodings. A great answer starts with a scatter plot, then adds the categorical data using color, shape, or faceting, explaining the tradeoffs. A red flag is suggesting a 3D chart, which is difficult to read.
How would you visualize three years of monthly revenue?
This tests your grasp of time-series visualization and data integrity. A strong answer picks a line chart, insists on a zero-based Y-axis and clear labels, and adds context like seasonality.
How do you shift analytics from growth to profitability?
This tests your ability to translate business strategy into technical changes. A great answer connects profitability drivers to specific updates in event taxonomy, data models, and dashboards. A red flag is ignoring core financial metrics like LTV and CAC.
How would you define and calculate Weekly Active Users (WAU)?
This tests your product sense and technical precision in defining a core business metric. A great answer defines 'active' with specific user actions, outlines the SQL/event-based calculation, and discusses pitfalls like bots and background events.
When is A/B testing not feasible, and what is an alternative?
Tests your grasp of causal inference when randomization isn't possible. A great answer names a scenario (like a regional launch), proposes Difference-in-Differences (DiD), and explains its core 'parallel trends' assumption.
Design a Schema Validation System for Analytics Events
This tests your ability to balance data quality, performance, and developer experience. A good answer defines a central 'Tracking Plan,' enforces it on the client for feedback and the server for integrity, and quarantines failed events.
Calculate MRR from a subscriptions table using SQL
Tests your ability to translate a business metric (MRR) into a precise SQL query. A great answer filters for active subscriptions this month and sums their prices, correctly amortizing annual plans.
How do you handle timezones for a daily global sales report?
This tests your understanding of time data modeling and business requirements. A good answer stores events in UTC with a timezone identifier, then converts to the business's chosen 'day' at query time. A red flag is storing local time without context.
Propose a multi-touch attribution model and its data pipeline
Tests your grasp of attribution models and their data engineering needs. Propose a rule-based model (e.g., time-decay), outline the data pipeline for it, and acknowledge privacy-driven signal loss. A red flag is ignoring the challenge of identity resolution.
Find leading indicators for long-term churn
This tests your ability to translate a business problem into a data investigation. A strong answer defines churned vs. retained cohorts, hypothesizes key early behaviors, and compares their frequency to find a leading indicator.
Calculate Daily Active Users (DAU) with SQL
This tests product sense and SQL fundamentals. Define 'active' with a core product action, describe the event data needed, then write a COUNT(DISTINCT user_id) query. A red flag is writing SQL before defining the business logic for 'active'.
Client-Side vs. Server-Side Event Tracking
Tests your grasp of data integrity and architectural trade-offs. A great answer defines both, favors server-side for reliability (avoids ad-blockers), but notes client-side's richness for UI events. A red flag is presenting them as equal choices.
How would you build a SQL query for a conversion funnel?
Tests your ability to translate a business need into a technical SQL solution. A good answer uses CTEs or LEFT JOINs to model sequential steps, counts users at each stage, and discusses attribution.
Get Analytics bites daily.
Five a day, five minutes, offline. With quizzes so it sticks.
Open testing — you’ll join as an early tester.