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 your source of truth for revenue. SourceMedium transforms raw order data into customer cohorts, LTV models, and attribution-ready datasets that join with your marketing spend to reveal true ROAS.
Customer cohort analysis
Orders are automatically enriched with first-order attribution, customer lifetime value, and cohort membership.
Marketing attribution
Each order links to UTMs, landing pages, and sessions—enabling first-touch, last-touch, and multi-touch attribution.
Return & refund tracking
Net revenue calculations include refunds, returns, and adjustments so your LTV and AOV are always accurate.
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
Get started in minutes. Connect your account, configure sync settings, and start querying unified data in BigQuery.
Connect your store
OAuth into Shopify with read-only access. We pull orders, customers, products, and transactions.
Backfill & transform
Historical orders are enriched with attribution data and customer cohorts. Incremental syncs run 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?
Get started
Tell us a bit about your brand and stack—we’ll follow up shortly.
You're all set