Google Analytical Interview Questions

Coach - "Great question, give me a moment to collect my thoughts…. When faced with a situation where a product defect is impacting my customers as a product manager my goal would be to roll out a quick & effective enough solution that minimizes the negative impact on users. I would seek available incident information to understand, its blast radius i.e. the impacted users, platforms, duration, if available understand the nature of failure i.e. recoverable vs not, it's root cause and short/long t"See full answer

Anonymous Muskox - "Clarification Questions Understanding of Netflix -> clarification Clarification regarding the meaning of logged into the platform -> not coming back or they are logged out From how long they we been seeing this issue and is this issue gradual? Which demography or geography are we talking about? The metrics which we are tracking are actually working or not? Internal Factors Any infrastructure problem, frequently "App not responding" or frequently auto log out? Any pa"See full answer

Karthik M. - "I would always pick a specific product and make a case. Answering this question without a specific product in mind makes the answer unstructured in my opinion. For instance, I would pick Gmail as an example to answer this and structure my response. Clarifications & Assumptions Let us pick a specific product and structure our response - for instance - let us pick Gmail as the product that you want to analyse and make a Go / No Recommendation to Sunset the Product. Overall Google Revenu"See full answer

Meenakshi sundaram M. - "Structure: 1. Ask Clarifying Questions 2. Look at external factors 3. Look at Internal factors ( Slice the data aross different cuts and plan accordingly) Clarifying Questions: What's an outbound message? Is it something Linkedin users send among each other? Decline trends: Is the decline steep or gradual? From when, are we seeing this decline (Say since a week, fortnight, month, etc) External Factors: Have we seen any competition led changes/ new campaigns etc? Have we see"See full answer

Prateek S. - "Clarifying questions: Why are we fixing the roads? Is it due to temporary damage or something structural has gone wrong? What is our purpose behind fixing the roads? Increase mobility in an area? Reduce inequality? reduce crime? Assumptions: Roads have had temporary damage due to rain / storm We know the specific roads which are bad and will need to be fixed Want to increase commercial traffic. Want people to visit a specific area which has bad roads and slow moving traffic. W"See full answer

Shreya S. - "Firstly, I would like to be in a room with all the stakeholders (tech/business) and the decision makers. Now starts the analysis of the situation. Certain questions that I will be looking for an answer are- Is this a new issue? or an old one? What is the severity and priority of the feature in the release? In terms of business values. How long would it take the engineering team to fix the issue? Can we manage for a workaround meanwhile the issue gets fixed? What are the risks inv"See full answer

Raymond W. - "Clarifications/assumptions - we're only interested in opening and closing hours, not serving times e.g. breakfast or lunch time format etc will be local only interested in regular hours not special holiday hours Potential users/data providers (ranked by order of authority) Businesses/Advertisers Consumers Google Goal Coverage Prioritising the most popular restaurants, or those who are willing to invest in advertising Accurate, but conservative - better be wrong to"See full answer

Y C. - "One way to develop project metrics is around what problem the project is trying to solve within a particular timeframe, at a cost of x dollars and with y quality Scope: Did the project deliver as per the problem statement - over and beyond Resources metrics: Planned resources were utilized to contribute to the success Budget: Did the cost of the project implementation be under the budget or over? Schedule: In-flight milestones were completed on time or not as per the plan Was the proje"See full answer

Gk K. - " can we use blomfilters to check existing usernames? and if both are creating at a time, like both are choosing some abcd , here system checks whether user with that name exists or not. so while checking , it will add an entry on redis (example) with this name as key and obtain lock using some distributed lock. , it will lock on that name. (like seat booking in bookmyshow) with some TTL value. so this check will happen once user enters his interest username and also while submit .. 2 times che"See full answer

Rika S. - "Let's start by understanding Google's goals with Search. Google Search is by far the #1 search engine, capturing 70% of the search market. There are probably two reasons why Google would bid to maintain its place as the default search engine on Firefox: the first, Firefox is a popular web browser, with many users, and Google wants to retain the large user base who search on Firefox. Second, Firefox users tend to be more privacy oriented than users of other browsers, therefore Google wants to c"See full answer

Christopher K. - "Amazon is releasing a product recommendation carousel. Q1. How would we approach this launch with executive leadership? Q2. How would you obtain the data to find out if you should launch and what sample size should your testing batch be for an A/B test scenario? Clarifying Questions What is the current goal for the product recommendation - Increase sales How does the current product recommendation view look like on the home page - A mosaic list view Are there any existing custome"See full answer

Anil K. - "Acquisition New sign-ups for Google Drive Service Google Drive app installs Activation Number of users with at least one file since sign-up Paid Google Drive Users Engagement DAU, MAU Sessions, Frequency Time spend Files accessed per session Task completion - sharing file, setting up automatic back up etc. Retention % Repeat Users % Users Churning out Google App Uninstalls Referral Inviting"See full answer

Coach - "Product "XYZ" explain what it is and which audience it is serving. Goals Ease the anxiety Offer the most comprehensive perspective of Cloud Engagement Democratize Upsell Insights Business Review Deck Slide #1: NPS - Now, Trend & Insights + Call To Action: FYI & solicit feedback Slide #2: User Engagement Update - DAU, WAU, MAU, Actions Completed + Call To Action: FYI & solicit feedback Slide #3: Partnership Update - Share new cross org collabor"See full answer

Pm P. - "Clarification: What does "share" imply? is it the action of sharing the app or website ? My assumption here we are not talking about stock market share :P, other factors come into play there. Diving-in: I would like to classify the questions into 2 buckets Internal Do we have data on which platform the shares increases and split up by Mobile and if mobile via app or via browser, split by apple/android, split via desktop, tablet . Essentially source of the shares. What this will t"See full answer

Calyan - "Hangouts 100k feedback gave 3* rating, in 2013. What to do next Clarify: Solving for 2013, should disregard changes made (Allo, Gchat, Gmeet) since then? [yes] Is this on any specific platform - App Store or Play store? [both] Consumer or Enterprise [consumer] Problem framing - - - - - - - - - - - - - Mission: org world info., be helpful. Hangouts role in this mission to help users stay connected, exchange info and content (via messages and calls) Biz/ Prod goals Growth/ acq Install ba"See full answer

Katie - "Union−Find -We illustrate our basic approach to developing and analyzing algorithms by considering the dynamic connectivity problem. We introduce the union−find data type and consider several implementations (quick find, quick union, weighted quick union, and weighted quick union with path compression). Finally, we apply the union−find data type to the percolation problem from physical chemistry. Analysis of Algorithms -The basis of our approach for analyzing the performance of algorithms is th"See full answer

Madhu K. - "Define success for Youtube search I would start with clarifying questions / assumptions, followed by mission of YouTube (YT). I would then list down a few metrics that would be guided by the goal of YouTube and which user actions link to that goal and finally which of them should be used to define success. Clarifying questions: When you say YouTube search, can I assume only text search for now and exclude voice search ? Interviewer: Thats fine. We can stick to text search for now. "See full answer