Interview Questions

Mohit C. - "-- LTV = Sum of all purchases made by that user -- order the results by desc on LTV select u.user_id, sum(a.purchase_value) as LTV from user_sessions u join attribution a on u.sessionid = a.sessionid group by u.user_id order by sum(a.purchase_value) desc"See full answer

Abdurhman M. - "Graphic design is the process of visual communication and problem-solving through the use of typography, photography"See full answer

Chayan R. - "Clarifying questions: You said on average, having 5 reviews can have positive impact, so I am assuming we will plan to pay for 500 reviews. Is that correct or am I missing anything here ? One information which seems to be missing here to come up with the exact price per review is the number of active visitors from which we are calculating the sales conversion rate. Do we have that information or I should include that as a variable in the price per review. ( assuming we are taking that as a var"See full answer

Anjali M. - "Colleague moved to a different role, so I decided to fill in and did outshine in showing results within the group."See full answer

Reno S. - "import Foundation func spiralCopy(inputMatrix: [[Int]]) -> [Int] { let arr = inputMatrix var top = 0, down = arr.count - 1 var left = 0, right = arr[0].count - 1 if top == down && left == right { return arr[top] } var ans: [Int] = [] while top <= down && left <= right { for i in left..<right { ans.append(arrtop) } for i in top..<down { ans.append(arri) } fo"See full answer

Anonymous Hummingbird - "Q: How do we know that they spend too much time in the app? A: User research/Qualitative survey goal: decrease dissatisfaction that they spend too much time in IG Persona's, lets segment based on usage: New users: just signed up and getting the hang of it lurkers: don't post or engage, just follow contributors: post occasionally (stories + posts) super users/micro influencers: post daily, engage with commenters, spend a lot of time in discover tab IG mission statement is to capture and s"See full answer

Olasile A. - "How would you decide on ad placement on Pinterest? First I would ask clarifying questions as to the reason why no ads have been placed in the top left section of the page feed. Is this more strategic to Pinterest's mission? Is this by design to lay out the architecture of the page feed this way? In the prompt, it is explained that the company is targeting revenue increase as a goal this quarter. Are there alternatives means to generate more revenue in order not to compromise our values an"See full answer

Irina L. - "I’ve named Netflix, Acloset, Youtube music. Focused of YouTube music, increasing social interaction of existing users."See full answer

shg - "In my experience, project success translates to three things: Customer Success => Quality increments to service leading to customer success. (Measure by KPIs like customer satisfaction score, SLA, Revenue growth etc) Team Success => High Team morale with successful execution and collaboration of project. Individual Success => Individual career goals and aspirations are met I think the later two are difficult are measured via KPIs. Although there can be indirect KPIs to measure those as we"See full answer

M N. - "Driver retention is important to ensure growth since we need healthy retention of existing drivers while we acquire new drivers so that we meet growing demand. Should we look at a specific driver segment to improve retention? We might divide the drivers by their age on the platform: New drivers(less than 3 months since first ride), Medium age (3mos to 1 year), Long term(1+ years). Let's focus on the medium term since I assume them to be the biggest segment. Now lets try to list out possible pr"See full answer

Pm P. - "Alexa: Is the virtual assistant that runs on amazon smart speakers as well as on other devices. Clarification on goals/Objectives: What would the goal at that point of time be? Is it increase in revenue ? Either via new customers i.e. adoption or Increasing the wallet share of the customer? Increasing the sales ordered via Alexa ? Why do people want to use Alexa? To get answers, make their lives easier by automating activities within their home Integrates with amazon account so"See full answer