Build a report
Sign in with Google
Works with Looker Studio

Amazon Seller Central FBA Inventory dashboard template for Google Sheets

Monitor your Amazon FBA inventory with ease: track fulfillable and unfulfillable quantities, manage inbound shipments, and identify damaged items. Analyze SKU performance, optimize stock levels, and ensure timely restocking. Stay informed with key metrics like total inventory, researching quantities, and pending orders.

Download Template

By Porter

This template is built by the same marketers behind all our tutorials, support, and our template gallery.

Data sources included

+40,000 marketers have downloaded our dashboards

Questions you can answer using this Amazon Seller Central dashboard template

  • How many SKUs are currently in inventory?
  • What is the total quantity of items in stock?
  • How many items are fulfillable versus unfulfillable?
  • What is the status of inbound shipments (receiving, shipped, working)?
  • How many items are reserved?
  • What are the quantities of warehouse, carrier, and customer-damaged items?
  • How does damaged inventory break down by product type?
  • How many items are currently being researched?
  • What is the quantity of pending customer orders?
  • How many items are pending transshipment?
  • What are the total and fulfillable quantities for each SKU?
  • Which SKUs have the highest inbound receiving quantities?

How to set up this Google Sheets template?

Copy the Amazon Seller Central FBA Inventory dashboard template for Google Sheets in one click and automate your reporting

Follow these steps:


  • Step 1: Make a copy of the template.

  • Step 2: Download the extension and authorize your profile.

  • Step 3: Choose the accounts you want to pull data from.

  • Step 4: Use our prebuilt queries or build one from scratch to automate your data collection. Alternatively, you can input data manually.

  • Step 5: Set up automatic refresh to keep your dashboard updated.


Metrics and dimensions included

Customize the template’s metrics and dimensions as you like. See all available Amazon Seller Central fields

Metrics

  • Inventory

    • Total SKUs
    • Total Quantity
    • Fulfillable Quantity
    • Unfulfillable Quantity

  • Customizable charts

    • Warehouse Damaged Quantity
    • Carrier Damaged Quantity
    • Customer Damaged Quantity
    • Defective Quantity

  • Inventory Status

    • Inbound Receiving Quantity
    • Inbound Shipped Quantity
    • Inbound Working Quantity
    • Reserved Quantity

Dimensions

  • Product type

    • Envelope
    • Carrier Bag Case
    • File Folder

  • Product name

    • Seller SKU
    • Product Name

  • Listing Item Status

    • Discoverable
    • Buyable

Features

You can customize your marketing reports directly in Google Sheets with your logo, colors, and branding.
Set up email alerts using conditional notifications when a cell value changes.
Edit all charts and change style values, and then paste them on your Google Slides so they can auto sync.

Utilize functions like SUMIF, VLOOKUP, IF, and ARRAYFORMULA to calculate key metrics like CPA, ROAS, and CTR, automating calculations and combining data fields.

Pull your historical marketing data automatically using our Google Sheets marketing extension.

Filter by date, campaign, channel, and more to get the insights you need.
Set, track, and achieve marketing goals with real-time updates.
Set sync intervals to match your reporting needs, whether daily, weekly, or monthly.
Connect Google Analytics, Facebook Ads, Instagram, LinkedIn, and more to create a unified view of your marketing performance.

FAQs

An Amazon FBA inventory dashboard report should include key metrics such as Total SKUs, Total Quantity, Fulfillable Quantity, and Unfulfillable Quantity to provide a comprehensive view of your inventory status. The dashboard should track metrics like Inbound Receiving, Shipped, and Working Quantities to monitor the flow of inventory into Amazon’s fulfillment centers. Additionally, it should highlight Damaged Inventory by type (Warehouse, Carrier, Customer) and Researching Quantities to identify potential issues affecting inventory health.

Month-over-month trends in Inventory Levels and Fulfillment Status offer insights into inventory management efficiency. Monitoring metrics like Pending Customer Orders and Transshipment Quantities helps assess processing times and fulfillment capabilities

.Visualizations such as Inventory Status Breakdown, Damaged Inventory by Product Type, and SKU-specific performance charts help make informed decisions about restocking or addressing damaged goods. Including actionable insights on SKUs with high inbound quantities or those needing attention due to damage will optimize stock management and operational strategies.

Also, include an auto-sync feature for real-time data updates from Amazon Seller Central using Porter Metrics Google Sheets extension.

While this template is designed specifically for Amazon Seller Central you can use Google Sheets’ multichannel connectors such as LinkedIn Ads, GA4 to integrate data from other marketing platforms. By combining insights from different sources, you can create a unified view of your overall marketing performance.

To set up email alerts, use the built-in notifications feature in Google Sheets. You can create custom rules to trigger email alerts based on specific conditions, such as when your actual spend exceeds the budget or when pacing percentages hit certain thresholds.

Yes, you can fully customize the charts in the dashboard. You can choose different chart types, adjust colors, fonts, and styles, add data labels, legends, and trendlines, and customize axes and gridlines to match your reporting needs.

Additional marketing templates you can copy

Start a 14-day free trial

Connectors

Learn Looker Studio

Looker Studio templates

Resources