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

Ancestry Business Analyst Interview Questions

The questions to prepare for a Ancestry Business Analyst interview. Questions from real interview reports rank first. Updated daily.

24questions
~4htotal time
Track your progressSign up free to work through all 24 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 1 drill · ~55 min
Compare Monthly User Retention CohortsMedium
Practice

Calculate month-1 retention for January vs February signup cohorts using joins, date filtering, and aggregation.

Window FunctionsDate FunctionsAggregationsAncestry
Average Time to First DiscoveryMedium
Practice

Calculate the average number of days from DNA activation to each user's first subsequent login.

Date FunctionsJoinsAggregationsAncestry
Window Functions for RetentionMedium
Practice
Practice drill

Measure monthly retention for a January Ancestry Family Tree cohort using CTEs and ROW_NUMBER().

Window Functionsuser retentionsqlAncestrySpring Health
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership13 questions · ~117 min
More Behavioral & Leadership questions with a free account
3
More topics6 questions · ~54 min
Attributing Behavior to Marketing SpendHard

Evaluates causal reasoning and inference quality from marketing and customer data.

Data AnalysisAncestry
Making Money Across ProductsHard

Assesses product and revenue strategy thinking grounded in Ancestry's portfolio.

Business ModelAncestry
A/B Test for Mobile CheckoutMedium

Tests experimental design and metric selection for improving conversion on Ancestry’s mobile app.

experiment designMetricsA/B TestingAncestry
Drive Retention from Family Tree FeaturesMedium

Tests product analytics approach, causal reasoning, and ability to connect features to retention outcomes.

Feature PrioritizationRetentionuser valueAncestry
Estimate ROI for International RecordsHard

Tests strategy, forecasting, and ability to link investment decisions to measurable engagement outcomes.

roiuser engagementMarket SizingAncestry
Diagnose 10% Week-over-Week Sign-Up DropMedium

Tests metrics thinking, funnel analysis, and structured troubleshooting for Ancestry subscription performance.

Conversion RateacquisitionDiagnosisAncestry

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 24 questions plus 1 hands-on drill to finish this plan.