Case Study: PuppySpot reduces ETL lag from 6 hours to 5 minutes with Stitch

Pets to people and data to analytics at PuppySpot

PuppySpot is an online retailer that connects vetted breeders with pet buyers. When Analytics Manager Andrew Pafitis joined, he inherited a custom in-house ETL that used full-table replication on MySQL for CRM, sales, and inventory data and took 4–6 hours to update, causing lag and inconsistencies. After evaluating several cloud options, he chose Stitch for its straightforward pricing, ease of use, and support for binary log replication.

Using Stitch, PuppySpot cut ETL lag from about six hours to five minutes, enabling intraday analytics, faster decision-making, and fewer cross-table discrepancies. They’ve also added integrations like Google Analytics and Google Ads for better attribution and conversion insights, and plan to expand to NetSuite and a new CRM as they grow — all managed through an intuitive, cost-effective Stitch interface.

PuppySpot

Andrew Pafitis

Analytics Manager