Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Amazon Vendor Central data to
Amazon Vendor Central Connector Reference
49 metrics87 dimensions
The Amazon Vendor Central connector exposes 136 fields (49 metrics, 87 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available options
vendor_analytics_currency_code Currency for Vendor Analytics Data Kiosk queries
Currency code for all monetary amounts in Vendor Analytics Data Kiosk queries in ISO 4217 format.
Possible values (107)
AEDAFNALLANGARSAUDAWGAZNBAMBBDBGNBHDBMDBNDBOBBRLBSDBWPBYNBZDCADCHFCLPCNYCOPCRCCUPCZKDKKDOPEGPEURFJDFKPGBPGIPGTQGYDHKDHNLHRKHUFIDRILSINRIRRISKJMDJPYKGSKHRKPWKRWKWDKYDKZTLAKLBPLKRLRDMDLMKDMNTMURMXNMYRMZNNADNGNNIONOKNPRNZDOMRPABPENPHPPKRPLNPYGQARRONRSDRUBSARSBDSCRSEKSGDSHPSOSSRDSVCSYPTHBTRYTTDTWDUAHUSDdefaultUYUUZSVEFVNDXCDYERZAR
vendor_analytics_distributor_view Distributor View for Vendor Analytics Data Kiosk Queries
Distributor View to use for Vendor Analytics Data Kiosk Queries.
Possible values (2)
SOURCINGdefaultMANUFACTURING
vendor_sales_distributor_view Distributor View for Vendor Sales Report
Distributor View to use for Vendor Sales Report. By default SOURCING is used unless any of those fields are requested: orderedRevenue-amount (get_vendor_sales_report), orderedRevenue-currencyCode (get_vendor_sales_report), orderedUnits (get_vendor_sales_report). In this case used Distributor View is MANUFACTURING. More details here: https://developer-docs.amazon.com/sp-api/docs/vendor-reports-faq#what-is-the-difference-between-distributorview-manufacturing-and-distributorview-sourcing
Possible values (3)
defaultdefaultSOURCINGMANUFACTURING
vendor_sales_selling_program Selling Program for Vendor Sales Report
Selling Program to use for Vendor Sales Report. By default RETAIL is used. Before using any other option, make sure the account is enrolled with the Program, especially for FRESH.
Possible values (4)
defaultdefaultRETAILBUSINESSFRESH
vendor_forecasting_selling_program Selling Program for Vendor Forecasting Report
Selling Program to use for Vendor Forecasting Report. By default RETAIL is used. Before using any other option, make sure the account is enrolled with the Program.
Possible values (3)
defaultdefaultRETAILFRESH
vendor_inventory_selling_program Selling Program for Vendor Inventory Report
Selling Program to use for Vendor Inventory Report. By default RETAIL is used. Before using any other option, make sure the account is enrolled with the Program.
Possible values (3)
defaultdefaultRETAILFRESH
Amazon Vendor Central Fields
Amazon Vendor Central geo_sales fields
The geo_sales report of the Amazon Vendor Central connector includes 40 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| geo_sales__asin | TEXT | ASIN (Geo Sales) | Amazon Standard Identification Number, used to uniquely identify products in Amazon's catalog. |
| geo_sales__average_sales_discount__amount | NUMERIC | Average Sales Discount Amount (Geo Sales) | The average selling discount per unit of shipped items. The average sales discount is equal to the sales discount divided by the shipped quantity. |
| geo_sales__average_sales_discount__currency_code | TEXT | Average Sales Discount Currency Code (Geo Sales) | Currency code of the average selling discount per unit of shipped items. The average sales discount is equal to the sales discount divided by the shipped quantity. |
| geo_sales__average_selling_price__amount | NUMERIC | Average Selling Price Amount (Geo Sales) | The average selling price of shipped items, excluding sales tax or value-added taxes. This is calculated by dividing revenue by the number of shipped units. |
| geo_sales__average_selling_price__currency_code | TEXT | Average Selling Price Currency Code (Geo Sales) | Currency code of the price the average selling price of shipped items, excluding sales tax or value-added taxes. This is calculated by dividing revenue by the number of shipped units. |
| geo_sales__binding | TEXT | Binding (Geo Sales) | The format or type of the item, such as Hardcover, T-Shirt, or DVD-Audio. |
| geo_sales__brand | TEXT | Brand (Geo Sales) | Brand name. |
| geo_sales__brand_code | TEXT | Brand Code (Geo Sales) | Amazon brand code for the owning brand. |
| geo_sales__color | TEXT | Color (Geo Sales) | The color of the item, such as Red, Navy Blue, Pink, or Green. |
| geo_sales__contra_cogs__amount | NUMERIC | Contra COGS Amount (Geo Sales) | The total Contra Cost of Goods Sold (COGS), equal to the dollars realized by customer outbound shipments minus Display Ads Contra COGS. |
| geo_sales__contra_cogs__currency_code | TEXT | Contra COGS Currency Code (Geo Sales) | Currency code of the total Contra Cost of Goods Sold (COGS), equal to the dollars realized by customer outbound shipments minus Display Ads Contra COGS. |
| geo_sales__contra_cogs_per_unit__amount | NUMERIC | Contra COGS per Unit Amount (Geo Sales) | The average Vendor Funded Contra-COGS (VFCC) of shipped items. Contra-COGS per unit is equal to Contra-COGS divided by the shipped quantity. |
| geo_sales__contra_cogs_per_unit__currency_code | TEXT | Contra COGS per Unit Currency Code (Geo Sales) | Currency code of the average Vendor Funded Contra-COGS (VFCC) of shipped items. Contra-COGS per unit is equal to Contra-COGS divided by the shipped quantity. |
| geo_sales__ean | TEXT | EAN (Geo Sales) | European Article Number. A 13-digit product identifier, often represented on products as a barcode. |
| geo_sales__isbn13 | TEXT | ISBN13 (Geo Sales) | 13-digit International Standard Book Number. |
| geo_sales__manufacturer_code | TEXT | Manufacturer Code (Geo Sales) | Code used to identify the manufacturer, an entity who makes the products that are sold on Amazon. Only available with the manufacturing distributor view. |
| geo_sales__model_number | TEXT | Model Number (Geo Sales) | The model or style number of the product. |
| geo_sales__msrp__amount | NUMERIC | MSRP Amount (Geo Sales) | The manufacturer's suggested retail price (MSRP) of the item. Also known as the list price. |
| geo_sales__msrp__currency_code | TEXT | MSRP Currency Code (Geo Sales) | Currency code of the manufacturer's suggested retail price (MSRP) in ISO 4217 format. |
| geo_sales__net_ppm | NUMERIC | Net PPM (Geo Sales) | Net Pure Product Margin (PPM) is defined as Amazon's margin after taking into account CCOGs and sales discounts. Net PPM = (Shipped Revenue - Shipped CCOGS - Sales Discount) / Shipped Revenue. |
| geo_sales__parent_asin | TEXT | Parent ASIN (Geo Sales) | Products with variations (size, color, etc.) have a Parent ASIN and Child ASINs. The Parent ASIN represents the generic overall product (non-purchasable). |
| geo_sales__prep_instructions | TEXT | Prep Instructions (Geo Sales) | Which type of prep instructions are required, e.g., ASIN stickering, Boxing, Bubble wrapping, Shrinkwrap, Cap Sealing. |
| geo_sales__prep_instructions_performed_by | TEXT | Prep Instructions Performed By (Geo Sales) | Differentiates if the prep instructions required will be performed by Amazon or the vendor. |
| geo_sales__product_group | TEXT | Product Group (Geo Sales) | The product group which describes the business group, as defined by the Amazon catalog, e.g., PC, Wireless, Major Appliances. |
| geo_sales__product_title | TEXT | Product Title (Geo Sales) | Product name. |
| geo_sales__release_date | DATE | Release Date (Geo Sales) | The day that an item is available for purchase by the public. |
| geo_sales__replenishment_category | TEXT | Replenishment Category (Geo Sales) | Availability status for the ASIN. |
| geo_sales__sales_discount__amount | NUMERIC | Sales Discount Amount (Geo Sales) | Sales Discount is a transactional component of CP (Contribution Profit Amount) related to promotional activities that Amazon conducts at checkout, such as promotion code redemptions, giftcard promotions, employee discount, etc. |
| geo_sales__sales_discount__currency_code | TEXT | Sales Discount Currency Code (Geo Sales) | Currency code of Sales Discount, which is a transactional component of CP (Contribution Profit Amount) related to promotional activities that Amazon conducts at checkout, such as promotion code redemptions, giftcard promotions, employee discount, etc. |
| geo_sales__ship_to_city | CITY | Ship to City (Geo Sales) | Customer City for a shipment. |
| geo_sales__ship_to_country_code | COUNTRY | Ship to Country Code (Geo Sales) | Customer Country Code for a shipment in ISO 3166-1 alpha-2 format. |
| geo_sales__ship_to_state_or_province | REGION | Ship to State or Province (Geo Sales) | Customer State or Province for a shipment. |
| geo_sales__ship_to_zip_code | TEXT | Ship to Zip Code (Geo Sales) | The shipment destination's ZIP Code. |
| geo_sales__shipped_cogs__amount | NUMERIC | Shipped COGS Amount (Geo Sales) | The shipped cost of goods sold (COGS), which is the price Amazon paid to a vendor for item procurement, and is a component of contribution profit. |
| geo_sales__shipped_cogs__currency_code | TEXT | Shipped COGS Currency Code (Geo Sales) | Currency code of the shipped cost of goods sold (COGS), which is the price Amazon paid to a vendor for item procurement, and is a component of contribution profit. |
| geo_sales__shipped_units_with_revenue__amount | NUMERIC | Shipped Units Revenue Amount (Geo Sales) | The price the customer paid for the items shipped. Shipped Revenue Amount = Gross Price (the price the customer sees in the cart) * Shipped Units. |
| geo_sales__shipped_units_with_revenue__currency_code | TEXT | Shipped Units Revenue Currency Code (Geo Sales) | Currency code of the price the customer paid for the items shipped. Shipped Revenue Amount = Gross Price (the price the customer sees in the cart) * Shipped Units. |
| geo_sales__shipped_units_with_revenue__units | NUMERIC | Shipped Units Revenue Units Number (Geo Sales) | The number of items shipped and the associated gross price the customer paid for them. Shipped Revenue Amount = Gross Price (the price the customer sees in the cart) * Shipped Units. |
| geo_sales__upc | TEXT | UPC (Geo Sales) | The Universal Product Code (UPC) used for retail packaging scanning at the point of sale. |
| geo_sales__vendor_code | TEXT | Vendor Code (Geo Sales) | The hierarchy of vendor codes (parent-child relationships) for storage and retrieval of vendor item information such as cost and external IDs. |
Amazon Vendor Central get_vendor_forecasting_report fields
The get_vendor_forecasting_report report of the Amazon Vendor Central connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| vendor_forecasting_report__asin | TEXT | asin (get_vendor_forecasting_report) | asin (get_vendor_forecasting_report) |
| vendor_forecasting_report__enddate | DATE | endDate (get_vendor_forecasting_report) | endDate (get_vendor_forecasting_report) |
| vendor_forecasting_report__forecastgenerationdate | TEXT | forecastGenerationDate (get_vendor_forecasting_report) | forecastGenerationDate (get_vendor_forecasting_report) |
| vendor_forecasting_report__meanforecastunits | NUMERIC | meanForecastUnits (get_vendor_forecasting_report) | meanForecastUnits (get_vendor_forecasting_report) |
| vendor_forecasting_report__p70forecastunits | NUMERIC | p70ForecastUnits (get_vendor_forecasting_report) | p70ForecastUnits (get_vendor_forecasting_report) |
| vendor_forecasting_report__p80forecastunits | NUMERIC | p80ForecastUnits (get_vendor_forecasting_report) | p80ForecastUnits (get_vendor_forecasting_report) |
| vendor_forecasting_report__p90forecastunits | NUMERIC | p90ForecastUnits (get_vendor_forecasting_report) | p90ForecastUnits (get_vendor_forecasting_report) |
| vendor_forecasting_report__startdate | DATE | startDate (get_vendor_forecasting_report) | startDate (get_vendor_forecasting_report) |
Amazon Vendor Central get_vendor_inventory_report fields
The get_vendor_inventory_report report of the Amazon Vendor Central connector includes 26 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| vendor_inventory_report__aged90plusdayssellableinventorycost_amount | NUMERIC | aged90PlusDaysSellableInventoryCost-amount (get_vendor_inventory_report) | aged90PlusDaysSellableInventoryCost-amount (get_vendor_inventory_report) |
| vendor_inventory_report__aged90plusdayssellableinventorycost_currencycode | TEXT | aged90PlusDaysSellableInventoryCost-currencyCode (get_vendor_inventory_report) | aged90PlusDaysSellableInventoryCost-currencyCode (get_vendor_inventory_report) |
| vendor_inventory_report__aged90plusdayssellableinventoryunits | NUMERIC | aged90PlusDaysSellableInventoryUnits (get_vendor_inventory_report) | aged90PlusDaysSellableInventoryUnits (get_vendor_inventory_report) |
| vendor_inventory_report__asin | TEXT | asin (get_vendor_inventory_report) | asin (get_vendor_inventory_report) |
| vendor_inventory_report__averagevendorleadtimedays | NUMERIC | averageVendorLeadTimeDays (get_vendor_inventory_report) | averageVendorLeadTimeDays (get_vendor_inventory_report) |
| vendor_inventory_report__enddate | DATE | endDate (get_vendor_inventory_report) | endDate (get_vendor_inventory_report) |
| vendor_inventory_report__netreceivedinventorycost_amount | NUMERIC | netReceivedInventoryCost-amount (get_vendor_inventory_report) | netReceivedInventoryCost-amount (get_vendor_inventory_report) |
| vendor_inventory_report__netreceivedinventorycost_currencycode | TEXT | netReceivedInventoryCost-currencyCode (get_vendor_inventory_report) | netReceivedInventoryCost-currencyCode (get_vendor_inventory_report) |
| vendor_inventory_report__netreceivedinventoryunits | NUMERIC | netReceivedInventoryUnits (get_vendor_inventory_report) | netReceivedInventoryUnits (get_vendor_inventory_report) |
| vendor_inventory_report__openpurchaseorderunits | NUMERIC | openPurchaseOrderUnits (get_vendor_inventory_report) | openPurchaseOrderUnits (get_vendor_inventory_report) |
| vendor_inventory_report__procurableproductoutofstockrate | NUMERIC | procurableProductOutOfStockRate (get_vendor_inventory_report) | procurableProductOutOfStockRate (get_vendor_inventory_report) |
| vendor_inventory_report__receivefillrate | NUMERIC | receiveFillRate (get_vendor_inventory_report) | receiveFillRate (get_vendor_inventory_report) |
| vendor_inventory_report__sellableonhandinventorycost_amount | NUMERIC | sellableOnHandInventoryCost-amount (get_vendor_inventory_report) | sellableOnHandInventoryCost-amount (get_vendor_inventory_report) |
| vendor_inventory_report__sellableonhandinventorycost_currencycode | TEXT | sellableOnHandInventoryCost-currencyCode (get_vendor_inventory_report) | sellableOnHandInventoryCost-currencyCode (get_vendor_inventory_report) |
| vendor_inventory_report__sellableonhandinventoryunits | NUMERIC | sellableOnHandInventoryUnits (get_vendor_inventory_report) | sellableOnHandInventoryUnits (get_vendor_inventory_report) |
| vendor_inventory_report__sellthroughrate | NUMERIC | sellThroughRate (get_vendor_inventory_report) | sellThroughRate (get_vendor_inventory_report) |
| vendor_inventory_report__startdate | DATE | startDate (get_vendor_inventory_report) | startDate (get_vendor_inventory_report) |
| vendor_inventory_report__uft | NUMERIC | uft (get_vendor_inventory_report) | uft (get_vendor_inventory_report) |
| vendor_inventory_report__unfilledcustomerorderedunits | NUMERIC | unfilledCustomerOrderedUnits (get_vendor_inventory_report) | unfilledCustomerOrderedUnits (get_vendor_inventory_report) |
| vendor_inventory_report__unhealthyinventorycost_amount | NUMERIC | unhealthyInventoryCost-amount (get_vendor_inventory_report) | unhealthyInventoryCost-amount (get_vendor_inventory_report) |
| vendor_inventory_report__unhealthyinventorycost_currencycode | TEXT | unhealthyInventoryCost-currencyCode (get_vendor_inventory_report) | unhealthyInventoryCost-currencyCode (get_vendor_inventory_report) |
| vendor_inventory_report__unhealthyinventoryunits | NUMERIC | unhealthyInventoryUnits (get_vendor_inventory_report) | unhealthyInventoryUnits (get_vendor_inventory_report) |
| vendor_inventory_report__unsellableonhandinventorycost_amount | NUMERIC | unsellableOnHandInventoryCost-amount (get_vendor_inventory_report) | unsellableOnHandInventoryCost-amount (get_vendor_inventory_report) |
| vendor_inventory_report__unsellableonhandinventorycost_currencycode | TEXT | unsellableOnHandInventoryCost-currencyCode (get_vendor_inventory_report) | unsellableOnHandInventoryCost-currencyCode (get_vendor_inventory_report) |
| vendor_inventory_report__unsellableonhandinventoryunits | NUMERIC | unsellableOnHandInventoryUnits (get_vendor_inventory_report) | unsellableOnHandInventoryUnits (get_vendor_inventory_report) |
| vendor_inventory_report__vendorconfirmationrate | NUMERIC | vendorConfirmationRate (get_vendor_inventory_report) | vendorConfirmationRate (get_vendor_inventory_report) |
Amazon Vendor Central get_vendor_net_pure_product_margin_report fields
The get_vendor_net_pure_product_margin_report report of the Amazon Vendor Central connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| vendor_net_pure_product_margin_report__asin | TEXT | asin (get_vendor_net_pure_product_margin_report) | asin (get_vendor_net_pure_product_margin_report) |
| vendor_net_pure_product_margin_report__enddate | DATE | endDate (get_vendor_net_pure_product_margin_report) | endDate (get_vendor_net_pure_product_margin_report) |
| vendor_net_pure_product_margin_report__netpureproductmargin | NUMERIC | netPureProductMargin (get_vendor_net_pure_product_margin_report) | netPureProductMargin (get_vendor_net_pure_product_margin_report) |
| vendor_net_pure_product_margin_report__startdate | DATE | startDate (get_vendor_net_pure_product_margin_report) | startDate (get_vendor_net_pure_product_margin_report) |
Amazon Vendor Central get_vendor_real_time_inventory_report fields
The get_vendor_real_time_inventory_report report of the Amazon Vendor Central connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| vendor_real_time_inventory_report__asin | TEXT | asin (get_vendor_real_time_inventory_report) | asin (get_vendor_real_time_inventory_report) |
| vendor_real_time_inventory_report__endtime | endTime (get_vendor_real_time_inventory_report) | endTime (get_vendor_real_time_inventory_report) | |
| vendor_real_time_inventory_report__highlyavailableinventory | NUMERIC | highlyAvailableInventory (get_vendor_real_time_inventory_report) | highlyAvailableInventory (get_vendor_real_time_inventory_report) |
| vendor_real_time_inventory_report__starttime | startTime (get_vendor_real_time_inventory_report) | startTime (get_vendor_real_time_inventory_report) |
Amazon Vendor Central get_vendor_real_time_sales_report fields
The get_vendor_real_time_sales_report report of the Amazon Vendor Central connector includes 5 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| vendor_real_time_sales_report__asin | TEXT | asin (get_vendor_real_time_sales_report) | asin (get_vendor_real_time_sales_report) |
| vendor_real_time_sales_report__endtime | endTime (get_vendor_real_time_sales_report) | endTime (get_vendor_real_time_sales_report) | |
| vendor_real_time_sales_report__orderedrevenue | NUMERIC | orderedRevenue (get_vendor_real_time_sales) | orderedRevenue (get_vendor_real_time_sales) |
| vendor_real_time_sales_report__orderedunits | NUMERIC | orderedUnits (get_vendor_real_time_sales_report) | orderedUnits (get_vendor_real_time_sales_report) |
| vendor_real_time_sales_report__starttime | startTime (get_vendor_real_time_sales_report) | startTime (get_vendor_real_time_sales_report) |
Amazon Vendor Central get_vendor_sales_report fields
The get_vendor_sales_report report of the Amazon Vendor Central connector includes 23 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| vendor_sales_aggregate__customerreturns | NUMERIC | customerReturns (get_vendor_sales_report salesAggregate) | customerReturns (get_vendor_sales_report salesAggregate) |
| vendor_sales_aggregate__enddate | DATE | endDate (get_vendor_sales_report salesAggregate) | endDate (get_vendor_sales_report salesAggregate) |
| vendor_sales_aggregate__orderedrevenue_amount | NUMERIC | orderedRevenue-amount (get_vendor_sales_report salesAggregate) | orderedRevenue-amount (get_vendor_sales_report salesAggregate) (Manufacturing) |
| vendor_sales_aggregate__orderedrevenue_currencycode | TEXT | orderedRevenue-currencyCode (get_vendor_sales_report salesAggregate) | orderedRevenue-currencyCode (get_vendor_sales_report salesAggregate) (Manufacturing) |
| vendor_sales_aggregate__orderedunits | NUMERIC | orderedUnits (get_vendor_sales_report salesAggregate) | orderedUnits (get_vendor_sales_report salesAggregate) (Manufacturing) |
| vendor_sales_aggregate__shippedcogs_amount | NUMERIC | shippedCogs-amount (get_vendor_sales_report salesAggregate) | shippedCogs-amount (get_vendor_sales_report salesAggregate) |
| vendor_sales_aggregate__shippedcogs_currencycode | TEXT | shippedCogs-currencyCode (get_vendor_sales_report salesAggregate) | shippedCogs-currencyCode (get_vendor_sales_report salesAggregate) |
| vendor_sales_aggregate__shippedrevenue_amount | NUMERIC | shippedRevenue-amount (get_vendor_sales_report salesAggregate) | shippedRevenue-amount (get_vendor_sales_report salesAggregate) |
| vendor_sales_aggregate__shippedrevenue_currencycode | TEXT | shippedRevenue-currencyCode (get_vendor_sales_report salesAggregate) | shippedRevenue-currencyCode (get_vendor_sales_report salesAggregate) |
| vendor_sales_aggregate__shippedunits | NUMERIC | shippedUnits (get_vendor_sales_report salesAggregate) | shippedUnits (get_vendor_sales_report salesAggregate) |
| vendor_sales_aggregate__startdate | DATE | startDate (get_vendor_sales_report salesAggregate) | startDate (get_vendor_sales_report salesAggregate) |
| vendor_sales_report__asin | TEXT | asin (get_vendor_sales_report) | asin (get_vendor_sales_report) |
| vendor_sales_report__customerreturns | NUMERIC | customerReturns (get_vendor_sales_report) | customerReturns (get_vendor_sales_report) |
| vendor_sales_report__enddate | DATE | endDate (get_vendor_sales_report) | endDate (get_vendor_sales_report) |
| vendor_sales_report__orderedrevenue_amount | NUMERIC | orderedRevenue-amount (get_vendor_sales_report) | orderedRevenue-amount (get_vendor_sales_report) (Manufacturing) |
| vendor_sales_report__orderedrevenue_currencycode | TEXT | orderedRevenue-currencyCode (get_vendor_sales_report) | orderedRevenue-currencyCode (get_vendor_sales_report) (Manufacturing) |
| vendor_sales_report__orderedunits | NUMERIC | orderedUnits (get_vendor_sales_report) | orderedUnits (get_vendor_sales_report) (Manufacturing) |
| vendor_sales_report__shippedcogs_amount | NUMERIC | shippedCogs-amount (get_vendor_sales_report) | shippedCogs-amount (get_vendor_sales_report) |
| vendor_sales_report__shippedcogs_currencycode | TEXT | shippedCogs-currencyCode (get_vendor_sales_report) | shippedCogs-currencyCode (get_vendor_sales_report) |
| vendor_sales_report__shippedrevenue_amount | NUMERIC | shippedRevenue-amount (get_vendor_sales_report) | shippedRevenue-amount (get_vendor_sales_report) |
| vendor_sales_report__shippedrevenue_currencycode | TEXT | shippedRevenue-currencyCode (get_vendor_sales_report) | shippedRevenue-currencyCode (get_vendor_sales_report) |
| vendor_sales_report__shippedunits | NUMERIC | shippedUnits (get_vendor_sales_report) | shippedUnits (get_vendor_sales_report) |
| vendor_sales_report__startdate | DATE | startDate (get_vendor_sales_report) | startDate (get_vendor_sales_report) |
Amazon Vendor Central get_vendor_traffic_report fields
The get_vendor_traffic_report report of the Amazon Vendor Central connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| vendor_traffic_report__asin | TEXT | asin (get_vendor_traffic_report) | asin (get_vendor_traffic_report) |
| vendor_traffic_report__enddate | DATE | endDate (get_vendor_traffic_report) | endDate (get_vendor_traffic_report) |
| vendor_traffic_report__glanceviews | NUMERIC | glanceViews (get_vendor_traffic_report) | glanceViews (get_vendor_traffic_report) |
| vendor_traffic_report__startdate | DATE | startDate (get_vendor_traffic_report) | startDate (get_vendor_traffic_report) |
Amazon Vendor Central other fields
The Amazon Vendor Central connector has 22 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | The account ID | |
| account_name | TEXT | Account Name | The account name | |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date of the report | |
| day_of_month | TEXT | Day of month | Day of the month | |
| marketplace_country | COUNTRY | Marketplace Country | The Marketplace Country | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |