Catalog
8 branches of analytics, product and AI interview questions
Explore eight skill tracks, called branches, filterable by subtopic, company, tool and difficulty. SQL questions run against sample tables, choice and numeric answers are checked instantly, and written cases are scored against evaluation criteria.
Filters (2)
Branches
Subtopics
Access
Free onlyQuestion type
Type to find a company, then pick it from the list below.
Tool
15 questions
Why last-click flatters brand search
Identify the bias in last-click attribution.
Quick check · Attribution · 5 min · Easy
Digital & Marketing Analytics · Original Uplift question
Blended ROAS from spend and revenue
Compute blended return on ad spend.
Calculation · Campaigns · 5 min · Easy
Digital & Marketing Analytics · Original Uplift question
Which attribution model over-credits early touchpoints
A customer sees a Facebook ad (first touch), later clicks a Google search ad, then converts after an email.
Quick check · Attribution · 6 min · Medium
Digital & Marketing Analytics · Company-context scenario
ROAS looks great, is the campaign profitable
A campaign spent $10,000 and drove $40,000 in revenue (ROAS = 4).
Calculation · Campaigns · 6 min · Medium
Digital & Marketing Analytics · Company-context scenario
Is the LTV:CAC healthy
A SaaS product has customer lifetime value (LTV) of $900 and customer acquisition cost (CAC) of $300.
Calculation · Unit economics · 5 min · Easy
Digital & Marketing Analytics · Company-context scenario
Measure an email campaign's success
Airbnb sends a destination-inspiration email to eligible travelers.
Written case · Campaigns · 16 min · Medium
Digital & Marketing Analytics · Reported at Airbnb
Expected cost of a rider coupon
Lyft gives a $5 coupon to 20,000 riders.
Calculation · Campaigns · 8 min · Easy
Digital & Marketing Analytics · Reported at Lyft
Choose between a prop and an eVar
Stakeholders want to know which internal search term a shopper used before an order placed several pages later.
Quick check · Adobe analytics · Adobe Analytics · 5 min · Easy
Digital & Marketing Analytics · Original Uplift question
Explain channel counts that do not add up
Channel rows for unique visitors sum to more than the report total for the same period.
Quick check · Adobe analytics · Adobe Analytics · 6 min · Medium
Digital & Marketing Analytics · Original Uplift question
Read the occurrences metric honestly
A stakeholder reads occurrences next to internal search terms as the number of people who searched.
Quick check · Adobe analytics · Adobe Analytics · 5 min · Easy
Digital & Marketing Analytics · Original Uplift question
Diagnose a page-view drop after a tag release
Adobe Analytics page views fall 35% overnight after a tag release while backend orders stay flat.
Written case · Adobe analytics · Adobe Analytics · 15 min · Medium
Digital & Marketing Analytics · Original Uplift question
Choose the right Adobe Target activity type
Marketing wants a clean read on which of three homepage heroes drives the most subscriptions.
Quick check · Testing personalization · Adobe Target · 5 min · Easy
Digital & Marketing Analytics · Original Uplift question
Explain the GA4 data model to a stakeholder
A stakeholder moving from Universal Analytics asks why everything in GA4 looks like an event.
Quick check · Google analytics · Google Analytics 4 · 5 min · Easy
Digital & Marketing Analytics · Original Uplift question
Count sessions after a long pause
A visitor reads for 40 minutes with no interaction, then clicks a link.
Quick check · Google analytics · Google Analytics 4 · 6 min · Medium
Digital & Marketing Analytics · Original Uplift question
Reconcile GA4 purchases with the order table
GA4 reports 30% fewer purchases than the order table for the same week.
Written case · Google analytics · Google Analytics 4 · 15 min · Medium
Digital & Marketing Analytics · Original Uplift question