Integration Specifications

This page will help you learn about the Amazon Vendor Central integration and provide technical specifications for working with the Amazon Vendor Central source tables and Daasity data models.

The Daasity integration for Amazon Vendor Central provides daily insights into sales, traffic, and inventory at the product level ("ASIN"), and provides comprehensive analysis of product performance on Amazon.

---

Availability: all Enterprise merchants

Refresh Cadence: daily

---

Where to Find This Data

Dashboards

• Omnichannel Sales Dashboard

• Amazon Vendor Central Dashboard

Explores

• Amazon Vendor Central Sales Explore

• Amazon Vendor Central Traffic Explore

• Amazon Vendor Central Inventory Explore

For more on how to use this data and best practices - see "How to use"

---

Data Model

Entity Relationship Diagram (ERD)

The integration leverages multiple source tables that are interconnected within Daasity’s data model. The ERD for this integration illustrates how sales, traffic, and inventory data are joined by ASIN and date keys across different reports.

Click here to view the ERD for Amazon Vendor Central Integration

Source Schemas

These tables are available through the Amazon Vendor Central API, extracted daily.

• Vendor Sales Report

• Vendor Traffic Report

• Vendor Inventory Report

Vendor Sales Report

Sales, COGS, and return metrics by product ASIN and date.

• Endpoint: Vendor Retail Analytics Reports

• Update Method: UPSERT

• Table Name: [amazon_vendor_central.get_vendor_sales_report]

CSV Column	Database Column
start_date	start_date
asin	asin
distributor_view	distributor_view
customer_returns	customer_returns
end_date	end_date
ordered_revenue_amount	ordered_revenue_amount
ordered_revenue_currency_code	ordered_revenue_currency_code
ordered_units	ordered_units
report_run_date	report_run_date
selling_program	selling_program
shipped_cogs_amount	shipped_cogs_amount
shipped_cogs_currency_code	shipped_cogs_currency_code
shipped_revenue_amount	shipped_revenue_amount
shipped_revenue_currency_code	shipped_revenue_currency_code
shipped_units	shipped_units

---

Vendor Traffic Report

Consumer web traffic to product pages at the ASIN and day-level, measuring consumer interest (number of views) and the effectiveness of the product listing (conversion rate of views > transactions).

• Endpoint: Vendor Retail Analytics Reports

• Update Method: UPSERT

• Table Name: [amazon_vendor_central.get_vendor_traffic_report]

CSV Column	Database Column
start_date	start_date
asin	asin
end_date	end_date
glance_views	glance_views
report_run_date	report_run_date

---

Vendor Inventory Report

Provides inventory metrics by product and date, detailing stock levels, aging inventory, lead times, sell-through rates, and unhealthy inventory. The data is organized by ASIN and distributor view.

• Endpoint: Vendor Retail Analytics Reports

• Update Method: UPSERT

• Table Name: [amazon_vendor_central.get_vendor_inventory_report]

CSV Column	Database Column
start_date	start_date
asin	asin
distributor_view	distributor_view
selling_program	selling_program
aged_90_plus_days_sellable_inventory_cost_amount	aged_90_plus_days_sellable_inventory_cost_amount
aged_90_plus_days_sellable_inventory_cost_currency_code	aged_90_plus_days_sellable_inventory_cost_currency_code
aged_90_plus_days_sellable_inventory_units	aged_90_plus_days_sellable_inventory_units
average_vendor_lead_time_days	average_vendor_lead_time_days
end_date	end_date
net_received_inventory_cost_amount	net_received_inventory_cost_amount
net_received_inventory_cost_currency_code	net_received_inventory_cost_currency_code
net_received_inventory_units	net_received_inventory_units
open_purchase_order_units	open_purchase_order_units
procurable_product_out_of_stock_rate	procurable_product_out_of_stock_rate
report_run_date	report_run_date
sell_through_rate	sell_through_rate
sellable_on_hand_inventory_cost_amount	sellable_on_hand_inventory_cost_amount
sellable_on_hand_inventory_cost_currency_code	sellable_on_hand_inventory_cost_currency_code
sellable_on_hand_inventory_units	sellable_on_hand_inventory_units
unfilled_customer_ordered_units	unfilled_customer_ordered_units
unhealthy_inventory_cost_amount	unhealthy_inventory_cost_amount
unhealthy_inventory_cost_currency_code	unhealthy_inventory_cost_currency_code
unhealthy_inventory_units	unhealthy_inventory_units
unsellable_on_hand_inventory_cost_amount	unsellable_on_hand_inventory_cost_amount
unsellable_on_hand_inventory_cost_currency_code	unsellable_on_hand_inventory_cost_currency_code
unsellable_on_hand_inventory_units	unsellable_on_hand_inventory_units
vendor_confirmation_rate	vendor_confirmation_rate