Dataford
Dataford
Top 17
Prep plan
Updated weekly · Last refresh Oct 30

Hotstar Consultant Interview Questions

The questions to prepare for a Hotstar Consultant interview. Questions from real interview reports rank first. Updated daily.

17questions
~2htotal time
Track your progressSign up free to work through all 17 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 4 questions · ~32 min
CPM, CPI, CTR for StreamingMedium

Tests practical metric computation and interpretation for streaming ad performance.

Hotstar
Impressions, Reach, FrequencyEasy

Tests core advertising metric literacy and correct interpretation of funnel signals.

Hotstar
More Metrics questions with a free account
2
SQL & Data Manipulation5 questions + 3 drills · ~70 min
Identify Top-Performing Ad SlotsHard

Tests advanced analysis and ranking logic for ad inventory performance.

Data AnalysisHotstar
VLOOKUP vs XLOOKUP/INDEX-MATCHMedium

Tests spreadsheet lookup proficiency and ability to choose robust formulas.

excel functionsHotstar
Top Viewed Shows Per RegionMedium
Practice
Practice drill

Find the five most viewed Hotstar shows in each region using joins, aggregation, and regional ranking.

Joinssql queryData AnalysisHotstar
Top Shows by RegionMedium
Practice
Practice drill

Write a query to find the top 10 most-watched shows in a specific region over the last 30 days on Hotstar. Use IN as the target region and CURRENTDATE as ...

Date FunctionsJoinssql queryHotstar
7-Day Rolling Active UsersMedium
Practice
Practice drill

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsMetaSpotifyMeta IT
More SQL & Data Manipulation questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Product Sense3 questions · ~24 min
Understanding Ad FormatsMedium

Tests knowledge of ad inventory formats and how they impact delivery and performance.

digital marketinguser engagementHotstar
More Product Sense questions with a free account
4
More topics5 questions · ~40 min
Customer Acquisition Cost DriversMedium

Tests ability to diagnose CAC drivers and connect them to acquisition strategy.

market analysisHotstar
Optimize High Reach, Low ConversionHard

Tests campaign optimization skills and ability to troubleshoot conversion bottlenecks.

Conversion RateHotstar
Automate a Monthly ReportHard

Tests ability to build repeatable reporting pipelines and reduce manual effort.

process improvementExcelHotstar
More questions with a free account
The finish line: interview-readyComplete all 17 questions plus 3 hands-on drills to finish this plan.