Your ecommerce data lives in Google BigQuery, the industry-standard data warehouse. We manage the foundation, you own every table. Query it with any tool, extend it with your own models, and take everything with you if you leave.
Integrated AI-to-BI stack on Google Cloud
20+ core tables across commerce, marketing, and executive reporting.
Track revenue, customer behavior, and order economics from one foundation.
Measure acquisition efficiency and where conversion breaks down.
Give leadership a fast read on daily KPIs and long-term value.
Start with the business-ready tables for dashboards and reporting. Go deeper with the building-block tables if your data team wants to customize.
Explore the full schema + table docsWhy BigQuery
Most ecommerce data tools lock your data inside their platform. We chose BigQuery so you keep full ownership, native Google integrations, and an ecosystem of tools that already speak its language.
When the warehouse works, every team moves faster. Here's what that looks like by role.
“SourceMedium's managed BigQuery instance has been a revelation for our team. It has democratized access to data across our entire organization, empowering everyone to create custom metrics and transformations without relying on a dedicated BI team.”
Nick Osborn
Head of Growth, Catalina Crunch
Trust layer
The reason data teams prefer working with us.
2,500+
daily quality checks
180+
metric catalog
Consistent
Best-practice naming
Native
dbt-compatible
Example: orders table
Explore documentation| Column | Type |
|---|---|
| sm_order_key | STRING |
| order_processed_at | TIMESTAMP |
| order_net_revenue | FLOAT |
| sm_channel | STRING |
| sm_customer_key | STRING |
| is_order_sm_valid | BOOLEAN |
Want the details on cleaning, transformation, and enrichment? See Data Transformation .
Extensibility
Your data lives in BigQuery, not a proprietary vendor system, so you can centralize anything. Finance data, ops data, custom sources, third-party APIs. Standard BigQuery storage, no additional vendor fees for bringing in more data.
SourceMedium manages the ecommerce foundation. Your team extends the warehouse however you need.
Catalina Crunch integrated retail POS data alongside their ecommerce data and built a real-time P&L dashboard in 3 weeks.
CPAP set up webhooks to pull fulfillment-date revenue recognition into BigQuery for finance-grade reporting.
Brands that need non-automated data (SPINS, wholesale, marketplace) upload via Google Sheets on a cadence, cast to the schema, and it becomes part of the same governed foundation.
Yes. You keep your data.
Your data, your control
We don't hold your data hostage. If you leave, you keep the warehouse tables, dashboards, and SQL. No rebuild. Move it to a BigQuery project you control. Our internal dbt models and SQL transformation logic remain SourceMedium IP. Your data, schema, and any custom models you built are yours to keep.
Warehouse customers
“SourceMedium has future-proofed our data infrastructure. Their comprehensive solution not only supports our current needs but is also scalable as we grow. With their managed BigQuery instance, we have full control over our data, creating custom metrics and insights rapidly. This has empowered our team to answer complex business questions and focus on strategic growth initiatives.”
“Acquiring confidence in your data is literally money. We've nearly doubled revenue in the short time we've used SourceMedium. They are the layer through which all our data flows and gets transformed into a unified, coherent and reliable language that my entire team leverages regardless of analytical capability.”
“SourceMedium is our command center; it helps us identify problems before they get bigger. It's easy enough for everyone on the team to use, and it empowers all people.”
“We've spent months looking for an analytics solution that would present accurate data we 100% trust in a digestible format that's easily understandable by any team member. We found that in SourceMedium.”
“SourceMedium is a game-changer for our business. We have a single, reliable source of truth with their data infrastructure that allows us to make data driven decisions against the short and long term impact of our marketing and customer experience efforts.”
“The real win wasn't the cost savings (though those were nice). It's that my team stopped arguing about which dashboard was right. One source of truth for reporting AND attribution means we actually build things now instead of reconciling data.”
Tell us a bit about your brand and stack—we’ll follow up shortly.
You're all set
