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 Family | By Account on Connections | By SKU on Connections | By Account on the Web App | By 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.
| Schema | Table | About | Columns |
|---|---|---|---|
| ADVERTISING | ADVERTISING_ACCOUNT_METRICS | Advertising metrics on an account level | COSTS SELLER_NAME ORDERS CLICKS ACCOUNT_KEY SALES SPONSORED_TYPE UNITS_SOLD DATE_DAY IMPRESSIONS * MARKETPLACE_KEY |
| ADVERTISING | ADVERTISING_CAMPAIGN_METRICS | Advertising 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 |
| ADVERTISING | ADVERTISING_PRODUCT_CAMPAIGN_METRICS | Advertising 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 |
| ADVERTISING | ADVERTISING_PRODUCT_METRICS | Advertising 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
Updated 8 days ago