Shopify dashboard: what's built in and how to go further

If you run a DTC or e-commerce business on Shopify, the built-in analytics are better than most people give them credit for. Revenue reports, cohort analysis, inventory tracking, customer LTV estimates — for a small team, it covers the basics reasonably well.

But as the business grows and questions get more specific, Shopify's reports start to feel like a floor rather than a ceiling.

"Which acquisition channels are actually profitable after accounting for ad spend and cost of goods?" "Do customers acquired through influencer campaigns have higher LTV than those from paid search?" "What's our true contribution margin per product, and which SKUs are we better off discontinuing?"

Shopify knows about orders and customers. It doesn't know about your ad costs, your COGS, your inventory carrying costs, or the full picture of your marketing spend. This post covers what Shopify's built-in analytics gives you, where it falls short, and how to build a more complete view.

What Shopify's built-in analytics covers

Shopify Analytics includes a solid set of e-commerce reports:

• Sales reports: Revenue by day, product, variant, channel, and staff
• Orders report: Order volume, average order value, and refund rates
• Customer reports: New vs. returning customers, customer LTV estimates, purchase frequency
• Cohort analysis: Retention cohorts showing repeat purchase behavior by acquisition month
• Marketing attribution: Basic first/last-touch attribution for connected Shopify campaigns
• Inventory reports: Stock levels, inventory value, and sell-through rates
• Finance reports: Payments, taxes, and payout summaries
• Search and behavior analytics: Top search terms and product page performance (higher plans)

You can filter most of this by date range, product, and sales channel. For day-to-day monitoring and basic revenue tracking, it's often sufficient. You can see what's selling, who's buying, and whether returning customers are growing as a share of revenue.

On higher Shopify plans, the analytics get more detailed. The built-in cohort analysis is better than many platforms — you can see repeat purchase rates by month of first order, which is genuinely useful for understanding retention. For early-stage DTC brands, Shopify's native analytics can take you surprisingly far before you need to look elsewhere.

Where Shopify analytics hits its limits

The gaps appear the moment you need to move from "what's selling?" to "what's actually working?"

No margin or profitability data. Shopify reports revenue. It does not know your cost of goods, shipping costs, ad spend, or fulfillment fees. You can see which products sell the most, but not which ones are actually profitable. Optimizing for revenue without margin data leads to a business that looks good in Shopify's dashboard and bleeds money in reality — a trap many fast-growing DTC brands fall into.

Marketing attribution stops at the Shopify boundary. Shopify's attribution only covers channels directly connected to your store. Attribution is largely last-click. There's no multi-touch model, no visibility into influencer-driven traffic that arrives organically, and no clean connection between ad spend on Meta or Google Ads and the orders those campaigns actually drove.

Cross-channel visibility doesn't exist. If you sell on Shopify, Amazon, and wholesale, each channel lives in a different system. Shopify only sees Shopify orders. Your true business picture — total revenue, channel mix, inventory allocation across channels — requires pulling all of them together.

Customer segmentation is limited to purchase behavior. Shopify can segment customers by what they bought and when. It can't segment by acquisition channel (unless you've been rigorous with UTM parameters), demographic, or any attribute that lives outside Shopify. Understanding who your highest-value customers actually are requires combining order data with ad platform, CRM, or survey data.

Cohort analysis doesn't include costs. Shopify's built-in cohort analysis shows repeat purchase rates. It doesn't show cohort LTV after subtracting acquisition cost — the number that actually tells you whether your marketing is working. That calculation requires combining Shopify revenue data with ad platform spend data by acquisition period.

None of this is a knock on Shopify. It's an e-commerce platform, not a business intelligence tool. But if you're making significant marketing or product decisions based on Shopify's analytics alone, you're missing a large part of the picture.

What a better Shopify analytics dashboard looks like

The goal isn't to replace Shopify's operational reports. You still need to see daily revenue, top products, and refund rates. The goal is to add layers that connect order data to the context that actually explains business performance.

Here's what that looks like in practice:

Profitability by product, not just revenue. Connect Shopify order data with a COGS feed from your inventory system or a manually maintained cost table, and you can build margin reports at the product and variant level. Which products should you promote more? Which are a drag on contribution margin? Revenue alone can't answer that — margin data does. This is often the single most valuable analysis for any e-commerce operator.

True CAC and payback period by channel. Pull Shopify revenue alongside ad spend from Meta, Google Ads, and other platforms. Calculate actual CAC by channel: the dollars you spent on each channel divided by the new customers it generated. Then layer in 12-month LTV to calculate payback periods per channel. This is what makes marketing budget decisions defensible.

Cohort LTV with acquisition cost baked in. Combine Shopify order data, organized by customer acquisition date, with the ad spend during the period those customers were acquired. You get a real cohort LTV-to-CAC curve: which months did you acquire profitable cohorts, and which months did you overspend? This changes how you think about seasonal campaigns and promotional periods.

Cross-channel revenue in one view. Pull order data from Shopify, Amazon Seller Central, and your wholesale system into a single view. See your true channel mix, compare performance across channels, and understand how inventory should be allocated — rather than looking at each channel in isolation.

Customer re-engagement signals. Identify customers approaching lapse — those who haven't bought in 90 days but have historically repurchased every 60 days. Combine Shopify purchase history with email engagement data to build a re-engagement priority list based on predicted LTV, not just recency.

Three ways to build a more complete Shopify analytics dashboard

Here's a quick comparison of how they stack up:

Option 1: CSV exports + spreadsheets

Export order reports, customer reports, and product reports from Shopify. Export ad spend from Meta and Google Ads. Build margin calculations in Google Sheets using a COGS lookup table. This works for quarterly reviews but breaks for anything real-time: data is stale, the matching methodology is rough, and the spreadsheet requires manual refresh every time someone wants updated numbers. Most DTC teams spend more time maintaining these spreadsheets than they realize.

Option 2: Data warehouse + BI tool

Use Shopify's native export to BigQuery or a connector like Fivetran to sync order, product, and customer data into a warehouse. Load ad spend from Google Ads and Meta alongside it. Add COGS data from your inventory system. Query with dbt, visualize in Looker or Metabase. This is the right architecture for a serious e-commerce analytics operation. The cost is a data engineer and several weeks of setup, plus BI licensing. For most DTC brands under $10M ARR, it's typically more infrastructure than the problem warrants.

Option 3: Connect directly with an AI-native analytics platform

This is the approach we built Fabi around.

Connect Shopify to Fabi alongside your ad platforms and cost data. Query across all of them without building infrastructure.

"Show me gross margin by product category for the last 90 days, using COGS from my cost table."

"Which acquisition channels had the best 12-month LTV-to-CAC ratio for customers acquired in Q4 last year?"

"Show me customers who last ordered more than 60 days ago but have a predicted LTV above $500."

Fabi generates SQL against your connected sources and makes the logic auditable. Setup is minutes, not weeks.

It also solves the ad hoc problem. When your founder asks "which SKUs are we actually making money on?" before a buying cycle, anyone on the team can get the answer without spending three hours in spreadsheets.

What to look for in a Shopify analytics tool

If you're evaluating options, a few things that separate useful tools from ones that collect dust:

Order-level and customer-level data. Aggregate revenue numbers are already in Shopify. Look for a tool that gives you row-level access to orders and customers so you can do real segmentation and cohort work.

COGS and cost data support. Revenue analytics without margin data is half the picture. Look for a tool that lets you bring in cost data — from an inventory system or a manually maintained table — so you can calculate margin alongside revenue.

Ad platform connectors. Shopify order data alone can't tell you marketing ROI. The tool needs to pull ad spend from Meta Ads, Google Ads, TikTok Ads, or wherever you're spending, so you can calculate real CAC and payback period.

Cohort LTV modeling. Look for a tool that can build customer cohorts by acquisition period and calculate actual LTV over time — not just repeat purchase rate, but revenue generated per cohort net of acquisition cost.

Non-technical usability. The founder or marketing lead asking "which channel is profitable?" shouldn't need SQL. Look for natural language querying or low-code interfaces alongside SQL support.

Frequently asked questions

What analytics does Shopify have built in?Shopify includes sales reports, order analytics, customer reports (LTV estimates, purchase frequency, cohort retention by acquisition month), inventory reports, and basic marketing attribution. Higher Shopify plans include more detailed reports. The built-in cohort analysis showing repeat purchase rates by acquisition month is one of the stronger native features.

Does Shopify track profit margins?No. Shopify reports gross revenue. It has no visibility into cost of goods sold, shipping costs, ad spend, or fulfillment fees. Margin analysis requires bringing cost data in from an external source and joining it with Shopify order data.

How do I see ROI by marketing channel in Shopify?Shopify's marketing reports show basic attribution for directly connected channels, largely on a last-click basis. For real marketing ROI — ad spend against revenue by channel, with LTV factored in — you need to join Shopify data with ad platform spend data externally. For a look at what a complete marketing analytics view looks like, see how to build a marketing dashboard.

Can Shopify analytics show cost of goods sold?Not natively. Shopify has a COGS field in product settings, but it's not surfaced as a deduction from revenue in analytics reports. Most operators track COGS in an inventory management system or spreadsheet and join it with Shopify order data externally.

How do I connect Shopify to Google Analytics?Shopify has a native Google Analytics integration that fires GA4 events (page views, add-to-cart, purchases) on your storefront. This provides website behavior data in GA4 alongside transaction data. For deeper cross-source analysis — joining GA4 session data with Shopify customer records — you need an external analytics tool.

What are the best Shopify analytics tools?Options range from data warehouse pipelines (Fivetran into BigQuery + Looker) to purpose-built e-commerce analytics (Triple Whale, Northbeam) to AI-native platforms like Fabi that let you join Shopify data with ad spend and cost data in real time without infrastructure setup.

Frequently asked questions

What analytics does Shopify have built in?

Shopify includes sales reports, order analytics, customer reports (LTV estimates, purchase frequency, cohort retention by acquisition month), inventory reports, and basic marketing attribution. Higher Shopify plans include more detailed reports. The built-in cohort analysis showing repeat purchase rates by acquisition month is one of the stronger native features.

Does Shopify track profit margins?

No. Shopify reports gross revenue. It has no visibility into cost of goods sold, shipping costs, ad spend, or fulfillment fees. Margin analysis requires bringing cost data in from an external source and joining it with Shopify order data.

How do I see ROI by marketing channel in Shopify?

Shopify's marketing reports show basic attribution for directly connected channels, largely on a last-click basis. For real marketing ROI, ad spend against revenue by channel, with LTV factored in, you need to join Shopify data with ad platform spend data externally. For a look at what a complete marketing analytics view looks like, see [how to build a marketing dashboard](https://www.fabi.ai/blog/marketing-dashboard-what-it-is-and-how-to-build-one-in-6-steps).

Can Shopify analytics show cost of goods sold?

Not natively. Shopify has a COGS field in product settings, but it's not surfaced as a deduction from revenue in analytics reports. Most operators track COGS in an inventory management system or spreadsheet and join it with Shopify order data externally.

How do I connect Shopify to Google Analytics?

Shopify has a native Google Analytics integration that fires GA4 events (page views, add-to-cart, purchases) on your storefront. This provides website behavior data in GA4 alongside transaction data. For deeper cross-source analysis, joining GA4 session data with Shopify customer records, you need an external analytics tool.

What are the best Shopify analytics tools?

Options range from data warehouse pipelines (Fivetran into BigQuery + Looker) to purpose-built e-commerce analytics (Triple Whale, Northbeam) to AI-native platforms like Fabi that let you join Shopify data with ad spend and cost data in real time without infrastructure setup.

Shopify is a great e-commerce platform. It's not a profitability analytics tool.

Shopify's analytics tell you what's selling. They can't tell you what's profitable. And profitability — by product, by channel, by customer cohort — is what actually drives the decisions worth making.

The gap between "which products are generating the most revenue?" and "which products are generating the most profit?" sounds obvious, but it's where a surprising number of e-commerce decisions go wrong. The data to answer the second question exists. It's spread across Shopify, your ad platforms, and your cost data. Connecting those sources is the problem worth solving.

You don't need to build a warehouse to do it. Connect your data sources, ask the questions Shopify's dashboard can't answer, and build the e-commerce analytics view your business actually needs.

Try Fabi free and connect Shopify alongside your ad platforms and cost data to start querying across everything in minutes.