Google Data Analyst Interview Questions (2026)

1. 1Recruiter screen30 minEasy

   Background, level calibration, and process walkthrough with a recruiter.

2. 2Technical phone screen45 minHard

   One or two DSA problems solved live in a shared editor with emphasis on optimal complexity and clean code.

3. 3Coding round (onsite)45 minHard

   Harder DSA with follow-up constraint changes; interviewer scores GCA and RRK on a rubric.

4. 4System design round45 minHard

   Design a planet-scale system (e.g. a piece of Search or YouTube) with explicit capacity estimates and tradeoffs.

5. 5Googleyness & Leadership45 minMedium

   Behavioral round on collaboration, ambiguity, and user-first judgment scored against Google's structured rubric.

6. 6Hiring Committee review30 minMedium

   No candidate interaction; the written feedback packet is reviewed and the hire/no-hire decision is made, followed by team matching.

1. Q1

   For YouTube Shorts, should randomization happen at user, session, device, advertiser, or country level? Explain the tradeoffs

   MediumStatistics & Experimentation RoundA/B TestingGoogle-specific

   Context: Consider cross-device behavior, interference, marketplace effects, and operational feasibility.

   How to answer: Randomization for YouTube Shorts should primarily happen at the user level to ensure independent observations and avoid contamination. Session or device level randomization could be considered for very short-term, immediate impact tests where user identity across sessions/devices is hard to track, but risks user-level contamination. Advertiser or country level randomization is generally too broad and introduces significant confounding factors, making it difficult to isolate the treatment effect for a product like Shorts, which is consumed individually.

2. Q2

   Choose primary and guardrail metrics for a Google Ads experiment aimed at improving query success rate. What metrics would prevent a harmful launch?

   MediumStatistics & Experimentation RoundA/B TestingGoogle-specific

   Context: Include user experience, partner health, revenue, reliability, and long-term retention considerations.

   How to answer: A strong candidate would identify 'Query Success Rate' (e.g., clicks on ads, conversions, or user engagement post-query) as the primary metric. For guardrail metrics, they would suggest 'Revenue per User/Query' (to ensure profitability isn't negatively impacted), 'Ad Impression Share' or 'Click-Through Rate (CTR)' (to monitor ad visibility and user interaction), and 'Latency' or 'Error Rate' (to ensure system stability and user experience aren't degraded). The key is to balance user experience improvements with business objectives and technical performance.

3. Q3

   The Google Play experiment is trending positive after two days. A PM wants to stop early and launch. How do you handle peeking and sequential testing?

   MediumStatistics & Experimentation RoundA/B TestingGoogle-specific

   Context: Discuss pre-specified stopping rules, alpha spending, business urgency, and risk.

   How to answer: Explain that stopping an A/B test early due to positive trends (peeking) inflates the Type I error rate, leading to false positives. Discuss the need for pre-defined sample sizes or test durations based on power analysis to ensure statistical validity. Propose solutions like using sequential testing methods (e.g., Always Valid p-values, O'Brien-Fleming boundaries) or Bayesian approaches to allow for early stopping while controlling error rates. Emphasize communicating the risks of peeking to the PM and advocating for a full-duration test unless a valid sequential method is employed.

4. Q4

   In a marketplace-like Search feature, treatment users may affect control users. How would network effects or interference bias the experiment?

   MediumStatistics & Experimentation RoundA/B TestingGoogle-specific

   Context: Examples include advertiser supply, content inventory, delivery capacity, or pricing pressure.

   How to answer: Network effects in a marketplace A/B test can lead to interference, where the actions of treatment users impact control users, or vice-versa. This typically biases the experiment results, often underestimating the true treatment effect if the effect is positive (e.g., increased supply from treatment users benefits control users). The bias arises because the control group no longer represents a true baseline without the treatment's influence. This invalidates the core assumption of independent user groups, making direct comparison misleading.

5. Q5

   Midway through the Search test, tracking for Google Ads changed. How would you decide whether the experiment results are still usable?

   HardStatistics & Experimentation RoundA/B TestingGoogle-specific

   Context: Compare instrumentation versions, affected traffic share, raw logs, and sensitivity analyses.

   How to answer: A strong candidate would first identify the nature of the change (e.g., tracking pixel, attribution model, data schema) and its potential impact on key metrics like conversions or revenue. They would then propose analyzing pre- and post-change data for both control and experiment groups, looking for a significant shift or divergence in trends. Key methods include a difference-in-differences analysis or examining the change point for anomalies. If the change introduced a systemic bias affecting both groups equally and proportionally, the relative lift might still be valid; otherwise, the results are likely compromised or require advanced causal inference techniques to salvage.

6. Q6

   Refunds, cancellations, or failures are rising for Google Maps. Quantify the business impact and recommend where to intervene first

   HardProduct Analytics & Business CaseBusiness CasesGoogle-specific

   Context: Break the problem into customer experience, partner quality, operations, and policy effects.

   How to answer: A strong candidate would first clarify the 'rising' trend (magnitude, duration, specific product/service within Maps) and define 'refunds, cancellations, failures' (e.g., subscription refunds, ad campaign cancellations, API call failures). They would then quantify the business impact by estimating lost revenue (e.g., subscription fees, ad spend, API usage), increased operational costs (e.g., customer support, engineering debugging), and potential reputational damage. Finally, they would recommend intervention points based on a root cause analysis framework (e.g., user error, technical bug, pricing issue, competitor action) and prioritize by impact vs. effort.

7. Q7

   How would you grow high-quality advertiser supply for Google Play without sacrificing customer trust?

   HardProduct Analytics & Business CaseBusiness CasesGoogle-specific

   Context: Include supply quality metrics, incentives, onboarding friction, and long-term health.

   How to answer: A strong answer would propose a multi-pronged strategy focusing on developer incentives, quality control, and transparent communication. Key initiatives should include a tiered incentive program rewarding high-quality, engaging apps with better ad placements or revenue share, alongside robust developer support and educational resources. Simultaneously, implement stricter ad quality guidelines and review processes, leveraging AI and human moderation to prevent low-quality or deceptive ads. Finally, ensure clear communication with both advertisers and users about ad policies and quality standards to build and maintain trust.

8. Q8

   YouTube Shorts is preparing for a high-traffic event or sale. What metrics and analyses would you use to prevent a business-critical failure?

   HardProduct Analytics & Business CaseBusiness CasesGoogle-specific

   Context: Think capacity, inventory, payments, support load, latency, and real-time alerting.

   How to answer: To prevent a business-critical failure for a YouTube Shorts high-traffic event, I would focus on a tiered approach. First, establish key performance indicators (KPIs) for system health and user experience, such as server response time, error rates (5xx, 4xx), database query latency, and content loading speed, setting clear thresholds for each. Second, implement real-time monitoring dashboards with alerts for any metric exceeding these thresholds, categorizing alerts by severity. Third, conduct pre-event load testing and stress testing to simulate expected and peak traffic, identifying bottlenecks and scaling needs. Finally, develop a rollback plan and a communication strategy for incident response, ensuring quick resolution and transparency.

9. Q9

   Design an executive dashboard for Google's Search. What KPIs, filters, comparisons, and drill-downs would you include?

   EasyDashboarding, Stakeholder & Hiring Manager RoundDashboardingGoogle-specific

   Context: Audience is leadership; avoid vanity metrics and make actions clear.

   How to answer: A strong answer would propose an executive dashboard for Google Search focusing on key business objectives: user engagement, revenue, and product quality. Key KPIs would include daily active users (DAU), search queries per user, ad revenue per query, click-through rate (CTR) on ads and organic results, and search latency. Essential filters would encompass timeframes (daily, weekly, monthly, quarterly), geographic regions, device types, and search query categories. Comparisons should enable period-over-period analysis (e.g., WoW, MoM, YoY) and A/B test result comparisons. Drill-downs would allow executives to investigate specific regions, device types, query categories, or ad campaigns to understand performance drivers.

10. Q10

    You need to create a self-serve dashboard for Google Ads that PMs and business teams will use weekly. How do you define metrics and prevent misuse?

    EasyDashboarding, Stakeholder & Hiring Manager RoundDashboardingGoogle-specific

    Context: Include metric glossary, data freshness, filters, caveats, and examples.

    How to answer: A strong answer will first define key metrics, categorizing them into performance (e.g., CTR, CPC, Conversion Rate), financial (e.g., ROAS, CPA, Spend), and operational (e.g., Impression Share, Quality Score). For each, specify clear definitions, calculation methodologies, and relevant dimensions (e.g., campaign, ad group, geography). To prevent misuse, emphasize data governance through clear documentation, tooltips, and a glossary. Implement user training, access controls, and validation rules, and establish a feedback loop for continuous improvement and clarification.

11. Q11

    Design a funnel dashboard for Google Play from first exposure to qualified click. How would you highlight the biggest conversion opportunities?

    MediumDashboarding, Stakeholder & Hiring Manager RoundDashboardingGoogle-specific

    Context: Include step-level conversion, drop-off contribution, trend, and segmentation.

    How to answer: A strong answer outlines a multi-stage funnel: Impression (Play Store search/browse), View (app page), Interaction (scroll/video play), Install Click, and finally, Qualified Click (e.g., app opened, first action taken). Key metrics for each stage would be counts, conversion rates, and drop-offs. To highlight opportunities, candidates should propose a 'biggest drop-off' visualization (e.g., a waterfall chart) and segment analysis (e.g., by device, country, app category) to identify specific user groups or app types underperforming. A/B testing insights and qualitative feedback integration would also be valuable.

12. Q12

    Design a retention analysis for Google Ads. Which cohorts, time windows, and segments would you use?

    EasyProduct Analytics & Business CaseProduct AnalyticsGoogle-specific

    Context: Make the cohort definition precise and explain how you would separate activation from retention.

    How to answer: To design a retention analysis for Google Ads, I would define cohorts based on the month of their *first ad campaign launch* or *first significant ad spend* (e.g., $100+). Time windows would be measured in months or weeks post-cohort entry, tracking key engagement metrics like active campaigns, ad spend, or conversions. Segments would include advertiser type (SMB vs. Enterprise), industry, ad product used (Search, Display, YouTube), and geographic region to identify specific retention drivers and drop-off points.

13. Q13

    A new Google Maps feature has 30% adoption but no movement in query success rate. What analyses would you run before calling it unsuccessful?

    EasyProduct Analytics & Business CaseProduct AnalyticsGoogle-specific

    Context: Consider exposure, eligibility, frequency, quality of adoption, and segment fit.

    How to answer: A strong candidate would first segment users by adoption status (adopters vs. non-adopters) and analyze query success rates within each group to isolate the feature's impact. Next, they would investigate potential confounding factors such as user demographics, device types, or geographic location, as well as the specific types of queries being made by adopters. Finally, they would consider the feature's intended goal beyond query success rate, such as engagement, retention, or user satisfaction, and analyze relevant metrics to determine broader success.

14. Q14

    Evaluate search or discovery quality for YouTube Shorts. Which metrics would tell you whether users are finding what they want?

    MediumProduct Analytics & Business CaseProduct AnalyticsGoogle-specific

    Context: Include query refinement, zero results, click depth, conversion, and long-term satisfaction.

    How to answer: To evaluate search/discovery quality for YouTube Shorts, key metrics would focus on user engagement and satisfaction post-discovery. Important metrics include 'Watch Time per Short Discovered' and 'Completion Rate' (percentage of a Short watched). Additionally, 'Repeat Engagement' with the creator or similar content, 'Likes/Dislikes', and 'Shares' indicate content relevance and user satisfaction. For search specifically, 'Click-Through Rate (CTR) on Search Results' and 'Search Refinement Rate' would be crucial to assess if initial results meet user intent.

15. Q15

    Google wants to personalize Google Ads. What are the risks of optimizing for short-term engagement, and how would you measure long-term quality?

    MediumProduct Analytics & Business CaseProduct AnalyticsGoogle-specific

    Context: Discuss filter bubbles, partner fairness, novelty, fatigue, and retention.

    How to answer: Optimizing Google Ads for short-term engagement risks user burnout, irrelevant ad exposure, and ultimately decreased long-term user satisfaction and advertiser ROI. This can manifest as 'click farms' or 'ad stuffing' where engagement metrics are gamed without genuine interest. To measure long-term quality, I would track metrics like user retention (e.g., 30-day, 90-day active users post-ad interaction), conversion quality (e.g., post-click purchase value, subscription renewals), and advertiser churn rate. Additionally, A/B testing with a long-term holdout group and user surveys on ad relevance and satisfaction would be crucial.

Practice these with instant AI feedback in a live mock interview → Start a Google Data Analyst mock

Master DSA and communicate your thinking out loud; use Google's structured Explain-Clarify-Improve approach; prepare for Googleyness/behavioral

Indicative Data Analyst pay in India: ~₹6–22 LPA (role-level range, not a Google-specific figure).

Other roles at Google

Data Analyst interviews at other companies