Product Analyst Interview Questions

4,437 product analyst interview questions shared by candidates

They provided some CSV data and asked me question about it. Describing the data a. How many customers do we have ATO product data for? b. Over what time period does the ATO data exist? c. How many ATO detectors are there? d. What is the range of customer sizes by number of users? 2. Calculating metrics a. What is the average monthly false negative rate of the ATO product? b. What is the average monthly false positive rate of the ATO product? c. What fraction of user events are flagged by a detector at any confidence? At high confidence? d. Calculate the precision of each detector based on cases surfaced to customers. Which detector has the highest precision? Which detector has the lowest precision? e. Which detector flags the highest number of customer-confirmed true positive cases? 3. Building a data pipeline a. Calculating each metric above individually only requires a small subset of tables joined per metric. However, we want to enable all our downstream consumers, including Product and Engineering stakeholders, to have one table act as a source of truth for all analyses. We also want this same table to be upstream of all metrics calculations. Write a query which joins together all necessary information into a single table that can be used to answer all of the metrics questions above.
avatar

Product Analyst

Interviewed at Abnormal AI

3.8
May 9, 2025

They provided some CSV data and asked me question about it. Describing the data a. How many customers do we have ATO product data for? b. Over what time period does the ATO data exist? c. How many ATO detectors are there? d. What is the range of customer sizes by number of users? 2. Calculating metrics a. What is the average monthly false negative rate of the ATO product? b. What is the average monthly false positive rate of the ATO product? c. What fraction of user events are flagged by a detector at any confidence? At high confidence? d. Calculate the precision of each detector based on cases surfaced to customers. Which detector has the highest precision? Which detector has the lowest precision? e. Which detector flags the highest number of customer-confirmed true positive cases? 3. Building a data pipeline a. Calculating each metric above individually only requires a small subset of tables joined per metric. However, we want to enable all our downstream consumers, including Product and Engineering stakeholders, to have one table act as a source of truth for all analyses. We also want this same table to be upstream of all metrics calculations. Write a query which joins together all necessary information into a single table that can be used to answer all of the metrics questions above.

Super weird interview questions 1. Pro and cons of having partner business e.g. product like looker has partner business to use as an example 2. How would you help decide your COO if company should invest in forums Unclear responses and hesitation in responding to follow up questions asked. e.g. I asked 1. what are partners for looker as an example to make sure i was going in the right direction when thinking of pros and cons. 2. Can you tell me more about what kind of forums are we talking about? Is it in product or outside and therefore can be accessed by anyone? Accessible to free users as well or paid users only? (Because i was thinking of A/B test therefore needed to think about appropriate metrics) --> Interviewer's response, can be anywhere and can be accessed by any type of users
avatar

Product growth analyst

Interviewed at Docusign

3.6
Jan 20, 2024

Super weird interview questions 1. Pro and cons of having partner business e.g. product like looker has partner business to use as an example 2. How would you help decide your COO if company should invest in forums Unclear responses and hesitation in responding to follow up questions asked. e.g. I asked 1. what are partners for looker as an example to make sure i was going in the right direction when thinking of pros and cons. 2. Can you tell me more about what kind of forums are we talking about? Is it in product or outside and therefore can be accessed by anyone? Accessible to free users as well or paid users only? (Because i was thinking of A/B test therefore needed to think about appropriate metrics) --> Interviewer's response, can be anywhere and can be accessed by any type of users

Viewing 531 - 540 interview questions

Glassdoor has 4,437 interview questions and reports from Product analyst interviews. Prepare for your interview. Get hired. Love your job.