Meesho Ads Data Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Data Analyst at an Indian unicorn or high-growth startup like Meesho Ads supports business and product teams by extracting, cleaning, and analyzing data to drive decisions on ad performance, user behavior, and revenue growth. Day to day, you write SQL queries, build dashboards, run experiments, and present insights to stakeholders. You work closely with product managers, engineers, and marketing teams to optimize campaigns and improve key metrics.

Role and Technical Knowledge

1. 1

   What are the key metrics you would track for an ads platform like Meesho Ads?

   A strong answer covers impressions, clicks, CTR, CPC, CPM, conversion rate, ROAS, and take rate, and explains how each ties to advertiser value and platform revenue.

2. 2

   Explain the difference between a left join and an inner join with an example from ad campaign data.

   Use a scenario like joining a campaigns table with a clicks table to show how left join keeps all campaigns even those with zero clicks, while inner join drops them.

3. 3

   How would you design an A/B test to measure the impact of a new ad placement on click-through rate?

   Cover random assignment, control vs treatment, sample size calculation, primary and guardrail metrics, and how to check for statistical significance.

4. 4

   What is the difference between correlation and causation? Give an example from user engagement data.

   Explain that correlation does not imply causation, and give an example like users who see more ads may click more, but it could be due to higher intent, not the ads themselves.

Practical Scenarios and Case Studies

1. 5

   Ad revenue for a particular category dropped 20% week-over-week. How would you investigate?

   A strong answer segments by advertiser, placement, geography, and device, checks for data pipeline issues, seasonality, and competitor actions, and suggests next steps.

2. 6

   You need to estimate the average revenue per user (ARPU) for a new ad product. What data would you pull and how would you calculate it?

   Mention defining the user base, time period, total revenue from the product, and handling edge cases like refunds or inactive users.

3. 7

   How would you identify and handle outliers in a dataset of ad click timestamps?

   Discuss methods like IQR, z-scores, or visualization, and explain whether to remove, cap, or investigate outliers based on business context.

4. 8

   A product manager asks you to build a dashboard to track ad campaign performance. What would you include?

   Cover key metrics, filters (date, campaign, advertiser), trend lines, and comparison to benchmarks, and mention tools like Tableau or Metabase.

Behavioural and Situational Questions

1. 9

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

   Use STAR format: describe the problem, how you collected and analyzed data, the insight, and the outcome or learning.

2. 10

   Describe a situation where you had to explain a technical concept to a non-technical person.

   Show empathy and clarity: focus on simplifying without jargon, using analogies, and checking for understanding.

3. 11

   How do you prioritize when you have multiple ad hoc data requests from different teams?

   Mention assessing urgency and impact, communicating with stakeholders, and using a simple framework like Eisenhower matrix or impact vs effort.

4. 12

   Give an example of a time you made a mistake in your analysis. How did you handle it?

   Be honest, show ownership, explain how you caught it, corrected it, and what you changed in your process to avoid recurrence.

HR and Culture Fit

1. 13

   Why do you want to work as a data analyst at a fast-growing startup like Meesho Ads?

   Show passion for data-driven decision making, interest in e-commerce and ads, and comfort with ambiguity and rapid change.

2. 14

   Where do you see yourself in 3 years?

   Align your growth with the company: mention deepening analytics skills, taking ownership of larger projects, and potentially mentoring juniors.

3. 15

   How do you handle tight deadlines and pressure?

   Give a concrete example of managing multiple deadlines, using prioritization and communication, and staying calm.

4. 16

   What are your salary expectations?

   Research typical fresher data analyst salaries in Indian startups, give a range, and express flexibility based on overall compensation and learning opportunities.