Dataford
Top 27
Prep plan
Updated weekly · Last refresh Aug 30

Collinson Marketing Analytics Specialist Interview Questions

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

27questions
~4htotal time
Track your progressSign up free to work through all 27 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 4 questions · ~32 min
Measure Marketing Campaign SuccessEasy

Define campaign success using business KPIs, funnel conversion, acquisition cost, and leading indicators tied to outcomes.

Funnel AnalysisKPIsLeading IndicatorsCollinson
More Metrics questions with a free account
2
Strategy5 questions · ~40 min
First Step for Retention AnalysisMedium

Tests your prioritization of retention hypotheses and initial measurement plan.

Data AnalysisCollinson
Go-To-Market Data PrioritiesHard

Tests your ability to connect GTM decisions to measurable data for driving customer behavior and revenue.

product launchCollinson
More Strategy questions with a free account
3
SQL & Data Manipulation3 questions + 3 drills · ~54 min
Reconciling Cross-Platform DataMedium

Tests your approach to diagnosing and reconciling inconsistent marketing data across platforms.

data integrityreportingCollinson
SQL Funnel Drop-Off AnalysisHard
Practice
Practice drill

Measure sequential Airbnb Homes funnel engagement and drop-off using CTEs, joins, aggregation, and LAG.

sql queryData Analysisuser engagementAirbnb
Top 10 Users by Watch TimeMedium
Practice
Practice drill

Rank the top 10 Disney+ Hotstar users in India by January watch time using a CTE, LEFT JOIN, and aggregation.

sql queryData Analysisuser engagementDDisney+HotStar
SQL: Top Engaged Save InteractorsMedium
Practice
Practice drill

Use joins, aggregation, a CTE, and ROW_NUMBER to rank Instagram Save users by quarterly engagement within each region.

sql queryData Analysisuser engagementMeta
More SQL & Data Manipulation questions with a free account
4
Behavioral & Leadership11 questions · ~88 min
More Behavioral & Leadership questions with a free account
5
More topics4 questions · ~32 min
A/B Test for Email CampaignMedium

Design and analyze an A/B test for a new email campaign, including metrics, power, guardrails, and common experiment risks.

email campaignAnalysisA/B TestingCollinson
Analytics in Loyalty and BenefitsMedium

Tests your domain understanding of loyalty analytics and your perspective on industry evolution.

industry interestCollinson
Validating Model AccuracyMedium

Tests your model validation approach, including testing, calibration, and communication of uncertainty.

Accuracymodel validationdata integrityCollinson
Power-Analysis for Email Message TestEasy

Design a simple email A/B test, define metrics and guardrails, and size the experiment to detect a meaningful lift.

Hypothesis TestingSample SizeA/B TestingCollinson

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 27 questions plus 3 hands-on drills to finish this plan.