Amazon seller dashboard and free Google Sheet custom reports

written by GORILLA ROI

amazon seller dashboard

This article is for people wanting to create a flexible and custom Amazon seller dashboard within Google Sheets.

It is NOT for people learning how to navigate Seller Central and understanding how the widgets work.

What you’ll learn today:

  • Different types of FBA dashboards
  • Creating custom and flexible Amazon seller dashboards
  • How to automate data collection for dashboards
  • Free FBA dashboard spreadsheets for Google Sheets

Looking for flexible and custom FBA seller dashboards?

We have a lot of free dashboards for FBA sellers on this website.

It’s possible with Google sheets because of the flexibility and no code environment.

If you have the data inside your spreadsheet, you can create unique dashboards that fit your business needs rather than being stuck with software that is not flexible enough to meet your needs.

Here are some dashboard examples that you can copy to your Google account.

FBA Profit and Inventory Dashboard

amazon profit and inventory dashboard
amazon profit and inventory dashboard

Amazon Sales Performance Dashboard

FBA sales performance dashboard
FBA sales performance dashboard

Amazon Inventory Management Dashboard

amazon inventory management system dashboard presentation
Amazon inventory management dashboard

Amazon Sales and Profit Dashboard

sales profit dashboard
sales profit dashboard

Simplify getting data for your dashboards

The hardest, most tedious and draining part of working with FBA dashboards is getting the data.

If you have good design sense, create the nice looking layout is simple. It’s just a bunch of tables, charts and colors. Spreadsheets make it super easy to create dashboards.

Use our addon to automatically load all your Seller Central Data inside Google Sheets. Stop working for data. Let data work for you.

  1. Download the Gorilla ROI Amazon to Google Sheets addon
  2. Follow the getting started instructions to authorize and connect

Getting sales data for your dashboards

If you want a sales dashboard, you can pull Amazon data for various sales periods and also at a SKU level using our sales related formulas.

To pull units sold, you can do something as simple as:

=GORILLA_SALESCOUNT("THIS YEAR")

and for more control over what data you want to pull:

=GORILLA_SALESCOUNT("THIS MONTH", "ALL", "IPHN3724", "SHIPPED")

The syntax of the formula is

GORILLA_SALESCOUNT(PERIOD, [MARKETPLACE], [SKU], [STATUS], [MCF], [START_DATE], [END_DATE])

By automating the data import process, you can create your own highly flexible and custom sales dashboards that perfectly fit your needs.

Getting Amazon inventory data for dashboards

If you expand into advanced Amazon seller dashboard territory, consider inventory dashboards to improve your operations and performance as a seller.

On your Amazon Seller Central account, there is nothing that helps you much regarding Amazon inventory management. You can get sales data by clicking and downloading multiple reports and doing a lot of wasted manual work, but if you combine sales and inventory, your Amazon seller dashboard will be unbeatable.

  • See sales data on a sku level for last 7, 14, 30 days and how it affects inventory.
  • Create your own velocity calculations based on sales data AND inventory in stock.
  • See what the max restock levels are compared to sales.

Sales and inventory go hand in hand.

INVENTORY()
INVENTORYRESTOCK()

=GORILLA_INVENTORY(A1:A100, "US", "INBOUND_RECEIVING")

The syntax is as simple as entering the SKU, marketplace and what inventory status you want to look up.

GORILLA_INVENTORY(SKU, [MARKETPLACE], [STATUS])

To get inventory restock reports and data, it’s as simple as:

=GORILLA_INVENTORYRESTOCK(A1:A100)

You can make the formula as simple and broad as you want. Or get deep and detailed data points by following the syntax and documentation.

GORILLA_INVENTORYRESTOCK(SKU, [MARKETPLACE], [CONDITION], [DATAPOINT], [HEADER])

Creating Amazon seller dashboards for FBA and FBM

Now you know how to automate the data collection whether you sell FBA or FBM.

Time to create your seller dashboards.

We have a very extensive step by step tutorial on best practices and how to create a sales tracking spreadsheet and inventory management system you can follow.

The brief version today is that if you want to create something like the example dashboards I show up top, it’s all about making the dashboard fully dynamic using advanced spreadsheet formulas.

Step 1

Use our Gorilla formulas to load the data into a table format to create your own database.

Step 2

Create a new tab and name it “Dashboard”. Use formulas such as

  1. VLOOKUP
  2. QUERY
  3. IMPORTRANGE
  4. Data validation drop down lists
  5. FILTER

to create a dynamic way of displaying the data from the table in step 1.

Dynamic formulas to make dashboards

VLOOKUP() – Google Sheets VLOOKUP explanation

Sample Usage

VLOOKUP("B088325DS", A2:B26, 2, FALSE)

Syntax

VLOOKUP(SEARCH_KEY, RANGE, INDEX, [IS_SORTED])

In the example formula, it is best to use a cell reference instead of manually entering the ASIN into the formula.

VLOOKUP searches for the ASIN or SKU from the table that has all the data and then loads the matching values for “last 7 days”.

sales velocity vlookup
sales velocity vlookup

Use VLOOKUP to eliminate manual data entry.

If you do a formula like =I13 to link to the same cell, it does not work well if you add or remove rows and change your data table.

QUERY() – Google Sheets QUERY explanation.

Super powerful function that you must know.

Knowing how to use QUERY() alone will take you from beginner level to advanced spreadsheet nerd status.

Microsoft Excel does not have this (ha).

This functions lets you truly use your spreadsheet like a database.

Sample Usage

QUERY(A2:E6,"SELECT AVG(A) PIVOT B")

QUERY(A2:E6,F2,FALSE)

This is how we use it for our Amazon sales dashboard.

QUERY is used only on the dashboard tab and not in any of our data tables as it is a dynamic formula and should only be used to pull information and display it.

It is the king of finding information in a big messy table and displaying only what you want to see.

spreadsheet query dashboard
spreadsheet query dashboard
=QUERY('AZUSA-SALES'!$A3:$BB,"SELECT G, A, AZ, L, M, Q, S ORDER BY L DESC", 1)

My query formula is getting the data from columns G,A,AZ,L,M,Q and S from the tab “AZUSA-SALES”.

It then tells the query formula to sort it in descending order based on the data in column L of the AZUSA-SALES table.

The result is what you see in the screenshot above.

IMPORTRANGE –Google Sheets explanation

To link multiple files together, use this function.

Let’s say you have sales data in a spreadsheet file called “Amazon-Sales” and another spreadsheet file for “FBA-Inventory”.

Each spreadsheet is separate. You can create a new file called “Sales-Inventory-Analysis” and then import the data from both spreadsheets using the IMPORTRANGE formula.

Sample Usage

IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10")
IMPORTRANGE(A2,"B2")

This way, you can combine different files into a central spreadsheet and also keep it separated as you may not want to combine all the data into 1 file.

If you have a massive spreadsheet, this makes even more sense.

Seller dashboard design tips

The goal is to make it 100% hands off and automated.

  • Don’t type in unique values into your formulas.
  • Don’t enter values into the dashboard anywhere
  • Don’t clutter the dashboard
  • Don’t create too many different chart formats
  • Don’t use too many colors

The keys to a well designed dashboard are:

  • Use labels as much as possible
  • Breathing space between objects
  • Non high contrast or blinding colors
  • Max 2 different types of charts
  • Simple is always better

Free Amazon seller dashboards for download

Amazon Profit and Loss Dashboard

PREVIEW LINK: Preview link here
DOWNLOAD LINK: Spreadsheet link here

Detail Page Sales and Traffic by Child Item Dashboard

PREVIEW LINK: Preview link here
DOWNLOAD LINK: Spreadsheet link here

Sales and Traffic Report Dashboard

PREVIEW LINK: Preview link here
DOWNLOAD LINK: Spreadsheet link here

Product attributes and details dash

PREVIEW LINK: Preview link here
DOWNLOAD LINK: Spreadsheet link here
FREE GORILLA ADDON TO PULL DATA: Google Chrome page

Sales performance spreadsheet

PREVIEW LINK: Preview link here
DOWNLOAD LINK: Spreadsheet link here
FREE GORILLA ADDON TO PULL DATA: Google Chrome page

Amazon P&L monthly spreadsheet

DOWNLOAD LINK: Spreadsheet link here
FREE GORILLA ADDON TO PULL DATA: Google Chrome page

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

Leave a Reply

Your email address will not be published. Required fields are marked *