Niblin
complete Guide22 min read

Shopify Plus Analytics: The Complete Guide for $5M-20M Brands (2026)

Everything $5M-20M Shopify Plus brands need to know about native analytics - what works, what's broken, what you need third-party tools for, and how to build a real analytics stack.

Last Updated: May 25, 2026Atul TirkeyBy Atul Tirkey, Founder at Niblin

What Shopify Plus Analytics Actually Includes

Shopify Plus starts at $2,300 per month. Most brands focus on checkout customization and Shopify Flow, but analytics is a significant component of what you're paying for. Here's exactly what you get for analytics that you don't get on lower plans, and equally important, what you still don't get even at the Plus tier.

FeatureBasic/ShopifyAdvanced ($399/mo)Plus ($2,300+/mo)
Custom reportsNoYesYes + ShopifyQL
Customer cohort analysisNoNoYes
ShopifyQL NotebooksNoNoYes
Organization analytics (multi-store)NoNoYes
Checkout extensibility + Web PixelsNoNoYes
60+ pre-built reportsLimitedYesYes
B2B channel analyticsNoNoYes
Benchmarking (being deprecated May 2026)NoNoBeing removed

Critical gap: What Plus does NOT include (even at $2,300/month) is cross-channel attribution, ad spend data integration, ROAS or MER (Marketing Efficiency Ratio) calculations, true profitability analysis with COGS, customer lifetime value segmented by acquisition channel, predictive analytics, or anomaly detection. These are the features every analytical $5M-20M brand actually needs to make decisions. All of them require third-party tools regardless of which Shopify plan you're on.

The analytics upgrade from Advanced to Plus is meaningful - customer cohort analysis alone is useful for retention-focused teams, and ShopifyQL opens up custom query capabilities that Advanced doesn't have. But this is an incremental upgrade, not a revolution. You're not moving from "no analytics" to "complete analytics." You're moving from "basic analytics" to "more flexible analytics with custom queries."

ShopifyQL Notebooks: Custom Analytics Without SQL (Sort Of)

ShopifyQL is Shopify's biggest exclusive analytics feature on the Plus plan. It's positioned as "SQL for Shopify data," and that's technically accurate, but it's important to understand what that really means. ShopifyQL is not standard SQL. It's a Shopify-proprietary commerce-specific query language designed for ecommerce use cases. This is both a strength and a limitation.

  • Query orders, products, customers, and sessions data with granular filters and dimensions
  • Build calculated metrics on the fly - for example, average order value by product category or revenue by discount code applied
  • Create visualizations (though limited to one chart type per notebook)
  • Save queries as reusable reports that run on schedule
  • Use pre-built templates for common analyses like top selling products, impact of discount codes, seasonal trends
  • Use Sidekick AI to generate query scaffolds from natural language - describe what you want to analyze and it writes basic query structure
  • It's not real SQL. If your team has SQL experience in PostgreSQL, MySQL, or BigQuery, they'll need to learn ShopifyQL's different syntax. The language is much less flexible, and common SQL patterns don't work the same way. It's optimized for ecommerce but restricts what you can do compared to standard SQL.
  • Performance degradation with large date ranges. Running a query over 2-3 years of data is slow. Running it over 5 years is often impossible. During peak sales periods like Black Friday/Cyber Monday, even moderate date ranges timeout.
  • Complexity-based rate limiting. Shopify limits how complex a single query can be. If you build something too sophisticated, you hit a 429 rate limit error and have to wait 60 seconds before retrying. No way around it.
  • Single visualization per notebook. You cannot build a multi-panel dashboard in one notebook. One notebook = one query = one chart. If you want 5 different views of the same data, you create 5 notebooks.
  • Session data only goes back to October 2022. Any traffic analysis or session-based insights before October 2022 are gone. Your behavioral history is truncated.
  • Sidekick AI hallucinations are real. Below 500 orders of history, the AI-generated query scaffolds are often nonsensical. It tries to use fields that don't exist or creates syntax errors. The feature works better on mature stores but is unreliable for new ones.

The real use case for ShopifyQL: It's a power tool for ad-hoc analysis. A merchant or analyst asking "which products have the highest attach rate" or "how did we perform in January 2025" can get answers quickly without exporting to a spreadsheet. But it's not a replacement for a real BI platform like Looker or Tableau, and it's certainly not a replacement for proper anomaly detection or cross-channel insights.

Let's say you want to find your top 20 products by net sales with the discount impact visible. Here's a basic ShopifyQL query that works:

This works perfectly. You get your top 20 products and can see how much discount revenue you're leaving on the table. But here's where it breaks down: if you want to add COGS per product to calculate actual margin, you can't. COGS doesn't exist in ShopifyQL - Shopify doesn't store product cost natively. If you want to see attribution data (which channel drove each product's sales), you can't access that either. If you want to compare this against ad spend to calculate true ROAS per product, you're completely blocked. This is where third-party tools become essential.

Multi-Store Organization Analytics: The Promise vs Reality

Shopify Plus is the only plan that lets you run multiple stores under one account and see organization-level analytics. This is genuinely useful if you operate several brands, regional variations, or separate DTC channels. However, the implementation has serious limitations that most brands discover only after investing heavily in multi-store setup.

  • High-level KPI cards showing aggregated total sales, orders, and conversion rates across all stores
  • Store dimension available in custom reports - you can filter by individual store
  • Winter 2026 update: ShopifyQL now works across stores, so you can write queries that span multiple stores in a single notebook
  • Heatmap visualizations comparing store performance side-by-side
  • Organization-level customer cohort analysis (view repeat purchase patterns across stores)
  • Siloed architecture. Shopify Plus uses completely independent, separate stores, not a unified data model. Each store is its own database. This means aggregation is artificial - it happens at the reporting layer, not at the data layer.
  • No cross-store trend analysis. If Store A is growing 15% while Store B declined 8%, you have to manually compare the reports. There's no automatic "X store is outperforming Y store by these factors" insight.
  • Multi-currency normalization nightmare. If you operate in different regions with different base currencies, aggregating sales meaningfully requires manual conversion. "Total sales across all stores" might sound clean but the math is actually ugly.
  • No shared inventory reporting. If you sell from multiple stores with shared inventory, you cannot see total stock across all locations natively. You'll export each store's inventory data and consolidate manually.
  • 3-4x setup effort for cross-store reports. Building a single custom report that spans stores takes much longer than a single-store report. The ShopifyQL queries get complex fast.

Most $5M-20M brands with multiple Shopify stores that need real unified analytics end up building a data warehouse pipeline. They connect Shopify → Fivetran → BigQuery → Looker and consolidate everything there. This costs $300-3,000 per month but solves the siloed architecture problem completely. It's a real solution; Shopify Plus organization analytics is a partial solution.

When multi-store reporting works: If you just need a dashboard showing "Store 1: $50K, Store 2: $45K, Store 3: $60K," Shopify Plus organization analytics is fine. If you need to understand what's driving differences between stores or track shared inventory, you need a data warehouse or a unified analytics platform.

Custom Reports: What You Can and Can't Build

Both Advanced and Plus include Shopify's Data Exploration Builder, which lets you build custom reports without writing code. It's a drag-and-drop interface where you select metrics, dimensions, and filters. Plus adds ShopifyQL on top, giving you more power for complex analyses. Let's break down the hard limits that affect every brand, regardless of tier.

  • Any report that combines order, product, customer, or session dimensions from Shopify data
  • Add multiple filters and segments to narrow down data
  • Calculate derived metrics on the fly using built-in functions
  • Save custom reports for recurring use
  • Use Sidekick AI to generate report starting templates from natural language descriptions
  • B2B-specific reports with filters for B2B orders, customer type
  • Side-by-side B2B vs D2C sales comparison for brands selling both
LimitationImpact on Your AnalyticsWhat to Use Instead
Reports API deprecated (REST API 2024-04)You can't programmatically create or access reports via API anymore. No automation for report generation.Use ShopifyQL via GraphQL API instead, or use third-party tools
Admin displays max 1,000 rowsYou can't see full datasets in the browser. Reports get truncated if you have large catalogs or customer lists.CSV export to spreadsheet, but capped at 10,000 rows
CSV exports capped at 10,000 rowsBrands with 50,000+ SKUs or large customer lists get incomplete data. Historical data is lost.Data warehouse pipeline (Fivetran to BigQuery) required
No COGS integrationYou cannot calculate gross margin or profit per product natively. No margin trending.Mipler, BeProfit, or manual COGS upload
No Customer Lifetime Value by acquisition channelYou can't determine which marketing channels produce the highest-value customers. Attribution is missing.Lifetimely, Niblin, or Triple Whale
No predictive modelsNo churn prediction, demand forecasting, or customer lifetime value projections.Custom BI solution or specialized predictive analytics tool

The Reports API deprecation in April 2024 was significant. Many brands had built automated workflows that pulled reports at 3am and fed them into Slack or email. That's no longer possible via the REST API. The GraphQL API exists but requires more engineering work to set up.

The Checkout Tracking Crisis Nobody's Talking About

If you're a Shopify Plus merchant and noticed your conversion tracking numbers dropped in late August 2025, you're not alone. And it's not a bug in your store - it's a fundamental change Shopify made to how checkout works. This affected thousands of brands and it's still causing problems six months later.

Shopify disabled checkout.liquid for thank you pages and order status pages. For the previous 5+ years, merchants could inject custom JavaScript into checkout.liquid and it would execute on the checkout confirmation page. This was the standard way to fire conversion tracking events to Google Analytics 4, Meta, Google Ads, and other third-party platforms.

On August 28, 2025, all custom JavaScript inside checkout.liquid stopped firing. Shopify moved checkout to a completely sandboxed, privacy-first environment. The old way of tracking - inject JavaScript, access the DOM, read order details, fire events - no longer works.

  • Custom GA4 conversion tracking scripts that relied on checkout.liquid
  • Meta/Facebook pixel purchase events from the thank you page
  • Google Ads conversion tracking tags
  • Any third-party tracking that relied on DOM access to read order data
  • UTM parameter forwarding to analytics platforms

For a $10M/year brand, a 30-40% loss of checkout conversion data is a serious problem. That represents roughly $100K-$150K per month in untracked revenue. The downstream effects are worse: your ad platforms have 30-40% less conversion data to optimize on. Your attribution models become unreliable. Your CFO gets reports showing $5M in Shopify revenue but GA4 only tracked $3M in purchases. You're flying blind.

This impacts your ad optimization directly. Meta and Google Ads use conversion data to train their algorithms. With 30-40% less data, their bidding becomes less efficient. You typically see CPM increases of 15-25% as the algorithm degrades. This isn't an analytics problem; it's a revenue problem.

  1. Compare your Shopify order count (from the Orders report) to GA4 purchase events for the past 30 days
  2. If GA4 shows 30%+ fewer purchases than Shopify recorded, your checkout tracking is broken
  3. Check Meta Events Manager (if you have the Meta pixel installed) for purchase event drops after August 2025
  4. Review your Customer Events settings in Shopify admin - if it shows 0 or very low purchase events being sent, the integration is broken
  • Migrate to Web Pixels API: Shopify's new standard for checkout tracking. Replace checkout.liquid with Web Pixels. This requires engineering work but is the official solution.
  • Use Analyzify or Littledata: Both offer managed migration services. They handle the technical work of re-implementing tracking via Web Pixels.
  • Implement Meta Conversions API (CAPI): Server-side tracking that doesn't rely on client-side pixels. Meta CAPI sends purchase events from your backend, bypassing browser-level tracking issues entirely.
  • Set up GA4 server-side tracking: Via Google Tag Manager's server container or directly via Shopify's Customer Events API.
  • Use Niblin's anomaly detection: Even if your tracking is degraded, Niblin monitors for tracking gaps automatically. It can alert you when conversion data drops unexpectedly, catching problems before they cascade.

The Web Pixels API is the long-term solution. But it requires rebuilding your tracking setup. Most brands who've migrated report it takes 2-4 weeks to fully implement and validate. In the meantime, server-side tracking (CAPI) is a workaround that restores most of the missing data.

What's Missing from Shopify Plus Analytics (The Honest List)

Even at $2,300+/month, Shopify Plus analytics has enormous gaps. These gaps exist on EVERY Shopify plan, even Plus. Understanding what's missing is critical for building a real analytics stack.

Missing MetricWhy It's Critical at $5M+What to Use Instead
Customer Lifetime Value (by channel)Need to know which acquisition channels produce highest-value customers. This drives CAC optimization decisions.Lifetimely ($49/mo), Niblin ($299/mo), Triple Whale ($500+/mo)
Customer Acquisition Cost (CAC)Can't calculate without integrating ad spend data across channels. Shopify has zero access to your ad accounts.Manual calculation via spreadsheet or analytics platform with ad spend integration
ROAS / MER (Marketing Efficiency Ratio)The most important metric for scaling. No ad spend integration means no ROAS.Triple Whale, Niblin, Polar Analytics (all include ad spend integration)
True profit per orderNo COGS, 3PL fees, payment processing costs, or shipping cost integration. Revenue ≠ profit.BeProfit, Niblin, manual spreadsheet with cost data
Contribution margin by productCan't identify which SKUs are actually profitable vs loss-leaders. Mix optimization is impossible.Custom BI tool or analytics platform with COGS data
Churn predictionNo predictive modeling. Can't forecast which customers are at risk of churning.Peel Insights, custom machine learning model
Multi-touch attributionOnly last-click attribution available. First-click, linear, and time-decay models not supported.Triple Whale, Northbeam, Rockerbox
Missing CapabilityImpact on Your BusinessWhat to Use Instead
Anomaly detection / alertsProblems go unnoticed for 12-24 hours. Tracking breaks, conversion rates drop, inventory runs out - all silently.Niblin (47+ alert rules with <1 hour detection)
Cross-platform unified viewShopify + Amazon + Meta + Google + TikTok all siloed. No single dashboard showing business health.Niblin, Daasity, Polar Analytics
Behavioral analytics (heatmaps, session replay)Can't see where users click, scroll, drop off. Checkout optimization is guesswork.Microsoft Clarity (free), Hotjar ($99+/mo)
Real-time data during peak sales12-24 hour data delay during BFCM makes real-time decisions impossible. You're optimizing blind.Third-party dashboards with real-time connectors
Historical data beyond 13 monthsYoY comparisons impossible after 13 months. Long-term trends are erased.Data warehouse (BigQuery, Snowflake) with full historical export
Automated reporting to Slack/emailManual checking required every day. No proactive briefings.Niblin Monday briefings, custom Flow automation with third-party tools
Funnel visualizationCan't trace customer journey from ad click → product view → checkout → order. Conversion optimization is disconnected.GA4 funnel exploration + behavioral analytics tool

This isn't criticism of Shopify. Shopify is a commerce platform, not a business intelligence platform. The platform does what it's designed to do: run checkouts, manage inventory, process orders. Analytics is secondary. The key insight is: know what you're missing, and plan for the gaps in your stack.

The Real Analytics Stack for $5M-20M Shopify Plus Brands

What does the analytics infrastructure actually look like at successful $5M-20M brands? We analyzed ecosystem data and spoke with merchants. Here's what works in practice.

This is what we recommend for brands that want baseline coverage without over-investing:

LayerToolCostWhat It Solves
Commerce dataShopify Plus (native)$2,300+/moOrder data, inventory, customer basics, ShopifyQL custom queries
Traffic & behaviorGoogle Analytics 4FreeUser behavior, traffic sources, funnel analysis, conversion tracking
Cross-channel intelligenceNiblin$299/moUnified view of Shopify + Meta + Google + Amazon, anomaly detection, AI Q&A, Monday briefings
Behavioral analysisMicrosoft ClarityFreeHeatmaps, session replay, scroll depth, interaction analytics

Total monthly cost: ~$2,600 (Plus subscription + Niblin). This covers 80% of what growing $5M-20M brands need to make data-driven decisions. You have commerce data, traffic insights, cross-channel visibility, behavioral analytics, and proactive anomaly detection.

For brands with dedicated growth teams or complex operations, this is more complete:

LayerToolCostWhat It Adds
Minimum stack - ~$2,600/mo -
Multi-touch attributionTriple Whale or Northbeam$500-2,000/moFirst-touch, linear, time-decay attribution; ad spend integration; incremental ROAS
Profitability & COGSBeProfit or Finaloop$75-500/moCOGS integration, margin by product, true P&L by channel
Data warehouseFivetran → BigQuery → Looker$1,000-3,000/moUnlimited custom analysis, historical data, unified multi-store reporting
Advanced retention/LTVLifetimely or Peel Insights$49-500/moCohort retention curves, predictive LTV, segment analysis, forecast modeling

Total monthly cost: $4,000-9,000. This is what brands with dedicated analytics or growth teams run. It provides attribution modeling, profitability visibility, unlimited historical data, and predictive analytics.

ROI math: If you're doing $10M/year and your analytics stack costs $5,000/month ($60,000/year), the stack only needs to improve decisions by 0.6% to pay for itself. Most data-driven brands find 5-15% improvement in ad spend efficiency, margin, or inventory optimization. The ROI is almost always positive.

  • Minimum Viable Stack: You have 1-2 revenue channels. You don't have a dedicated analyst. You want to understand your business without hiring. This is the right choice.
  • Full Stack: You have multiple channels (DTC + Amazon + wholesale). You have a team making data-driven decisions. You need attribution modeling and profit visibility.
  • Enterprise Stack: You're $20M+ or operating complex fulfillment. You need unlimited querying, predictive models, and dedicated BI/analytics engineering resources.

Shopify Plus vs Advanced: Is the Analytics Upgrade Worth $2,000/Month?

Many brands ask: should we upgrade from Advanced ($399/mo) to Plus ($2,300+/mo) just for better analytics? Let's be direct: the analytics improvements alone are not worth the upgrade. But the full platform might be.

FeatureWorth Upgrading For?Why / Why Not
ShopifyQL NotebooksMaybe - useful but overratedGood for ad-hoc queries, but limited visualization, performance issues, and rate limiting reduce value. Lifetimely or a BI tool often feels more complete.
Customer cohort analysisYes - if retention is criticalGenuinely valuable for understanding repeat purchase patterns. But Lifetimely does cohorts better for $49/mo. Advanced already has basic cohort reports.
Organization analyticsYes - if you run 2+ storesOnly relevant if you have multiple stores. If single-store, this is irrelevant. Even if multi-store, the siloed architecture limits usefulness.
Checkout extensibilityYes - high impactCustom checkout drives real revenue. But this is a platform feature, not analytics. Still listed under "analytics upgrade" because it's integrated.
B2B channel analyticsYes - if you sell B2BNative B2B support is genuinely better than third-party apps. Analytics are basic but functional.

The honest answer: Don't upgrade to Plus for analytics alone. The incremental analytics features (ShopifyQL, cohorts) can often be replicated with $50-300/month third-party tools. Upgrade to Plus for the full platform features - checkout customization, B2B, Shopify Flow, lower transaction fees. Then layer analytics on top with purpose-built tools. You'll likely end up at similar or lower total cost with better analytical capabilities.

If you're Advanced ($399/mo) + Lifetimely ($49/mo) + Triple Whale ($500/mo) = $948/mo in analytics spend, you're getting cohorts, LTV analysis, and ROAS. Moving to Plus ($2,300+/mo) alone and using its native features gives you ShopifyQL and cohorts, but you still need Triple Whale ($500/mo) for ROAS, so you're at $2,800+/mo. You've spent more money and gotten less value. That's the trap.

Fill the Gaps in Your Shopify Plus Analytics

Shopify Plus handles order data well. Custom reports work. ShopifyQL is useful for ad-hoc queries. But for cross-channel intelligence, anomaly detection, and answers to "why did this happen?" - you need a layer on top.

That's what Niblin does. It connects to Shopify Plus, Meta, Google Ads, Amazon, TikTok, and GA4. Ask your data anything in plain English. Get your Monday morning briefing automatically. Know when metrics deviate from expectations before they become problems. All the gaps Shopify Plus leaves - unified view, anomaly detection, ROAS by channel, LTV by source - Niblin fills.

See what unified analytics looks like.
Connect your Shopify Plus store in 15 minutes. Access all data sources on every plan. No credit card required.

Start Your Free Trial

Key Takeaways

  • Shopify Plus analytics adds ShopifyQL, cohort analysis, multi-store reporting, and B2B dimensions - but these are incremental improvements, not a revolution
  • ShopifyQL is powerful for ad-hoc queries but has performance limitations, rate limiting, and is not standard SQL
  • Multi-store organization analytics exist but use siloed architecture - true unified reporting requires a data warehouse pipeline
  • The August 2025 checkout.liquid deprecation silently broke conversion tracking for many Plus stores - check your GA4 vs Shopify order counts immediately
  • Shopify Plus at $2,300+/month lacks: cross-channel attribution, ad spend data, ROAS, profitability, LTV by channel, anomaly detection, and predictive analytics
  • Don't upgrade to Plus for analytics alone - the incremental features cost less via third-party tools. Upgrade for the full platform (checkout, B2B, Flow) and supplement analytics separately
  • Minimum viable analytics stack for $5M-20M brands is ~$2,600/month (Plus + one unified platform). Full stack with attribution and profitability is $4K-9K/month
  • The ROI on analytics investment is typically 5-15% improvement in ad efficiency or margin - almost always positive

Frequently Asked Questions

What analytics does Shopify Plus include?

Shopify Plus includes everything in lower plans - pre-built reports, data exploration builder - plus ShopifyQL Notebooks for custom queries, customer cohort analysis, organization analytics for multi-store reporting, checkout extensibility with Web Pixels, and B2B channel analytics. However, it does NOT include cross-channel attribution, ad spend data, ROAS, true profitability with COGS, customer lifetime value by channel, or anomaly detection. Those require third-party tools on any plan.

Is Shopify Plus worth it for analytics alone?

No. The analytics upgrades from Advanced to Plus - ShopifyQL, cohort analysis - are incremental improvements. Most of these capabilities can be replicated with third-party tools for $50-300/month. Upgrade to Plus for the full platform (checkout customization, B2B, Shopify Flow, lower transaction fees), not analytics alone. Then supplement with purpose-built analytics tools.

What is ShopifyQL?

ShopifyQL is Shopify's proprietary commerce-specific query language, exclusive to Shopify Plus. It lets you write custom queries against your store's orders, products, customers, and sessions data. It's similar to SQL but uses different syntax and is optimized for ecommerce. Key limitations: performance degrades with large date ranges, single chart per notebook, complexity-based rate limiting, and session data only goes back to October 2022.

Does Shopify Plus have better reporting than Advanced?

Yes, but incrementally. Plus adds ShopifyQL Notebooks, customer cohort analysis, multi-store organization analytics, and B2B reporting dimensions. Advanced already includes custom reports and the data exploration builder. The biggest gaps - cross-channel attribution, profitability analysis, predictive analytics - exist on BOTH plans and require third-party tools.

How much does a full analytics stack cost for a $5M+ Shopify Plus brand?

A minimum viable stack runs about $2,600/month (Plus subscription + one unified analytics platform like Niblin). A full data-driven stack with multi-touch attribution, profitability tracking, and a data warehouse runs $4,000-9,000/month. The ROI is typically 5-15% improvement in ad efficiency or margin, which easily justifies the investment.

What should I do about the checkout tracking crisis?

The August 2025 migration broke conversion tracking for many stores. Fix it by: (1) migrating to Web Pixels API (official Shopify solution), (2) implementing Meta Conversions API (server-side tracking), or (3) using Analyzify/Littledata for managed migration. Check your conversion data immediately by comparing Shopify orders to GA4 purchases. If there's a 30%+ gap, your tracking is broken.

Ready to optimize your e-commerce analytics?

Connect your Shopify and Amazon stores to get unified insights across all your sales channels.