View Data Tools: Advanced


This article shows you how to use the Global Settings tools on the View Data page in Advanced mode. In Advanced mode, you get a comprehensive set of tools to analyse and organise search results. 

These View Data instructions can be used to learn about the Global Settings tools for the following search portals:

Basic mode

In View Data Basic mode, you get essential tools and a simple table layout. To learn about the View Data tools in Basic mode, see:

More information

The View Data page in Advanced mode is a giant table filled with a panoply of data, buttons, and images. At first glance, it can be a bit intimidating. 

To simplify the explanations, we divided the instructions into smaller articles. To understand key functionality on the View Data page, you should also read:

Opening the View Data page

There are several ways to open the View Data page. 

  • On the main dashboard, click View Data on the black menu on the left side of the screen. A drop-down menu displays. Select View. The View Data page for Product Search displays.

  • On the main dashboard page, click the View button on a search portal. The range of portals on your dashboard depends on your subscription service.

  • Inside the search portal, click the blue View Data button.

Choosing the Advanced mode

  1. Scroll up to the top of the screen.
  2. Toggle the switch towards Advanced.

1.  Selecting a search

You can either look at all the data discovered to date, or if you have run more than one search, select a search you've run for a more granular approach.

  1. Scroll up to the top of the page.
  2. Click the field beside You are watching. A drop-down menu displays.
  3. Select a search on the menu. The search results display on the page for you to select from.

1.1  Viewing process details

After selecting a saved search, a green INFO button and blue pencil display on the menu bar.

  1. Click the green INFO button. A Process info panel displays.
  2. Click the X to close the panel.

The panel has information about the search, including the URL, search date, and number of products added.

1.2  Changing the search name

You can change the name of the saved search.

  1. Click the blue pencil. A new field displays.
  2. Edit the search name.
  3. Click the check mark to save the name change.
  4. Click the X to cancel the change.

2. Reverse Search Button

After selecting a saved search, a blue REVERSE SEARCH button displays on the menu bar. (This tool is not available on the Reverse portal.)

This option is here if you would like to Reverse Search the results shown. Selecting this will cause a new Reverse Product Search tab to open on the browser, pre-loaded with all the ASINS from the results in the View Data process you are looking at.

For more information about Reverse searches, see:

3.  Adding notes

After selecting a saved search, a Notes button displays on the menu bar. This handy tool lets you jot down notes as you work through the data analysis. 

  1. Click the Notes button. A new panel displays. 
  2. Write a note and then click SAVE. 
  3. The pencil will go green indicating a note is saved here for viewing.

4.  Displaying hidden information

The horizontal bar at the top of the page contains three unrelated but interesting tools. Each tool hides or reveals information in the View Data table.

The tools in horizontal bar are:

  1. Competitive Range from the Buy Box
  2. Show barcodes
  3. Show 3D Box Shapes

Each tool is described below.

4.1  Competitive Range from the Buy Box

Is there a lot of competition for a product? This tool answers that question. 

This tool tells you the number of sellers offering a product price close to the Amazon Buy Box price. It's a global tool, so any change you make here customises the figures in the table for all products.

  • By seller, we mean the number of FBA or MF sellers.
  • By close, we mean a price inside a percentage range of the Buy Box price.
  1. Click the field next to Competitive Range from the Buy Box. A drop-down menu displays.
  2. Select a percentage on the menu. The smaller the number, the smaller the gap between the sellers' prices and the Buy Box price. 

4.1.1  Locating the number of sellers

After selecting a figure on the Competitive Range from the Buy Box tool, you have to find the results.

There are two places.

The first, is easy - simply look for the column - Competitive FBA Sellers. This will display the number of FBA sellers within that % range of the Buy Box. This data runs on a short cached period but is more often than not, correct.

The second, requires you to open a new panel for additional live information.

  1. Go to the table and select a product you want to investigate.
  2. Locate the New Sellers column.
  3. Click the green FBA / MF button. A new panel displays.

The new panel shows you three sets of information for that product:

  • number of FBA / MF sellers 
  • percentage range selected (e.g. 2%)
  • number of sellers with a price within that percentage range compared to the Amazon Buy Box price

Here's an example. 

  • The image below tells us there are 23 sellers (17 + 6) of this product. 
  • The image also tells us 4 sellers (i.e. 1 FBA and 3 MF)  have a price which is close to the Amazon Buy Box price. In this panel, close means within 2%.

Here's a panel for the same product with a 20% competition figure. 

  • The total number of sellers is the same as above (that's to be expected). 
  • There's more competition for prices within 20% of the Buy Box price. The box tells us there are 8 sellers with a price that's within 20% of the Amazon buy box price.

4.2  Show barcodes

This switch controls the display of barcode images in two columns: Amazon UPC/EAN and UPC/EAN.

  1. Toggle ON the switch (blue) to display barcode images for the products in the table.
  2. Toggle OFF the switch (orange) to hide the barcodes.

4.3  Show 3D Box Shapes

Toggle ON this switch to show 3D box shapes in the Product Size column for a visual representation on the product shape.

5.  Managing columns

The MANAGE COLUMNS button lets you customise the way columns display on the table. You can:

  • hide columns 
  • change the order of columns on the table
  • save preferences as a new style
  • set a new default which can be used on other View Data pages

5.1  Opening the manage columns panel

  1. Scroll up to the top of the page.
  2. Click the blue MANAGE COLUMNS button. The Manage Columns panel displays.

5.2  Hiding columns 

  1. Toggle OFF (orange) a column header switch.
  2. Click APPLY.
  3. To display a column on the View Data table, toggle ON (blue) a column header switch.
  4. Click APPLY.

5.2.1  Another option

You can hide columns while working on the View Data table.

  1. Scroll up to the top of the page.
  2. Locate the toolbar with blue magnifying glasses.
  3. Locate the column you want to hide.
  4. Click the grey button with an eye. The column is hidden.
  5. To unhide all columns, scroll to the left side of the toolbar and click the eye button next to the green button. All hidden columns are now visible.

  • Note: To reveal the toolbar with blue magnifying glasses, make sure you see the words HIDE FILTERS next to the FILTER MANAGER button. If you see the text SHOW FILTERS, the toolbar is hidden. Click SHOW FILTERS to reveal the toolbar.

5.3  Changing the column order

You can change the order of columns on the table inside the Manage Columns panel.

  1. Click a column title. The mouse pointer changes into 4 arrows.
  2. Drag the column title to a new location and then release the mouse.

5.3.1  Dragging columns

You can change the order of columns while working on the the View Data itself with the drag and drop tool.

  1. Go the View Data table.
  2. Click and drag a column title.
  3. Drop the column in a new location.
  4. Release the mouse.

5.4  Saving column display choices

Inside the Manage Columns panel, you can save a column layout as a new style and use it when looking at other View Data pages.

  1. Click the field beside Add New Style and then type a file name.
  2. Click the (+) button.
  4. Click SAVE.

6.  Updating global table data

Use this tool to update information on your table. This button updates data for all of the products on the table. 

  • Using the Row Toolbar, you may also get current information for individual rows of data. That button is discussed here.
  1. Scroll up to the top of the View Data page.
  2. Click the orange UPDATE DATA button. A drop-down menu displays. 

The drop-down menu has four options:

  • update source prices
  • update adjusted prices
  • update Amazon data
  • update all data

Each option is described below.

6.1  Updating source prices

Get current source prices for every product in the table. 

  • Note: This menu item is not available on the Wholesale View data page.

Tactical Arbitrage visits the source of each product and checks the price. If a different price is found, it is presented in the table.

6.2  Updating adjusted prices

Get the current adjusted price information for every product in the table. The adjusted price is your net buy cost after discounts as well as cashback and giftcard rebates. The adjusted price is used to calculate the gross ROI for each product.

This tool is very handy if you come across a new special discount or offer. For example, you learn that a company is offering a 10% cashback rate for a limited time.

  1. Click UPDATE ADJUSTED PRICES. A new panel displays.
  2. Add new information to one, some, or all of the fields in the Update Adjusted Prices panel.

After updating the information, inspect the Adjusted Price column on the table. You'll also see changes to the gross profit and gross ROI.

6.3  Updating Amazon data

Update table information from Amazon. This includes:

  • Amazon Buy Box Price
  • Amazon Return After Fees
  • Sales Rank
  • Average Price for 30 and 90 days

 6.4  Updating all data

Update all pricing information. This includes store prices and Amazon Buy Box prices.

This tool does not update adjusted prices. That information is handled in a separate update tool (see above).

7.  Using the search tool 

The search tool is next to the UPDATE DATA button. Use this tool when you want to narrow the search results based on a keyword in the title. You can also use it to search a UPC, EAN, or ASIN. 

  1. Enter a keyword (or product code) in the search field.
  2. Click the magnifying glass or hit ENTER on the keyboard. Products with that key word (or product code) display in the table.
  3. To remove the search filter and display all results, delete the keyword from the search field and then click the magnifying glass (or hit ENTER on the keyboard).

8.  Using the download all tool 

Use this tool to download your search results. The DOWNLOAD ALL tool is near the top of the page. It's in a box with two other buttons.

8.1  Selecting a download destination

  1. Click the green DOWNLOAD ALL button. A small drop-down menu displays.
  2. Select the destination for your file: your computer or your Google drive. 
  3. If you select Google, you're prompted to login to your Google account. 

8.2  Selecting a file format

After selecting a file destination, the Download All panel displays. Choose the type of file to download. There are several options:

  1. download the entire file as a csv or xlsx
  2. download all visible table data (excludes hidden columns and rows) as a csv or xlsx

Hiding columns and rows

Before exporting a file, you might want to customise the table by hiding some columns and rows.

  • Section 5.2 above shows you how to hide table columns.

9.  Using the delete all tool 

The DELETE ALL tool looks simple, but it's not. It's a little more sophisticated than wiping an entire table of data.

9.1  Deleting the table

On a basic level, the DELETE ALL button wipes the whole table.

  1. Click the DELETE ALL button. A confirmation panel displays.
  2. Click DELETE ALL. 
  • Note: After deleting a table, the data is gone; there is no UNDO button.

9.2  Deleting selected columns or rows in a table

There are other delete options. These options appear if you have hidden columns or rows.

Click the DELETE ALL button. A confirmation panel displays. You can delete:

  • the entire table (DELETE ALL)
  • the columns and rows that are not visible (DELETE HIDDEN)
  • the visible columns and rows and keep the hidden content (DELETE VISIBLE)

10.  Using the move all tool 

The MOVE ALL is very handy when you want to save a large View Data table. The Move All tool takes all of the information in a View Data table and saves it in a folder. 

  1. Scroll up to the top of the View Data page.
  2. Click the MOVE ALL button. A confirmation panel displays.

With the Move/Copy All panel open, you have several options, as described below.

10.1  Destination

The first option is selecting a save destination.

  1. To move the data to an existing folder, click the field next to Select Your Folder. A drop-menu displays.
  2. Select an option. If you have not created any folders, the default is Main Folder.
  3. To create a new folder, click the field next to Create.
  4. Enter a folder name.

10.2  Move or copy

The next step is to decide how to save the data.

  1. Select MOVE ALL to remove the table from the View Data page and place it in the selected folder. After a MOVE ALL, the View Data page is empty.
  2. Select COPY ALL to place a duplicate of the table in the selected folder. After finishing a COPY ALL step, the table on the View Data page is unchanged. 

11.  Using the page display tool 

The page display tool helps you navigate the table. This is a handy tool when there are hundreds or even thousands of search results.

Scroll up to the top of the View Data page. The toolbar shows several pieces of information.

11.1  Current page

The page currently on display in the table is highlighted in the toolbar. The current page is blue.  Click a different number to change the table page.

11.2  Change page

There are two ways to change the table page. You can click a number in the toolbar. Or you can click the field next to Go and type a page number. Click Go and the table data changes. 

11.3 Show results

You can change the number of items on display in the table. Click the field next to Show and select a number on the menu. The maximum number is 100.

11.4  Number of entries

On the right side of the toolbar, you can see the number of entries currently on display in the table. You also see the total number of entries for this search.

In the image below, the toolbar shows the total number of entries for this search is 280.

12.  Looking at exchange rates

Scroll to the top of the View Data page and you'll see the words Exchange Rates.

Click the nearby question mark and a panel displays. It shows current exchange rates used when calculating prices and margins for cross-country transactions (e.g. buy in the UK and sell in the US).

The panel on the View Data page is for information purposes. This data cannot be changed. In addition, it us only useful when you are doing cross-country transactions. 

Is this article helpful?
0 0 0