Analytical Interview Questions

Sri A. - "Success for Yelp reviews. (assuming these are standard reviews posted by customers, for a restaurant or bar or a cafe listed on Yelp. Has a 5-star calibration that users can enter and free-form text.) Select Metrics should span the entire funnel across adoption, engagement, quality, and overall impact for Yelp. Adoption metrics: Total # of reviews written, Avg reviews/ listing Engagement metrics: # reviews being scanned, marked as being useful, etc. Quality metrics: %ge of disputed"See full answer

Spencer W. - "A YoY decline in conversion actually seems like it's not that unexpected of a finding but I think you'd need to know how Nike operates. They regularly release sneakers that are limited edition, highly-sought-after, and are sold out within seconds of release. So there are probably a lot of people who are able to add items to their cart, only to find out that the items are actually sold out before they are able to complete the sale. If that were the root cause in this question, I'm curious if ther"See full answer

Rudra pratap S. - "Spotify is a platform which allows users to listen songs across the globe with variety of songs+singers and also gives opportunity to singers to create some money. It’s mission is to unlock the potential of human creativity by giving a million creative artists the opportunity to live off their art and billions of fans the opportunity to enjoy and be inspired by it. Spotify’s discover weekly feature is well aligned with the mission of Spotify as it recommends songs based on their previous content"See full answer

D I. - "Is this considered to be a passing answer for a Google interview? Seems very basic and shallow, but hey.. Train the model on what? How do you label something as bullying or not. Seems like it's a classification problem, or personalization problem. Also remedying in the problem was very weak."See full answer

Soodong P. - "Product and Mission To allow users to create events and host on FB pages. It can be one time or recurring. It can include FB users through feeds or referrals or can be shared out with a link. Product objective is to build strong online and offline bonding through connecting people with common interests and ensure continued engagements. Aligns with the core Meta mission. User Journey and Value + Metrics Organizers: Finds the value when the many participants share interest or"See full answer

Jack F. - "What is our goal during onboarding? e.x. Site-visits, add-to-cart, completed checkout etc? After asking clarifying questions we learn that our north-star goal is to get more customers to complete a checkout, therefore our goal is to increase our conversion rate. Are we looking to sell more of a particular product or increase conversion rate holistically? Segmentation: Do we have a particular market or demographic in mind? Commercial/business vs. individuals One time buyers vs. repeat purch"See full answer

Michelle D. - "I'd start by trying to understand the high level north star for Stripe Atlas with respect to Stripe's mission of increasing the GDP of the internet. Example north star: Increase successfully created startups MoM, YoY I'd ask the interviewer to confirm my understanding on the following: Atlas allows entrepreneurs to easily launch their startups within a matter of only a few days from signup to receiving a tax ID. I would take this understanding and understand the input metrics towards the n"See full answer

Ajinkya P. - " I would ask some clarifying questions to refine my objective and know about our users? What do you mean by experience? Travel, food, short stay, long stay, dating, event, work, airport, registration? - Improve Food, Travel, Event experience, which can be a short or long stay. What do you mean by the movement to a new city? International travel/ within a specific country (designing solution for any country?) or any geography? - within a country suppose India What is our business objecti"See full answer

Apurv W. - "Clarify: Understanding of wallets an UPI What is failure rate here? - transaction failed Is it real time failure or successful on front end but failed in backend - assuming it is front end, real time failure. Have other related products/features experienced the same change? Diagnose (impact, significance) Failure rate = assuming it is significantly increasing Impact = customer lifetime value, # of bookings, Avg order value and satisfaction too. Users & value Seller = Revenue "See full answer

Nikita B. - "Mission for TikTok shop is to increase brand growth and sales. TikTok gives platform to these brands/advertiser to market their products via influencers/creators to be able to sell their products faster and users on tiktok platform(mainly Gen-z) are motivated to make inspirational based discovery of products and purchase them So main objective for TikTok shop could be Increase sales for diverse brands So, some of the metrics to consider would be: no of orders placed per week"See full answer

Yuexiang Y. - "clarify: so does the 5% drop a sudden drop or overtime in the one week does it broadly drop 5% or it dropped only in some regions or in some segments like new acqusition / frequent active customers? or does the 5% drop also happened last year same period? DAU = acqusition x activation x retention segment: I will first quickly do some EDA to find out problem, like calculate the DAU drop in new customer, tenured customer, between regions to find out is there any difference. then I will also look"See full answer

Kartikeya N. - "Clarifying questions What do we mean by bookings? Is it nights booked or transactions?: Nights booked Are there any constraints like platform or anything else while calculating the nights booked? : No If a user books a night but does not show up, do we still count him? : Yes If a user cancels before turning up, do we not count him? : Yes Expedia operates globally. Its major markets are Europe, USA, Asia, Africa etc. We will take the following high level approach **Total population →"See full answer

Arthur Y. - "Clarifying Questions: What are Discovery features on IG? My assumed answer: posts of followers you don’t already follow that you see on the Discovery tab of IG. The posts consist of video clips, IGTV posts, and pics. User can browse through endless scroll of posts, and can filter by category (e.g. sports, comedy, etc.) on the Discovery tab. Exclude IGTV and IG Shopping, which can also be accessed by Discovery tab, and just focus on Discovery of users you don’t already follow as"See full answer

Saket S. - "I will use the following approach for this situation: Understand Current Status of the Program: Program Goals, Schedule, How many teams, what are their deliverables, dependencies between teams Team level view of progress: Through tools like Burn down charts, Gantt charts etc. Identify laggards (lagging teams). Trend analysis for lagging teams: Understand at what point, the decline started. If the decline has started around same time, then following may be the potential issues: -"See full answer

Malvika S. - "Top three most important variables Uber could use to estimate the ETA for passenger pickup, beyond the ETA on Google Maps can be: Driver related - sometimes driver cancel rides after they are assigned or agree to pickup, especially at odd hours. Sometimes, they can also cancel midway through their journeys. Other factor can be that they drive slower or faster than google maps ETA. Car related - The car may be old or not maintained well than other cars. It can be CNG, Diesel, petrol or elec"See full answer

Harsh W. - "Me: That's an interesting challenge. I would like to get some clarifications before jumping into potential solutions. Are we talking about the global search market irrespective of device or are we talking about a specific geography / device type? Interviewer: Lets go ahead with all possible searches. Me: Ok. Is there a specific reason we want to capture a significant market share from Google (e.g. higher search revenue, cross-selling MSFT services etc.) and are there any timelines we should k"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

Meagan R. - "Collaborate with the team to determine which team's product will move the needle the most in achieving the strategic goals and prioritize that work."See full answer