Top 18
Prep plan
Updated weekly · Last refresh Aug 30

University of Oklahoma Marketing Analytics Specialist Interview Questions

The questions to prepare for a University of Oklahoma Marketing Analytics Specialist interview. Questions from real interview reports rank first. Updated weekly.

18questions
~2htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 8 questions · ~64 min
Track CTR and Cost Per AcquisitionMedium

Tests measurement of recruitment ad KPIs and ability to compute CAC and CTR for OU.

CACKPIConversion RateUniversity of Oklahoma
Use Google Analytics for Multi-ChannelMedium

Tests proficiency with GA and ability to measure multi-channel performance for OU marketing.

Funnel AnalysisattributionKPIUniversity of Oklahoma
More Metrics questions with a free account
2
Strategy3 questions · ~24 min
Optimize Spend With EvidenceMedium

Tests experimentation, optimization thinking, and evidence-based spend decisions for OU.

EstimationCompetitive AnalysisGrowth StrategyUniversity of Oklahoma
Predict High-Quality Applicant RegionsHard

Tests forecasting, segmentation, and use of historical enrollment signals for OU recruitment targeting.

EstimationGrowth StrategyMarket SizingUniversity of Oklahoma
More Strategy questions with a free account
3
SQL & Data Manipulation3 questions + 3 drills · ~54 min
Deep-Dive Queries and ManipulationMedium

Tests depth of SQL/data manipulation capability for OU analytics investigations.

JoinsData WranglingAggregationsUniversity of Oklahoma
Advanced SQL for Marketing DecisionsMedium

Tests advanced SQL skills for extracting and shaping data to drive OU marketing decisions.

Window FunctionsJoinsAggregationsUniversity of Oklahoma
Use Excel for Deep AnalysisEasy

Tests practical Excel skills for analysis, cleaning, and manipulation supporting OU reporting.

Data WranglingCase WhenAggregationsUniversity of Oklahoma
Weekly Service KPI by TeamMedium
Practice
Practice drill

Analyze weekly service delivery performance by team using joins, a CTE, date aggregation, and KPI calculations.

KPIJoinssqlDeloitteReputation
Analyze Decision Impact by RegionEasy
Practice
Practice drill

Use joins, CASE WHEN, and date filtering to compare outcome rates before and after a decision.

Data WranglingDiagnosisAggregationsHarbourVest Partners
Identify Funnel Bottlenecks in OnboardingHard
Practice
Practice drill

Use joins, CTEs, and aggregations to find the weakest step in an onboarding funnel and estimate lost conversions.

Funnel AnalysissqlDiagnosisAtlassianRevolut
4
Behavioral & Leadership3 questions · ~24 min
More Behavioral & Leadership questions with a free account
5
More topics1 question · ~8 min
The finish line: interview-readyComplete all 18 questions plus 3 hands-on drills to finish this plan.