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 (1)
Branches
Subtopics
Access
Free onlyQuestion type
Type to find a company, then pick it from the list below.
Tool
32 questions · page 1 of 2
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
Cost per acquisition by channel
ProAggregate campaign spend into per-channel CPA and rank it.
Live SQL · Campaigns · PostgreSQL · 15 min · Medium
Digital & Marketing Analytics · Original Uplift question
Incrementality test for brand search spend
ProProve whether brand search ads add sales or harvest them.
Written case · Site · 20 min · Medium
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
Prove paid social is actually incremental
ProYour paid social campaigns report a 4x ROAS from the ad platform's attribution.
Written case · Attribution · 20 min · Hard
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
MMM vs multi-touch attribution
ProWith third-party cookies deprecating, a CMO asks why the team is investing in Marketing Mix Modeling (MMM) instead of relying on multi-touch...
Quick check · Attribution · 6 min · Medium
Digital & Marketing Analytics · Company-context scenario
Measure a brand campaign with no direct conversions
ProMarketing runs a $5M brand awareness campaign (TV + video) with no direct-response call to action.
Written case · Site · 15 min · Medium
Digital & Marketing Analytics · Company-context scenario
Is this campaign's traffic real
ProA display campaign suddenly shows a huge spike in clicks and traffic but flat conversions.
Written case · Campaigns · 15 min · Medium
Digital & Marketing Analytics · Company-context scenario
Measure an Instagram subway campaign
ProInstagram plans a display campaign in New York City subway stations.
Written case · Attribution · 18 min · Medium
Digital & Marketing Analytics · Reported at Meta
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
Allocate budget with conflicting attribution models
ProA customer sees a paid-social ad, later searches the brand, clicks a paid-search ad, and buys.
Written case · Attribution · 22 min · Hard
Digital & Marketing Analytics · Reported interview question
Surface promotions that need attention
ProTarget runs hundreds of promotions across channels.
Written case · Campaigns · 18 min · Medium
Digital & Marketing Analytics · Reported at Target
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
Pick the right segment container
ProYou need people who viewed a product page and also ordered at some point in the window, not necessarily in the same visit.
Quick check · Adobe analytics · Adobe Analytics · 7 min · Medium
Digital & Marketing Analytics · Original Uplift question
Clean up two years of messy campaign codes
ProHistorical tracking codes need to be grouped into channel, region, and creative, including past data.
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
Fix flicker in a client-side test
ProQA sees the original hero flash before the test hero appears.
Quick check · Testing personalization · Adobe Target · 6 min · Medium
Digital & Marketing Analytics · Original Uplift question