Skip to main content
Before starting your SourceMedium integration, it’s helpful to understand your Shopify store’s historical data volume. This helps us set accurate expectations for your onboarding timeline and plan the best ingestion strategy.
Why does data volume matter?SourceMedium ingests your complete historical data to power accurate LTV calculations, cohort analysis, and customer journey insights. Larger data volumes take longer to process—and for very large stores, we may recommend a phased approach to get you up and running faster.

​
What You’ll Need

  • Shopify Admin access with permissions to view Analytics/Reports
  • 5 minutes to run a simple query and share the results

​
Step-by-Step Instructions

1

Open the ShopifyQL Editor

  1. Log into your Shopify Admin at https://your-store.myshopify.com/admin
  2. Click Analytics in the left sidebar
  3. Click the Reports tab (or go to Analytics → Reports)
  4. Click Create custom report (or look for “Explore” / “New exploration”)
The ShopifyQL Editor is available in Shopify Admin under Analytics → Reports. The exact UI may vary depending on your Shopify plan and permissions.
2

Copy and Paste the Query

Copy this entire query and paste it into the ShopifyQL Editor:
FROM sales
SHOW
  orders AS "Order Count",
  units_sold AS "Units Sold",
  customers AS "Customer Count"
TIMESERIES year
SINCE 2010-01-01
UNTIL today
About the SINCE date: We use 2010 to capture most stores’ full history. If your store is older, adjust to an earlier date. ShopifyQL will only return data from when your store actually started.
3

Run the Query

Click the Run button (or press Cmd/Ctrl + Enter) to execute the query.You’ll see a table with one row per year showing:
  • Order Count — Number of orders placed that year
  • Units Sold — Total quantity of items sold (e.g., an order with 2 shirts and 1 hat = 3 units)
  • Customer Count — Number of unique customers that year
Example output:
YearOrder CountUnits SoldCustomer Count
201945,00095,00032,000
2020120,000260,00085,000
2021180,000400,000125,000
…………
Current year (YTD)85,000190,00060,000
Sum up the Order Count column to get your total.
4

Share the Results

Take a screenshot of the table or copy the numbers and share them with your SourceMedium onboarding contact via Slack or email.A screenshot of the results works great, or just copy/paste the table. Include:
  • The year-by-year breakdown
  • Your total order count
  • When your store launched (first year with data)

​
What Happens With Your Results

Once you share your data volume, your SourceMedium contact will confirm your expected onboarding timeline. We always prefer full historical ingestion — it gives you the most accurate LTV calculations, complete cohort analysis, and reliable year-over-year comparisons. For very high-volume stores (think: 10+ years of history, millions of orders), full ingestion may take longer. If you have a specific go-live deadline, let us know and we can discuss options—such as starting with recent data while full history loads in the background.
Why does historical data matter?Lifetime Value (LTV) calculations depend on seeing a customer’s complete purchase history. If we only load 2 years of data, a customer who first purchased 5 years ago will appear as a “new” customer—which understates their true LTV.Once full history is loaded, all calculations automatically update to reflect complete customer journeys.

​
Frequently Asked Questions

The exact location varies by Shopify plan and UI version. Try:
  • Go to Analytics → Reports and look for “Create custom report” or “Explore”
  • Go directly to: https://your-store.myshopify.com/admin/reports
If you still can’t find it, take a screenshot of what you see under Analytics and share it with us—we’ll help.
Common issues:
  1. “Syntax error” — Make sure you copied the entire query exactly, including the line breaks.
  2. “No data returned” — Your store may be very new. That’s fine—just let us know.
  3. “Access denied” — You may need different permissions. Ask your store owner to run it, or share what you see and we’ll help.
Yes — change TIMESERIES year to TIMESERIES quarter in the query. This is helpful if you want to see seasonal patterns.
These counts determine how long data ingestion takes:
  • Orders — The primary driver of ingestion time
  • Units Sold — Shows data density; more units per order means more data per order
  • Customers — Used for LTV calculations, cohort analysis, and customer journey insights
Order count is the best single predictor of ingestion time, but units sold gives us a sense of how much data each order contains.
If you have a specific go-live deadline and your data volume is high, let your SourceMedium contact know during onboarding. We can discuss options like starting with recent data while full history loads in the background.

​
What Happens Next

After sharing your data volume assessment:
  1. We’ll confirm your onboarding timeline — Based on your volume, we’ll set realistic expectations
  2. You’ll receive integration instructions — Follow our Shopify Integration Guide to grant access
  3. Data ingestion begins — We’ll start pulling your data and notify you when it’s ready for review

Ready to integrate?

Continue to Shopify Integration Instructions →