Clovia Product Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Product Analyst at Indian unicorns and high-growth startups like Clovia works with product managers and engineers to define success metrics, run experiments, and analyse user behaviour to improve features and drive business outcomes. Day to day, they write SQL queries, build dashboards, design A/B tests, and translate data into actionable product recommendations. The role sits at the intersection of data, business, and user experience, often requiring close collaboration with marketing, design, and engineering teams.

Role and Technical Knowledge

1. 1

   What are the key metrics you would track for a lingerie e-commerce app like Clovia?

   Cover acquisition (CAC, installs), activation (first purchase, size quiz completion), retention (repeat purchase rate, 30-day retention), revenue (AOV, LTV), and referral. Mention how metrics differ for app vs web.

2. 2

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

   Use a subquery or CTE to identify first purchases per user, then group by city, count distinct users, order descending, and limit 5. Explain date filtering and handling of nulls.

3. 3

   Explain the difference between correlation and causation in product analytics. Give an example from an e-commerce setting.

   Correlation means two variables move together, causation means one causes the other. Example: users who use the size guide may have higher conversion, but it could be because they are more intent on buying. Suggest A/B testing to establish causation.

4. 4

   What is a cohort analysis and how would you use it to improve retention for a fashion startup?

   Cohort analysis groups users by a common characteristic (e.g., sign-up month) and tracks their behaviour over time. Use it to spot drops in repeat purchases and test interventions like personalised recommendations or loyalty programs.

Practical Scenarios and Case Studies

1. 5

   Clovia's app has a high cart abandonment rate. How would you investigate and reduce it?

   Break down the funnel: add-to-cart to checkout. Check for payment failures, shipping costs, forced sign-up, or slow load times. Suggest A/B tests for simplified checkout, guest checkout, or trust badges. Quantify impact using current abandonment rate and potential lift.

2. 6

   You notice that daily active users (DAU) dropped 15% week-over-week. How would you diagnose the cause?

   Segment by platform, geography, acquisition channel, and user tenure. Check for app updates, marketing pauses, or competitor launches. Use internal dashboards and external sources. Propose a hypothesis and next steps to validate.

3. 7

   Design an A/B test to measure the impact of a new recommendation algorithm on conversion rate. What metrics and sample size would you consider?

   Define control and treatment groups, primary metric (conversion rate), secondary metrics (AOV, engagement). Calculate sample size using baseline conversion, minimum detectable effect, and power. Mention randomisation, test duration, and avoiding peeking.

4. 8

   How would you estimate the market size for plus-size lingerie in India for a company like Clovia?

   Use a top-down or bottom-up approach. Top-down: target female population, age group, urban vs rural, purchasing power, average spend. Bottom-up: number of potential customers times frequency times price. State assumptions clearly and sanity-check.

Behavioural and HR Questions

1. 9

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

   Use STAR format: Situation, Task, Action, Result. Highlight the data source, analysis method, and measurable outcome. Emphasise collaboration and learning.

2. 10

   Why do you want to work as a Product Analyst at a fast-growing startup like Clovia?

   Show passion for data-driven product decisions and e-commerce. Mention Clovia's focus on women's intimate wear and how analytics can improve customer experience. Avoid generic answers about 'growth'.

3. 11

   Describe a time you had to explain a complex analysis to a non-technical audience. How did you ensure clarity?

   Focus on simplifying jargon, using visuals, and tying insights to business impact. Mention feedback from the audience and how you adjusted your approach.

4. 12

   How do you prioritise multiple tasks when you have deadlines from different stakeholders?

   Discuss frameworks like impact vs effort, or urgent vs important. Give an example of balancing a quick data pull with a longer analysis. Emphasise communication and expectation setting.

Product Sense and Metrics Deep Dive

1. 13

   If you could add one feature to Clovia's app to increase repeat purchases, what would it be and how would you measure success?

   Propose a feature like personalised size recommendations or a subscription for essentials. Define success metrics: repeat purchase rate, retention, AOV. Mention how you would test it (A/B test) and guardrail metrics.

2. 14

   What is the North Star metric for a lingerie e-commerce company and why?

   Suggest 'number of repeat purchases' or 'monthly active buyers' as it reflects both acquisition and retention. Explain how it aligns with revenue and customer lifetime value. Contrast with vanity metrics.

3. 15

   How would you define and measure user engagement for a fashion app?

   Use metrics like DAU/MAU, session duration, pages per session, and actions like wishlisting or sharing. Segment by user type (new vs returning). Explain how engagement correlates with conversion.

4. 16

   A product manager asks you to analyse why conversion rate dropped after a UI change. What steps would you take?

   Check if the change was rolled out to all users or a subset. Compare pre and post periods, segment by device and user cohort. Look for technical issues, seasonality, or external factors. Suggest reverting or iterating based on findings.