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


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.