From raw orders to customer lifetime value
Raw Shopify orders answer no cohort or LTV question. SourceMedium models them into analytics-ready fact and dimension tables in your BigQuery.
- Authorization
- A Shopify store admin approves the connection
- Access
- Read-only: orders, customers, products, collections, inventory, locations, marketing events, returns, fulfillment
- Store domain
- Your permanent .myshopify.com domain
- MCP server
- Official server, checked September 2026
Shopify
Commerce, order, billing, and subscription systems that anchor revenue and lifecycle reporting.
Why Shopify?
Shopify is a primary source for storefront orders. SourceMedium transforms raw order data into customer cohorts, LTV models, and attribution-ready datasets that join with marketing spend to compare attributed revenue and spend on governed definitions.
Customer cohort analysis
Orders are automatically enriched with first-order attribution, customer lifetime value, and cohort membership.
Marketing attribution
Eligible orders link to available UTMs, landing pages, and session context where identity signals allow.
Return & refund tracking
Net revenue calculations incorporate the refunds, returns, and adjustments available from connected sources, with documented definitions for LTV and AOV.
Subscription intelligence
Line-level data from ReCharge, Skio, Stay AI, or Loop Subscriptions separates subscription from one-time revenue.
Before you analyze
Boundaries that change how Shopify numbers should be read.
Which returns source counts
When Loop Returns or ReturnGO is connected, SourceMedium reads returns from it instead of from Shopify.
Details in the docsNative returns are thin
Native Shopify returns carry no return-level timestamps or complete return money, so timing fields and net return cost can be empty.
Details in the docsCount returned orders once
One order can have several return events. Count returned orders as distinct sm_order_key, not as rows.
Details in the docsSubscription order type is not a lifecycle
The subscription order type classifies each order. It does not give active subscribers, cancellations, or MRR.
Details in the docsWhat you can ask
With SourceMedium Agent, you can query Shopify data using natural language. Here are some examples.
What's our repeat purchase rate by channel? Show me LTV by acquisition month for the last 12 months Which products have the highest customer LTV? What's our average order value trend over the past 90 days? How much revenue came from subscriptions vs. one-time purchases? Joins with other integrations
Shopify 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.
Connect your store
Enter your store domain and approve read-only access in your Shopify admin. The first sync starts on its own.
Backfill & transform
Eligible historical orders are enriched with available attribution context where identity signals allow, and customer cohorts are built from the available order history.
Query or ask
Access tables directly in BigQuery with Pro, or ask SourceMedium Agent questions in plain English.
Ready to stop debating the numbers?
In 30 minutes, we will
-
Map your current systems and reporting gaps.
-
Show one workflow relevant to your team.
-
Outline likely fit, implementation scope, and next steps.
Book a walkthrough
Share a little context, then choose a time immediately after submitting.
Choose a time for your walkthrough
We couldn't load available times here.
Open the scheduling calendar in a new tab. If you cannot schedule now, we will still follow up.
Open scheduling calendar