Case Study: SamCart achieves faster, more consistent analytics with Cube Dev

How SamCart Achieved New Levels of Consistency, Efficiency, and Performance with Cube

SamCart, the eCommerce platform powering over 75,000 creators, needed a way to centralize and standardize its reporting data as customer demand grew. The company was struggling with slow dashboard performance, data discrepancies, and increasing support requests, making it harder to deliver a reliable source of truth for customers. To address these issues, SamCart turned to Cube Dev and its universal semantic layer, Cube Cloud.

Cube Dev helped SamCart connect first to MySQL and later to Snowflake with dbt Labs, centralizing data models and using pre-aggregations to improve performance and consistency. The results were dramatic: query times dropped from as high as 20 seconds to as little as 1.1 seconds, averaging around 600 milliseconds, while pre-aggregation build times fell from eight minutes to just seconds. With Cube Dev, SamCart improved dashboard load times, reduced support requests, and lowered direct Snowflake query usage.

SamCart

Mason Tiffin

Data Engineer