Table & Column Referential

An exhaustive list of all tables and their respective columns, labeled by schema, can be found in this Google Sheets document:

https://docs.google.com/spreadsheets/d/1gYGqKQP9Z71nz1lOb4y0wJ15i27NvsUzdliIJeIx0HY/edit#gid=175439716

Frequently Asked Questions

How can I see data on sessions and page views of my products?

Currently, this data is available as a preview in the PREVIEW_RAW_SELLER schema. Here, you’ll find data on sessions and page views broken down by platform (browser vs. mobile app). This data is available at SKU-level, Child ASIN-level, and Parent ASIN-level.

How can I check which brands dominate a specific category?

Upon tracking a category, the table REPORTS.REPORT_MARKET_PRODUCT_SALES_RANK_AND_ESTIMATES will contain this data within both the brand and brand_catalog columns.

How can I check which brands dominate search results for a specific keyword?

Upon tracking a keyword, the tables REPORTS.REPORT_SEO_PRODUCT_ORGANIC_RANK and REPORTS.REPORT_SEO_PRODUCT_SPONSORED_RANK will contain this data within both the brand and brand_catalog columns.

Why do some of these tables contain two brand columns?

We gather brand data from two distinct sources - directly from the Amazon website and via their API. It is worth noting that brand names may vary between these two sources, and thus, we present both to provide more exhaustive information to the user.

What if I want to analyze brand data among products within my other data, like Inventory or Advertising?

Simply refer to REPORTS.REPORT_PRODUCT_LATEST_VERSION. This table contains brand data, as well as other basic data points, on all your products.

Why are some schemas labeled “Raw”?

The “Raw” label means that this data is exactly what we have collected from Amazon’s API’s, with very minimal transformation on DataHawk’s side.

Why are some schemas labeled “Preview”?

The “Preview” label means that this data is currently in the works, and subject to change in terms of form and content. However, we believe that this data can already provide value to you despite being a work-in-progress.

I want to access this data in a more raw/unaggregated format. Would this be possible?

In most cases, yes! If you would like to request this type of access, please reach out to us, and we will do our best to accommodate your request.