Cart Abandonment Analysis: 4 Useful SQL Queries
I add things to my cart and change my mind too, and it turns out businesses can measure exactly where that happens. Here is how I explored cart abandonment analysis with SQL and a dashboard.
Retail & E-commerce
Festive Season Funnel Analysis: Where Diwali Marketing Campaigns Actually Convert
Diwali offers are everywhere, but which channels actually convert? In this festive season funnel analysis, I break a Diwali campaign down by funnel stage, channel, CAC, ROAS and RTO, so “sales went up” turns into a decision you can act on.
Festive Season Funnel Analysis: Where Diwali Marketing Campaigns Actually Convert Read Post »
75 Ecommerce and Marketing Analytics Interview Questions (With Model SQL and Answers)
A working set of 75 ecommerce and marketing analytics interview questions, each with a model answer and SQL query built against one shared practice schema, from business fundamentals through advanced SQL and statistics.
75 Ecommerce and Marketing Analytics Interview Questions (With Model SQL and Answers) Read Post »
Why Your SQL Answer Is Wrong: 5 Critical Questions to Ask First
Revenue is up 20% — but is that really good news? Learn how e-commerce analysts can look beyond revenue, analyze discounts, returns, margins, and repeatability, and uncover when impressive growth is actually a warning sign.
Why Your SQL Answer Is Wrong: 5 Critical Questions to Ask First Read Post »
Why domain knowledge matters (and why I had to learn it the hard way)
A data-analyst aspirant’s real breakdown of the e-commerce metrics that actually come up in interviews—CAC, ROAS, conversion rate, AOV, and LTV—with a worked example you can follow along with.
Why domain knowledge matters (and why I had to learn it the hard way) Read Post »
