Farmley Product Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Product Analyst at an Indian unicorn or high-growth startup like Farmley works with product managers, engineers, and business teams to turn data into decisions. Day to day, you write SQL queries, build dashboards, run experiments, and analyse user behaviour to improve features, retention, and revenue. You are the bridge between raw data and product strategy, often owning metrics for a specific product area.

Role and technical knowledge

1. 1

   What is the difference between a metric and a KPI? Give an example from a D2C food brand like Farmley.

   A metric is any measurable value; a KPI is a metric tied directly to a strategic goal. For a D2C brand, 'number of orders' is a metric, but 'repeat purchase rate within 90 days' can be a KPI for retention.

2. 2

   How would you write a SQL query to find the top 5 cities by number of orders in the last 30 days?

   Use GROUP BY city, COUNT(order_id), filter with WHERE order_date >= CURRENT_DATE - INTERVAL '30 days', ORDER BY count DESC, LIMIT 5. Mention handling of null cities or test orders.

3. 3

   Explain the difference between a funnel analysis and a cohort analysis. When would you use each?

   Funnel shows drop-offs across steps in a single journey (e.g., cart to checkout). Cohort groups users by a common start date to track behaviour over time (e.g., monthly retention). Use funnel for conversion fixes, cohort for retention trends.

4. 4

   What is an A/B test? What are the key assumptions and pitfalls a product analyst must check?

   Cover random assignment, sufficient sample size, one primary metric, and pitfalls like peeking, novelty effect, and multiple comparisons. Mention checking for sample ratio mismatch.

Practical scenarios

1. 5

   Farmly (a hypothetical D2C brand) sees a 20 percent drop in weekly active users. How would you investigate?

   Start by validating the data pipeline, then segment by platform, geography, acquisition channel, and user tenure. Check for recent releases, marketing pauses, or seasonality. End with a hypothesis and next steps.

2. 6

   You are asked to increase the conversion rate on a product page. What data would you pull and what experiment would you run?

   Pull funnel data from page view to add-to-cart to purchase, segment by device and traffic source. Propose an A/B test on one element (e.g., price display, images, reviews) with a clear success metric and guardrail metrics.

3. 7

   How would you measure the success of a new loyalty program for a fast-growing snacks brand?

   Define primary metrics like repeat purchase rate, average order value, and retention lift. Use a control group if possible. Also track cost per redeemed point and impact on margin. Mention short-term vs long-term effects.

4. 8

   A product manager asks you to build a dashboard for daily orders. What would you include and why?

   Include total orders, revenue, average order value, new vs returning split, top categories, and cancellation rate. Add filters for date, city, and channel. Explain how each metric helps daily decision-making.

Business and product sense

1. 9

   How would you estimate the market size for healthy snacks in India for a brand like Farmley?

   Use a top-down or bottom-up approach. Top-down: population, urban share, snacking frequency, average spend. Bottom-up: number of target households times monthly purchase. State assumptions clearly and sanity-check.

2. 10

   If you could track only three metrics for a D2C startup, what would they be and why?

   Pick metrics that cover growth, engagement, and unit economics. For example: monthly revenue growth, repeat purchase rate, and contribution margin. Justify why each is leading or lagging.

3. 11

   A new feature increased sign-ups but decreased retention. How do you decide whether to keep it?

   Look at net impact on a north-star metric like 30-day active users or LTV. Segment by user type to see who churns. Consider whether the drop is temporary or permanent. Recommend a follow-up test or a rollback with a plan to fix retention.

4. 12

   How would you prioritise between two product ideas: one improves conversion by 5 percent, the other improves retention by 2 percent?

   Estimate impact on revenue or LTV using current numbers. Consider effort, confidence, and strategic fit. Use a simple framework like RICE. Show that you can quantify trade-offs, not just guess.

Behavioural and HR questions

1. 13

   Tell me about a time you used data to solve a problem in a college project or internship.

   Use STAR format. Focus on the data you collected, the analysis method, and the decision it drove. Quantify the outcome if possible, even if it was a small project.

2. 14

   Why do you want to work as a product analyst at a fast-growing startup like Farmley instead of a large company?

   Show comfort with ambiguity, ownership, and speed. Mention learning opportunities across the stack and the chance to see your analysis directly impact product decisions. Avoid generic answers about 'growth'.

3. 15

   Describe a time you had to explain a technical finding to a non-technical person.

   Highlight simplifying without losing accuracy. Show you used visuals or analogies, checked understanding, and adapted to the audience. End with the action they took based on your explanation.

4. 16

   Where do you see yourself in three years, and how does this role fit?

   Align your growth with the company's needs. Mention deepening product analytics skills, owning a product area, and possibly mentoring juniors. Avoid saying you want to move into a different function too soon.