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

Nikita G. - "Thanks for the question. The way I would like to proceed with this question is firstly, to get more context about the problem by asking some clarifying questions and narrowing the scope. Then, I would like to break the problem into smaller components to understand where exactly our problem lies. Then make a user journey for that particular area and identify the technical and non-technical factors which might affect this change specific to our company/product. Post that, I'll analyse the external"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

Sachin P. - "The key here is a) not to overreact to Sales bypassing me going straight to Engineering (while understanding every team acts according to their incentives), and b) communicate with all parties as much as possible to get everyone on the same page. 1) First, I'd speak to Sales and understand the feature being requested. I consider Sales to be one of the most important primary research funnels - they have direct, regular touchpoints with the client and are finely attuned to the lifeblood o"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

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

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

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

Manish E. - "Clarifying questions: US-based? And All year including holidays? First, what is the goal? Grow user base of Prime? Add revenue? I'd imagine it's to grow Prime base, as it's sticky and I imagine the Lifetime Value is higher as people will shop more if they have Prime. Then, I would look at the users. What are they trying to do? They're purchasing gifts, and looking to gift wrap. Take a look at the number of gift purchases total with gift receipt and no gift wrap. Call this X. Break thi"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

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

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

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

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

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