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
21 questions
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
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
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
Surface promotions that need attention
ProTarget runs hundreds of promotions across channels.
Written case · Campaigns · 18 min · Medium
Digital & Marketing Analytics · Reported at Target
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
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
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
Push back on a personalization lift claim
ProAn Experience Targeting activity shows loyalty members converting 20% higher than the default experience.
Quick check · Testing personalization · Adobe Target · 6 min · Medium
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
Handle an (other) row in a GA4 report
ProAn (other) row absorbs 18% of page-path rows in a standard report.
Quick check · Google analytics · Google Analytics 4 · 7 min · Medium
Digital & Marketing Analytics · Original Uplift question
Interpret a shift in attribution credit
ProPaid search conversions fall 12% and email rises after an attribution model change.
Quick check · Google analytics · Google Analytics 4 · 6 min · Medium
Digital & Marketing Analytics · Original Uplift question
Use modeled conversions responsibly
ProWith consent mode active, a GA4 report includes modeled conversions.
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