Google Analytical Interview Questions

Aeshvarya J. - "Clarifying questions : When we speak about video buffering, are we looking at long video (more than an hour), medium video, short videos and shorts? I will assume its all video types. Is this was a steady increase or sudden one and over what time period? I will assume sudden one over last week? Has we experienced any such issues in the past or trends? I will assume no. Are we experiencing this globaly or for some region? I assume globaly The KPI we are measuring is Average Video Buffering T"See full answer

Stanislav I. - "First, take a BIG short position in Tesla stocks!"See full answer

Anonymous Krill - "Clarify the question. Any specific system? Will study the related systems in the environment. Will define the goal, attributes of the system, stakeholders expectations, problems this system is going to address in case these things don't exist already. With the above two steps, I Will come up with a draft of the System KPI. Will run it with leadership, stakeholders and will incorporate feedback. In parallel, will come up with quantification on these performance factors. Fina"See full answer

Dev S. - "Since you have indicated that the drop has been from the past few days and it is the sales drop. Assumption 1: It is not a gradual decrease and something that has been seen in the last few days. My assumption is the e-commerce site is a google store site where google sells all the products. At a very High-level the decline in sales could be caused by customers buying less on the site, customer churn, or decline in new customers, higher cart abandonment rate, checkout process. I would struc"See full answer

fuzzyicecream14 - "1. Sales & Revenue Metrics Total Units Sold – Tracks overall headset sales volume. Revenue Growth (%) – Measures whether revenue is increasing from headset sales over time. Sales by Channel – Identifies how sales are distributed across Google Store, third-party retailers (Amazon, Best Buy), and carrier partnerships. Sales by Region – Helps understand geographic demand and refine regional marketing efforts. Attach Rate – Measures how often the headset is purc"See full answer

Cameron P. - "Assuming I am a PM for company X and my current task for the morning is resolving a new conflicting product requirement. First I would like to inquire more about the product and about the conflict. Product: Assuming I am new and I didn’t already know what the product was, what is our product's value proposition to our customers? How does our product align with our company's goals? What does success look like for our product? Have we been successful in the past? Who are our customers? Conflict"See full answer

Anonymous Muskox - "Goal/Vission of company Understanding of Whatsapp -> Whatsapp platform for people where they can connect with people remotely, they can chat with them, they can do a video call, they can send pdf, location, contacts, etc. Basically, clarify your understanding of WhatsApp. Whatsapp Goal -> connecting the people remotely in a hassle-free manner Vission 3-4 years down the line -> More engagement and retention of the users. For this vision what is the user's intended action Define"See full answer

Tian H. - "google photos: edit, organize, search, and backup your photos. both android and iOS users can use google photos. together with the google drive, users can have 15 gigabytes free storage. photos market: main competitor, apple photos. this is a relatively mature market with two biggest players. when evaluating the acquisition, retention/engagement, rev, we would focus more on the retention. Higher retention and more usage are also strong signals of upgrading to larger storage and rev growth. "See full answer

Agnes D. - "Clarify: What is the objective? Grow user base of Prime or add revenue? Hypothesis: I believe it would be to grow user base of Prime. In that case, I would look at the target users for this – which will be mostly Non-Prime members whom we are trying to convert to Prime users. If I analyze who would be interested in purchasing gifts and having them gift-wrapped, user segmentation would not really add value as age, gender or geographical segmentation will not provide much differentiatio"See full answer

Rahul R. - "I would first call out the two types of Google Doodles that are published. First would be the static doodle which just shows a picture, and users can get more information on it by hovering on it or clicking on it. Second would be the dynamic google doodles which are either short videos or games through which users engage a bit more. My top 3 metrics that covers both would be: Click-through rate and post-click CTR - Although different metrics, I clubbed them since they fall under similar"See full answer

Saket S. - "I will look at the % of overspend. If we are within 10%, I would not worry about it too much as most budgets factor in 10% contingency. If Budget has exceeded 10% Threshold, I will use the following approach: Deep dive on current status: Understand % work completed/accepted Analyse Schedule/Time progress Understand Project Priority: P1/P2/P3 Resourcing: Internal/External Complexity: Technical design (Number of Applications involved/ Number of Interfaces to be build e"See full answer

Sunflower - "Can you clarify how we define cyberbullying? To me, it means negative or abusive content targeted towards an individual or a group. This can be in the form or text or media. Lets talk about Reddit as a product: To enable positive discussions on diverse topics. Did I miss anything here? Lets talk about users here: We have: Teenagers: 13 - 19 years old Millennials: 20 - 39 years old Gen X and Baby Boomers: 40+ I think teenagers are the most vulnerable and the highest priority group for this use"See full answer

Rustam - "There are number of ways where an app could lose users. I would try and speak with the following teams to figure out the issue. Data Team - I'd ask data team to see if there are any drops in the existing game funnels. There could have been an issue in game design. Potentially players could have gotten stuck on a super hard level and left or flew through a puzzle that was too easy, and also left. Essentially, figuring out the progression curve of the game, which often times can lead to play"See full answer

Sarabjeet S. - "Goal of YT search is to enable quick access to a video of interest to user. So success for YT search would mean access to videos that interest, and user actually clicks on one or more searched videos to watch them. It also means reduced time searching overall, with high relevance results shown for search string. Actions performed by users are: Goes to the YT site or Mobile app Clicks on the Search window to type Enters search string and presses enter Browses the list, scrolls"See full answer

Anonymous Flamingo - "As a product manager, my first step in designing a free product would be to define the product's target audience and the problem it aims to solve. Once these factors are established, I can then determine the best way to monetize the product. One way to monetize a free product is through advertising. This involves displaying ads to users as they use the product, and earning revenue based on the number of clicks or impressions the ads receive. This model is commonly used by social media platforms,"See full answer

Pathworks P. - "I would begin by asking the following clarifying questions: Are there any special use cases such as VIP Penthouse access, restricted floors etc? Do we need to consider safety requirements or other technical constraints such as maximum load/capacity? If the lobby for the entire hotel located on the ground floor? Can we assume that the majority of the guest amenities are located near the lobby and lower floors? Can we assume that the passenger controls on the floors are purely directional"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

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

Aniket A. - "Clarification: Is it consumer facing or business? -- consumer Launch is global or regional? -- global Is this full blown launch or beta release? -- full blown What goal does this app serve? How is it aligned with the company goals? -- AI Chatbot Can you explain the strategic importance of the app? -- gain market share; compete with other players who are already ahead in the market Do we have any data around potential customers/TAM with this app? -- billions of users "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