Dataford
Dataford
Top 14
Prep plan
Updated weekly · Last refresh Nov 6

Google Strategy & Data Analyst Interview Questions

The questions to prepare for a Google Strategy & Data Analyst interview. Questions from real interview reports rank first. Updated daily.

14questions
~3htotal time
Track your progressSign up free to work through all 14 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions · ~61 min
SQL for User RetentionMedium
Practice

Measure monthly user retention by signup cohort using date calculations and aggregated activity.

Window FunctionsDate FunctionsCTEsGoogle
Handling Dirty Data in Large PipelinesHard
Practice

Audit missing, corrupted, and duplicate pipeline records, then report accepted rows by source batch.

missing valuesdata cleaningdata validationGoogle
Detecting Anomalies in DAU Across RegionsMedium
Practice

Aggregate daily active users by region and flag monitored regions with at least a 20% day-over-day decline.

Date Functionsdata anomalyAggregationsGoogle
Top Campaigns by CTR per RegionMedium
Practice

Rank Google ad campaigns by quarterly click-through rate and return the top three campaigns within each region.

Date FunctionsJoinssql queryGoogle
Joining Mismatched DatasetsMedium
Practice

Reconcile daily metrics and monthly targets when identifiers and aggregation levels differ.

aggregationJoinsdata integrityGoogle
2
Behavioral & Leadership7 questions · ~86 min
Why Google and This RoleEasy

Tests motivation, alignment, and self-awareness in a hiring manager interview.

achievementalignmentbehavioralGoogle
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~25 min
Evaluating Market Entry OpportunityHard

Assess whether a new regional market offers an attractive, defensible opportunity for a core Google service.

analytical thinkingCompetitive AnalysisGo-to-MarketGoogle
KPIs for Google Ads Onboarding HealthMedium

Select and structure KPIs to evaluate Google Ads small business onboarding health, activation, retention, and business value.

Funnel AnalysisKPI selectionActivationGoogle

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 14 questions to finish this plan.