Google Analytical Interview Questions

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

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

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

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

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

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

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

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

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

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

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

Pattern P. - "In Drive > Slack > In Shorts Shortlisted for further discussion - In Drive (Ride Hailing App) Briefly: > \>> JTBD: > Search, Book, Cancel, Rate and Complain for Rides > > \>> User Segments: > Based on frequency of usage > User Engagement Metrics: > Use Cases or JTBD used interchaneably Frequency of all the JTBD Performed in a Unit Time (Breadth) Ratio of Searches compared to Book Ride in a Unit Time (Monetization Use Case) Ratio of Cancellations compared to Book Ride in a"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

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

RockyBalboa - "Clarifying question(s): what constitute a COVID related search? is it more on number of cases by geography, virus strains, vaccine information etc. ? Besides engagement is there anything we should take into account? Which personas are likely to be targeted: Journalists gathering more information for reporting Doctors and SMEs Common crowd with moderate to advanced education on health and safety measures and likely type of at-home entertainment Pharmaceuticals orga"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