Skip to content
Pro85 ProblemsSQL + Python

AdTech SQL & Python Interview Questions

Advertising technology companies process billions of ad events daily — impressions, clicks, conversions, and revenue signals. These SQL and Python challenges are modeled after real analytics work at Google, Meta, Amazon Ads, The Trade Desk, TikTok, Microsoft Advertising, Criteo, Snap, Pinterest, DoubleVerify, and more. Practice attribution modeling, campaign ROI measurement, audience segmentation, CTR & CPM analysis, bid strategy optimization, and cross-channel reporting.

AdTech

85 total problems

SQL39
Python46
Companies working in AdTech

These practice problems are modeled after the kind of data and analytics challenges teams in this industry typically face.

Google
Google
Meta
Meta
Amazon Ads
Amazon Ads
The Trade Desk
The Trade Desk
TikTok
TikTok
Microsoft Advertising
Microsoft Advertising
Criteo
Criteo
Snap
Snap
Pinterest
Pinterest
DoubleVerify
DoubleVerify
Integral Ad Science
Integral Ad Science
Roku
Roku
OpenX
OpenX
Magnite
Magnite
LiveRamp
LiveRamp
Zeta Global
Zeta Global
PubMatic
PubMatic
Taboola
Taboola
RTB House
RTB House
Yahoo Advertising
Yahoo Advertising

Company names and logos are trademarks of their respective owners, used here only to describe the kind of data these companies work with. Let's Data Science is not affiliated with, endorsed by, or sponsored by any company shown. Practice problems are original works and are not real interview questions from these companies. Rights & takedowns.

Difficulty Breakdown

85 problems
14 Easy(16%)
29 Medium(34%)
34 Hard(40%)
8 Expert(9%)

What You'll Practice

Campaign performance metricsAttribution modelingFunnel conversion analysisAudience segmentationRevenue & ROAS optimizationCTR & CPM calculationsCross-channel reportingBid strategy analysis

Topics Covered

22 topics
SQL · 10
ab testingaggregationbasic queries filteringcleaning transformdate timejoinsscenario sqlset operationssubqueries cteswindow functions
Python · 13
ab testingeda statisticsfeature engineeringpandas aggregationpandas applypandas basicspandas cleaningpandas datetimepandas filteringpandas mergingpandas reshapingpandas scenariopandas window

All Problems85 total

Open in editor

Ready to practice AdTech?

85 SQL and Python challenges built from real adtech data. Graded instantly in your browser — no setup required.