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.
Marketing
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 »
