Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Create an Inventory Dashboard in Google Analytics

Cody Schneider••9 min read

Tracking product inventory can feel like a full-time job, especially when your sales data lives in one place and your stock levels live somewhere else. Creating an inventory dashboard within Google Analytics gives you a powerful way to connect user behavior with product performance. This article will walk you through exactly how to build a clear, actionable dashboard to monitor which products are selling fastest, which are lagging, and which might need a stock alert.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Why Bother Tracking Inventory in Google Analytics?

Your Google Analytics 4 property is a goldmine of information about what your customers are doing, but it becomes truly powerful when you connect that behavior to business operations like inventory management. While GA4 doesn't track inventory levels directly, building a sales-focused dashboard can help you see your product catalog through the eyes of your customers.

By monitoring product performance in GA4, you can:

  • Prevent Stockouts: Identify your fastest-selling products so you can reorder them before you run out and lose sales.
  • Optimize Marketing Spend: See which marketing campaigns are driving sales for specific items. You can pause ads for low-stock products and double down on promoting items that have plenty of inventory.
  • Unload Slow-Moving Stock: Spot which products have low views, low add-to-cart rates, and low sales. This is your signal to create a flash sale or promotional bundle to clear them out.
  • Make Better Merchandising Decisions: Understand which product categories are most popular and which new items are gaining traction, helping you decide what to feature on your homepage or invest in for the next season.

Combining sales velocity with inventory status allows you to move from reactive reordering to proactive inventory management, all driven by real user data.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

What GA4 Can (and Cannot) Tell You Out of the Box

It's important to understand GA4's built-in capabilities regarding e-commerce and inventory. This helps set the right expectations for your dashboard.

What Google Analytics 4 tracks right out of the box (with proper e-commerce setup):

  • Items Purchased: The total number of units sold for each product. This is your best indicator of sales velocity.
  • Item Revenue: The total revenue generated by each product.
  • Items Added to Cart: How many times a product was added to a shopping cart.
  • Items Viewed: How many times a product detail page was viewed.

What Google Analytics 4 cannot track natively:

  • Current Stock Level: GA4 has no idea if you have 5 or 5,000 units of a product remaining in your warehouse.
  • Product Cost: While it tracks revenue, GA4 doesn’t know your cost of goods sold (COGS), so it can't calculate profit margins on its own.
  • Supplier Information: It cannot tell you which supplier a product came from or what the reorder lead time is.

The key takeaway is that GA4 excels at tracking demand. Our goal is to leverage that demand data to make smart inferences about our inventory. For a complete picture that includes actual stock levels, we'll need to combine GA4 with another tool - more on that in a moment.

Method 1: Building a Sales Velocity Report Inside GA4

First, let’s build a powerful report using only the standard tools within Google Analytics. This "Sales Velocity" report will show you which products are flying off the shelves so you can keep them in stock. Since GA4 replaced dashboards with "Overview Reports" in the Library, we'll create a detailed e-commerce report first and then add its insights to a custom overview dashboard.

Step 1: Create a Custom "Product Performance" Report

We'll start by making a new detailed report focused on key product metrics.

  1. Navigate to the Reports section in your GA4 property.
  2. On the bottom of the left navigation menu, click Library.
  3. Click the + Create new report button, then select Create detail report.
  4. You can start with a blank template or use the "E-commerce purchases" template. For this guide, let's start from Blank.
  5. In the Dimensions card on the right, click "Add dimension" and add the following:
  6. Next, in the Metrics card, click "Add metric." Add the metrics that signal demand:
  7. Drag Items purchased to the top of the metrics list to make it the primary sorting column.
  8. Click Save at the top right. Name your report something clear, like "Product Sales Velocity," and add a description. Click Save again.

Step 2: Add Your New Report to the Navigation Menu

Your beautiful new report is now saved in the Library, but it won’t appear in your main navigation panel until you add it to a collection.

  1. While still in the Library, find the collection named "Life cycle" (or another one you prefer) and click Edit collection.
  2. In the search box under "Drag reports to create collection," find the "Product Sales Velocity" report you just made.
  3. Drag it over to the menu on the left, perhaps under the "Monetization" section.
  4. Click Save, then Save changes to current collection. Now your custom report will be accessible anytime from your main reporting dashboard! You can use this report's table to quickly identify your top-selling products by units sold.

Method 2: Creating a True Inventory Dashboard with Looker Studio

That first method is great for tracking demand within GA4. But for a true inventory dashboard that compares sales data with actual stock levels, the best tool for the job is Google's own Looker Studio (formerly Data Studio).

Why use Looker Studio? Because it lets you blend data from multiple sources. We can pull our sales data from Google Analytics and merge it with our inventory data from a simple Google Sheet. This gives us one unified dashboard to see both sides of the coin.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Step 1: Prepare Your Inventory Data in a Google Sheet

First, we need a simple source for our inventory data. A Google Sheet is perfect for this. Your e-commerce platform (like Shopify or WooCommerce) may have an app or export function that can automate keeping this sheet updated.

Create a Google Sheet with at least these columns:

  • SKU: This is the most important column! The values here must match the "Item ID" value you send to Google Analytics. This is how the data gets joined together.
  • Product Name: For easy reference on your dashboard.
  • Current Stock: The number of units you currently have available.
  • Stock Status: A simple text field like "In Stock," "Low Stock," or "Out of Stock." This is great for color-coding later.

Step 2: Connect GA4 and Google Sheets to Looker Studio

Now, let's pull our data into a new Looker Studio report.

  1. Go to lookerstudio.google.com and open a Blank Report.
  2. You'll be prompted to connect a data source. Find and select the Google Analytics connector.
  3. Authorize the connection, then select your GA4 Account and Property. Click Add.
  4. Now, let's add the spreadsheet. Go to the menu and click Add data. Find and select the Google Sheets connector.
  5. Choose the inventory spreadsheet you just created, ensure "Use first row as headers" is checked, and click Add.

You now have both of your data sets loaded into one Looker Studio report.

Step 3: Blend Your Data Sources Together

This is where the magic happens. We'll tell Looker Studio how to link the sales data and inventory data.

  1. Select any chart on your canvas (or add a new one, like a table).
  2. In the chart's Setup panel on the right, under "Data source," click Blend data.
  3. A new interface will pop up. Your GA4 source will be on the left (Table 1), and you can add your Google Sheet source on the right (Table 2).
  4. From the GA4 table, drag these over:
  5. On the right side for the Google Sheets table, add:
  6. Now, configure the Join condition. This is how you link the two tables. Click into the condition and set the "Join key" to be GA4's Item ID and the sheet's SKU. This tells Looker Studio they are the same thing.
  7. Click Save. You now have a new blended data source ready to power your dashboard!

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Step 4: Build Your Inventory Dashboard Widgets

With your new blended data source, you can build incredibly useful charts to monitor inventory health.

1. Inventory Status Table

Create a table that serves as your main command center. Use your blended data source and add these fields:

  • Dimension: Item name
  • Metrics: Items purchased, Current Stock, Stock Status

Under the table's Style > Conditional formatting tab, you can create rules to highlight rows. For example, create a rule that says: "If Current Stock is less than 20, make the row background red." Now you can spot low-stock items in an instant.

2. Sales Velocity vs. Stock Level Chart

A combo bar chart helps you see which high-volume items are at risk of a stockout.

  • Dimension: Item name
  • Metric 1: Items purchased (as a bar)
  • Metric 2: Current Stock (as a line or another bar)

Sort by Items purchased in descending order. When you see a tall blue bar (high sales) close to a low yellow bar (low stock), you know exactly what needs reordering.

3. At-Risk Products Scorecard

Add a "Scorecard" chart to your dashboard. For its metric, create a new calculated field with a formula like:

COUNT_DISTINCT(CASE WHEN Current Stock < 20 THEN Item name END)

Title this card "Products with Low Stock." It gives you an immediate count of all items that need your attention.

Final Thoughts

Using Google Analytics by itself is great for understanding product demand and sales velocity, but its native reporting can't see your actual stock levels. To create a true inventory dashboard, the best approach is to connect GA4 with a Google Sheet in Looker Studio, giving you a centralized view that connects sales performance directly to operational readiness.

Manually blending data sources in different tools just to get basic answers can be a major time sink. That’s why we built Graphed to do the heavy lifting for you. Simply connect your e-commerce platform like Shopify along with your Google Analytics, and you can instantly build real-time monitoring dashboards using plain English. Instead of fumbling with data joins, you can just ask, "Create a dashboard showing items purchased and current inventory levels for my top 10 products," and get a live, automated report in seconds.

Related Articles