This is why you shouldn’t use scouting tools on your listing

The two biggest research tools for Amazon sellers are:

  1. Jungle Scout
  2. Amz Scout

Research tools have changed the way we source and get data, but there comes a risk with using the tool.

What I’m going to show you is when and when not to use these scouting tools.

Not how or how not to use. There are plenty of tutorials and people wanting to make affiliate sales that will go over how to use it and why you should.

None of the negatives associated with it. No affiliate links here. Just straight truth of when and when not to use it.

Let’s go.

How scouting tools work

One area I find sellers to be overzealous is in the area of data protection and fear that a software company will steal their product idea.

I have found this to be far from the truth.

The real fear shouldn’t be whether the software company is going to use your data. But whether they use your data as part of their service to other users.

Scouting and research related tools work like this:

  • You give access to the tool and enter your seller ID and authorization token.
  • The software will start to download your data via the Amazon API.
  • Free chrome addons or paid extensions require you to feed them data manually.
  • The software will clean up and arrange the data.

Next comes the biggest difference between software tools.

  • Any tool that offers research functionality like inventory lab or paid web app tools will make your data searchable and viewable. It’s open for anyone paying for access to find and analyze. This is called “one to many” access.
Basic idea of how Amazon research tools collect and provide data
Basic idea of how Amazon research tools collect and provide data
  • Software like Gorilla ROI and accounting tools (think Quickbooks) do not share your data with anyone. It is siloed to your account. Meaning we provide 1-1 connection access only. No one outside of you can see or find your data. Our service is not dependent on being fed data from other users for the rest of the user base to see and use.
Gorilla ROI Silo connection to prevent outside access
Gorilla ROI Silo connection to prevent outside access

If you sell yoyo’s, another seller will not be able to check your sales data on yoyo’s. Each seller can only access their own data. Everyone is walled off from each other.

Knowing this important if you are worried about other sellers finding your product.

When to use scouting software

The best time to use Amazon scouting software is to perform research on a product or to find a category or idea.

Think of it as a filter.

Scouting tools help you when you are at the top of the funnel with thousands of different products and categories to choose from.

It helps you narrow the list down.

The lower you get in the funnel, the less you need scouting software.

I won’t get into the details of how to use the tool because there are so many tutorials out there.

When not to use Amazon scouting software

I’ve used Jungle Scout before but canceled and ultimately chose AMZ Scout as my chrome extension.

With the majority of Amazon sellers using Jungle Scout, every time the tool is run on a particular product, the data gets entered into the Jungle scout servers.

You guessed it.

The more people there are using it, the more likely people will find it.

With AMZ Scout, it’s lesser to some extent.

The key is once you have identified your niche and product, stop using the scouting software. There is no need to continually feed the latest data into a database for tens of thousands of other people to find.

One day when AMZ Scout made an update to their tool called “saturation”, it really opened my eyes to the data they are seeing.

AMZ SCOUT saturation score shows data on how many people found it
AMZ SCOUT saturation score shows data on how many people found it

This is for a random skin routine product I came across. Looks like 4 other people found the exact same product and brand.

Here’s a look at bbq gloves. One of the most copied and private labeled products on Amazon.

Other tools have the same thing, but AMZ Scout now shows you how many other people are searching for it.

I assume the numbers are calculated based on a monthly tally or something. 39 people in the last 30 days looking for bbq gloves. Not a product I want to be in.

For this very reason, once you know your product, it is better to try and keep it under wraps by not using scouting tools.

You have the experience and judgement to figure out how much something sells based on the BSR.

The best way to use scouting software

Using these tools to keep tabs on your competitor is a good strategy.

BUT

If you are searching in such a way that will expose your product, then it’s not good.

The better way is to use the research tool on your competitors Amazon storefront.

  • Not the search results after typing a keyword
  • Not the listing page

The Amazon Storefont – because it will only list the products in their storefront in the tools.

This way, you can hide your product while giving AMZ Scout or whoever, the data of your competitors.

Sure.

People can still trace it back to your product, but at least you aren’t updating your product and data for all to see.

Use scouting tools on competitor Amazon Storefront
Use scouting tools on competitor Amazon Storefront

Summary

  • Scouting and research tools are great and have made work so much easier.
  • Once you get past the initial stages of finding your niche and product, stop using the tool.
  • Publicly available tools require data to be loaded onto the servers allowing for others to use it.
  • Use the tools to look up competitor storefronts.
  • Use your internal data to keep track of your sales like with Gorilla ROI.

Looking to get data from Amazon into Google Sheets?

If you are looking to connect Amazon with Google Sheets, then you’ve come to the right place.

We are the only software that allows you to take full control of your data.

Rather than locking down what you can and can’t do, you get the flexibility to use your data how you want it. Get direct and flexible access to your Amazon data without having to know code.

Gorilla ROI is a Google Sheets Add-on that allows you to connect and import data directly from your Amazon Seller Central account into Google Sheets.

Do things like bulk convert your ASIN’s to SKU’s or FNSKU, breakdown the fees and charges per sku, pull historical inventory level for projections, load the number of units sold by month, week, last year, last month and more.

Here’s a demo that I did where you can see it in action and how it works.

Full transcript and timeline is available at https://orangeklik.com/demo-gorilla-roi/

FBA spreadsheets are available for new users.

Free Amazon templates are also available. No sign ups, no emails. Just copy to your account and away you go.

Free Amazon FBA Spreadsheet Template for Google Sheets and Excel

What you’ll learn

  • Free Amazon FBA spreadsheets to download and use
  • How to organize and use these Amazon seller spreadsheet templates
  • The difference between each of the free Amazon FBA spreadsheets

download amazon spreadsheet

This is a growing list of free FBA spreadsheets. As more are created, I will continue to update and add to this page.

Make sure to bookmark and share for other sellers to benefit from the free FBA spreadsheets.

Use the table of contents above to quickly jump to the spreadsheet you are looking for.

Free Amazon FBA spreadsheet list and growing

So far, the list of template spreadsheets include:

  • Detail child item sales analysis
  • Amazon PPC Customer Search keyword analysis dashboard
  • Amazon PPC Targeting Keyword analysis dashboard
  • Seller sales performance stats
  • Product listings information template
  • Sale & traffic analysis dashboard

If you have a request for a spreadsheet, leave a comment and I’ll see if I can make it and then add it to this list.

Or if you have a spreadsheet of high quality that you want to add to this list, comment below also.

How to copy the free spreadsheets to your account

These spreadsheets are based on Google spreadsheets. Not excel templates.

They can be converted to an Excel based spreadsheet, but some formulas will have to be updated. If you don’t have the skills with spreadsheets, best stick to Google Sheets.

To copy any spreadsheet to your account:

  • Click the link to the Google sheet that you want
  • Click on File > Make a copy
  • (do not select any “Request edit access”)
how to copy spreadsheets to your account
How to copy over the free Amazon FBA spreadsheets to your account

Now onto the spreadsheets.

Analysis Spreadsheet for Detail Page Sales and Traffic by Child Item

free amazon spreadsheet child sales stats traffic
free Amazon spreadsheet child sales stats traffic

What is it?

Amazon is continuing to make it harder to find and understand data.

With this Amazon spreadsheet, it will automatically sort, reorganize and provide a dashboard to help you understand your data.

It takes your report and displays:

  • Best selling product and associated stats
  • Best converting product and associated stats
  • Top 7 sellers, how much each generated in sales, the conversion rate
  • Worst selling product
  • Lowest converting product
  • Bottom 7 sellers with at least 1 sale. Products with zero sales are ignored.

How it works

Instructions for this FBA spreadsheet is included in the spreadsheet, but here’s a quick rundown.

  1. Export your csv report from Reports > Business Reports > Detail Page Sales and Traffic by Child Item
  2. Copy the data from the csv file
  3. Paste it into the Free FBA spreadsheet where the tab says “data” or “copydatahere”. Make sure the column positioning matches the example.

That’s it.

Just copy and paste and the spreadsheet will take care of the rest. Let the spreadsheet become your Amazon sales analysis tool along with the rest of the seller spreadsheets here.

Sales and Traffic Report Dashboard

free fba sales traffic analysis
free fba sales traffic analysis

What is it?

Next on this list of free sales analysis tools is a Sales & Traffic Report analysis dashboard. It works very similar to the Child Items Detail report above.

This template takes a higher level approach of analyzing and deciphering  your overall business performance based on the Sales and Traffic report.

Once you copy this spreadsheet over to your account, you can copy and paste your data in it to quickly see:

  • best performing month and stats for that month
  • best converting month and stats
  • slowest month and stats
  • lowest converting month and stats

How it works

Instructions for this FBA spreadsheet is included in the spreadsheet, but here’s a quick rundown.

  1. Export your csv report from Reports > Business Reports > Sales and Traffic
  2. Change the settings to display your data in months, and then expand it to a 2 year view. A screenshot is included in the instructions inside the spreadsheet.
  3. Copy the data from the csv file
  4. Paste it into the FBA template where the tab says “data” or “copydatahere”. Make sure the column positioning matches the example.

Advertising report – customer search term analyzer

Advertising report analyzer for customer search term
Advertising report analyzer for customer search term

What is it?

This is the first of two advertising report analysis spreadsheets you can download.

This spreadsheet is built for “search term” reports from your advertising reports page.

The two main exports are for “targeting” and “search term”. Search term are the terms that customers type in and find your products. And because the columns and exports are slightly different, I’ve created two separate versions so you don’t get confused.

I’ve found that ROAS is the best indicator to use when filtering and analyzing your search terms.

ACoS breaks down if you don’t have any sales. You could end up spending $1,000 on a particular keyword, but if there are no sales, it will be blank and you’ll be left in the dark.

Note that this is a manual spreadsheet. So you have to copy and paste the data in from your CSV file. Automation will come later via the addon for Gorilla ROI.

With this seller advertising spreadsheet, you can:

  • see key stats related to what customers are looking for
  • see best revenue generating keyword
  • see lowest and highest ACoS keyword
  • see top 10 best and worst keywords
  • see highest spend keyword

This type of analysis should help you figure out where you need to improve, or where your current campaigns are strong so that you can make it even stronger and box out competitors.

How it works

Instructions for this FBA spreadsheet is included in the spreadsheet, but here’s a quick rundown.

  1. Go to Reports > Advertising Reports
  2. Select “Sponsored Products”
  3. Select “Search term”
  4. Select your report period
  5. Create the report and then download the csv
  6. Copy the data from the csv file
  7. Paste it into the FBA template where the tab says “data” or “copydatahere”.
    Make sure the column positioning matches the example.

Advertising report – targeting keyword analyzer

Advertising report spreadsheet analyzer fba
advertising report spreadsheet analyzer fba

What is it?

This is the second of the two advertising report analyzer spreadsheets. While the customer search term spreadsheet above looks up the stats for the search terms your customer types in to the search bar, this one looks up the stats related to the keywords you currently have in your campaign.

Return on Ad Spend (RoAS) is the key filtering metric here. Focus on getting a higher RoAS number as it means your return is higher compared to the spend.

The way this spreadsheet has been designed is to make the data easy to understand and without having to click the same filter button so-many-times to do the same thing over and over again.

In order to automate this spreadsheet, it’s built with a lot of complex INDEX() and MATCH() functions. If you don’t know what you are doing, try playing around a little bit and undoing the changes to return it back to normal.

Once you figure out how this spreadsheet and the formulas work, you can create more “widgets” based on criteria you need to look up.

How it works

Instructions for this targeting keyword spreadsheet is included in the spreadsheet, but here’s a quick rundown.

  1. Go to Reports > Advertising Reports
  2. Select “Sponsored Products”
  3. Select Targeting
  4. Select your report period
  5. Create the report and then download the csv
  6. Copy the data from the csv file
  7. Paste it into the FBA template where the tab says “data” or “copydatahere”.
    Make sure the column positioning matches the example.

Product attributes and details listing

Product listing seller spreadsheet
Product listing seller spreadsheet

What is it?

This is one of the basic spreadsheets I offer for all users of Gorilla ROI.

It’s a spreadsheet to track your listing information, category, URL’s review links and so on.

Think of it as a log to track your listing performance and how it does over time. You can update the numbers of this spreadsheet weekly, monthly or however often you want.

The real benefit of this is to combine it with Gorilla ROI addon to automatically pull all of your data into the spreadsheet.

You can use this seller template, but the real power and time saving benefit comes from the automation. The addon is free to use for any 3 FBA sku’s. It will not work for FBM. Only FBA.

How it works

If you manually update the spreadsheet, it’s very easy to figure out. Enter the info into the tab “LISTINGS” as often as you want.

If you use Gorilla ROI addon to pull your data into the spreadsheet, follow the instructions on how to install and add any 3 of your SKU’s.

Allow the addon to start collecting your Amazon seller data for a few hours and then it will start populating the spreadsheet.

Detailed instructions are here.

Amazon detailed sales performance spreadsheet

Amazon sales performance spreadsheet
Amazon sales performance spreadsheet

What is it?

Don’t judge this spreadsheet by the image above.

Because it’s one of the most sought after and requested spreadsheets. This sales spreadsheet automatically pulls, loads your data and displays it over 25 preset periods.

If you want to get a granular breakdown of your sales performance, look no more.

Just look at the different preset time periods you can pull for your seller sales.

  • Today
  • Yesterday
  • Same day last week
  • Same day last month
  • Same day last year
  • Last 7 Days
  • Last 14 Days
  • Last 30 Days
  • This week
  • Max
  • This month
  • This quarter
  • This year
  • This Year-to-Last-Month
  • Last Week
  • Last Month
  • Last Quarter
  • Last Year
  • Last 60 Days
  • Last 12 Months
  • Last 7 Days Week Ago
  • Last 7 Days Year Ago
  • Last 30 Days Month Ago
  • Last 30 Days Year Ago
  • Last Week Year Ago
  • Last Month Year Ago
  • YYYY-MM (set format as text)
  • YYYYQ1… YYYYQ4

Trying to get this manually to understand and dig into your data will be a nightmare.

The spreadsheet includes the formulas required to get this information from your seller central account data. All you have to do is install the Gorilla ROI addon, activate it and away you go.

With this type of breakdown, it helps you see how your business is doing. Rather than procrastinating or wasting time (which is money) to do it manually or not doing it at all, you can keep track of sales and jump on things that need attention.

If you want to see how deep and granular you can go, check out the preview above. It’s a version that all Gorilla ROI members get along with other special spreadsheets and dashboards to make life easier as an FBA seller.

How it works

This one is not a manual spreadsheet.

There is simply no way you can update this manually. And that’s the point. Data like this should be automated.

Follow the instructions on how to install and add any 3 of your FBA SKU’s. FBM is not supported.

Allow the addon to start collecting your Amazon seller data for a few hours and then it will start populating the spreadsheet.

Detailed instructions are here.

Why Amazon sellers should be using spreadsheets

Many software tools for FBA are popping up, but I believe that spreadsheets are necessary to give flexibility to the user.

Subscribing to software is great and there are many tools out there, but seeing how you can customize a car, home and pretty much most products, you should have the flexibility to use your own data in a way that makes sense to you.

You and I have different KPI’s and the point of using spreadsheet tools is to create basic templates that you or your team members can use without interrupting your workflow.

As Google continues to enhance their Google Sheets product, the power of Sheets continues to increase. Few years back, G Sheets could barely do the basics, but today, you have a full blown spreadsheet application online.

Combine with Google Data Studio, Zapier, Slack and other apps and you have the tools and power to create internal apps and software processes for pennies.

How the spreadsheets are designed

I wrote about how I do spreadsheets here. This article will help as you can see and understand the architecture of the spreadsheets allowing you to extend it and create bigger, better versions of it.

Just remember to separate the data and the display tabs.

In all the free templates I’ve shared with you, there is a tab for entering the raw data, one that processes the data and one that displays the data.

Keep it like that and you’ll see how easy and quick it is to manage and use a spreadsheet, rather than the messy monsters you are likely used to.

What other spreadsheets do you want?

I love creating free Amazon FBA spreadsheet around here. Whether it be for Google Sheets or for Excel, spreadsheets are not going away anytime soon.

Rather than just creating spreadsheet templates that are nothing but some titles, I want to create functional tools for FBA that you can use.

If you have ideas or a request, leave a comment below.

I will continue to make spreadsheets and add them to this free spreadsheets resource page.

Make sure you bookmark it or share it with others. The more demand, the more FBA templates I’ll offer.

Frequently asked questions

Does this work for Excel?

  • All the Amazon spreadsheets you find here are created for Google Sheets. You can save them as excel format, but there will be formulas that needs to be converted to MS excel format. Functions like QUERY() are not supported in excel and you’ll have to whip out advanced techniques like power queries to run the same thing. Or a lot of VLOOKUPS, INDEX, MATCH functions.

What other spreadsheets and tools do you offer?

  • We offer a suite of ready to go Business Pro Spreadsheets and documents to improve your FBA operations. Things like forecasting calculators, inventory analysis sheets, manufacturing agreements in Chinese and English and so on. The suite of spreadsheets and docs continue to grow and it is a lifetime access for a single payment.

Do you provide support for these spreadsheets?

  • I’ve created these spreadsheets so that people of any level can use them. I take software engineering approach to create very easy to use spreadsheets and you will see how easy it is once you open them up. I’ll continue updating these spreadsheets if Amazon changes their reports or formatting.

Do I need the Gorilla ROI addon for these spreadsheets to work?

  • Not for all. The spreadsheet for product listings and detailed sales performance is best with the addon. The addon is free for any 3 of your FBA sku’s and if you can automate the process, what have you got to lose? Takes a minute to install and if you don’t like it, just uninstall it.

Can I share these spreadsheets with others?

  • Yes you can share it with your team, family, friends and whoever else may benefit from having a free Amazon FBA spreadsheet. Please don’t remove the attribution as I have spent a lot of time making these spreadsheets and would hate to take it down if people are found to be claiming they made the spreadsheets.

Do you make custom spreadsheets for Amazon sellers?

  • No. I do not offer custom services. My team does offer support and custom integration into your existing spreadsheets if you sign up to use Gorilla ROI and purchase the Support and Warranty package found in your account.

(GorillaROI) New features and downloads ready

Who doesn’t love new stuff?

Over the past few months, we’ve quietly pushed a lot of updates for Gorilla ROI users.

New features.

New downloads.

More updates.

Let’s go.

A brief outline of what has happened

First thing is that Q1 has been a rush. Amazon is not slowing up, our sales are increasing and 2019 looks like another year of big growth.

We are going to start publishing more on the blog to share our short term goal of targeting $5M in revenue over the next 2-4 years.

That comes out to $420k revenue a month. We are currently half way there at $200k/mo, but it hasn’t always been pretty.

Note that I’m referring to revenue, not profit.

Our focus is to keep driving growth in order to bring our costs lower, scale for efficiency and then to start turn on the profitability tap. More on this at a later time.

I’ll share the joys and pains of what goes on.

If this interests you, subscribe to the blog and stay tuned for juicy and actionable content.

In addition to this, we’ve had our heads down

  1. researching and developing new products
  2. creating and optimizing systems and processes to simplify and automate areas of our business
  3. and of course coding and continually upgrading Gorilla ROI

Gorilla Agency is here

gorilla roi agency addon

Gorilla Agency is finally here.

Something a lot of you have been asking for. If you are a seller or agency managing multiple seller accounts, you can now combine it all with Gorilla Agency.

If you manage 5 brands, the problem is you have to:

  • log in to the account
  • export the data
  • process it
  • repeat 4 more times

With Gorilla Agency, you can now centralize the data and pull across all 5 seller accounts directly into Google Sheets with a single click.

No more wasting time on the little things. You can focus on better things.

To see the full details and learn more, check out the full page on Gorilla Agency and what you get.

New functions to pull data

amazon finances template
Amazon finances template

We’ve implemented finance related functions where you can pull in a detailed breakdown of what fees and other charges Amazon is making you pay.

It’s a great way to see in detail your Amazon finances with all the income and expenses in one very detailed view.

The new functions allow you to see the charges made by Amazon, and the fees for using their services.

  • =Gorilla_ChargeTotal() – shows all charges related to an order and shipment
  • =Gorilla_ChargeType() – shows the list of line items categorized as “charges”
  • =Gorilla_FeeTotal() – shows all fees related to an order and shipment
  • =Gorilla_FeeType() – shows the list of line items categorized as a “fee”
  • Full explanations available on the functions page

Want to see how it looks? Check it out with this preview.

New templates and documents

With the new addition of Gorilla Agency and the new functions ChargeTotal, ChargeType, FeeTotal and FeeType, new templates are available.

Log in to your account at app.gorillaroi.com to copy them over to your account to start.

It doesn’t end there.

For PRO Spreadsheet buyers, we are adding business and operational documents that should get you excited. We’ve uploaded a bilingual NNN agreement as well as another document we get all of our suppliers to sign.

It has saved our necks on many occasion.

Bilingual English and Chinese NNN Agreement for manufacturing
Bilingual English and Chinese NNN Agreement for manufacturing

If you try to create your own NNN agreement and then get it reviewed and translated by a Chinese lawyer, it will be north of $1,000. But we are throwing in this document as part of the PRO package to sweeten the deal.

If you have already purchased, log in and download your free upgrade today.

New preset periods for Gorilla ROI

I tend to analyze deeply. Sometimes too deep.

And I find myself constantly changing dates and checking different time periods. That’s why we offer so many preset time periods already. But we’ve added more to the mix.

With Gorilla ROI functions like RankHist(), SalesTotal(), and ChargeTotal() where you define dates, you can pull data by month and quarters.

  • =GORILLA_SALESTOTAL(“2019Q1”) returns sales total for 2019 Q1
  • =GORILLA_SALESTOTAL(“2019-03”) returns sales total for 2019 March

How it helps?

By being able to pull quarterly and monthly data, you can easily create monthly reports and track performance side by side.

More to Come

Only touching the surface of the new features you get access too. Pulling PPC data into Google Sheets is another major request which we are reviewing and will begin to work on.

If you are not a member of Gorilla ROI, learn about our products and see how you can increase efficiency and also lessen your workload by pulling Amazon Data into Google Sheets.