Google Analytical Interview Questions

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

Pm P. - "Since success metrics is a very broad term, to dive deep into WCS - What constitutes success. What is the objective of the company/product, north star/mission of the organization or product? Dependent on the company, market, the industry they play in. As an example: Facebook's mission is now empowerment, bringing the people together and giving them the power to build communities. Every part of its product aligns in one way or other with this goal. Be it, its Web/Mobile platform, Instagram,"See full answer

Will P. - "The first step is to clarify what the interviewer means by a sales decline. Questions I would ask here include: Did sales drop suddenly or gradually? What is the magnitude of the sales drop? Are sales down for a specific product? Are sales down for a specific channel (drive-thru, walk-in, etc.)? This series of questions is to make sure we are on the same page when we say 'sales are down.' We may not know the why yet, but the what should be easy to align on. Otherwise, how would"See full answer

A F. - "Clarifying questions: 1M users- are these paying users? Daily active users? Once we know which users, we look at certain areas of initial investigation for patterns: Dashboards: Is this a flaw in the dashboard, or metrics pipelines not running? (Assuming not a problem) Geography: Are these users in a certain geolocation? (Ex: China bans the use of Netflix?) Users segments: Are these certain age group (kids, where parents might have restricted) or first-time users (they watched only one"See full answer

Roy C. - "Note: This is my answer that I generated loosely while I was practicing this question. I didnt want to go down the product design framework as this is more of an execution question, so I came up with my own zombified framework to focus more on strategy + execution. Open to feedback on my answer - understand its not the most perfect! Question: How would I launch a digital library product as a Google PM Clarifications: Standalone product? : standalone Region specific: No (up to me) Goa"See full answer

GSWarriors - "Clarification questions: Is it correct to assume that I am an insurance company provide insurance coverage for Waymo? yes Is it safe to assume that we are talking about self-driving cars (no drivers)? yes Several factors are taken into consideration when insurance companies provide insurance quotes (please not that all of these will apply to self-driving cars): M/F Age Years of driving experience Driving record Expected miles driven / year Cost of vehicle If car will be used for c"See full answer

Praniti S. - "Google VR mission - my understanding is to provide user an immersive experience where your room is the exploration ground/canvas and consumer has limitless possibilities What i know about VR : VR umbrella: Daydream and Cardboard VR devices: Headset/Cardboard/Desktop/Mobile VR product: Google Maps VR/ Carboard VR/Youtube VR/ TiltBrush/ Blocks VR feature: High quality video/ low latency video? Which product are we adding a new feature to? Tilt Brush which device are we implementing the new feat"See full answer

Googlepm 1. - "Clarifying questions like what is the end goal that we are trying to achieve ? Is it revenue Improving user experience Improving current state - load times / find times / web page rendering / images ? External API consideration Introduction of a new feature in Google Maps Branding related ? Introducing a lite version of Google maps , say for emerging markets ? Based on the above, calculate : What are the positives of the algos ? "See full answer

Henil S. - "Clarifying Questions Goal - What is the goal for launching a new recommendation algorithm? (Assume an increase in user engagement) User Persona Using a recommendation system to explore new artists/songs in the same genre Using a recommendation system to explore new genres of songs Using a recommendation system to explore to format of content(Podcasts, Comedy, Stories) Metrics to look at to analyze if we need a new algorithm or not. Metrics Number of songs listened to"See full answer

Joohi M. - "Think about 3 types of users - 1) User who only uses Google photos and no other Google product. What is the value that Google gets out of such user? 2) User who uses all the google products including photos but does not spend a penny on google photos (think of storage fee, buying photo albums etc.). How do photos increase the value provided by that user in conjunction with other Google products? 3) Use who spends money on Google photos. The value provided by the first user is through their pho"See full answer

Exponent - "You should be able to easily identify this as a Measure Success question. These kinds of questions are used to test your analytical skills, as well as your ability to track project progress post-launch. Recall the strategy for tackling them methodically and thoroughly: Ask clarifying questions State the goal of the feature / product Behavior Mapping / UX Flow Mapping Provide criteria to prioritize metrics Prioritize metrics Summarize Let's begin! "See full answer

Piya B. - "You are planning to start a grocery store. How many manual checkout and automated checkout aisles would you have? Clarify: Is this in an urban or a rural city ? For instance is this for NY, where population is 8m Densely populated? Not a franchise of walmart.or. A big brand Which means no restrictions? Approach This will definitely depend on my budget but also the target segment . For instance, for an older population, self checkout may not be very popular. Hence, I will be making some sweepi"See full answer

slouchingtowardssv - "Clarify the problem / make assumptions: What are we defining as misleading? For this problem, any video that contains information countering accepted scientific/research-driven results What is meant by fix? Does that entail removing said videos? For this problem, I want to see if we can minimize the amount of videos pulled from YouTube Intro to the product: YouTube is a video-sharing platform that was acquired by Google in 2006 YouTube's original mission statement:"See full answer

Ash K. - "Below is the step by step approach I would take: Identify potential risks: Firstly, I thoroughly analyze the project and identify potential risks that could impact its success. This involves reviewing project documentation, conducting stakeholder interviews, and seeking input from team members who have expertise in different areas. Assess the impact and likelihood: I evaluate each identified risk by assessing its potential impact on the project objectives and determining the likelihood of"See full answer

Sarabjeet S. - "Clarification - How is this feature accessed by users? Is it part of the camera app or after taking the photo or both? Assume both. Is bulk upload possible? Yes Goal - Drive engagement with this feature so Pixel owners upload more pictures to google photos Actions that support this goal of engagement with this feature: Click upload right after taking a photo from camera. Take a stored picture from saved photos and click upload for it Select multiple photos from saved photos and click u"See full answer

Calyan - "Launch p2p payments on a chat application Clarify - - - - - - - - - - - any specific chat app in mind? [no] Is there a 3rd party vendor tech we can incorporate [no, build grounds-up] Markets [US] Framing - - - - - - - - - - - Messaging apps mission: be the go-to destination for 1:1, n:n info sharing and comms. Use network effects to gain market share Biz/product goals: Growth, gain more market share Engagement: time spent, instances of interaction and sharing Revenue: ads,"See full answer

Negar H. - "SW: Headway (Audio book app) Goal: Track user engagement with the product. (Analytics) To Track user engagement with the product I would first define the user actions defined as user engagement, and then define quantitative metrics to track user behaviour. User actions -> engagement: Actions: User Plays an Audio book (following by user's retention) User uses Next chapter button to continue listening User marks Audio books as favourites User shares Audio books Metrics: DAU & 2."See full answer

Rev - "Narrow down on a person (born in city childhood - school - college - work - retirement) Age: 0-5 = ignoring travel for this part (might travel with parents) 5-19 = weekdays school, weekends outings School distance 5 km , total = 10km (to & fro) (4 intersections * 1min(time spent) = 4 min/ day) 52 x 5 x 4 = 1040 mins ~ 15 hrs 15 * 14 yrs = 210 hrs Weekends 52 x 2 = 104 days * 0.3 = 30 days Trips = 10 km (8 intersections * 1min(time spent) = 8 mins) 30 x 8 ="See full answer

Anuradha T. - "Clarifying questions: What kind of users are we talking about? Internal or external ? (Assumption: External) When was this issue discovered? (Not so long ago) Is this specific to a particular geographical location ? (Answer: No) External: Geography, time ? Internal: Pain points: Technical - latency, lag Engagement - Less engagement available on website , users are bored while waiting for their search results to appear Review - Explore platform options for users to review their experie"See full answer

Sadhana U. - "Know your audience Understand who the end user is and their role within the organization. Adapt technical lingo to lingo that can be understood by the end user. Diagrams of functions with less dense text is helpful for non-technical users. If it presents like a Manual, that's a turnoff. If it presents like a Guide, non-technical people can follow it. Simplify the problem By simplifying the problem you can explain it to your client in her/his own words. Try to use examples from the client'"See full answer