Skip to main content
Ecommerce & Subscription

Headless commerce data, analytics-ready in BigQuery

SourceMedium syncs your Medusa store's orders, customers, products, and inventory through a read-only reporting API on your backend, then shapes them into the same commerce reporting Shopify brands use, so headless doesn't mean reporting-blind.

Medusa

Commerce, order, billing, and subscription systems that anchor revenue and lifecycle reporting.

Why Medusa?

Medusa gives your engineering team full control of the commerce stack, but that flexibility usually means building analytics yourself. SourceMedium reads Medusa through a lightweight reporting projection and delivers order, product, customer, and subscription reporting without maintaining the downstream analytics pipeline.

Full order detail

Orders sync with line items, shipping, fulfillments, refunds, and payment capture details, ready for revenue, AOV, and fulfillment analysis.

Shopify-parity schema

Medusa data lands in the same table shape as Shopify, so commerce reporting works consistently across platforms.

Catalog and inventory

Products, variants, and inventory levels stay current for merchandising and stock analysis.

Subscription reporting

For stores with a subscription module, recurring orders link back to their subscriptions for retention and LTV analysis.

What you can ask

With the AI Analyst, you can query Medusa data using natural language. Here are some examples.

What's our repeat purchase rate by cohort?
Show revenue by product this quarter
Which customers have the highest lifetime value?
What's our refund rate by month?
How many orders are currently unfulfilled?

Joins with other integrations

Medusa data is designed to join with your other data sources for unified analysis.

How it works

Setup depends on the source. We confirm access requirements, history, cadence, and customer responsibilities before implementation begins.

1

Enable the reporting API

Your developer exposes a read-only reporting projection on your Medusa backend using our checklist.

2

Share your credentials

Send SourceMedium your publishable API key and store URL; we provision the connection.

3

Validated historical backfill

We validate the data contract, backfill the available history exposed by the reporting projection, and start scheduled syncs.

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.