Kids commerce: what makes parents happy, late or loyal

SQL and Excel analysis of 99K real orders (6,787 with kids items). Built for OZi's Product / Product Analyst internship.

25% vs 9%1-2 star reviews when an order missed its promised date vs on time, at the same 7-14 day delivery time
17% fewerbroken promises with my delivery-time model, at the same promise length
10% of productscarry 50% of kids units sold
11 of 50top kids products were still top 50 six months later

Try it: what if fewer orders arrive late?

Orders rated 1-2 stars:

Uses the measured rates for kids orders: 67.6% rated 1-2 stars when late, 8.5% when on time. An association, not proof of cause; the README shows the controlled version.

Try it: how many products should a dark store carry?

Products needed:

Findings

Charts: satisfaction by delivery time, late vs on time, assortment, local stock
Chart: promises kept vs days promised, model vs store

Built by Pavitra Seth (BITS Pilani). Public data used as a stand-in; not affiliated with the company. Code and method: see the repository README.