Hotstar Consultant Interview Questions
The questions to prepare for a Hotstar Consultant interview. Questions from real interview reports rank first. Updated daily.
Tests practical metric computation and interpretation for streaming ad performance.
HotstarTests core advertising metric literacy and correct interpretation of funnel signals.
HotstarTests advanced analysis and ranking logic for ad inventory performance.
HotstarTests spreadsheet lookup proficiency and ability to choose robust formulas.
HotstarCompute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.
Meta
Spotify
Meta ITUse CTEs, joins, and date filtering to calculate 30-day retention by signup cohort from login and feature usage data.
Curefit
Indeed
TikTokCalculate month-1 retention for January vs February signup cohorts using joins, date filtering, and aggregation.
Trideum
Zulily
eBaySign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests knowledge of ad inventory formats and how they impact delivery and performance.
HotstarTests ability to diagnose CAC drivers and connect them to acquisition strategy.
HotstarTests campaign optimization skills and ability to troubleshoot conversion bottlenecks.
HotstarTests ability to build repeatable reporting pipelines and reduce manual effort.
Hotstar