Shopify Analytics Tutorial: Beyond the Default Dashboard

Shopify's analytics dashboard is designed to answer one question: what sold? It does that job well. Revenue by day, top products, sessions by channel, conversion rate, average order value — these are clean numbers, updated in near real time, and accessible to any team member without SQL.

The problem is that "what sold" is rarely the question operators need answered. The questions that drive decisions are different: Which products are actually profitable after shipping and returns? Which acquisition channels have acceptable payback periods? Are customers who came through email retaining at higher rates than paid social cohorts? Shopify's default dashboard does not answer any of those questions — and on most plans, it cannot.

This tutorial covers what Shopify Analytics actually includes, where its hard limits are, how to use its custom report builder effectively, and which external tools fill the gaps that native reporting was never designed to close.

What Shopify Analytics actually includes

Shopify ships with more than 60 reports across eight categories: overview, sales, orders, customers, products, inventory, marketing, and custom. The depth varies significantly by plan, but even on Advanced, the reports are bounded by what Shopify can see — which is the commerce layer only.

Overview dashboard

The overview dashboard shows total sales, orders, sessions, returning customer rate, and online store conversion rate for any date range. You can compare to a prior period and break sessions down by device. This is Shopify at its most useful: clean, real-time revenue tracking that requires no configuration.

Sales reports

Sales reports break revenue down by channel, product, SKU, customer, discount, and fulfillment status. The "Sales by product" report is one of the most-used native reports — it shows units sold, gross revenue, returns, and net sales per product. What it does not show is margin, because Shopify does not automatically factor in cost of goods.

Customer reports

Customer reports include new vs. returning customer analysis, customer over time, and — on Advanced and Plus — cohort analysis. The cohort report groups customers by first purchase month and shows how much each cohort spent in subsequent months. It is a genuine analytical capability, but it is tightly scoped: no channel segmentation, no LTV projection, no CAC comparison.

Marketing reports

Marketing reports show sessions and conversion attributed to each traffic source using last-click attribution. The channel breakdown includes organic search, paid search, social, email, direct, and referral. If a customer clicked a TikTok ad, then came back through email three days later and converted, the sale is credited entirely to email. The TikTok ad gets no attribution credit — and there is no way to change that within Shopify's native marketing reports.

The four gaps that Shopify Analytics cannot close

Shopify's reporting gaps are structural — they reflect deliberate product choices, not missing features that will be patched in the next release. Understanding them precisely matters more than hoping for native fixes.

1. Last-click attribution only

Every sale in Shopify is attributed to the channel that drove the final click before purchase. There is no multi-touch model, no linear attribution, no time-decay weighting. This systematically overstates the value of direct traffic and remarketing campaigns — both of which appear at the bottom of the funnel — while understating the contribution of top-of-funnel channels like TikTok, YouTube, and influencer content that drive awareness but rarely capture the final click.

For stores running active paid media across more than one channel, last-click attribution produces budget decisions that reward the wrong channels. The effect compounds as ad spend scales.

2. No profit visibility without COGS setup

Shopify can display gross profit per product, but only if you have manually populated the "Cost per item" field on every product variant in your admin. Many stores never complete this step. Those that do still get an incomplete picture: the profit report accounts for COGS but excludes shipping costs, payment processing fees, refund handling, and ad spend — so the margin it shows is gross margin in the accounting sense, not the contribution margin that operators actually need to make sourcing and pricing decisions.

A store doing $200,000 in monthly revenue with 40% gross margin on products does not have a 40% contribution margin if shipping costs 8%, transaction fees take 2.9%, and paid acquisition averages 15% of revenue. The actual contribution margin is closer to 14% — and Shopify's default profit report will not show you that number.

3. Cohort analysis locked behind Advanced

Cohort retention is one of the most predictive metrics available to an ecommerce operator. Knowing whether customers acquired in January are still buying in July tells you far more about the business's health than average order value or monthly revenue. Shopify's cohort report is only available on Advanced ($299/month) and Plus plans. On Shopify Basic ($39/month) and the standard Shopify plan ($79/month), there is no native cohort analysis at all.

Even on Advanced, the cohort report is limited to revenue-based retention. It does not segment by acquisition channel, product category, discount use, or customer geography. If you want to know whether paid social cohorts retain better than organic search cohorts — a question central to CAC payback analysis — the native report cannot answer it.

4. No cross-data-source joins

Shopify only sees data that lives inside Shopify. It cannot pull in ad spend from Facebook or Google, landed cost data from your 3PL or ERP, financial data from QuickBooks, or behavioral data from Klaviyo or Postscript. This means any analysis that requires combining Shopify order data with data from another system — true ROAS, contribution margin by channel, LTV by acquisition source, or gross margin adjusted for landed costs — requires going outside Shopify entirely.

How to set up custom reports in Shopify

Shopify's custom report builder is available on the Shopify plan and above (not Basic or Starter). It lets you create reports from a set of pre-defined dimensions and metrics — you cannot write SQL or create truly arbitrary views, but you can combine dimensions like product, order date, channel, customer tag, and location with metrics like units sold, gross revenue, net sales, and returns.

Step 1: Navigate to the custom report builder

In Shopify Admin, go to Analytics > Reports, then click "Create custom report" in the upper right. You will be prompted to choose a report template as a starting point — Sales, Products, Customers, or Inventory. Starting from "Sales" gives you the widest range of metrics for most operational questions.

Step 2: Add dimensions and filters

Click "Edit columns" to add the dimensions you want to analyze. Useful combinations for operational reporting include:

• Product title + Product variant + Net sales + Returns: Shows which specific variants are generating refunds at above-average rates
• Customer tag + Orders + Gross revenue: Compares order value across customer segments if you use Shopify tags for segmentation
• Sales channel + Average order value + Number of orders: Compares performance across your active sales channels
• Order date (monthly) + New customers + Returning customers: Builds a basic acquisition vs. retention trend without the full cohort view

Filters let you scope the report to specific products, channels, locations, or customer tags. Apply date range filters to control the analysis window.

Step 3: Understand what custom reports cannot do

The custom report builder in Shopify cannot: calculate derived metrics (you cannot create a "margin %" column by dividing two other columns), join data from outside Shopify, apply custom attribution models, or segment cohorts by acquisition source. These limits are not configurable — they reflect the underlying data model. When you hit them, the right move is to export data via CSV or Shopify's Admin API and analyze it externally, or to use a purpose-built analytics app.

Connecting Shopify to external analytics tools

For operators who need more than Shopify's native reports can provide, the options fall into three categories: app-based tools that extend Shopify from within the ecosystem, data pipeline tools that move Shopify data to a warehouse, and operating intelligence platforms that connect Shopify to the broader business context.

App-based analytics extensions

Several Shopify apps add the analytical capabilities the native dashboard lacks. Lifetimely by AMP specializes in customer LTV and cohort analysis — it calculates CAC payback by cohort, segments retention by acquisition channel, and provides a P&L dashboard that accounts for ad spend alongside product cost. Triple Whale addresses attribution directly with pixel-based tracking that builds a multi-touch view of the customer journey across Meta, Google, and TikTok. Mipler and Report Pundit extend the custom report builder with more dimensions, scheduled exports, and the ability to create reports from metafield data — useful for stores that track custom product attributes outside Shopify's standard taxonomy.

These tools solve specific gaps without requiring infrastructure investment. They are the right choice for stores that have identified a clear missing capability — attribution, cohort analysis, or per-SKU profit — and want to address it without building a data stack from scratch.

Connecting Shopify to BigQuery or Snowflake

For brands that need to join Shopify data with ad spend, COGS from an ERP, or behavioral data from other sources, moving data to a warehouse unlocks full analytical flexibility. BigQuery is the most common destination because it integrates natively with GA4 and Google Ads, is serverless (no infrastructure to manage), and connects directly to Looker Studio for visualization without additional tooling.

The practical setup involves an ETL connector — Fivetran, Stitch, and Estuary all offer pre-built Shopify integrations — that pulls order, product, customer, and inventory data into BigQuery on a daily or near-real-time schedule. Once the data lands in the warehouse, you can write SQL to calculate true contribution margin, build cohort retention matrices segmented by any dimension, or join Shopify orders to ad spend from the Google Ads API to produce actual ROAS at the campaign level.

Supermetrics offers a lighter-weight version of this approach: it pulls Shopify and ad platform data into a single reporting layer (BigQuery, Google Sheets, or Looker Studio) without requiring you to build a full warehouse pipeline. For teams that need joined Shopify and ad data but do not have a data engineer, it is a practical middle path.

The tradeoff is setup and maintenance complexity. Warehouse pipelines require schema management, monitoring for upstream changes, and someone who can write SQL. The value proposition improves significantly as order volume increases and as the number of data sources that need to be joined grows.

Operating intelligence platforms

The category of tools that sits above individual analytics apps is operating intelligence — platforms that connect Shopify data not just to ad spend and COGS, but to the full operating context of the business: inventory commitments, headcount costs, margin by channel, and forward-looking signals. Fairview is built for exactly this layer: it pulls in Shopify revenue data alongside the cost and operational data that determines whether that revenue is actually moving the business forward, surfacing the gaps between what's making money and what's leaking margin without requiring operators to maintain separate BI infrastructure.

This matters particularly for ecommerce operators managing multiple SKUs, multiple channels, and meaningful ad spend simultaneously — where the signal in any single data source is incomplete and the decision-relevant question is always some combination of at least two or three sources.

What to set up first: a practical sequence

If you are starting from Shopify's default dashboard and want to build toward a more complete analytics picture, the sequence below minimizes setup overhead while closing the most important gaps first.

Week 1: Populate product costs

Go to Products in your Shopify Admin and populate the "Cost per item" field on every active variant. This takes under an hour for most catalogs using the bulk editor. Once cost data is populated, Shopify's Profit by Product report becomes meaningful — and any third-party profit tracking app you add later will import those costs automatically.

Week 2: Install a pixel-based attribution tool

Triple Whale's free tier installs a tracking pixel that begins building first-party attribution history immediately. Even if you are not ready to pay for the full platform, the pixel collects data that makes future attribution analysis more accurate. Server-side tracking via Shopify's Customer Events API or a Meta Conversions API integration also improves signal quality significantly as third-party cookies continue to degrade.

Week 3: Build your first cohort baseline

If you are on Advanced or Plus, run the native cohort analysis report for the past 12 months and export it. This becomes your baseline — the starting point for measuring whether retention is improving or declining over time. If you are on a lower plan, Lifetimely's paid tier provides the same cohort view with more segmentation options.

Month 2: Connect Shopify to your ad platforms

At this point, install a tool that joins Shopify order data with ad spend from your active paid channels. The goal is a single view showing revenue, COGS, and ad spend together — so you can calculate true contribution margin by channel rather than ROAS in isolation. Platforms like Fairview handle this connection as part of their core operating layer, making it straightforward to see which channels are profitable after all costs are accounted for.

Month 3+: Evaluate the warehouse path

Once you have outgrown what app-based tools can provide — typically when you need custom SQL, want to join five or more data sources, or need to run analysis that no existing app template covers — evaluate a warehouse integration. Start with Estuary's free tier or Stitch's 14-day trial to test the pipeline before committing to the infrastructure overhead. The value threshold for warehouse investment is roughly when you have someone on staff who can write SQL and you are making decisions frequently enough that manual exports have become a real bottleneck.