Google Analytical Interview Questions

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

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

Anthony F. - "Asked clarifying questions to know if this was a program already in existence, how long the problem had been, causes and how the problem was brought to attention. Using that information, went through a framework (provided generally below): Making sure to review documentation/existing contracts/vendors/plans. Review budget and timeline for the program. Review resources available. Review the data (or gather) and the scope of the project (city center, suburbs, few blocks, whole city, etc). Set mee"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

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

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

Krishnan S. - "I would start with few clarifying questions for the investigation and diagnosis of the problem. Timing and volume: For how long is the peak surge being noticed? Past few days / weeks / months? Clarify about 'certain times'. Is it weekday Morning (Peak), Morning (off peak), Afternoon, Afternoon (peak), Evening (peak), Evening (off peak) or weekend? Do we info on vehicle type that have the most volume? Cars, trucks, commercial vehicles, etc., Location and convenience of the gas st"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

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

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

Rahul J. - "Netflix Solves a problem that's mass market High importance and people actively looking for new solutions Value proposition Variety of content reasonable prices for tier 1, 2 and 3 cities Available on mobile, desktops and tablets Business model: subscription based, Revenue = f { # of users, lifetime of subscription, fee charged to user } --> Should Improve engagement to increase lifetime. User journey: Find content: Search for it / take a recommendation Watch it Give"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