← StackAdapt Interview Insights

StackAdapt·Software Engineer·Take-home Assignment·Senior

Senior
Mar 2026

Summary

A take-home case study for a Senior BI Engineer role at Stackadapt, centered on ad spend data analysis in Excel. The bar was higher than I expected: they weren't just checking if you could write formulas, they wanted real business thinking around what the numbers actually mean.

Questions Asked (1)

Q1

Given a dataset of ad spend across multiple markets, analyze the data and produce a structured output covering data quality issues, trend analysis, top and bottom performing markets, assumptions made, and business recommendations.

Product Analytics & MetricsRoot Cause AnalysisAdaptability & Ambiguity
Author's notes

This felt like a lot more than a 'do some Excel' exercise.

Create a free account to read the full note

AI HintsAI Generated

Suggested Approach

Start by clarifying the dataset structure and business context, then systematically assess data quality before diving into trends and market performance. Structure your analysis to lead with key insights and actionable recommendations, while explicitly stating assumptions and acknowledging limitations.

Pro tip: Demonstrate engineering rigor by proposing a reproducible analysis pipeline (e.g., SQL queries or Python scripts) and highlighting how you would automate data quality checks and metric calculations for scalability.

1. Clarify and Validate Data

Ask clarifying questions about the dataset (e.g., time period, metrics, market definitions) and perform initial data quality checks (missing values, outliers, consistency).

2. Explore Trends and Patterns

Analyze ad spend over time, across markets, and by channel to identify overall trends, seasonality, and anomalies.

3. Identify Top and Bottom Performers

Rank markets by key metrics (e.g., spend, ROI, CPA) to highlight top and bottom performers, and investigate potential reasons for their performance.

4. State Assumptions and Limitations

Explicitly list assumptions made during analysis (e.g., data completeness, attribution windows) and note any limitations that could affect conclusions.

5. Derive Business Recommendations

Translate insights into actionable recommendations, such as reallocating budget, improving data collection, or testing new strategies in underperforming markets.

Key Points to Mention

  • Data quality issues: missing values, outliers, inconsistent market naming, time zone discrepancies.
  • Trend analysis: seasonality, growth/decline patterns, correlation with external factors (e.g., holidays, campaigns).
  • Top/bottom markets: define performance metrics (ROAS, CPA, CTR) and consider market size and maturity.
  • Assumptions: data completeness, attribution model, currency conversion, and that past performance predicts future results.
  • Business recommendations: budget reallocation, A/B testing, data pipeline improvements, and market-specific strategies.
  • Engineering mindset: propose automated data validation, reproducible analysis, and scalable metrics computation.

AI-generated suggestions, not part of the candidate's original notes. May be inaccurate — verify before relying on them.