"Functional Requirement
User should be able to add review the food item/order
User should be able to rate the food item delivered
User should be able to Like/Dislike others reviews
User should be able to see all reviews on a food item
Users should be able to receive rewards based on criteria- (Quality of the reviews- Based on number of likes - Monthly cash card)
OOS - Item is already ordered and exists in a separate system, User is authenticated. No Media
Non Functional requireme"
Anshika R. - "Functional Requirement
User should be able to add review the food item/order
User should be able to rate the food item delivered
User should be able to Like/Dislike others reviews
User should be able to see all reviews on a food item
Users should be able to receive rewards based on criteria- (Quality of the reviews- Based on number of likes - Monthly cash card)
OOS - Item is already ordered and exists in a separate system, User is authenticated. No Media
Non Functional requireme"See full answer
"Clarifying questions :
I would like to confirm what type of parking spots we are talking about, should we assume cars ? Assumption : Cars
Is it referring to only parking spots in non-residential complexes or public places or does it include residential too ?Assumption : both
Assumptions :
Places where we could see parking spots
Shopping malls
Parking in the park
Residence spots
Legal parking spots
Variables in play
Population = assuming a family of 4 => population / 4 (nu"
Karthik T. - "Clarifying questions :
I would like to confirm what type of parking spots we are talking about, should we assume cars ? Assumption : Cars
Is it referring to only parking spots in non-residential complexes or public places or does it include residential too ?Assumption : both
Assumptions :
Places where we could see parking spots
Shopping malls
Parking in the park
Residence spots
Legal parking spots
Variables in play
Population = assuming a family of 4 => population / 4 (nu"See full answer
Product Manager
Estimation
🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.
"Context - I joined a large public-facing service as a PM midway through its development.
Situation - Due to the SOPs of the company the team already had a metrics framework. That included your standard DAUs, Retention and Acquisition Metrics
Concern -
As SOP metrics were publicly accepted, the team did not internalise what success actually means to the product they are developing, as the actual value was not being encapsulated in the framework
This was evident in the show and tells as the"
Umang S. - "Context - I joined a large public-facing service as a PM midway through its development.
Situation - Due to the SOPs of the company the team already had a metrics framework. That included your standard DAUs, Retention and Acquisition Metrics
Concern -
As SOP metrics were publicly accepted, the team did not internalise what success actually means to the product they are developing, as the actual value was not being encapsulated in the framework
This was evident in the show and tells as the"See full answer
"Designing a Price Drop Tracker system like CamelCamelCamel involves creating a platform that tracks price changes for products on various e-commerce websites and notifies users when prices drop. Here’s a detailed system design for such a service:
Functional Requirements
User Registration and Authentication\:
Users can register and log in.
Support for social media logins (e.g., Google, Facebook).
Product Tracking\:
Users can add products to their watchlist for"
Scott S. - "Designing a Price Drop Tracker system like CamelCamelCamel involves creating a platform that tracks price changes for products on various e-commerce websites and notifies users when prices drop. Here’s a detailed system design for such a service:
Functional Requirements
User Registration and Authentication\:
Users can register and log in.
Support for social media logins (e.g., Google, Facebook).
Product Tracking\:
Users can add products to their watchlist for"See full answer
"These are a set of utilities used to manage the heap memory as part of an application. The C standard library implements these functions.
malloc(bytes) takes a number of bytes and returns a pointer to the start of the allocated buffer. If the allocation failed, a null pointer is returned instead.
calloc(count, size) behaves like malloc(count * size), but also zero-initializes the allocated buffer, assuming the allocation succeeded.
realloc(ptr, size) takes a pointer to a previously al"
J R. - "These are a set of utilities used to manage the heap memory as part of an application. The C standard library implements these functions.
malloc(bytes) takes a number of bytes and returns a pointer to the start of the allocated buffer. If the allocation failed, a null pointer is returned instead.
calloc(count, size) behaves like malloc(count * size), but also zero-initializes the allocated buffer, assuming the allocation succeeded.
realloc(ptr, size) takes a pointer to a previously al"See full answer
"
Compare alternate houses i.e for each house starting from the third, calculate the maximum money that can be stolen up to that house by choosing between:
Skipping the current house and taking the maximum money stolen up to the previous house.
Robbing the current house and adding its value to the maximum money stolen up to the house two steps back.
package main
import (
"fmt"
)
// rob function calculates the maximum money a robber can steal
func maxRob(nums []int) int {
ln"
VContaineers - "
Compare alternate houses i.e for each house starting from the third, calculate the maximum money that can be stolen up to that house by choosing between:
Skipping the current house and taking the maximum money stolen up to the previous house.
Robbing the current house and adding its value to the maximum money stolen up to the house two steps back.
package main
import (
"fmt"
)
// rob function calculates the maximum money a robber can steal
func maxRob(nums []int) int {
ln"See full answer
"Clarification questions:
What do you mean by online furniture-selling market?
Why would google want to do it?
Why does google want to do it now?
Where does google want to launch it?
Let me make the assumptions answering above questions:
It is like google flights, say we call it google furnitures, where it organizes, curates furniture information to the users and then refers to the seller website instead of selling furniture directly to the consumer like amazon, walmart, way"
Bimal M. - "Clarification questions:
What do you mean by online furniture-selling market?
Why would google want to do it?
Why does google want to do it now?
Where does google want to launch it?
Let me make the assumptions answering above questions:
It is like google flights, say we call it google furnitures, where it organizes, curates furniture information to the users and then refers to the seller website instead of selling furniture directly to the consumer like amazon, walmart, way"See full answer
"Meta Pay - What is it?
Payment platform that lets people buy and send money on Facebook, IG and Instagram
on platforms like FB and IG, people already find things they like and the businesses can sell directly on the platform through shops so Pay is closing the last mile and letting them also check out quickly once they’ve added their card details once. It’s making it a real one-stop shop.
It also allows making more transactions directly on the platform without having to enter card deta"
Rotem L. - "Meta Pay - What is it?
Payment platform that lets people buy and send money on Facebook, IG and Instagram
on platforms like FB and IG, people already find things they like and the businesses can sell directly on the platform through shops so Pay is closing the last mile and letting them also check out quickly once they’ve added their card details once. It’s making it a real one-stop shop.
It also allows making more transactions directly on the platform without having to enter card deta"See full answer
"Ask clarifying questions
1/ Are there any business changes to be aware of?
2/ Youtube Premium already exists so I am guessing we are not revisiting changing the prices just restarting the process from scratch
3/ Pricing for a specific market? North America, Asia, somewhere else?
To tackle this I would break down the problem into a few steps,
What is Google's mission and how Youtube premium fits into that
Google's mission is to organize information and make it accessible to all
You"
Glados - "Ask clarifying questions
1/ Are there any business changes to be aware of?
2/ Youtube Premium already exists so I am guessing we are not revisiting changing the prices just restarting the process from scratch
3/ Pricing for a specific market? North America, Asia, somewhere else?
To tackle this I would break down the problem into a few steps,
What is Google's mission and how Youtube premium fits into that
Google's mission is to organize information and make it accessible to all
You"See full answer
"Clarifying Questions:
Do we want to target a particular geography or location or should it be done globally? Assume global
Is there any particular platform and device we are targeting (App/web) or should it be cross platforms? Cross platforms
Can I think about it as Product led solutions or do you want to consider marketing alternatives as well? Let's start with Product led solutions & later if time permits, we can touch on the marketing side as well
Are there any constra"
Hashmina H. - "Clarifying Questions:
Do we want to target a particular geography or location or should it be done globally? Assume global
Is there any particular platform and device we are targeting (App/web) or should it be cross platforms? Cross platforms
Can I think about it as Product led solutions or do you want to consider marketing alternatives as well? Let's start with Product led solutions & later if time permits, we can touch on the marketing side as well
Are there any constra"See full answer
"CQ:
What's the goal - we are just exploring
Any specific timeline we are targeting - NA
Why specifically podcast - its a growing area and can help engage the customers
Any specific geography to be kept on mind - You tell
Approach:
Understand Netflix’s landscape
Understand more about the Podcast space via Porter’s 5 Forces framework
Decide mode of entry
Tradeoffs & Risk
Netflix’s landscape;
Product - OTT player
Who uses - kids, adults
When do they use – leisure"
Anonymous Newt - "CQ:
What's the goal - we are just exploring
Any specific timeline we are targeting - NA
Why specifically podcast - its a growing area and can help engage the customers
Any specific geography to be kept on mind - You tell
Approach:
Understand Netflix’s landscape
Understand more about the Podcast space via Porter’s 5 Forces framework
Decide mode of entry
Tradeoffs & Risk
Netflix’s landscape;
Product - OTT player
Who uses - kids, adults
When do they use – leisure"See full answer
"Clarifying question:
AOV/USER it means that the total price paid by a user in a certain period should be more than what it is now ?
Is the average taken on a daily/ weekly/monthly basis ? I would presume it to be a monthly basis , as it helps us a defined period of time to analyse user beharviour and track number of orders. Daily wont be succesfull mertric , as ocassionally only a user may order multiple times in a day , also weekly is also a viable metric but that wont help us to analyse"
Sdn D. - "Clarifying question:
AOV/USER it means that the total price paid by a user in a certain period should be more than what it is now ?
Is the average taken on a daily/ weekly/monthly basis ? I would presume it to be a monthly basis , as it helps us a defined period of time to analyse user beharviour and track number of orders. Daily wont be succesfull mertric , as ocassionally only a user may order multiple times in a day , also weekly is also a viable metric but that wont help us to analyse"See full answer
"I generally struggle with stakeholders and partners who doesn't communicate enough. Now it could be either they don't invest sufficient time and energy in doing so or at times they lack the skill sets to do so. In both the cases, the entire responsibility fell on the other person to dig deep into why someone is doing the way they are doing, reading into patterns and behaviour of their personality and adapting to those communication styles"
Lati K. - "I generally struggle with stakeholders and partners who doesn't communicate enough. Now it could be either they don't invest sufficient time and energy in doing so or at times they lack the skill sets to do so. In both the cases, the entire responsibility fell on the other person to dig deep into why someone is doing the way they are doing, reading into patterns and behaviour of their personality and adapting to those communication styles"See full answer
"Best practices for prioritizing customer service requests
Prioritizing support requests is a key part of creating a customer journey optimized for maximum revenue. If you want to start using a ticket prioritization process that will boost both customer satisfaction and your bottom line, we've got nine proven best practices below:
Respond to your most loyal customers first
Tag repeat customers as high-priority tickets
Automate simple requests wherever possible
Mark tickets with urg"
Hayatu H. - "Best practices for prioritizing customer service requests
Prioritizing support requests is a key part of creating a customer journey optimized for maximum revenue. If you want to start using a ticket prioritization process that will boost both customer satisfaction and your bottom line, we've got nine proven best practices below:
Respond to your most loyal customers first
Tag repeat customers as high-priority tickets
Automate simple requests wherever possible
Mark tickets with urg"See full answer
"WITH filtered_posts AS (
SELECT
p.user_id,
p.issuccessfulpost
FROM
post p
WHERE
p.postdate >= '2023-11-01' AND p.postdate < '2023-12-01'
),
post_summary AS (
SELECT
pu.user_type,
COUNT(*) AS post_attempt,
SUM(CASE WHEN fp.issuccessfulpost = 1 THEN 1 ELSE 0 END) AS post_success
FROM
filtered_posts fp
JOIN
postuser pu ON fp.userid = pu.user_id
GROUP BY
pu.user_type
)
SELECT
user_type,
post_success,
post_attempt,
CAST(postsuccess AS FLOAT) / postattempt AS postsuccessrate
FROM
po"
David I. - "WITH filtered_posts AS (
SELECT
p.user_id,
p.issuccessfulpost
FROM
post p
WHERE
p.postdate >= '2023-11-01' AND p.postdate < '2023-12-01'
),
post_summary AS (
SELECT
pu.user_type,
COUNT(*) AS post_attempt,
SUM(CASE WHEN fp.issuccessfulpost = 1 THEN 1 ELSE 0 END) AS post_success
FROM
filtered_posts fp
JOIN
postuser pu ON fp.userid = pu.user_id
GROUP BY
pu.user_type
)
SELECT
user_type,
post_success,
post_attempt,
CAST(postsuccess AS FLOAT) / postattempt AS postsuccessrate
FROM
po"See full answer