Collecting data from Keepa

This guide explains how to collect data from Keepa. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.

  • Keepa can collect a maximum of 1 million rows per single report. To fetch more data than this, split your fetch into smaller date ranges in the Initial Fetch step of creating a datastream.

Prerequisites

Before you start collecting data from Keepa, perform all of the following actions:

Creating a datastream to collect data from Keepa

The basics of creating a datastream to collect data from any data source are explained in our guide to Creating a datastream. This guide contains information about the specific steps to create a datastream to fetch data from Keepa.

Configuration: Choose the data you want to collect from Keepa

To choose what data to collect and customize the Keepa datastream configuration, follow these steps:

  1. (Optional) Rename your datastream.

  1. In Report type, select the type of data to collect from Keepa. The selected report type determines the additional fields to populate.

  1. In Domain, select the web domain on which to collect data.

  2. In Product statistics input type, select one of the following options:

    • Select Custom Query to enter a custom API query for the data you want to collect.

    • Select Adverity to configure the data collection using Adverity's user interface.

  3. In Root Category, enter the ID for the category on which to collect data. To collect a list of root categories, enter the value 0 into the field.

  4. In Average 30 day sales greater than or equal to, enter the minimum average number of sales on which to collect data.

  5. In Average 30 day sales less than or equal to, enter the maximum average number of sales on which to collect data.

  6. In Excluded categories, enter the IDs of the categories for which you do not want to collect data. To exclude multiple categories, enter the IDs separated by commas.

  7. In Product Type, select at least one product type on which to collect data.

  8. For the Best Sellers report type, in Categories, select the categories for which to collect data. If you do not select any items in a drop-down list, Adverity collects data for all items in the drop-down list.

  9. For the Best Sellers report type, in Sales rank average, select the time range on which to base the report.

  10. Select the Only returns ASINs without product details checkbox to only collect data on the Amazon Standard Identification Numbers (ASINs). The product details associated with the ASIN are not returned.

Run initial fetch: Collect data from Keepa

To collect data on the Best Sellers report type, do not run an initial data fetch when you create the datastream. Instead, follow the instructions in Updating the available categories list for the Best Sellers report type.

What's next?

Advanced Keepa tips

Updating the available categories list for the Best Sellers report type

To update the list of available categories when collecting data using the Best Sellers report, follow these steps:

  1. Open the Keepa datastream overview.

  2. In the top right corner of the page, click More.

  3. In the menu, click Update Categories.

  4. In Domains, select the domains on which to collect data.

  5. Click Update categories for the selected domains. As a result, you are navigated to the datastream overview page.

  6. In the top navigation panel, click Settings.

  7. In Report type, select Best Sellers.

  8. In Categories, select the categories for which to collect data from the updated list.

  9. Click Save.

As a result, the Keepa datastream is configured and you can collect up-to-date data for the Best Sellers report.