Advertising Account

Amazon Advertising is the platform Sellers, and Vendors use to advertise their products on Amazon.

DataHawk allows you to connect your Amazon Advertising data using the Amazon Ads API. Whether you are a Seller or Vendor, you can connect your Amazon Advertising account to DataHawk.

Connecting your Amazon Advertising account allows you to automatically collect your advertising data and facilitate reporting on it, store it to prevent data loss, and consolidate it with other metrics such as financial and search data to get a unified view of how advertising impacts other parts of your business.

DataHawk integration works for Advertisers registered in all Amazon regions:

  • North America: US, Canada, Mexico, and Brazil.
  • Europe: UK, Germany, Italy, France, Spain, Netherlands, UAE, Sweden, and Poland.
  • Far East: Japan, Singapore, and Australia.

📘

Tip

Solve Amazon Advertising reporting and storage limitations and facilitate data consolidation with DataHawk, a powerful data storage solution for your critical business data, giving you full data ownership and advanced reporting capabilities

Datasets

Metrics resulting from integrating a Seller Central account can be accessed both in a raw format and ready-to-use reports and dashboards.

  • Raw data can be accessed via Connections and can notably be used to build dashboards on your favorite BI solution.
  • Ready-to-use dashboards and reports are available on the web application.

Overview

The table below highlights a very high-level summary of the datasets available, where they can be accessed, and how.

Metric FamilyBy Account on ConnectionsBy SKU on ConnectionsBy Account on the Web AppBy SKU on the Web App
Sales✅✅✅❌
Orders✅✅✅❌
Units Sold✅✅✅❌
Returns✅✅✅❌
Refunds and Returns✅✅✅❌
Reimbursements✅✅✅❌
Advertising✅✅✅❌
Marketing✅✅✅❌
Referral Costs✅✅✅❌
Warehousing Costs✅✅✅❌
Shipping Costs✅✅✅❌
Other Costs✅✅✅❌

Connections Datasets

Your DataHawk-powered Snowflake database contains multiple tables about advertising data. These tables contain a very exhaustive list of data points as columns and are organized into what is called a schema.

SchemaTableAboutColumns
ADVERTISINGADVERTISING_ACCOUNT_METRICSAdvertising metrics on an account level COSTS
SELLER_NAME
ORDERS
CLICKS
ACCOUNT_KEY
SALES
SPONSORED_TYPE
UNITS_SOLD
DATE_DAY
IMPRESSIONS
* MARKETPLACE_KEY
ADVERTISINGADVERTISING_CAMPAIGN_METRICSAdvertising metrics on a campaign level DATE_DAY
ORDERS
COSTS
MARKETPLACE_KEY
CAMPAIGN_NAME
SALES
SYNC_TIME
SELLER_NAME
UNITS_SOLD
CAMPAIGN_ID
IMPRESSIONS
SPONSORED_TYPE
ACCOUNT_KEY
CLICKS
ADVERTISINGADVERTISING_PRODUCT_CAMPAIGN_METRICSAdvertising metrics on a product and campaign level MARKETPLACE_KEY
SYNC_TIME
COSTS
DATE_DAY
SELLER_NAME
SPONSORED_TYPE
CAMPAIGN_NAME
SALES
CAMPAIGN_ID
ACCOUNT_KEY
CLICKS
CHANNEL_PRODUCT_ID
ORDERS
PRODUCT_KEY
IMPRESSIONS
UNITS_SOLD
ADVERTISINGADVERTISING_PRODUCT_METRICSAdvertising metrics on a product level IMPRESSIONS
SALES
SELLER_NAME
MARKETPLACE_KEY
CHANNEL_PRODUCT_ID
SYNC_TIME
UNITS_SOLD_7D
CLICKS
SPONSORED_TYPE
UNITS_SOLD
ORDERS
PRODUCT_KEY
DATE_DAY
COSTS
* ACCOUNT_KEY

Dashboards

  • Advertising
  • Profit and Loss (with detailed advertising budget)

Enhanced Reports

  • Sponsored Products Ads Keyword Audit
  • Advertising History
  • Top-spending ASINs Advertising History
  • Sponsored Products Ads ASINs Audit
  • Sponsored Products Bidding Recommendations
  • Campaign Optimization Recommendations - Sponsored Products
  • Sales and Advertising History
  • Top-selling ASINS Sales and Advertising History

Raw Data Exports

  • Sponsored Products Ads Report - Account

Product Analysis Tools

  • Advertising