Top 50 campaign performance Interview Questions
The most frequently asked campaign performance questions across all roles and companies, ranked by real interview frequency. Updated daily.
Use DENSE_RANK to identify the top three campaigns by conversions within each EXL Service Philippines region.
EXL Service PhilippinesRank active Amazon DSP campaigns by click-through rate over the latest 30 days using a CTE, aggregation, and RANK().
Amazon DSPCompare campaign conversion rates across weeks and regions to identify meaningful performance drops.
MetaUse PostgreSQL joins and monthly aggregation to count distinct active users from a specific signup campaign.
GitHubCalculate monthly campaign open rates and find each campaign's largest month-over-month decline.
Rent The RunwayAggregate campaign spend and conversions by channel and month, then calculate conversion rates with PostgreSQL.
Samyang AmericaSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests ownership and analytical decision-making when a campaign misses targets, including root-cause diagnosis and forward-looking recommendations.
The Hartford
Grainger Corporate Services
AkamaiCalculate customer acquisition cost from campaign budget, impression cost, and conversion rate.
GameStop
Ancestry Marketing
Mastercard