Analytics
494 bites tagged Analytics — interview questions with model answers, and 60-second explainers.
Leading vs. Lagging Indicators: Predict the Future or Report the Past?
Leading indicators are predictive inputs (like sales calls made) that forecast future results. Lagging indicators are outputs (like quarterly revenue) that report what already happened.
North Star Metric: Aligning Your Team With One Metric
A North Star Metric (NSM) is the single number that best captures the core value your product delivers, acting as a compass for your team. It aligns everyone on a shared goal, like Spotify using 'Time Spent Listening.' The biggest footgun is not having one.
Hypothesis-Driven Analysis: Ask First, Analyze Second
Start with a specific question, then use data to find a clear yes/no answer. This approach is perfect for A/B testing or diagnosing metric changes, but watch out for confirmation bias—seeking data that only proves your initial belief.
The MECE Principle: No Overlaps, No Gaps
The MECE principle structures analysis with 'no overlaps, no gaps.' Use it to break down problems, segment users, or plan projects. The footgun is achieving one rule (exclusive categories) but not the other (covering all cases), leading to flawed conclusions.
Marketing Attribution: Who Gets Credit for a Sale?
Marketing attribution decides which ad or email gets credit for a sale. It helps justify marketing spend by showing which channels work, preventing the common mistake of giving 100% credit to the final click and ignoring what built initial interest.
Conversion Lift Study: Proving Your Ads Actually Work
A conversion lift study proves your ads caused sales, not just correlated with them. It's a controlled experiment that withholds ads from a control group to measure the true, incremental impact on conversions compared to those who saw the ads.
Assisted Conversions: Giving Credit Beyond the Final Click
An assisted conversion credits any channel a user interacts with before the final one. It's like crediting the pass before the goal, showing how channels like social or organic search contribute to sales that are ultimately closed by a direct visit or ad.
Scroll Depth Tracking: Measure Engagement Beyond the Fold
Scroll depth tracking measures how much of a page a user actually sees, not just that they landed on it. It fires analytics tags at specific scroll points, like 25% or 75% down the page, to gauge engagement on long articles.
Goal Tracking: From User Clicks to Business Conversions
Goal tracking translates user actions into business metrics. Analytics platforms use automatically collected events (like `ad_click`) as building blocks to track these goals. The footgun is confusing any interaction with a valuable, defined conversion.
Traffic Sources: Where Your Users Come From
Traffic sources pinpoint where users come from using a `Source/Medium` pair, like `google/organic`. This tells you which channels—SEO, paid ads, or social—drive visitors. The footgun is confusing them: `google` is a Source, `organic` is the Medium.
Bounce Rate: The Opposite of Engagement
Bounce rate is the percentage of website sessions that weren't engaged. In Google Analytics 4, a bounce means the visit was under 10 seconds, had no key events, and viewed only one page.
Session Replay: A DVR for Your User's Experience
Session replay is like a DVR for your website, letting you watch a user's exact journey. It's used to debug issues, find conversion blockers, and understand user behavior. The footgun is watching aimlessly; without a hypothesis, you're just invading privacy.
Heatmap Analysis: Seeing Where Your Users Look
A heatmap is a weather map for your webpage, showing 'hot' spots of high engagement and 'cold' spots users ignore. Use it to see which headlines get clicks or how far down a sales page users scroll.
Social Listening: Tracking Unsolicited Customer Feedback
Social listening is like being a fly on the wall, hearing what customers say when you're not asking. Marketers use it to track brand sentiment and find pain points. The footgun is just counting mentions instead of analyzing the 'why' behind them.
OLAP Cube: Pre-Aggregating Data for Fast Analysis
An OLAP cube is like a Rubik's Cube for your data, pre-calculating answers to complex business questions. It powers BI tools, letting you 'slice and dice' sales data by region and time for fast reports. The footgun: data is typically stale, not real-time.
Dimensional Modeling: Facts vs. Dimensions
Dimensional modeling organizes data like a story: 'facts' are what happened (sales numbers) and 'dimensions' are the who, what, and where (customer, product). It's the foundation for data warehouses, turning raw data into analyzable BI reports.
Cloud Data Warehouse: Analytics Without the Hardware
A cloud data warehouse is your company's analytical brain, but without the hardware headache. It separates storage and compute, letting you query massive historical datasets from sales, marketing, and ops.
Color Theory: Guiding the Eye in Data Visualization
Color in a chart is a cognitive shortcut, telling the viewer's brain what to notice and how to feel. Use it to highlight trends (green for growth) or group categories. The footgun is using too many colors, which creates noise and obscures insights.
Data Dashboards: The Single-Page Business Story
A data dashboard is the executive summary for your metrics, telling a story on a single page with key visualizations. It consolidates data from multiple reports, providing a high-level view to monitor business performance.
Analytics CoE: Centralizing Your Data Strategy
An Analytics Center of Excellence (CoE) is an internal data consulting group, centralizing experts to set standards and drive strategy. It helps large organizations standardize data quality and tooling. The footgun: becoming a bottleneck that slows teams down.
Time to Value (TTV): From Signup to 'Aha!'
Time to Value (TTV) measures the time from a user's first touch to their first 'aha moment' of real value. It's crucial for optimizing onboarding and reducing churn. The main footgun is defining value from the company's view, not the customer's.
Data-as-a-Product: Treat Your Data Like Software
Data-as-a-Product (DaaP) treats internal datasets like software, with owners, versions, and SLAs. This provides reliable, self-service data for consumers like analysts or other apps.
Snowflake: Decoupled Storage and Compute
Snowflake decouples storage from compute, acting like a shared-disk system for data management but a shared-nothing system for query performance. This lets you scale compute and storage independently, ideal for variable analytic workloads.
Multivariate Testing: Finding the Best Combination
Multivariate testing (MVT) finds the best *combination* of changes, not just the best single change. It tests multiple elements at once, like three headlines and two button colors, to see how they interact.
Get Analytics bites daily.
Five a day, five minutes, offline. With quizzes so it sticks.
Open testing — you’ll join as an early tester.