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

Ancestry Marketing Research Analyst Interview Questions

The questions to prepare for a Ancestry Marketing Research Analyst interview. Questions from real interview reports rank first. Updated weekly.

34questions
~5htotal time
Track your progressSign up free to work through all 34 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 11 questions · ~88 min
Evaluate A/B Test Results for New FeatureMedium

Assess the impact of a new feature on conversion rates through A/B testing analysis and statistical significance evaluation.

ExperimentationA/B TestingAncestry Marketing
Define Campaign North Star MetricMedium

Define a campaign north star metric and a KPI set that captures business value, early signals, and funnel health.

North Star MetricKPIsDiagnosisAncestry Marketing
More Metrics questions with a free account
2
Strategy3 questions · ~24 min
Financial Analysis Driving Business DecisionsEasy

Describe a time your financial analysis changed a business decision, with clear business impact and strong commercial judgment.

EstimationGrowth StrategyDiagnosisAncestry Marketing
Estimating Market SizeMedium

Tests market sizing approach and assumptions for product planning.

EstimationTAM/SAM/SOMMarket SizingAncestry Marketing
More Strategy 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 Sense8 questions · ~64 min
Motivation in Data-Driven Product WorkEasy

Explain what drives strong performance in a data-driven product environment and how that motivation connects to impact.

User NeedsValue PropositionProduct VisionAncestry Marketing
Using User Research to Refine FeaturesHard

Tests your ability to translate qualitative and quantitative research into product improvements.

User ResearchFeature PrioritizationPain PointsAncestry Marketing
More Product Sense questions with a free account
4
Statistics & Probability9 questions · ~72 min
Estimating Sample SizeHard

Tests power analysis and study planning for reliable results.

ExperimentationPower AnalysisSample SizeAncestry Marketing
More Statistics & Probability questions with a free account
5
More topics3 questions · ~24 min
Discuss Data Analysis Tooling ChoicesEasy

Explain how SQL fits with data analysis and visualization tools, and when to use each in an analytics workflow.

JoinsData WranglingAggregationsAncestry Marketing
More questions with a free account
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
SQL for 30-Day DNA Kit RetentionHard
Practice
Practice drill

Calculate 30-day DNA kit retention for an Ancestry Marketing promotion using CTEs, window functions, joins, and conditional aggregation.

Date FunctionsJoinsAggregationsAncestry Marketing
Calculate 30-Day User RetentionHard
Practice
Practice drill

Use CTEs, joins, and date filtering to calculate 30-day retention by signup cohort from login and feature usage data.

Window FunctionsDate FunctionsAggregationsCurefitReachMobiIndeed
Window Functions for ChurnEasy
Practice
Practice drill

Use ROW_NUMBER and date logic to identify Ancestry users who became inactive after repeated activity.

Window FunctionssqlAncestry Marketing
The finish line: interview-readyComplete all 34 questions plus 3 hands-on drills to finish this plan.