Shopify's analytics tab is fine for "how much did I sell today?" It's useless for "which acquisition channel has the best 90-day LTV?" or "alert me when inventory on my top 5 products drops below 2 weeks of supply."
I talk to Shopify store owners every week who are making decisions worth tens of thousands of dollars based on a dashboard that can't answer their actual questions. They know something is off—their ad spend keeps climbing but they can't tell which campaigns produce customers who come back—but the built-in tools don't give them the data to act on it.
Here's the thing: Shopify's analytics were designed for simplicity. And for a brand-new store doing $5k/month, that's fine. But the moment you're spending real money on ads, managing 50+ SKUs, or trying to understand repeat purchase behavior, you've outgrown it.
What Shopify analytics genuinely can't do
Let me be specific about the gaps, because "it's limited" isn't helpful:
Cohort analysis. You can't ask "do customers acquired in December have better retention than those acquired in June?" Shopify shows you total repeat purchase rate, but not broken down by acquisition cohort. This matters enormously for seasonal businesses.
Multi-touch attribution. Shopify will tell you the last click before a purchase. It won't tell you that a customer saw your Instagram ad, clicked a Google Shopping listing a week later, then came back directly to buy. Google Analytics 4 helps here, but has its own gaps (more on that below).
Inventory forecasting and alerts. You can see current inventory levels. You can't say "alert me when Product X has less than 14 days of supply based on its rolling 30-day sales velocity." That requires a calculation Shopify doesn't offer natively.
Custom SQL queries. Want to know your average order value by customer acquisition source, excluding returns, for customers who've placed 2+ orders? That's a SQL query. Shopify doesn't give you a SQL interface.
Combining with ad spend data. The real question isn't "what's my ROAS in Google Ads?" (Google will happily inflate that number). The real question is "what's my true CAC by channel after accounting for returns and chargebacks?" That requires joining Shopify order data with ad platform spend data—something the built-in dashboard simply cannot do.
Automated reporting. You can't set up "every Monday, send me a Slack message with last week's revenue, top products, and any SKUs that sold faster than expected." You have to log in and look.
Four levels of Shopify analytics sophistication
Not every store needs the same depth. Here's how I think about the progression:
Level 1: Built-in Shopify dashboard (free, limited)
This is where everyone starts. You get total sales, sessions, conversion rate, average order value, and top products. It's real-time, it's free, and it's fine for stores under $50k/month with simple product lines.
Good for: Quick daily health checks. "Did anything weird happen yesterday?"
Falls apart when: You need to understand customer behavior over time, optimize ad spend, or forecast inventory.
Level 2: Shopify + Google Analytics 4 (free, attribution gaps)
Adding GA4 gives you better traffic attribution, conversion paths, and audience insights. It's free and relatively easy to set up with Shopify's native integration.
Good for: Understanding which traffic sources drive purchases. Basic funnel analysis.
Falls apart when: You need accurate revenue numbers (GA4 and Shopify often disagree by 10-20% due to tracking gaps), you want to analyze post-purchase behavior like returns and repeat rates, or you need to combine with ad spend at the campaign level. GA4 also has a steep learning curve and its reporting interface frustrates most non-analysts.
Level 3: Third-party e-commerce analytics tools
This is where most growth-stage Shopify stores end up. Tools like Triple Whale ($100-150/mo), Lifetimely ($50-150/mo), and Polar Analytics (~$100/mo) are built specifically for e-commerce and give you cohort analysis, LTV calculations, and better attribution.
Good for: Stores spending $10k+/month on ads that need attribution clarity. LTV and cohort analysis out of the box.
Falls apart when: You need custom analysis beyond what their pre-built reports offer, you want to combine with non-standard data sources, or you need automated alerts on custom conditions. These tools also tend to be expensive for what they provide—$100-200/month for dashboards you could build yourself if you had the right infrastructure.
Level 4: Connect Shopify to an analytics platform
This is the "bring your own analysis" approach. You connect the Shopify API (orders, customers, products, inventory) to an analytics platform—whether that's a warehouse like BigQuery with a BI tool like Metabase, or an AI-powered platform like Fastero that lets you ask questions in natural language.
Good for: Stores that have specific analytical questions the pre-built tools can't answer. Teams that want alerts, custom metrics, and the ability to join Shopify data with ad spend, support tickets, or product data from other systems.
Falls apart when: You don't actually have complex analytical needs. If "what sold yesterday?" is genuinely your main question, this is overkill.
Five analyses every Shopify store should be running
Regardless of which level you're at, here are the questions that separate stores that grow profitably from stores that scale into a wall:
1. Customer cohort retention
The question: "Do customers I acquired in December (holiday season) actually come back? Or are they one-time buyers attracted by discounts?"
Why it matters: If your holiday acquisition costs $40/customer but those customers never return, your true CAC is $40 for a single purchase. If your Q2 customers cost $25 but 30% come back within 90 days, they're worth dramatically more.
What you need: Orders grouped by customer acquisition month, with repurchase rates at 30, 60, and 90 days.
2. True CAC by channel (not what the ad platform reports)
The question: "After returns, chargebacks, and attribution corrections, what does a new customer actually cost me from each channel?"
Why it matters: Google Ads will tell you your CPA is $22. But if 15% of those orders get returned and another 5% are existing customers Google is taking credit for, your real CAC might be $35. That changes your entire unit economics picture.
What you need: Ad spend by channel joined with Shopify new-customer orders, minus returns, deduped against existing customer records.
3. Product-level margin after returns
The question: "Which products are actually profitable after accounting for return rates, shipping costs, and ad spend to sell them?"
Why it matters: Your best-selling product might have a 40% return rate that makes it unprofitable. I've seen this happen more than once—a product looks great on the revenue line but is a net negative after returns and the ad spend required to sell it.
What you need: Revenue minus COGS minus returns minus allocated ad spend, per product.
4. Inventory velocity alerts
The question: "Based on current sell-through rates, when will each SKU run out? Alert me when anything drops below 2 weeks of supply."
Why it matters: Stockouts kill you twice—you lose the immediate revenue AND your ad performance tanks because you're still paying for clicks that can't convert. An alert system that says "Product X will be out of stock in 11 days at current velocity" gives you time to reorder.
What you need: Rolling 14-day (or 30-day) sales velocity per SKU, compared against current inventory, with threshold-based alerting.
5. Repeat purchase timing
The question: "What's the median time between first and second purchase? And what should I do about it?"
Why it matters: If your median repeat time is 45 days, your email/SMS win-back at day 30 is too early and your retargeting at day 60 is too late. Knowing this number shapes your entire retention strategy.
What you need: Time-between-orders distribution, segmented by product category and acquisition channel.
How to set this up with Fastero
If you're at Level 4 and want to build this yourself without hiring an analyst, here's the practical approach with Fastero:
Step 1: Connect your Shopify store. Fastero's Shopify integration pulls orders, customers, products, and inventory data via the API. Setup takes about 5 minutes.
Step 2: Connect your ad platforms. Add Google Ads (and Meta, if you run Facebook/Instagram ads) to get spend data alongside revenue data.
Step 3: Ask questions in natural language. Fastero's natural language query engine translates questions like "show me customer cohort retention by acquisition month" into the right analysis. No SQL required, though you can write SQL if you prefer.
Step 4: Save dashboards and set alerts. Once you have an analysis you want to monitor, save it as a dashboard. Then set up triggers—automated alerts that fire when conditions change. "Alert me in Slack when any SKU drops below 14 days of supply" is a single trigger configuration.
The whole setup takes an afternoon. After that, you have automated alerts running continuously and dashboards you can pull up whenever you need deeper answers.
When to stay with the built-in tools
I'm not going to pretend everyone needs Level 4 analytics. Here's when the built-in Shopify dashboard is genuinely sufficient:
- Revenue under $50k/month. Your analytical needs are probably simple enough that the built-in tools cover 80% of it. Spend your time on product and marketing, not analytics infrastructure.
- Simple product line (under 20 SKUs). You can track inventory and margins in your head or a simple spreadsheet. The complexity that justifies analytics tooling comes from SKU proliferation.
- Not running paid ads. If all your traffic is organic or word-of-mouth, the attribution question doesn't exist and your CAC is effectively zero. The built-in conversion rate and AOV metrics are probably enough.
- Solo operator with no time for analysis. If you're doing everything yourself and barely have time to fulfill orders, adding analytics tooling will just create another tab you feel guilty about not checking. Get the business stable first.
For everyone else—especially if you're spending $5k+ per month on ads and trying to figure out what's actually working—the built-in dashboard is costing you money in bad decisions. You just can't see how much because you don't have the data to measure it.
If you're running a Shopify store and want to see what your data actually says (not just what Shopify's dashboard shows you), start a free trial. Connect Shopify in 5 minutes, ask your first question, and see what you've been missing.
Related: Best BI tools for e-commerce teams | How to set up revenue alerts