From raw orders to customer lifetime value
SourceMedium ingests your Shopify orders, customers, products, and transactions—then transforms them into analytics-ready fact and dimension tables. Ask questions like 'What's our repeat purchase rate by channel?' and get answers immediately.
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
Orders sync with ReCharge, Stay AI, and Loop to distinguish subscription vs. one-time revenue.
What you can ask
With the AI Analyst, 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
OAuth into Shopify with read-only access. We pull orders, customers, products, and transactions.
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. Incremental syncs run approximately every 15 minutes.
Query or ask
Access tables directly in BigQuery, or ask the AI Analyst questions in plain English.
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.
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