FreshToHome Product Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Product Analyst at an Indian unicorn or high-growth startup like FreshToHome spends their day turning raw user, order, and supply-chain data into decisions. You will write SQL queries, build dashboards, define product metrics, and run experiments to improve conversion, retention, and delivery efficiency. You will work closely with product managers, engineers, and category teams to prioritise features that move business numbers.

Role and Technical Knowledge

1. 1

   What is a North Star metric for a hyperlocal fresh fish and meat delivery app, and why?

   A strong answer picks a metric like weekly orders per active customer or on-time delivery rate, and explains how it links to retention and unit economics. Avoid generic metrics like total downloads.

2. 2

   How would you write a SQL query to find the top 5 cities by repeat order rate in the last 30 days?

   Mention joining orders and customers tables, filtering by date, grouping by city, and using a window function or subquery to rank. Also clarify how you define a repeat order.

3. 3

   Explain the difference between a leading and a lagging metric for a product analyst at a quick-commerce startup.

   Use examples like cart additions (leading) versus monthly revenue (lagging). Show that you know leading metrics help you act early.

4. 4

   What is an A/B test, and what would you check before calling a winner in a delivery fee experiment?

   Cover randomisation, sample size, p-value, and guardrail metrics like order cancellation rate. Mention novelty effects and seasonality.

Practical Scenarios

1. 5

   Daily active users dropped by 15 percent week over week. How would you investigate?

   Segment by platform, city, acquisition channel, and new versus existing users. Check for tracking bugs, app release issues, or competitor promotions. Propose a fix and a follow-up metric.

2. 6

   You are asked to increase the conversion rate from product page to checkout by 2 percent. What data would you pull first?

   Ask for the current funnel, drop-off points, and user segments. Suggest looking at page load time, image quality, price competitiveness, and delivery slot availability.

3. 7

   A category manager wants to know which products to promote for weekend orders. How would you build a simple recommendation?

   Use historical order data to find high-margin, high-frequency items with low weekend penetration. Suggest a simple rule-based model or a dashboard the manager can use.

4. 8

   How would you measure the success of a new loyalty program for a fresh meat delivery app?

   Define control and test groups, track retention, order frequency, average order value, and referral rate. Include a cost-per-acquisition view and a 3-month window.

Product Sense and Metrics

1. 9

   How would you define and measure customer retention for a weekly fresh fish subscription?

   Use cohort analysis by sign-up week, track week-4 and week-8 retention, and separate voluntary from involuntary churn. Mention reactivation rates.

2. 10

   What is a good activation metric for a new user on a hyperlocal delivery app?

   A strong answer picks a specific action like placing the first order within 3 days of sign-up. Explain why that action predicts long-term retention.

3. 11

   You have limited engineering bandwidth. How would you prioritise between a search filter improvement and a referral program?

   Use an impact-effort matrix or RICE score. Estimate reach, impact on conversion, confidence, and effort. Show that you can defend a trade-off.

4. 12

   How would you set up a dashboard for the operations team to monitor delivery delays?

   Include real-time metrics like average delivery time, percentage of late orders, and delay reasons by city. Suggest alerts for threshold breaches.

Behavioural and HR Questions

1. 13

   Tell me about a time you used data to convince someone who disagreed with you.

   Use the STAR method. Focus on the data you gathered, how you presented it simply, and the final decision. Show humility and listening.

2. 14

   Why do you want to work as a product analyst at a high-growth Indian startup rather than a large MNC?

   Mention ownership, speed, direct impact on users, and learning across functions. Connect to the fresh food or hyperlocal sector if possible.

3. 15

   Describe a project where you had to learn a new tool or skill quickly. How did you do it?

   Pick a concrete example like learning SQL or Python for a college project. Emphasise self-learning, online resources, and applying it to a real problem.

4. 16

   How do you handle feedback that your analysis was wrong or incomplete?

   Show that you welcome feedback, ask clarifying questions, re-check your assumptions, and communicate the correction transparently. Avoid being defensive.