Subscription

Beyond Shopify Native Reports: Subscription Questions It Can't Answer

Sumeet Bose
Content Marketing Manager
Last updated:
November 19, 2026
15
min read
The subscription questions Shopify's native reports cannot answer on their own, and where the missing data lives.
TL;DR
  • Shopify's reports are accurate about what the store recorded, and subscription questions often sit outside it.
  • If the event a report counts is not an order, the store cannot report it.
  • Shopify's cohort exploration groups customers by first order and measures metrics such as net sales.
  • Native profit margin rests on a cost per item that Shopify calls static.
  • Cancellation reasons, failed charges and next scheduled charges are usually recorded by the subscription app.
  • A KPI master fixes what counts as subscription revenue, and default definitions settle the denominator.
  • Lineage shows which platform each figure came from, so a store-only share is easy to spot.

Shopify custom reports can be filtered, regrouped and queried in ShopifyQL, and they are accurate about what the store recorded. That accuracy is what makes them risky for a subscription brand. A correct answer to a store question can sit under a wrong answer to a business question, which often shows up only when a number reaches finance.

A report built on one system answers questions about that system, and the questions a subscription brand asks sit across several. This guide covers where the data for those questions lives, five questions a store report cannot answer alone, and where a second source starts to matter.

Where the Data for Subscription Questions Lives

Subscription questions draw on four places. The store holds orders, customers and the cost per item you enter. The subscription app holds status, cadence, cancellation reasons and the next scheduled charge. Amazon Seller Central holds Amazon orders, and finance holds closed revenue and costs.

What each source holds

Shopify custom reports draw only on the first of these, so each other source holds events the store never sees.

SourceWhat it holdsWhat it cannot see
Shopify storeOrders, customers, products, sessions and the cost per item you enterSubscription status and schedule, Amazon orders, costs beyond the cost per item
Subscription appStatus, cadence, cancellation reasons, failed charges, next scheduled chargeOrders and margin outside that app, Amazon
Amazon Seller CentralAmazon orders, including Subscribe & SaveStore orders and the app's schedule
FinanceClosed revenue and costsSubscription status and cohort

General patterns. Your setup may differ.

Shopify's default report categories are acquisition, behavior, customers, finance, fraud, inventory, marketing, order, profit, retail sales and sales, and none of them is a subscription category.

Why does the same metric differ between them?

A Shopify reporting dashboard shows the store's count of active subscribers, and the subscription app shows its own, so the two can differ while both are working. The mechanism is in why your subscription platform and Shopify numbers disagree.

The Subscription Questions Shopify Custom Reports Cannot Answer Alone

Shopify custom reports cover the store well, so the questions they cannot answer alone need a second source joined. The five that matter most are the share outside the store, retention after margin, why subscribers cancel, revenue already scheduled, and entry paths that earn their cost.

How much of the subscription business sits outside the store?

Amazon records Subscribe & Save orders in Amazon, so a report built on store orders leaves them out. In one illustrative brand, a store-only view reads a 33% subscription share against 52% with Amazon included. The full example is in why your Amazon Subscribe & Save business is invisible in your Shopify numbers.

Which cohorts retain after margin?

Shopify's cohort exploration groups customers by their first order and measures metrics such as net sales and amount spent per customer. Margin sits in separate profit reports, built on a cost per item that Shopify describes as static. A subscription cohort after intro offers needs the subscription start and the margin together, and how to choose LTV and cohort software for subscription brands covers the cuts.

Why do subscribers cancel, and is it a choice or a failed payment?

A store report sees orders that stop. The cancellation reason and the failed charge are usually recorded by the subscription app. The store cannot say which one ended the subscription, and when churn means three different things across your tools shows why that matters.

How much revenue is already scheduled to bill?

Future charges are not orders yet, so they do not appear in store order history. The next scheduled charge for each subscription sits in the subscription app, and reading it as a forward number is covered in your committed rebill revenue as a forward number.

Which entry paths earn their cost?

Store sales can be attributed to marketing channels in Shopify, but the costs its profit reports list are product cost, shipping, duties and import taxes, with no ad spend. Whether a first order started a subscription is recorded in the subscription app. An entry path earns its cost only when spend, subscription start and margin sit on one customer.

What Shopify Custom Reports Do Well and Where a Second Source Starts

Shopify custom reports are the right tool when the question stays inside store orders. That covers sales over time, profit by product with a cost per item entered, and customers grouped by first order. A second source becomes necessary when the question involves a subscription's status, an Amazon order or a cost the store does not hold.

Questions that stay inside the store

Per Shopify, the main analytics features are available on any plan, and a modified report can be saved as a custom exploration regardless of plan. Advanced reporting options beyond default Shopify reports, such as custom explorations with filters and ShopifyQL, can answer a store-only question without a second tool.

Where a second source becomes necessary

The cost-per-item field is static, Shopify notes, so profit reports reflect a point in time, and it suggests an ERP or accounting system for dynamic reporting. Advanced Shopify reports stop at the edge of the store's records, and an order the store never created, such as one from Amazon, is outside them.

Note: A quick test for any report is to ask which system recorded the event it counts. If the event is not a store order, a store report cannot count it.

In practice, the finance lead lists the questions the board asked last quarter and marks which system recorded each event. Questions marked store go to Shopify reports, and the rest go to the system that holds the event. Only the second group needs a joined view.

How Saras iQ Helps

Saras iQ reads the store, the subscription apps, Amazon and cost data in one certified layer, so the questions that cross sources get one answer. For a team that has outgrown Shopify custom reports, that means the subscription questions run on every source at once.

The store and the subscription apps in one view

In iQ, subscription records from Recharge, Skio, Loop, or Stay AI sit in one normalized dataset with the source platform on every record. The dataset includes cancellation reasons and comments, next scheduled charge, recurring revenue and cadence. A field a platform does not provide stays empty and is never inferred.

Where Saras iQ Fits

iQ does not replace Shopify reports for questions that stay inside the store. It adds the sources those reports cannot see. Lineage ties each figure to the platform it came from, and a KPI master and default definitions fix what counts as subscription revenue and which denominator a share uses. A Saras consultant writes them with the business, and a Saras analyst tests them against your historical questions before go-live.

LybCorp's CTO describes what cross-source reconciliation used to cost.

"Our monthly financials used to take 10+ days to reconcile. Now we've brought that process down to just a few hours."

Joe Cohn, CTO, LybCorp

The context layer behind iQ comes with three capabilities for questions that cross sources.

  • Lineage to each platform. A figure traces to the store, the app, Amazon or finance, so a store-only number stands out.
  • KPI master for subscription revenue and share. Each is defined once, with the denominator named.
  • Default definitions for basis and period. Defaults settle gross against net and which period a month covers.

Conclusion

Shopify custom reports earn their place on store questions, and the subscription questions that matter most need a second source joined. Before you rebuild a report, ask which system recorded the event it counts. Shopify reporting tools differ in what they read, so match the tool to the system that holds the event. The generic guides are in our Shopify reports guide, Shopify analytics dashboard guide and enterprise Shopify analytics platform guide.

If you want your store, subscription app, Amazon and cost data answering one question together, talk to our data consultants at Saras Analytics. They can set it up with Saras iQ.

Frequently Asked Questions (FAQs)

What are the alternatives to standard Shopify analytics for a subscription brand?
+

They sort by what they read. Custom explorations stay inside the store, the subscription app's own analytics stay inside that app, Shopify reporting apps extend the store's views, and a warehouse or governed layer joins sources. Pick by whether your question stays in one system.

Is my Shopify subscription share the whole picture?
+

Only if every subscription runs on Shopify. Amazon Subscribe & Save orders are recorded in Amazon, so a share built from store data alone understates the business. Name the denominator whenever you quote a share, because the same revenue reads differently over store revenue and company revenue.

When is a store report enough?
+

When the question stays inside store orders, such as sales over time, profit by product with a cost per item entered, or customers grouped by first order. It stops being enough when the question needs a subscription's status, an Amazon order or a cost the store does not hold.

Where does cancellation data live?
+

Usually in the subscription app, because that is where a subscriber cancels and where a failed charge is retried. A store report sees the orders that stop but not the reason. Check each app before you rely on a reason field, since what it records varies.

+
+

What to do next?

Test your Data Readiness
Take the Quiz
Take a quick 5-min quiz and find out how future-proof your stack really is.
See Saras in Action
If you're ready to stop pulling reports manually and centralize your eCommerce data, see exactly how Saras does it in a 25-minute demo. No prep required.
Book a Demo
Check out Saras Analytics × 9 Operators Podcast
Listen to how top eCommerce operators think about data, growth, and analytics
Listen Now
Table of Contents
Heading one of the blog
Heading one of the blog
Heading one of the blog
Heading one of the blog
Heading one of the blog
Heading one of the blog
Get instant, trusted answers across your business functions
Meet Saras iQ: The AI analyst for your e-commerce business

Must read resources

Get instant, trusted answers across your business functions

Meet Saras iQ: your e-commerce AI analyst, powered by your business data, certified by us