What happens if I ever decide to leave SourceMedium?

Modeled data already delivered to BigQuery, customer-built SQL and models, copied dashboards, and delivered documentation remain usable. SourceMedium-managed connectors, orchestration, monitoring, and proprietary platform code remain SourceMedium intellectual property. SourceMedium-managed refreshes stop after offboarding. To keep receiving fresh data, move the retained assets to a customer-managed BigQuery instance.

What is the SourceMedium Managed Data Warehouse?

It's a fully-managed, e-commerce-optimized BigQuery foundation your team can query directly with any BigQuery-compatible tool.

Data Foundation

A maintained data foundation in BigQuery.

SourceMedium gives your commerce team a managed BigQuery foundation with modeled tables, stable definitions, dashboard-ready outputs, and AI context. Query it directly, connect standard tools, and extend it without maintaining the pipelines, schemas, QA, and transformation layer underneath.

Book a platform walkthrough Explore the schema

Managed data and AI infrastructure

operates

Maintained data foundation

BigQuery

Google Cloud

AI infrastructure

Model services

A sample of the tables you get in BigQuery

20+ core tables across commerce, marketing, and executive reporting.

Commerce core

Track revenue, customer behavior, and order economics from one foundation.

Orders: Revenue trends, valid order counts, and daily performance.
Order lines: SKU-level units, product mix, and margin analysis.
Customers: New vs repeat behavior, cohorts, and customer value.
Products / variants: Stable product attributes for joins and segmentation.
Refunds: Return rates and refund impact on net revenue.
Discounts, shipping, taxes: Checkout components that shape contribution margin.

Marketing + funnel

Measure acquisition efficiency and where conversion breaks down.

Funnel event history: Customer pathing and touchpoint history across sources.
Ad performance (daily): Spend, clicks, and ROAS by platform and campaign.
Funnel events (hourly): Hourly conversion monitoring and drop-off diagnostics.
Outbound message performance (daily): Email/SMS campaign and flow performance at the channel level.

Exec rollups

Give leadership a fast read on daily KPIs and long-term value.

Executive summary (daily): Board-ready daily KPI snapshot across growth and finance metrics.
Cohort LTV: Lifetime value by first purchase source, channel, and campaign.

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 docs

Why BigQuery

Not a default. A deliberate choice.

We chose BigQuery so your team gets direct access to modeled data, native Google integrations, standard SQL, and a broad ecosystem of compatible tools.

1 Managed capacity for the platform workload. The monthly platform fee includes a documented BigQuery compute allowance. Any usage beyond that allowance follows the overage rate in the signed proposal, with advance usage alerts.
2 Native Google integrations built in. Your highest-volume data (GA4, Google Ads) flows into BigQuery through Google's own pipelines. Often no third-party connectors needed.
3 Commercial terms match the managed deployment. BigQuery runs in SourceMedium's managed environment by default. Included compute, overage rates, and the customer-owned deployment option are documented before signing.
4 Free dashboards for your whole team. Looker Studio does not require a separate per-viewer BI fee. Prefer Tableau, Hex, or Mode? Standard BigQuery-compatible tools can connect to the same modeled data.
5 AI that runs on your actual data. The AI Analyst answers questions in Slack using the maintained BigQuery foundation. Analytical answers can expose their SQL, while documentation and methodology answers cite governing sources.

What your team does with it.

When the warehouse works, every team moves faster. Here's what that looks like by role.

Data teams

Run custom SQL on modeled data without relying on a reporting API
Build dbt models on a documented, stable schema
Connect Tableau, Python, Hex, Mode, or other BigQuery-compatible tools
Run custom transformations within the included compute allowance
Use the schema as a foundation, extend it without breaking it

Growth teams

Pre-built dashboards read directly from BigQuery, one shared foundation
Analytical answers can expose the underlying SQL. Documentation and methodology answers cite the governing sources.
Attribution, LTV, cohort analysis: all queryable, all auditable
No new interface to learn if you just use dashboards + Slack

Executives

Differences are reconciled and documented, so your team knows which governed number applies to each use case
Board-ready reporting from the same warehouse your data team queries
If you ever hire a data team or bring in an analyst, they inherit a documented, governed foundation, not a mess

Agencies + consultants

Plug into your existing workflow: Hex, Mode, dbt, Tableau, any BigQuery-compatible tool
No data export rituals, no proprietary UI dependency
Serve multiple clients from a consistent, documented schema
Build custom analyses without learning a proprietary interface

“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

Former Head of Growth, Catalina Crunch

Trust layer

A schema you can build on.

The reason data teams prefer working with us.

Documented and consistently named. Every table and column follows a published naming convention so new team members can read it without a decoder ring.
Designed to stay stable. When we evolve the schema, we manage the transition so your dashboards and reports don't break.
4,000+ automated quality checks run every day to catch problems before they reach your reports.

4,000+

daily quality checks

180+

metric catalog

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

Extend the managed foundation with the data your team needs.

Because the modeled data is available in BigQuery, your team can add finance data, operations data, custom sources, and third-party APIs to the same analytical environment.

SourceMedium maintains the agreed commerce foundation. Customer-added sources and separately scoped custom work remain explicit.

Costco + grocery store data

Catalina Crunch integrated retail POS data alongside its commerce data and built a P&L dashboard in three weeks.

Custom fulfillment data

CPAP set up webhooks to pull fulfillment-date revenue recognition into BigQuery for finance-grade reporting.

Third-party data via Google Sheets

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.

What remains usable if you leave?

Modeled data already delivered to BigQuery
Customer-built SQL queries and models
Copied and customized dashboards
Delivered schema and metric documentation

You keep the delivered data and customer-built work listed here.

Your data, your control

Built to stay. Safe to leave.

If you leave, modeled data already delivered to BigQuery, customer-built SQL and models, copied dashboards, and delivered documentation remain usable. SourceMedium-managed connectors, orchestration, monitoring, and proprietary transformation logic remain SourceMedium IP. SourceMedium-managed refreshes stop after offboarding. To keep receiving fresh data, move the retained assets to a customer-managed BigQuery instance.

Book a platform walkthrough See how we compare

Warehouse customers

What warehouse customers say

“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.”

Read customer stories

Ready to stop debating the numbers?

Book a platform walkthrough

In a 30-minute walkthrough, we'll review your current data stack, show how SourceMedium would replace or complement it, and demonstrate workflows relevant to your business.