"One project that stands out involved building a customer segmentation dashboard for our marketing team using Power BI. The goal was to help them target campaigns more effectively by segmenting customers based on purchase behavior and demographics.
Early in the project, I noticed significant data quality issues in the source tables coming from our CRM system. There were missing values in key fields like customer age and region, duplicate customer IDs, and inconsistencies in how product categories"
Tim F. - "One project that stands out involved building a customer segmentation dashboard for our marketing team using Power BI. The goal was to help them target campaigns more effectively by segmenting customers based on purchase behavior and demographics.
Early in the project, I noticed significant data quality issues in the source tables coming from our CRM system. There were missing values in key fields like customer age and region, duplicate customer IDs, and inconsistencies in how product categories"See full answer
"Assumptions: This is an entirely new app and not part of FB
Clarification questions:
Q: What type of doctors are they looking for? It seems like an app would be for a more generalist doctor to establish relationship and not some type of emergency situation
A: Yes
Q: When we say looking for doctors whats the scope of this? Should we include making the actual appointment, does this happen on platform?
A: Yes, initial appointment
Ok thanks based on that I think we have enough to get started.
"
Anonymous Hummingbird - "Assumptions: This is an entirely new app and not part of FB
Clarification questions:
Q: What type of doctors are they looking for? It seems like an app would be for a more generalist doctor to establish relationship and not some type of emergency situation
A: Yes
Q: When we say looking for doctors whats the scope of this? Should we include making the actual appointment, does this happen on platform?
A: Yes, initial appointment
Ok thanks based on that I think we have enough to get started.
"See full answer
"Getting things done : I am extremely proud of walking the extra mile to get things done which I am extremely proud of in my career
Ladder transfer : Being on the tactical front, to dream about creating a product from its inception to the delivery and being able to achieve it
Gaining trust : Leading without authority is critical and gaining trust in the process of the peers and stakeholders is one thing I am extremely proud of."
Googlepm 1. - "Getting things done : I am extremely proud of walking the extra mile to get things done which I am extremely proud of in my career
Ladder transfer : Being on the tactical front, to dream about creating a product from its inception to the delivery and being able to achieve it
Gaining trust : Leading without authority is critical and gaining trust in the process of the peers and stakeholders is one thing I am extremely proud of."See full answer
"👇 Your feedback is very much appreciated 👇
Reduce scope of product for the initial launch. Streamline the PRD to an actual MVP and use the current PRD (that takes 6 months to build) for the V1"
Julien C. - "👇 Your feedback is very much appreciated 👇
Reduce scope of product for the initial launch. Streamline the PRD to an actual MVP and use the current PRD (that takes 6 months to build) for the V1"See full answer
"I would like to ask questions to the interviewer as to if the company or I as TPM have any success history handling this magnitude. Also, I will talk on my behalf to justify my experience and caliber to drive this magnitude of project to success.
But, I always follow a flow-chart approach when meeting exec management where I do my home work studying the current state of the project/ pain points/ issues/ blockers and steps we have taken or planning to take next to mitigate it. Now w.r.t the flow"
Pramod V. - "I would like to ask questions to the interviewer as to if the company or I as TPM have any success history handling this magnitude. Also, I will talk on my behalf to justify my experience and caliber to drive this magnitude of project to success.
But, I always follow a flow-chart approach when meeting exec management where I do my home work studying the current state of the project/ pain points/ issues/ blockers and steps we have taken or planning to take next to mitigate it. Now w.r.t the flow"See full answer
Technical Program Manager
Program Sense
+2 more
🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.
"Acquisition
New sign-ups for Google Drive Service
Google Drive app installs
Activation
Number of users with at least one file since sign-up
Paid Google Drive Users
Engagement
DAU, MAU
Sessions, Frequency
Time spend
Files accessed per session
Task completion - sharing file, setting up automatic back up etc.
Retention
% Repeat Users
% Users Churning out
Google App Uninstalls
Referral
Inviting"
Anil K. - "Acquisition
New sign-ups for Google Drive Service
Google Drive app installs
Activation
Number of users with at least one file since sign-up
Paid Google Drive Users
Engagement
DAU, MAU
Sessions, Frequency
Time spend
Files accessed per session
Task completion - sharing file, setting up automatic back up etc.
Retention
% Repeat Users
% Users Churning out
Google App Uninstalls
Referral
Inviting"See full answer
"Follow STAR
Example:
In my most recent role at x, we've been working every quarter to set our quarterly goals or even decide for the year but given in 2022 we've been through a great resignation phase there was a high attrition because of which we have overloaded engineering teams.
During last quarterly planning, I started to question with my manager about giving a focus to our engineering, so we complete one thing absolutely fine which is more impactful for our customers and add immediate val"
Ash I. - "Follow STAR
Example:
In my most recent role at x, we've been working every quarter to set our quarterly goals or even decide for the year but given in 2022 we've been through a great resignation phase there was a high attrition because of which we have overloaded engineering teams.
During last quarterly planning, I started to question with my manager about giving a focus to our engineering, so we complete one thing absolutely fine which is more impactful for our customers and add immediate val"See full answer
"JJ Zhou, co-founder at the previous company taught me this: if you want to get people build a boat, tell them how great the sea is. That advice guided me through challenges I face to get my team on board with my vision.
When i became the payment PM where I oversaw the user checkout experience, I decided to introduce Agile approach and organized the workflow into Scrums. The challenge was most engineers and data-scientists in my team were from banks so they were comfortable with water-fall. On"
Darren L. - "JJ Zhou, co-founder at the previous company taught me this: if you want to get people build a boat, tell them how great the sea is. That advice guided me through challenges I face to get my team on board with my vision.
When i became the payment PM where I oversaw the user checkout experience, I decided to introduce Agile approach and organized the workflow into Scrums. The challenge was most engineers and data-scientists in my team were from banks so they were comfortable with water-fall. On"See full answer
"Clarifying questions
By mutual follows, we mean that both of them follow each other on Tiktok, correct? : Yes
We want to know an average number for the same, ie mean and not median or any other value, right? : Yes
Shall we consider the global audience or that of a particular country? : Global
Can we assume the time setting of this question as of 2025?: yes
Here’s how I will tackle this question.
> We will first estimate the total number of Tiktok users. Then we will try to"
Kartikeya N. - "Clarifying questions
By mutual follows, we mean that both of them follow each other on Tiktok, correct? : Yes
We want to know an average number for the same, ie mean and not median or any other value, right? : Yes
Shall we consider the global audience or that of a particular country? : Global
Can we assume the time setting of this question as of 2025?: yes
Here’s how I will tackle this question.
> We will first estimate the total number of Tiktok users. Then we will try to"See full answer
"As a project or program manager to influence effectively without direct authority, focus on building credibility and trust by consistently delivering results, demonstrating empathy for stakeholder needs, and aligning everyone on shared goals. When managing up, tailor communication to leadership’s priorities and concerns—bring actionable insights, clear data, and potential solutions to the table. When managing down, empower teams by promoting ownership, offering timely recognition, and maintainin"
Elle M. - "As a project or program manager to influence effectively without direct authority, focus on building credibility and trust by consistently delivering results, demonstrating empathy for stakeholder needs, and aligning everyone on shared goals. When managing up, tailor communication to leadership’s priorities and concerns—bring actionable insights, clear data, and potential solutions to the table. When managing down, empower teams by promoting ownership, offering timely recognition, and maintainin"See full answer
"Clarifying questions
We are referring to Facebook here within Meta products, correct?: Yes
Can we base the CAC as of 2025?: yes
Facebook acquires users through multiple channels, are we focussed on any particular channel? : We are looking at an overall CAC for Facebook
What all do we want to include in CAC? Can we limit it to the marketing and advertising costs and leave aside technical, infrastructure or people costs?: yes
Here’s how I will calculate this.
**Customer acquisition c"
Kartikeya N. - "Clarifying questions
We are referring to Facebook here within Meta products, correct?: Yes
Can we base the CAC as of 2025?: yes
Facebook acquires users through multiple channels, are we focussed on any particular channel? : We are looking at an overall CAC for Facebook
What all do we want to include in CAC? Can we limit it to the marketing and advertising costs and leave aside technical, infrastructure or people costs?: yes
Here’s how I will calculate this.
**Customer acquisition c"See full answer
"Instagram is social media app where you can share photo and video to others. Impressions is an important metrics to track because it shows how many contents that users see.
Clarify Questions:
Is this drop happen suddenly or gradually? - Gradually
How long has it been happening? - Last 3 months
Is it happen globally or in certain region? - Globally
Is the drop happen to all user segments (age, new/existing, active/less active users)? - all user segments
When calculating an impressions,"
Nayla D. - "Instagram is social media app where you can share photo and video to others. Impressions is an important metrics to track because it shows how many contents that users see.
Clarify Questions:
Is this drop happen suddenly or gradually? - Gradually
How long has it been happening? - Last 3 months
Is it happen globally or in certain region? - Globally
Is the drop happen to all user segments (age, new/existing, active/less active users)? - all user segments
When calculating an impressions,"See full answer
"This is an interesting Favorite Product question. Normally when we're asked this question we pick technology products, but this time the interviewer wanted to throw us a curveball by asking about a non-technical product. Don't worry - it still follows the same approach:
Choose a product and briefly explain what it is
Who are the users?
What are their pain points?
How did competitors solve it in the past?
**How does this product address these pain points differe"
Exponent - "This is an interesting Favorite Product question. Normally when we're asked this question we pick technology products, but this time the interviewer wanted to throw us a curveball by asking about a non-technical product. Don't worry - it still follows the same approach:
Choose a product and briefly explain what it is
Who are the users?
What are their pain points?
How did competitors solve it in the past?
**How does this product address these pain points differe"See full answer
"I said dockerizing the application and taking them in the Kubernetes cluster will help, I created a diagram of all the API they had."
Dheeraj S. - "I said dockerizing the application and taking them in the Kubernetes cluster will help, I created a diagram of all the API they had."See full answer
"Assumptions, company, industry, external, customers, problems, solutions, metrics
Company is microsoft, its vision is to help people and organization to achieve their full potential by increasing productivity .
Task management - there are many products like notes, google task etc which exist but no one is market leader. A user had a list of tasks which she wants to complete by Y deadline and their is prirotization among these and could be categorized
Task - start day, end day, estimated time to"
Megha V. - "Assumptions, company, industry, external, customers, problems, solutions, metrics
Company is microsoft, its vision is to help people and organization to achieve their full potential by increasing productivity .
Task management - there are many products like notes, google task etc which exist but no one is market leader. A user had a list of tasks which she wants to complete by Y deadline and their is prirotization among these and could be categorized
Task - start day, end day, estimated time to"See full answer
"Let's start with clarifying question -> What do we want to achieve with increased engagement?
Let's say Spotify has personalization that prefers more engaged songs/podcast to be available to new users (who have not heard that song). Along the same lines as Facebook/Linkedin/Instagram prefers posts. The more the song/podcast is engaged among users, for more people it will be visible to listen.
What users we are targeting? There are 2 broad categories of users such as creators and listen"
Aidynn E. - "Let's start with clarifying question -> What do we want to achieve with increased engagement?
Let's say Spotify has personalization that prefers more engaged songs/podcast to be available to new users (who have not heard that song). Along the same lines as Facebook/Linkedin/Instagram prefers posts. The more the song/podcast is engaged among users, for more people it will be visible to listen.
What users we are targeting? There are 2 broad categories of users such as creators and listen"See full answer