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
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]
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]
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]
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
Last updated