{"sources":[{"id":"57a0cb319c10a395853afc0671579bf7ef0ff45d8a40c88ed9d2a5f61b4169a4","name":"Profit by SKU & Date","tableName":"amazon_profit_by_sku_and_date","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":"Date of the profit calculation in the local timezone of the marketplace. Each combination of marketplace, connection, child ASIN, SKU and date has a single row."},{"type":"TEXT","name":"parent_asin","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"NUMBER","name":"profit","nullable":false,"description":"Net profit calculated as total sales minus value of total_cost column."},{"type":"NUMBER","name":"total_cost","nullable":false,"description":"Total cost calculated as settlement fees plus COGS total and ad spend."},{"type":"NUMBER","name":"acos","nullable":false,"description":"Advertising Cost of Sales calculated as ad spend divided by 14-day ad sales, expressed as a percentage."},{"type":"NUMBER","name":"tacos","nullable":false,"description":"Total Advertising Cost of Sales calculated as ad spend divided by total sales, expressed as a percentage."},{"type":"NUMBER","name":"roi","nullable":false,"description":"Return on Investment calculated as profit divided by total cost, expressed as a percentage."},{"type":"NUMBER","name":"total_sales","nullable":false,"description":"Total sales from shipped order items."},{"type":"NUMBER","name":"total_units_sold","nullable":false,"description":"Total quantity sold from shipped order items."},{"type":"NUMBER","name":"total_orders","nullable":false,"description":"Distinct shipped orders this item appeared in."},{"type":"NUMBER","name":"cogs_item","nullable":false,"description":"Total item COGS from shipped order items."},{"type":"NUMBER","name":"cogs_shipping","nullable":false,"description":"Total shipping COGS from shipped order items."},{"type":"NUMBER","name":"cogs_total","nullable":false,"description":"Total COGS from shipped order items."},{"type":"NUMBER","name":"total_fees","nullable":false,"description":"Settlement fees from settlements. Presented as a negative amount."},{"type":"NUMBER","name":"total_selling_fees","nullable":false,"description":"Equal to the sum referral fee and return commission adjusted with refunded referral fee."},{"type":"NUMBER","name":"fba_fees","nullable":false,"description":"Sum of all FBA fees from Amazon settlements."},{"type":"NUMBER","name":"awd_fees","nullable":false,"description":"Sum of all AWD fees from Amazon settlements."},{"type":"NUMBER","name":"ad_spend","nullable":false,"description":"Attributed ad spend."},{"type":"NUMBER","name":"ad_sales","nullable":false,"description":"Attributed ad sales (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_orders","nullable":false,"description":"Attributed ad orders (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_units_sold","nullable":false,"description":"Attributed ad units sold (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_clicks","nullable":false,"description":"Attributed ad clicks."},{"type":"NUMBER","name":"ad_impressions","nullable":false,"description":"Attributed ad impressions."},{"type":"NUMBER","name":"buybox_percentage","nullable":false,"description":null},{"type":"NUMBER","name":"page_views","nullable":false,"description":null},{"type":"TEXT","name":"product_name","nullable":false,"description":null},{"type":"TEXT","name":"product_brand","nullable":false,"description":null},{"type":"TEXT","name":"product_category_root","nullable":false,"description":null},{"type":"TEXT","name":"product_category_node","nullable":false,"description":null},{"type":"TEXT","name":"product_image_url","nullable":false,"description":null},{"type":"TEXT","name":"product_url","nullable":false,"description":null},{"type":"TEXT","name":"currency","nullable":false,"description":null}],"userManaged":false,"isPremium":true,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Daily profit and cost breakdown per SKU and child ASIN based on shipped orders, settlements fees, COGS and ads spend. For profit and general performance analysis prefer this table over calculating manually from other tables. For ads it contains data from Sponsored Products and Sponsored Display.","fetchPeriods":[{"type":"CONTINUOUS"}],"dataAvailability":{"type":"INTRADAY","description":"Intraday updates are available when source data changes during the day.","refreshAt":"1pm"},"sources":["connections","raw_ads_api_report_advertised_products_sd","raw_ads_api_report_advertised_products_sp","raw_amazon_cogs","raw_sp_api_report_listings_data","raw_sp_api_report_orders","raw_sp_api_report_sales_and_traffic","raw_sp_api_report_settlements","refined_products_by_child_asin"],"containsPii":false},{"id":"b24cd69c061d107e5d5897d6fd06f95cd0432b3ed51b04b4ad8207e601da964c","name":"Profit by Date","tableName":"amazon_profit_by_date","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"currency","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":"Date of the profit calculation in the local timezone of the marketplace. Each combination of marketplace, connection, child ASIN, SKU and date has a single row."},{"type":"NUMBER","name":"total_sales","nullable":false,"description":"Total sales from shipped order items."},{"type":"NUMBER","name":"total_units_sold","nullable":false,"description":"Total quantity sold from shipped order items."},{"type":"NUMBER","name":"total_orders","nullable":false,"description":"Distinct shipped orders this item appeared in."},{"type":"NUMBER","name":"cogs_item","nullable":false,"description":"Total item COGS from shipped order items."},{"type":"NUMBER","name":"cogs_shipping","nullable":false,"description":"Total shipping COGS from shipped order items."},{"type":"NUMBER","name":"cogs_total","nullable":false,"description":"Total COGS from shipped order items."},{"type":"NUMBER","name":"total_fees","nullable":false,"description":"Settlement fees from settlements. Presented as a negative amount."},{"type":"NUMBER","name":"total_selling_fees","nullable":false,"description":"Equal to the sum referral fee and return commission adjusted with refunded referral fee."},{"type":"NUMBER","name":"fba_fees","nullable":false,"description":"Sum of all FBA fees from Amazon settlements."},{"type":"NUMBER","name":"awd_fees","nullable":false,"description":"Sum of all AWD fees from Amazon settlements."},{"type":"NUMBER","name":"ad_spend","nullable":false,"description":"Attributed ad spend."},{"type":"NUMBER","name":"ad_sales","nullable":false,"description":"Attributed ad sales (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_orders","nullable":false,"description":"Attributed ad orders (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_units_sold","nullable":false,"description":"Attributed ad units sold (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_clicks","nullable":false,"description":"Attributed ad clicks."},{"type":"NUMBER","name":"ad_impressions","nullable":false,"description":"Attributed ad impressions."},{"type":"NUMBER","name":"buybox_percentage","nullable":false,"description":null},{"type":"NUMBER","name":"page_views","nullable":false,"description":null},{"type":"NUMBER","name":"profit","nullable":false,"description":"Net profit calculated as total sales minus value of total_cost column."},{"type":"NUMBER","name":"total_cost","nullable":false,"description":"Total cost calculated as settlement fees plus COGS total and ad spend."},{"type":"NUMBER","name":"acos","nullable":false,"description":"Advertising Cost of Sales calculated as ad spend divided by 14-day ad sales, expressed as a percentage."},{"type":"NUMBER","name":"tacos","nullable":false,"description":"Total Advertising Cost of Sales calculated as ad spend divided by total sales, expressed as a percentage."},{"type":"NUMBER","name":"roi","nullable":false,"description":"Return on Investment calculated as profit divided by total cost, expressed as a percentage."}],"userManaged":false,"isPremium":true,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Daily profit and cost breakdown per day based on shipped orders, settlements fees, COGS and ads spend. For profit and general performance analysis prefer this table over calculating manually from other tables. For ads it contains data from all campaign types.","fetchPeriods":[{"type":"CONTINUOUS"}],"dataAvailability":{"type":"INTRADAY","description":"Intraday updates are available when source data changes during the day.","refreshAt":"1pm"},"sources":["connections","raw_ads_api_report_campaign_sd","raw_ads_api_report_campaign_sp","raw_ads_api_report_gross_and_invalid_traffic_sb","raw_ads_api_report_gross_and_invalid_traffic_sd","raw_ads_api_report_gross_and_invalid_traffic_sp","raw_ads_api_report_legacy_campaign_sb_all","raw_amazon_cogs","raw_sp_api_report_listings_data","raw_sp_api_report_orders","raw_sp_api_report_sales_and_traffic","raw_sp_api_report_settlements","refined_products_by_child_asin"],"containsPii":false},{"id":"401ffcd7e50c1ea9a18cacf221ddf99858db20a0f31eff65fc22a8e8140c7e1b","name":"Sales & Traffic by ASIN & Date","tableName":"amazon_sales_and_traffic_with_cogs","type":"SELLER_CENTRAL","columns":[{"type":"DATE","name":"date","nullable":false,"description":"Single date may occur multiple times."},{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"parent_asin","nullable":false,"description":null},{"type":"TEXT","name":"product_name","nullable":false,"description":null},{"type":"NUMBER","name":"buybox_percentage","nullable":false,"description":null},{"type":"NUMBER","name":"units_session_percentage","nullable":false,"description":null},{"type":"NUMBER","name":"page_views","nullable":false,"description":null},{"type":"NUMBER","name":"browser_page_views","nullable":false,"description":null},{"type":"NUMBER","name":"mobile_session","nullable":false,"description":null},{"type":"NUMBER","name":"mobile_page_views","nullable":false,"description":null},{"type":"NUMBER","name":"session","nullable":false,"description":null},{"type":"NUMBER","name":"browser_session","nullable":false,"description":null},{"type":"NUMBER","name":"total_sales","nullable":false,"description":null},{"type":"NUMBER","name":"total_units","nullable":false,"description":null},{"type":"NUMBER","name":"total_orders","nullable":false,"description":null},{"type":"NUMBER","name":"shipped_product_sales","nullable":false,"description":"Shipped product sales from the Sales and Traffic report."},{"type":"NUMBER","name":"shipped_product_sales_b2b","nullable":false,"description":"B2B shipped product sales from the Sales and Traffic report."},{"type":"NUMBER","name":"units_shipped","nullable":false,"description":"Units shipped from the Sales and Traffic report."},{"type":"NUMBER","name":"units_shipped_b2b","nullable":false,"description":"B2B units shipped from the Sales and Traffic report."},{"type":"NUMBER","name":"orders_shipped","nullable":false,"description":"Orders shipped from the Sales and Traffic report."},{"type":"NUMBER","name":"orders_shipped_b2b","nullable":false,"description":"B2B orders shipped from the Sales and Traffic report."},{"type":"NUMBER","name":"units_refunded","nullable":false,"description":"Units refunded from the Sales and Traffic report."},{"type":"NUMBER","name":"units_refunded_b2b","nullable":false,"description":"B2B units refunded from the Sales and Traffic report."},{"type":"NUMBER","name":"refund_rate","nullable":false,"description":"Refund rate from the Sales and Traffic report."},{"type":"NUMBER","name":"refund_rate_b2b","nullable":false,"description":"B2B refund rate from the Sales and Traffic report."},{"type":"NUMBER","name":"cogs_item_value","nullable":true,"description":"Total item cost of goods sold for items sold on this date."},{"type":"NUMBER","name":"cogs_shipping_value","nullable":true,"description":"Total shipping cost for items sold on this date."},{"type":"NUMBER","name":"cogs_total_value","nullable":true,"description":"Sum of cogs_item_value and cogs_shipping_value."},{"type":"TEXT","name":"cogs_currency","nullable":true,"description":"Currency code for COGS."},{"type":"TEXT","name":"item_supplier_name","nullable":true,"description":"Supplier name for the item COGS, if provided in COGS upload."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Sales and traffic metrics per child ASIN and date. This table is preffered for long time period analysis as this data may be delayed for up to 4 days. If you do not explicitly need data from this table use the `amazon_order_items_with_cogs` table instead.","fetchPeriods":[{"type":"INITIAL","numberOfDays":60},{"type":"RECURRING_DAILY","numberOfDays":4},{"type":"RECURRING_MONTHLY","numberOfDays":30,"shiftDays":4}],"sources":["connections","raw_amazon_cogs","raw_sp_api_report_sales_and_traffic","refined_products_by_child_asin"],"containsPii":false},{"id":"89b27535d27c2a94db5ae39af4717f542624ff4df7802fd633e16c78674a1778","name":"Order Line Items","tableName":"amazon_order_items_with_cogs","type":"SELLER_CENTRAL","columns":[{"type":"DATE","name":"date","nullable":false,"description":"Date of the purchase in the local timezone of the marketplace."},{"type":"DATE","name":"order_purchased_at_utc","nullable":false,"description":"Date and time of purchase in UTC timezone. May be different than the timezone of the marketplace or of the user."},{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_order_id","nullable":false,"description":null},{"type":"TEXT","name":"amazon_order_item_id","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":"May be null for orders placed in the last 4h."},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"product_name","nullable":false,"description":null},{"type":"NUMBER","name":"line_item_number","nullable":false,"description":null},{"type":"TEXT","name":"merchant_order_id","nullable":false,"description":null},{"type":"DATE","name":"amazon_order_updated_at","nullable":false,"description":null},{"type":"TEXT","name":"amazon_order_status","nullable":false,"description":"Pending/Shipped/Cancelled"},{"type":"TEXT","name":"fulfillment_channel","nullable":false,"description":"'Amazon' or 'Merchant'"},{"type":"TEXT","name":"amazon_order_channel","nullable":false,"description":"'MOBILEAPP', 'WEBSITE' or 'OTHER'"},{"type":"TEXT","name":"ship_service_level","nullable":false,"description":null},{"type":"TEXT","name":"item_status","nullable":true,"description":"Unshipped/Shipping/Shipped/Canceled; may be null for orders placed in the last 4h, for such orders amazon_order_status has current status"},{"type":"NUMBER","name":"quantity","nullable":false,"description":null},{"type":"NUMBER","name":"item_price_value","nullable":false,"description":"Total value of this line item. Use ONLY this column to calculate order value."},{"type":"TEXT","name":"item_price_currency","nullable":false,"description":"Currency code."},{"type":"NUMBER","name":"item_tax_value","nullable":true,"description":"Positive number or zero."},{"type":"NUMBER","name":"gift_wrap_price_value","nullable":true,"description":null},{"type":"NUMBER","name":"gift_wrap_tax_value","nullable":true,"description":null},{"type":"TEXT","name":"address_city","nullable":false,"description":null},{"type":"TEXT","name":"address_state","nullable":false,"description":null},{"type":"TEXT","name":"address_country","nullable":false,"description":null},{"type":"TEXT","name":"address_postal_code","nullable":false,"description":null},{"type":"LOGIC","name":"order_is_business","nullable":false,"description":null},{"type":"TEXT","name":"purchase_order_number","nullable":false,"description":null},{"type":"NUMBER","name":"cogs_item_value","nullable":true,"description":"Total item cost of goods sold for this order item."},{"type":"NUMBER","name":"cogs_shipping_value","nullable":true,"description":"Total shipping cost for items sold for this order item."},{"type":"NUMBER","name":"cogs_total_value","nullable":true,"description":"Sum of cogs_item_value and cogs_shipping_value."},{"type":"TEXT","name":"cogs_currency","nullable":true,"description":"Currency code for COGS."},{"type":"TEXT","name":"item_supplier_name","nullable":true,"description":"Supplier name for the item COGS, if provided in COGS upload."},{"type":"DATE","name":"order_date","nullable":false,"description":"Duplicate of date column. Prefer to use date column for date filtering."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Log of all orders per order id and order item. Aggregate this table to get order level data and sales per product or date.","fetchPeriods":[{"type":"INITIAL","numberOfDays":730},{"type":"RECURRING_DAILY","numberOfDays":28}],"dataAvailability":{"type":"REAL_TIME","description":"Orders are available up to 1 hour after being placed.","refreshAt":"10am, 1pm, 4pm, 7pm"},"sources":["connections","raw_amazon_cogs","raw_sp_api_report_orders"],"containsPii":false},{"id":"6ea445cdc459f9fbb9517c5c009384da60ef31a1e70d4de9187ea3d4c28535c4","name":"Listings (Raw JSON)","tableName":"amazon_listings_raw","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"parent_asin","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"amazon_product_type","nullable":false,"description":null},{"type":"TEXT","name":"product_type","nullable":false,"description":null},{"type":"JSON","name":"summaries","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"attributes","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"classifications","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"dimensions","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"identifiers","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"images","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"sales_ranks","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"offers","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"fulfillment_availability","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"issues","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"relationships","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"DATE","name":"last_seen_at","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Raw listings payload per SKU and marketplace. Recommended for advanced use cases. For most use cases, use the \"amazon_listings_with_cogs\" table instead. For AI agents: each row from this table has a lot of data, consider downloading it to file and not directly to the context.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","raw_sp_api_listings_items","refined_products_by_child_asin"],"containsPii":false},{"id":"ba689c05d7f7cee1a1690990c28995680a0654b7ed258230f4173d61bbcd1ab3","name":"Listings","tableName":"amazon_listings_with_cogs","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"listing_id","nullable":false,"description":"Unique identifier for the listing, not the SKU."},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"fnsku","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"listing_condition","nullable":false,"description":"Condition enum values."},{"type":"TEXT","name":"listing_name","nullable":false,"description":null},{"type":"NUMBER","name":"listing_price_value","nullable":false,"description":null},{"type":"NUMBER","name":"listing_estimated_per_item_referral_fee","nullable":true,"description":"Estimated referral fee per item."},{"type":"TEXT","name":"listing_price_currency","nullable":false,"description":"Currency code."},{"type":"NUMBER","name":"listing_current_quantity","nullable":false,"description":null},{"type":"NUMBER","name":"listing_pending_quantity","nullable":false,"description":null},{"type":"NUMBER","name":"fba_quantity_available","nullable":false,"description":null},{"type":"NUMBER","name":"fba_quantity_pending_removal","nullable":false,"description":null},{"type":"NUMBER","name":"fba_quantity_inbound","nullable":false,"description":null},{"type":"NUMBER","name":"fba_quantity_reserved","nullable":false,"description":null},{"type":"NUMBER","name":"awd_total_inbound_quantity","nullable":true,"description":null},{"type":"NUMBER","name":"awd_total_onhand_quantity","nullable":true,"description":null},{"type":"NUMBER","name":"awd_available_distributable_quantity","nullable":true,"description":null},{"type":"NUMBER","name":"awd_replenishment_quantity","nullable":true,"description":null},{"type":"NUMBER","name":"awd_reserved_distributable_quantity","nullable":true,"description":null},{"type":"DATE","name":"awd_next_expiration_at","nullable":true,"description":"Earliest known expiration timestamp for this SKU in AWD. Additional expirations can exist."},{"type":"NUMBER","name":"awd_next_expiration_quantity","nullable":true,"description":"On-hand quantity associated with the earliest known expiration in AWD. Additional expirations can exist."},{"type":"JSON","name":"awd_expirations","nullable":true,"description":"All expiration buckets for this SKU in AWD. Available only in direct BigQuery integration.","bigQueryOnly":true},{"type":"TEXT","name":"listing_fulfillment_channel","nullable":false,"description":"Enum of: DEFAULT / AMAZON_NA / AMAZON_EU / (null). DEFAULT means FBM, other means FBA."},{"type":"DATE","name":"listing_open_date","nullable":false,"description":null},{"type":"TEXT","name":"listing_status","nullable":false,"description":"Active / Inactive / Incomplete"},{"type":"NUMBER","name":"cogs_item_value","nullable":true,"description":"Current cost of goods sold for the item."},{"type":"NUMBER","name":"cogs_shipping_value","nullable":true,"description":"Current shipping cost for the item."},{"type":"NUMBER","name":"cogs_total_value","nullable":true,"description":"Sum of cogs_item_value and cogs_shipping_value."},{"type":"TEXT","name":"cogs_currency","nullable":true,"description":"Currency code for COGS."},{"type":"TEXT","name":"item_current_supplier_name","nullable":true,"description":"Current supplier name for the item COGS, if provided in COGS upload. Reflects the latest COGS row for the listing, not a date-effective value."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Data about own listings.","fetchPeriods":[{"type":"CONTINUOUS"}],"dataAvailability":{"type":"INTRADAY","description":"Intraday updates are available when source data changes during the day.","refreshAt":"1pm"},"sources":["connections","raw_amazon_cogs","raw_sp_api_awd_inventory","raw_sp_api_report_fba_inventory_planning","raw_sp_api_report_listings_data","raw_sp_api_report_referral_fee_preview"],"containsPii":false},{"id":"d190d57b0176fb9854685bb58b4cb2ef782c03000eec9d33d773721f74bf8dba","name":"AWD Inbound Shipments","tableName":"amazon_awd_inbound_shipments","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"awd_inbound_shipment_id","nullable":false,"description":null},{"type":"TEXT","name":"awd_inbound_order_id","nullable":true,"description":null},{"type":"TEXT","name":"external_reference_id","nullable":true,"description":null},{"type":"TEXT","name":"awd_inbound_shipment_status","nullable":true,"description":null},{"type":"TEXT","name":"carrier_code_type","nullable":true,"description":null},{"type":"TEXT","name":"carrier_code_value","nullable":true,"description":null},{"type":"TEXT","name":"awd_inbound_shipment_tracking_id","nullable":true,"description":null},{"type":"DATE","name":"ship_by","nullable":true,"description":null},{"type":"TEXT","name":"destination_region","nullable":true,"description":null},{"type":"TEXT","name":"warehouse_reference_id","nullable":true,"description":null},{"type":"JSON","name":"shipment_container_quantities","nullable":true,"description":null},{"type":"JSON","name":"received_quantity","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_name","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_address_line1","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_address_line2","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_address_line3","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_city","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_county","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_district","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_state_or_region","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_postal_code","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_country_code","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_phone_number","nullable":true,"description":null},{"type":"TEXT","name":"origin_address_name","nullable":true,"description":null},{"type":"TEXT","name":"origin_address_address_line1","nullable":true,"description":null},{"type":"TEXT","name":"origin_address_address_line2","nullable":true,"description":null},{"type":"TEXT","name":"origin_address_address_line3","nullable":true,"description":null},{"type":"TEXT","name":"origin_address_city","nullable":true,"description":null},{"type":"TEXT","name":"origin_address_county","nullable":true,"description":null},{"type":"TEXT","name":"origin_address_district","nullable":true,"description":null},{"type":"TEXT","name":"origin_address_state_or_region","nullable":true,"description":null},{"type":"TEXT","name":"origin_address_postal_code","nullable":true,"description":null},{"type":"TEXT","name":"origin_address_country_code","nullable":true,"description":null},{"type":"TEXT","name":"origin_address_phone_number","nullable":true,"description":null},{"type":"DATE","name":"created_at","nullable":true,"description":null},{"type":"DATE","name":"updated_at","nullable":true,"description":null},{"type":"DATE","name":"last_seen_at","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":"Date the shipment was created."}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"AWD inbound shipments by shipment id.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","raw_sp_api_awd_inbound_shipments"],"containsPii":false},{"id":"18bbce497127e8eecc6ab435fdbcaa72cf6dd66b313517749f4d33c0ad0169b1","name":"Replenishment Metrics by Date","tableName":"amazon_replenishment_metrics_by_date","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"DATE","name":"period_start_date","nullable":false,"description":null},{"type":"DATE","name":"period_end_date","nullable":false,"description":null},{"type":"TEXT","name":"amazon_replenishment_program_type","nullable":false,"description":"Always SUBSCRIBE_AND_SAVE."},{"type":"TEXT","name":"amazon_replenishment_time_period_type","nullable":false,"description":"Always PERFORMANCE."},{"type":"TEXT","name":"amazon_replenishment_aggregation_frequency","nullable":false,"description":"Always DAY."},{"type":"TEXT","name":"currency_code","nullable":false,"description":null},{"type":"DATE","name":"last_seen_at","nullable":false,"description":null},{"type":"NUMBER","name":"not_delivered_due_to_oos","nullable":false,"description":null},{"type":"NUMBER","name":"total_subscriptions_revenue","nullable":false,"description":null},{"type":"NUMBER","name":"shipped_subscription_units","nullable":false,"description":null},{"type":"NUMBER","name":"active_subscriptions","nullable":false,"description":null},{"type":"NUMBER","name":"subscriber_average_revenue","nullable":false,"description":null},{"type":"NUMBER","name":"non_subscriber_average_revenue","nullable":false,"description":null},{"type":"NUMBER","name":"lost_revenue_due_to_oos","nullable":false,"description":null},{"type":"NUMBER","name":"subscriber_average_reorders","nullable":false,"description":null},{"type":"NUMBER","name":"non_subscriber_average_reorders","nullable":false,"description":null},{"type":"NUMBER","name":"coupons_revenue_penetration","nullable":false,"description":null},{"type":"NUMBER","name":"revenue_from_subscriptions_with_multiple_deliveries","nullable":false,"description":null},{"type":"NUMBER","name":"revenue_from_active_subscriptions_with_single_delivery","nullable":false,"description":null},{"type":"NUMBER","name":"revenue_from_cancelled_subscriptions_after_single_delivery","nullable":false,"description":null},{"type":"NUMBER","name":"subscriber_retention_for_30_days","nullable":false,"description":null},{"type":"NUMBER","name":"subscriber_retention_for_90_days","nullable":false,"description":null},{"type":"NUMBER","name":"revenue_penetration_for_0_percent_seller_funding","nullable":false,"description":null},{"type":"NUMBER","name":"revenue_penetration_for_5_percent_seller_funding","nullable":false,"description":null},{"type":"NUMBER","name":"revenue_penetration_for_10_percent_seller_funding","nullable":false,"description":null},{"type":"NUMBER","name":"revenue_penetration_for_5_plus_percent_seller_funding","nullable":false,"description":null},{"type":"NUMBER","name":"share_of_coupon_subscriptions","nullable":false,"description":null},{"type":"NUMBER","name":"non_subscriber_lifetime_value_from_otp","nullable":false,"description":null},{"type":"NUMBER","name":"lost_subscriber_lifetime_value_from_otp","nullable":false,"description":null},{"type":"NUMBER","name":"lost_subscriber_lifetime_value_from_sns","nullable":false,"description":null},{"type":"NUMBER","name":"growing_subscriber_lifetime_value_from_otp","nullable":false,"description":null},{"type":"NUMBER","name":"growing_subscriber_lifetime_value_from_sns","nullable":false,"description":null},{"type":"NUMBER","name":"established_subscriber_lifetime_value_from_otp","nullable":false,"description":null},{"type":"NUMBER","name":"established_subscriber_lifetime_value_from_sns","nullable":false,"description":null},{"type":"NUMBER","name":"signup_conversion_for_0_percent_seller_funding","nullable":false,"description":null},{"type":"NUMBER","name":"signup_conversion_for_5_percent_seller_funding","nullable":false,"description":null},{"type":"NUMBER","name":"signup_conversion_for_10_percent_seller_funding","nullable":false,"description":null},{"type":"NUMBER","name":"signup_conversion_for_5_plus_percent_seller_funding","nullable":false,"description":null},{"type":"NUMBER","name":"revenue_penetration","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Amazon Subscribe & Save replenishment performance metrics aggregated by date.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","raw_sp_api_replenishment_metrics_by_date"],"containsPii":false},{"id":"e00006360d84f9b881db981cb543cef7226448931a82d9641d88562edeafb214","name":"Replenishment Metrics by SKU & Date","tableName":"amazon_replenishment_metrics_by_sku_and_date","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"DATE","name":"period_start_date","nullable":false,"description":null},{"type":"DATE","name":"period_end_date","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"amazon_replenishment_program_type","nullable":false,"description":"Always SUBSCRIBE_AND_SAVE."},{"type":"TEXT","name":"amazon_replenishment_time_period_type","nullable":false,"description":"Always PERFORMANCE."},{"type":"TEXT","name":"amazon_replenishment_aggregation_frequency","nullable":false,"description":"Always DAY."},{"type":"TEXT","name":"amazon_replenishment_fulfillment_channel_type","nullable":false,"description":null},{"type":"TEXT","name":"currency_code","nullable":false,"description":null},{"type":"DATE","name":"last_seen_at","nullable":false,"description":null},{"type":"NUMBER","name":"not_delivered_due_to_oos","nullable":false,"description":null},{"type":"NUMBER","name":"total_subscriptions_revenue","nullable":false,"description":null},{"type":"NUMBER","name":"shipped_subscription_units","nullable":false,"description":null},{"type":"NUMBER","name":"active_subscriptions","nullable":false,"description":null},{"type":"NUMBER","name":"revenue_penetration","nullable":false,"description":null},{"type":"NUMBER","name":"lost_revenue_due_to_oos","nullable":false,"description":null},{"type":"NUMBER","name":"coupons_revenue_penetration","nullable":false,"description":null},{"type":"NUMBER","name":"share_of_coupon_subscriptions","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Amazon Subscribe & Save replenishment performance metrics aggregated by SKU and date.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","raw_sp_api_replenishment_metrics_by_sku_and_date"],"containsPii":false},{"id":"7290b1c5846a68e57a8841eb300452dd1902c591770b99f8164af5de3fa70dfc","name":"Replenishment Offers","tableName":"amazon_replenishment_offers","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"amazon_replenishment_program_type","nullable":false,"description":"Always SUBSCRIBE_AND_SAVE."},{"type":"TEXT","name":"amazon_replenishment_program_eligibility","nullable":false,"description":null},{"type":"TEXT","name":"amazon_replenishment_fulfillment_network_id_type","nullable":false,"description":null},{"type":"NUMBER","name":"price","nullable":false,"description":null},{"type":"TEXT","name":"price_currency_code","nullable":false,"description":null},{"type":"JSON","name":"inventory","nullable":true,"description":null},{"type":"JSON","name":"subscriptions","nullable":true,"description":null},{"type":"TEXT","name":"stock_risk","nullable":true,"description":null},{"type":"JSON","name":"vendor_codes","nullable":true,"description":null},{"type":"JSON","name":"offer_program_configuration","nullable":true,"description":null},{"type":"JSON","name":"deliveries_conditions","nullable":true,"description":null},{"type":"JSON","name":"forecast_deliveries","nullable":true,"description":null},{"type":"DATE","name":"last_seen_at","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Amazon Subscribe & Save replenishment offer eligibility, configuration, inventory and subscription details by SKU.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","raw_sp_api_replenishment_offers"],"containsPii":false},{"id":"b7080fc32e526ffca1cb68908342409ce533b6ffd9c4b4bc2807dc56b98ec5a7","name":"AWD Inbound Shipment Line Items","tableName":"amazon_awd_inbound_shipment_line_items","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"awd_inbound_shipment_id","nullable":false,"description":null},{"type":"NUMBER","name":"line_item_no","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":true,"description":null},{"type":"JSON","name":"expected_quantity","nullable":true,"description":null},{"type":"JSON","name":"received_quantity","nullable":true,"description":null},{"type":"JSON","name":"line_item_data","nullable":true,"description":null,"bigQueryOnly":true},{"type":"DATE","name":"last_seen_at","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":"Date the shipment line item was last seen."}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"AWD inbound shipment line items by shipment id and line item number.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","raw_sp_api_awd_inbound_shipment_line_items"],"containsPii":false},{"id":"cedb25975382c4cbae7e2d8a5a58b19b12fa947bd64218476e2b6f4d530128d2","name":"AWD Replenishment Orders","tableName":"amazon_awd_replenishment_orders","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"awd_replenishment_order_id","nullable":false,"description":null},{"type":"TEXT","name":"awd_replenishment_order_status","nullable":true,"description":null},{"type":"DATE","name":"confirmed_on","nullable":true,"description":null},{"type":"DATE","name":"created_at","nullable":true,"description":null},{"type":"DATE","name":"updated_at","nullable":true,"description":null},{"type":"JSON","name":"distribution_ineligible_reasons","nullable":true,"description":null},{"type":"JSON","name":"outbound_shipments","nullable":true,"description":null},{"type":"DATE","name":"last_seen_at","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":"Date the order was created."}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"AWD replenishment orders by order id.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","raw_sp_api_awd_replenishment_orders"],"containsPii":false},{"id":"85aeada68a63908d0ecefff13badd6dd677923b18955c53bcb9edb8d991198d3","name":"AWD Replenishment Order Line Items","tableName":"amazon_awd_replenishment_order_line_items","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"awd_replenishment_order_id","nullable":false,"description":null},{"type":"TEXT","name":"line_item_source","nullable":false,"description":null},{"type":"NUMBER","name":"line_item_no","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":true,"description":null},{"type":"NUMBER","name":"quantity","nullable":true,"description":null},{"type":"TEXT","name":"awd_replenishment_shipment_id","nullable":true,"description":null},{"type":"TEXT","name":"awd_replenishment_shipment_status","nullable":true,"description":null},{"type":"TEXT","name":"failure_code","nullable":true,"description":null},{"type":"JSON","name":"failure_reasons","nullable":true,"description":null},{"type":"JSON","name":"attributes","nullable":true,"description":null,"bigQueryOnly":true},{"type":"JSON","name":"line_item_data","nullable":true,"description":null,"bigQueryOnly":true},{"type":"DATE","name":"last_seen_at","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":"Date the order line item was last seen."}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"AWD replenishment order line items by order id and line item number.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","raw_sp_api_awd_replenishment_order_line_items"],"containsPii":false},{"id":"8bc6f4bd0931e728b80b9d18abd92bbc7dfe2aeb3c05f290c731d9fb195db3bf","name":"FBA Inbound Shipments","tableName":"amazon_fba_inbound_shipments","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"inbound_plan_id","nullable":false,"description":null},{"type":"TEXT","name":"fba_inbound_shipment_id","nullable":false,"description":null},{"type":"TEXT","name":"seller_sku","nullable":false,"description":null},{"type":"TEXT","name":"fnsku","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"NUMBER","name":"quantity","nullable":false,"description":null},{"type":"DATE","name":"expiration","nullable":true,"description":null},{"type":"TEXT","name":"label_owner","nullable":false,"description":null},{"type":"TEXT","name":"manufacturing_lot_code","nullable":true,"description":null},{"type":"JSON","name":"prep_instructions","nullable":false,"description":null},{"type":"TEXT","name":"shipment_name","nullable":true,"description":null},{"type":"TEXT","name":"fba_inbound_shipment_status","nullable":false,"description":null},{"type":"TEXT","name":"shipment_confirmation_id","nullable":true,"description":null},{"type":"TEXT","name":"amazon_reference_id","nullable":true,"description":null},{"type":"TEXT","name":"destination_warehouse_id","nullable":true,"description":null},{"type":"TEXT","name":"destination_type","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_name","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_address_line1","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_address_line2","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_city","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_company_name","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_country_code","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_district_or_county","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_email","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_phone_number","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_postal_code","nullable":true,"description":null},{"type":"TEXT","name":"destination_address_state_or_province_code","nullable":true,"description":null},{"type":"TEXT","name":"source_address_name","nullable":true,"description":null},{"type":"TEXT","name":"source_address_address_line1","nullable":true,"description":null},{"type":"TEXT","name":"source_address_address_line2","nullable":true,"description":null},{"type":"TEXT","name":"source_address_city","nullable":true,"description":null},{"type":"TEXT","name":"source_address_company_name","nullable":true,"description":null},{"type":"TEXT","name":"source_address_country_code","nullable":true,"description":null},{"type":"TEXT","name":"source_address_district_or_county","nullable":true,"description":null},{"type":"TEXT","name":"source_address_email","nullable":true,"description":null},{"type":"TEXT","name":"source_address_phone_number","nullable":true,"description":null},{"type":"TEXT","name":"source_address_postal_code","nullable":true,"description":null},{"type":"TEXT","name":"source_address_state_or_province_code","nullable":true,"description":null},{"type":"DATE","name":"ready_to_ship_window_start","nullable":true,"description":null},{"type":"DATE","name":"ready_to_ship_window_end","nullable":true,"description":null},{"type":"DATE","name":"selected_delivery_window_start","nullable":true,"description":null},{"type":"DATE","name":"selected_delivery_window_end","nullable":true,"description":null},{"type":"TEXT","name":"placement_option_id","nullable":true,"description":null},{"type":"TEXT","name":"plan_name","nullable":true,"description":null},{"type":"TEXT","name":"plan_status","nullable":true,"description":null},{"type":"DATE","name":"plan_created_at","nullable":true,"description":null},{"type":"DATE","name":"plan_last_updated_at","nullable":true,"description":null},{"type":"DATE","name":"last_seen_at","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"FBA inbound shipment line items from inbound plans with shipment status, destination and source addresses, and plan metadata.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","raw_sp_api_fba_inbound_shipments"],"containsPii":false},{"id":"705516b99d12eae4bbe684c371f9408595f6325b5e52ef3ae9c4d293d0da7dad","name":"FBA Shipments","tableName":"amazon_fba_shipments","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"shipment_item_id","nullable":false,"description":null},{"type":"TEXT","name":"amazon_order_id","nullable":false,"description":null},{"type":"TEXT","name":"merchant_order_id","nullable":true,"description":null},{"type":"TEXT","name":"shipment_id","nullable":false,"description":null},{"type":"TEXT","name":"amazon_order_item_id","nullable":false,"description":null},{"type":"TEXT","name":"merchant_order_item_id","nullable":true,"description":null},{"type":"DATE","name":"purchase_date","nullable":true,"description":null},{"type":"DATE","name":"payments_date","nullable":true,"description":null},{"type":"DATE","name":"shipment_date","nullable":true,"description":null},{"type":"DATE","name":"reporting_date","nullable":true,"description":null},{"type":"TEXT","name":"buyer_email","nullable":true,"description":null},{"type":"TEXT","name":"buyer_name","nullable":true,"description":null},{"type":"TEXT","name":"buyer_phone_number","nullable":true,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"product_name","nullable":false,"description":null},{"type":"NUMBER","name":"quantity_shipped","nullable":true,"description":null},{"type":"TEXT","name":"currency","nullable":true,"description":null},{"type":"NUMBER","name":"item_price","nullable":true,"description":null},{"type":"NUMBER","name":"item_tax","nullable":true,"description":null},{"type":"NUMBER","name":"shipping_price","nullable":true,"description":null},{"type":"NUMBER","name":"shipping_tax","nullable":true,"description":null},{"type":"NUMBER","name":"gift_wrap_price","nullable":true,"description":null},{"type":"NUMBER","name":"gift_wrap_tax","nullable":true,"description":null},{"type":"TEXT","name":"ship_service_level","nullable":true,"description":null},{"type":"TEXT","name":"recipient_name","nullable":true,"description":null},{"type":"TEXT","name":"ship_address_1","nullable":true,"description":null},{"type":"TEXT","name":"ship_address_2","nullable":true,"description":null},{"type":"TEXT","name":"ship_address_3","nullable":true,"description":null},{"type":"TEXT","name":"ship_city","nullable":true,"description":null},{"type":"TEXT","name":"ship_state","nullable":true,"description":null},{"type":"TEXT","name":"ship_postal_code","nullable":true,"description":null},{"type":"TEXT","name":"ship_country","nullable":true,"description":null},{"type":"TEXT","name":"ship_phone_number","nullable":true,"description":null},{"type":"TEXT","name":"bill_address_1","nullable":true,"description":null},{"type":"TEXT","name":"bill_address_2","nullable":true,"description":null},{"type":"TEXT","name":"bill_address_3","nullable":true,"description":null},{"type":"TEXT","name":"bill_city","nullable":true,"description":null},{"type":"TEXT","name":"bill_state","nullable":true,"description":null},{"type":"TEXT","name":"bill_postal_code","nullable":true,"description":null},{"type":"TEXT","name":"bill_country","nullable":true,"description":null},{"type":"NUMBER","name":"item_promotion_discount","nullable":true,"description":null},{"type":"NUMBER","name":"ship_promotion_discount","nullable":true,"description":null},{"type":"TEXT","name":"carrier","nullable":true,"description":null},{"type":"TEXT","name":"fba_shipment_tracking_number","nullable":true,"description":null},{"type":"DATE","name":"estimated_arrival_date","nullable":true,"description":null},{"type":"TEXT","name":"fulfillment_center_id","nullable":true,"description":null},{"type":"TEXT","name":"fulfillment_channel","nullable":true,"description":null},{"type":"TEXT","name":"sales_channel","nullable":true,"description":null}],"userManaged":false,"isPremium":true,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Amazon-fulfilled shipment line items with order, item, pricing, and shipping address details.","fetchPeriods":[{"type":"INITIAL","numberOfDays":60},{"type":"RECURRING_DAILY","numberOfDays":60}],"sources":["connections","raw_sp_api_report_afn_shipments"],"containsPii":true},{"id":"5a6dd198558a83b086709f9416ec8c7c0b3696bb5eddee008f53ab322c8082c1","name":"FBA Removal Orders","tableName":"amazon_fba_removal_orders","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"DATE","name":"request_date","nullable":true,"description":null},{"type":"TEXT","name":"fba_removal_order_id","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"fnsku","nullable":false,"description":null},{"type":"TEXT","name":"disposition","nullable":true,"description":null},{"type":"DATE","name":"last_updated_date","nullable":true,"description":null},{"type":"TEXT","name":"fba_removal_order_source","nullable":true,"description":null},{"type":"TEXT","name":"fba_removal_order_type","nullable":true,"description":null},{"type":"TEXT","name":"service_speed","nullable":true,"description":null},{"type":"TEXT","name":"fba_removal_order_status","nullable":true,"description":null},{"type":"NUMBER","name":"requested_quantity","nullable":true,"description":null},{"type":"NUMBER","name":"cancelled_quantity","nullable":true,"description":null},{"type":"NUMBER","name":"disposed_quantity","nullable":true,"description":null},{"type":"NUMBER","name":"shipped_quantity","nullable":true,"description":null},{"type":"NUMBER","name":"in_process_quantity","nullable":true,"description":null},{"type":"NUMBER","name":"removal_fee","nullable":true,"description":null},{"type":"TEXT","name":"currency","nullable":true,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"FBA removal order line items with quantities, fees, and status.","fetchPeriods":[{"type":"INITIAL","numberOfDays":730},{"type":"RECURRING_DAILY","numberOfDays":30}],"sources":["connections","raw_sp_api_report_fba_removal_orders"],"containsPii":false},{"id":"23ed787fe0ac5ce848ae049fdcea14a0dc94d74792aa62ed49afe332ea6ed19e","name":"FBA Recommended Removals","tableName":"amazon_fba_removal_recommended","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"DATE","name":"snapshot_date","nullable":true,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"fnsku","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"product_name","nullable":false,"description":null},{"type":"TEXT","name":"condition","nullable":true,"description":null},{"type":"NUMBER","name":"sellable_quantity","nullable":true,"description":null},{"type":"NUMBER","name":"sellable_121_180_days","nullable":true,"description":null},{"type":"NUMBER","name":"sellable_181_270_days","nullable":true,"description":null},{"type":"NUMBER","name":"sellable_271_365_days","nullable":true,"description":null},{"type":"NUMBER","name":"sellable_365_plus_days","nullable":true,"description":null},{"type":"NUMBER","name":"sellable_removal_quantity","nullable":true,"description":null},{"type":"NUMBER","name":"unsellable_quantity","nullable":true,"description":null},{"type":"NUMBER","name":"unsellable_0_7_days","nullable":true,"description":null},{"type":"NUMBER","name":"unsellable_8_60_days","nullable":true,"description":null},{"type":"NUMBER","name":"unsellable_61_90_days","nullable":true,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Recommended FBA removal quantities by SKU with sellable and unsellable inventory age buckets.","fetchPeriods":[{"type":"INITIAL","numberOfDays":1},{"type":"RECURRING_DAILY","numberOfDays":1}],"sources":["connections","raw_sp_api_report_fba_recommended_removal"],"containsPii":false},{"id":"fd04a82a3af4ab17ca4fb9fd36516f332366f26a385e7af6ecaa38adfb96a337","name":"FBA Removal Shipments","tableName":"amazon_fba_removal_shipments","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"fba_removal_order_id","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"fnsku","nullable":false,"description":null},{"type":"TEXT","name":"fba_removal_shipment_tracking_number","nullable":true,"description":null},{"type":"DATE","name":"shipment_date","nullable":true,"description":null},{"type":"DATE","name":"request_date","nullable":true,"description":null},{"type":"NUMBER","name":"removal_shipment_no","nullable":true,"description":null},{"type":"NUMBER","name":"shipped_quantity","nullable":true,"description":null},{"type":"TEXT","name":"carrier","nullable":true,"description":null},{"type":"TEXT","name":"removal_order_type","nullable":true,"description":null},{"type":"TEXT","name":"disposition","nullable":true,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"FBA removal shipment details linked to removal orders.","fetchPeriods":[{"type":"INITIAL","numberOfDays":730},{"type":"RECURRING_DAILY","numberOfDays":30}],"sources":["connections","raw_sp_api_report_fba_removal_shipments"],"containsPii":false},{"id":"2e123a1fcf957a35cc86a54d45a9a922a60e1bc4eda669f60f8b8da625ffce3e","name":"FBA Replacement Shipments","tableName":"amazon_fba_replacement_shipments","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"replacement_amazon_order_id","nullable":false,"description":null},{"type":"TEXT","name":"original_amazon_order_id","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"NUMBER","name":"shipment_replacement_no","nullable":true,"description":null},{"type":"DATE","name":"shipment_date","nullable":true,"description":null},{"type":"TEXT","name":"fulfillment_center_id","nullable":true,"description":null},{"type":"TEXT","name":"original_fulfillment_center_id","nullable":true,"description":null},{"type":"TEXT","name":"replacement_reason_code","nullable":true,"description":null},{"type":"NUMBER","name":"quantity","nullable":true,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"FBA replacement shipments with original and replacement order references.","fetchPeriods":[{"type":"INITIAL","numberOfDays":730},{"type":"RECURRING_DAILY","numberOfDays":30}],"sources":["connections","raw_sp_api_report_fba_shipment_replacement"],"containsPii":false},{"id":"542b4c4b4e2d6a223d2af0ce839a7666a32fb3e5338a0731610ef9658cb7935c","name":"FBA Restock Recommendations","tableName":"amazon_fba_restock_recommendations","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"country","nullable":true,"description":null},{"type":"TEXT","name":"product_name","nullable":false,"description":null},{"type":"TEXT","name":"fnsku","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"condition","nullable":true,"description":null},{"type":"TEXT","name":"supplier","nullable":true,"description":null},{"type":"TEXT","name":"supplier_part_no","nullable":true,"description":null},{"type":"TEXT","name":"currency_code","nullable":true,"description":null},{"type":"NUMBER","name":"price","nullable":true,"description":null},{"type":"NUMBER","name":"sales_last_30_days","nullable":true,"description":null},{"type":"NUMBER","name":"units_sold_last_30_days","nullable":true,"description":null},{"type":"NUMBER","name":"total_units","nullable":true,"description":null},{"type":"NUMBER","name":"inbound","nullable":true,"description":null},{"type":"NUMBER","name":"available","nullable":true,"description":null},{"type":"NUMBER","name":"fc_transfer","nullable":true,"description":null},{"type":"NUMBER","name":"fc_processing","nullable":true,"description":null},{"type":"NUMBER","name":"customer_order","nullable":true,"description":null},{"type":"NUMBER","name":"unfulfillable","nullable":true,"description":null},{"type":"NUMBER","name":"working","nullable":true,"description":null},{"type":"NUMBER","name":"shipped","nullable":true,"description":null},{"type":"NUMBER","name":"receiving","nullable":true,"description":null},{"type":"TEXT","name":"fulfilled_by","nullable":true,"description":null},{"type":"NUMBER","name":"total_days_of_supply_including_units_from_open_shipments","nullable":true,"description":null},{"type":"NUMBER","name":"days_of_supply_at_amazon_fulfillment_network","nullable":true,"description":null},{"type":"TEXT","name":"alert","nullable":true,"description":null},{"type":"NUMBER","name":"recommended_replenishment_qty","nullable":true,"description":null},{"type":"DATE","name":"recommended_ship_date","nullable":true,"description":null},{"type":"TEXT","name":"unit_storage_size","nullable":true,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"FBA restock recommendations with inventory levels, sales velocity, and replenishment guidance.","fetchPeriods":[{"type":"INITIAL","numberOfDays":1},{"type":"RECURRING_DAILY","numberOfDays":1}],"dataAvailability":{"type":"INTRADAY","description":"Intraday updates are available when source data changes during the day.","refreshAt":"1pm"},"sources":["connections","raw_sp_api_report_restock_inventory"],"containsPii":false},{"id":"2a81389e421f7abeecb076466834cc274a5d085d28697c344e901d995ca2a432","name":"FBA Inventory by ASIN & Country","tableName":"amazon_fba_inventory_by_asin_by_country","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"country_code","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"fnsku","nullable":false,"description":null},{"type":"TEXT","name":"condition_type","nullable":false,"description":"Condition enum values."},{"type":"NUMBER","name":"quantity_for_local_fulfillment","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":"Single date may occur multiple times."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Daily inventory data for all FBA listings per country.","fetchPeriods":[{"type":"RECURRING_DAILY","numberOfDays":1}],"sources":["connections","refined_amazon_fba_inventory_by_asin_by_country"],"containsPii":false},{"id":"44fc5ba0ce81a7807601f6d7a9b8b7aaec64be4c7e046ea30dc6864d1a4aa823","name":"FBA Inventory Health","tableName":"amazon_fba_inventory_health","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"fnsku","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"product_name","nullable":false,"description":null},{"type":"TEXT","name":"condition","nullable":false,"description":"New / Used / or empty"},{"type":"NUMBER","name":"available","nullable":false,"description":null},{"type":"NUMBER","name":"pending_removal_quantity","nullable":false,"description":null},{"type":"NUMBER","name":"inv_age_0_to_90_days","nullable":false,"description":null},{"type":"NUMBER","name":"inv_age_91_to_180_days","nullable":false,"description":null},{"type":"NUMBER","name":"inv_age_181_to_270_days","nullable":false,"description":null},{"type":"NUMBER","name":"inv_age_271_to_365_days","nullable":false,"description":null},{"type":"TEXT","name":"currency","nullable":false,"description":null},{"type":"NUMBER","name":"units_shipped_t7","nullable":false,"description":null},{"type":"NUMBER","name":"units_shipped_t30","nullable":false,"description":null},{"type":"NUMBER","name":"units_shipped_t60","nullable":false,"description":null},{"type":"NUMBER","name":"units_shipped_t90","nullable":false,"description":null},{"type":"TEXT","name":"alert","nullable":false,"description":null},{"type":"NUMBER","name":"your_price","nullable":false,"description":null},{"type":"NUMBER","name":"sales_price","nullable":false,"description":null},{"type":"NUMBER","name":"lowest_price_new_plus_shipping","nullable":false,"description":null},{"type":"NUMBER","name":"lowest_price_used","nullable":false,"description":null},{"type":"TEXT","name":"recommended_action","nullable":false,"description":null},{"type":"NUMBER","name":"recommended_sales_price","nullable":false,"description":null},{"type":"NUMBER","name":"recommended_sale_duration_days","nullable":false,"description":null},{"type":"NUMBER","name":"recommended_removal_quantity","nullable":false,"description":null},{"type":"NUMBER","name":"estimated_cost_savings_of_recommended_actions","nullable":false,"description":null},{"type":"NUMBER","name":"sell_through","nullable":false,"description":null},{"type":"NUMBER","name":"item_volume","nullable":false,"description":null},{"type":"TEXT","name":"volume_unit_measurement","nullable":false,"description":"cubic feet / or empty"},{"type":"TEXT","name":"storage_type","nullable":false,"description":"Other / Footwear / Apparel / Standard / or empty"},{"type":"NUMBER","name":"storage_volume","nullable":false,"description":null},{"type":"TEXT","name":"marketplace","nullable":false,"description":"Marketplace enum values."},{"type":"TEXT","name":"product_group","nullable":false,"description":"gl_home_improvement / gl_drugstore / gl_home / gl_personal_care_appliances / gl_biss / gl_beauty / gl_sports / gl_apparel / gl_pet_products / gl_office_product / gl_kitchen / gl_toy / gl_shoes / gl_electronics"},{"type":"NUMBER","name":"sales_rank","nullable":false,"description":null},{"type":"NUMBER","name":"days_of_supply","nullable":false,"description":null},{"type":"NUMBER","name":"estimated_excess_quantity","nullable":false,"description":null},{"type":"NUMBER","name":"weeks_of_cover_t30","nullable":false,"description":null},{"type":"NUMBER","name":"weeks_of_cover_t90","nullable":false,"description":null},{"type":"NUMBER","name":"featuredoffer_price","nullable":false,"description":null},{"type":"NUMBER","name":"sales_shipped_last_7_days","nullable":false,"description":null},{"type":"NUMBER","name":"sales_shipped_last_30_days","nullable":false,"description":null},{"type":"NUMBER","name":"sales_shipped_last_60_days","nullable":false,"description":null},{"type":"NUMBER","name":"sales_shipped_last_90_days","nullable":false,"description":null},{"type":"NUMBER","name":"inv_age_0_to_30_days","nullable":false,"description":null},{"type":"NUMBER","name":"inv_age_31_to_60_days","nullable":false,"description":null},{"type":"NUMBER","name":"inv_age_61_to_90_days","nullable":false,"description":null},{"type":"NUMBER","name":"inv_age_181_to_330_days","nullable":false,"description":null},{"type":"NUMBER","name":"inv_age_331_to_365_days","nullable":false,"description":null},{"type":"NUMBER","name":"estimated_storage_cost_next_month","nullable":false,"description":null},{"type":"NUMBER","name":"inbound_quantity","nullable":false,"description":"Total quantity of units in inbound shipments. Sum of inbound_working, inbound_shipped, and inbound_received."},{"type":"NUMBER","name":"inbound_working","nullable":false,"description":null},{"type":"NUMBER","name":"inbound_shipped","nullable":false,"description":null},{"type":"NUMBER","name":"inbound_received","nullable":false,"description":null},{"type":"NUMBER","name":"no_sale_last_6_months","nullable":false,"description":null},{"type":"NUMBER","name":"total_reserved_quantity","nullable":false,"description":null},{"type":"NUMBER","name":"unfulfillable_quantity","nullable":false,"description":null},{"type":"NUMBER","name":"quantity_to_be_charged_ais_181_210_days","nullable":false,"description":null},{"type":"NUMBER","name":"estimated_ais_181_210_days","nullable":false,"description":null},{"type":"NUMBER","name":"quantity_to_be_charged_ais_211_240_days","nullable":false,"description":null},{"type":"NUMBER","name":"estimated_ais_211_240_days","nullable":false,"description":null},{"type":"NUMBER","name":"quantity_to_be_charged_ais_241_270_days","nullable":false,"description":null},{"type":"NUMBER","name":"estimated_ais_241_270_days","nullable":false,"description":null},{"type":"NUMBER","name":"quantity_to_be_charged_ais_271_300_days","nullable":false,"description":null},{"type":"NUMBER","name":"estimated_ais_271_300_days","nullable":false,"description":null},{"type":"NUMBER","name":"quantity_to_be_charged_ais_301_330_days","nullable":false,"description":null},{"type":"NUMBER","name":"estimated_ais_301_330_days","nullable":false,"description":null},{"type":"NUMBER","name":"quantity_to_be_charged_ais_331_365_days","nullable":false,"description":null},{"type":"NUMBER","name":"estimated_ais_331_365_days","nullable":false,"description":null},{"type":"NUMBER","name":"historical_days_of_supply","nullable":false,"description":null},{"type":"NUMBER","name":"fba_minimum_inventory_level","nullable":false,"description":null},{"type":"TEXT","name":"fba_inventory_level_health_status","nullable":false,"description":"FBA inventory level health status enum values."},{"type":"NUMBER","name":"recommended_ship_in_quantity","nullable":false,"description":null},{"type":"DATE","name":"recommended_ship_in_date","nullable":false,"description":null},{"type":"DATE","name":"last_updated_date_for_historical_days_of_supply","nullable":false,"description":null},{"type":"LOGIC","name":"exempted_from_low_inventory_level_fee","nullable":false,"description":null},{"type":"LOGIC","name":"low_inventory_level_fee_applied_in_current_week","nullable":false,"description":null},{"type":"NUMBER","name":"short_term_historical_days_of_supply","nullable":false,"description":null},{"type":"NUMBER","name":"long_term_historical_days_of_supply","nullable":false,"description":null},{"type":"DATE","name":"inventory_age_snapshot_date","nullable":false,"description":null},{"type":"NUMBER","name":"inventory_supply_at_fba","nullable":false,"description":"Total on-hand inventory at FBA fulfillment centers, including available and FC transfer units."},{"type":"NUMBER","name":"reserved_fc_transfer","nullable":true,"description":null},{"type":"NUMBER","name":"reserved_fc_processing","nullable":false,"description":null},{"type":"NUMBER","name":"reserved_customer_order","nullable":false,"description":null},{"type":"NUMBER","name":"total_days_of_supply_including_units_from_open_shipments","nullable":false,"description":null},{"type":"TEXT","name":"supplier","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Consolidated daily FBA inventory health view across sales windows (7, 30, 60, and 90 days), inbound shipment statuses (working, received, and shipped), estimated storage and long-term storage fees, aged and excess units, and recommended actions. Not available in the MX marketplace.","fetchPeriods":[{"type":"INITIAL","numberOfDays":1},{"type":"RECURRING_DAILY","numberOfDays":1}],"dataAvailability":{"type":"INTRADAY","description":"Intraday updates are available when source data changes during the day.","refreshAt":"1pm"},"sources":["connections","raw_sp_api_report_fba_inventory_planning","raw_sp_api_report_restock_inventory"],"containsPii":false},{"id":"d7716dee8fd10ff00f94a9d7fd4a0b0f74d6b6759e29a4ffca6ef4a0cb4816d9","name":"FBA Overage Fee Charges","tableName":"amazon_fba_overage_fees","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"charged_date","nullable":false,"description":null},{"type":"TEXT","name":"country_code","nullable":false,"description":null},{"type":"TEXT","name":"storage_type","nullable":false,"description":"Storage type enum values."},{"type":"TEXT","name":"charge_rate","nullable":false,"description":"Charge rate enum values."},{"type":"NUMBER","name":"storage_usage_volume","nullable":false,"description":null},{"type":"NUMBER","name":"storage_limit_volume","nullable":false,"description":null},{"type":"NUMBER","name":"overage_volume","nullable":false,"description":null},{"type":"TEXT","name":"volume_unit","nullable":false,"description":"Volume unit enum values."},{"type":"NUMBER","name":"charged_fee_amount","nullable":false,"description":null},{"type":"TEXT","name":"currency","nullable":false,"description":"Currency code."}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Daily overage fee charges based on FBA storage usage limits.","fetchPeriods":[{"type":"INITIAL","numberOfDays":1},{"type":"RECURRING_DAILY","numberOfDays":1}],"sources":["connections","raw_sp_api_report_fba_overage_fee_charges"],"containsPii":false},{"id":"829e34f54e72ade58cb032ae2db770cf70c863a5897fefda93c4dbae9bb38ad0","name":"FBA Ledger Summary","tableName":"amazon_fba_ledger_summary","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"fnsku","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"msku","nullable":false,"description":null},{"type":"TEXT","name":"title","nullable":false,"description":null},{"type":"TEXT","name":"disposition","nullable":false,"description":"DEFECTIVE / SELLABLE / CUSTOMER_DAMAGED"},{"type":"NUMBER","name":"starting_warehouse_balance","nullable":false,"description":null},{"type":"NUMBER","name":"in_transit_between_warehouses","nullable":false,"description":null},{"type":"NUMBER","name":"receipts","nullable":false,"description":null},{"type":"NUMBER","name":"customer_shipments","nullable":false,"description":null},{"type":"NUMBER","name":"customer_returns","nullable":false,"description":null},{"type":"NUMBER","name":"vendor_returns","nullable":false,"description":null},{"type":"NUMBER","name":"warehouse_transfer_in_out","nullable":false,"description":null},{"type":"NUMBER","name":"found","nullable":false,"description":null},{"type":"NUMBER","name":"lost","nullable":false,"description":null},{"type":"NUMBER","name":"damaged","nullable":false,"description":null},{"type":"NUMBER","name":"disposed","nullable":false,"description":null},{"type":"NUMBER","name":"other_events","nullable":false,"description":null},{"type":"NUMBER","name":"ending_warehouse_balance","nullable":false,"description":null},{"type":"NUMBER","name":"unknown_events","nullable":false,"description":null},{"type":"TEXT","name":"location","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Daily FBA ledger summary by fulfillment center with warehouse balance changes and inventory movement events.","fetchPeriods":[{"type":"INITIAL","numberOfDays":56},{"type":"RECURRING_DAILY","numberOfDays":7}],"sources":["connections","raw_sp_api_report_fba_ledger_summary"],"containsPii":false},{"id":"6a6e14526df6972c97b2a5cb55649855f91181832cd2899cfebc3cc5bb54bbf0","name":"FBA Ledger Details","tableName":"amazon_fba_ledger_details","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"fnsku","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"msku","nullable":false,"description":null},{"type":"TEXT","name":"title","nullable":false,"description":null},{"type":"TEXT","name":"event_type","nullable":false,"description":"Adjustments / CustomerReturns / Receipts / Shipments / VendorReturns / WhseTransfers"},{"type":"TEXT","name":"reference_id","nullable":false,"description":null},{"type":"NUMBER","name":"quantity","nullable":false,"description":null},{"type":"TEXT","name":"fulfillment_center","nullable":false,"description":null},{"type":"TEXT","name":"disposition","nullable":false,"description":"CARRIER_DAMAGED  / CUSTOMER_DAMAGED / DEFECTIVE / DISTRIBUTOR_DAMAGED / EXPIRED / SELLABLE / WAREHOUSE_DAMAGED"},{"type":"TEXT","name":"reason","nullable":false,"description":null},{"type":"TEXT","name":"country","nullable":false,"description":null},{"type":"NUMBER","name":"reconciled_quantity","nullable":false,"description":null},{"type":"NUMBER","name":"unreconciled_quantity","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Daily FBA ledger details with per-event inventory movements, references, and reconciliation quantities.","fetchPeriods":[{"type":"INITIAL","numberOfDays":56},{"type":"RECURRING_DAILY","numberOfDays":7}],"sources":["connections","raw_sp_api_report_fba_ledger_detail"],"containsPii":false},{"id":"316ea56bca9b5c665b2aa835c861b634d7cada971aa3814abf8f872b7e3f469e","name":"FBA Storage Fee Charges","tableName":"amazon_fba_storage_fees","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"fnsku","nullable":false,"description":null},{"type":"TEXT","name":"product_name","nullable":false,"description":null},{"type":"TEXT","name":"fulfillment_center","nullable":false,"description":null},{"type":"TEXT","name":"country_code","nullable":false,"description":null},{"type":"NUMBER","name":"longest_side","nullable":false,"description":null},{"type":"NUMBER","name":"median_side","nullable":false,"description":null},{"type":"NUMBER","name":"shortest_side","nullable":false,"description":null},{"type":"TEXT","name":"measurement_units","nullable":false,"description":"centimeters"},{"type":"NUMBER","name":"weight","nullable":false,"description":null},{"type":"TEXT","name":"weight_units","nullable":false,"description":"kilograms"},{"type":"NUMBER","name":"item_volume","nullable":false,"description":null},{"type":"TEXT","name":"volume_units","nullable":false,"description":"cubic feet / cubic meters"},{"type":"TEXT","name":"product_size_tier","nullable":false,"description":"Oversize / Standard-Size"},{"type":"NUMBER","name":"average_quantity_on_hand","nullable":false,"description":null},{"type":"NUMBER","name":"average_quantity_pending_removal","nullable":false,"description":null},{"type":"NUMBER","name":"estimated_total_item_volume","nullable":false,"description":null},{"type":"DATE","name":"month_of_charge","nullable":false,"description":"First day of the month this charge refers to."},{"type":"NUMBER","name":"storage_rate","nullable":false,"description":null},{"type":"TEXT","name":"currency","nullable":false,"description":"Currency code."},{"type":"NUMBER","name":"estimated_monthly_storage_fee","nullable":false,"description":null},{"type":"TEXT","name":"dangerous_goods_storage_type","nullable":false,"description":"Dangerous goods storage type enum values."},{"type":"LOGIC","name":"eligible_for_inventory_discount","nullable":false,"description":null},{"type":"LOGIC","name":"qualifies_for_inventory_discount","nullable":false,"description":null},{"type":"NUMBER","name":"total_incentive_fee_amount","nullable":false,"description":null},{"type":"NUMBER","name":"breakdown_incentive_fee_amount","nullable":false,"description":null},{"type":"NUMBER","name":"average_quantity_customer_orders","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Daily FBA storage fee charges with historical data.","fetchPeriods":[{"type":"INITIAL","numberOfDays":-1},{"type":"RECURRING_DAILY","numberOfDays":1}],"sources":["connections","raw_sp_api_report_fba_storage_fee_charges"],"containsPii":false},{"id":"4e67eb700fbd05a0840c41a5157bf77dd47f12a41696db34f058ed20dd432aac","name":"FBA Long-Term Storage Fee Charges","tableName":"amazon_fba_long_term_storage_fees","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"DATE","name":"snapshot_date","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"fnsku","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"product_name","nullable":false,"description":null},{"type":"TEXT","name":"condition","nullable":false,"description":"Used / New / No Listing"},{"type":"NUMBER","name":"per_unit_volume","nullable":false,"description":null},{"type":"TEXT","name":"currency","nullable":false,"description":"Currency code."},{"type":"TEXT","name":"volume_unit","nullable":false,"description":"cubic_meters / cubic_feet"},{"type":"TEXT","name":"country","nullable":false,"description":"Marketplace country code"},{"type":"NUMBER","name":"qty_charged","nullable":false,"description":null},{"type":"NUMBER","name":"amount_charged","nullable":false,"description":null},{"type":"TEXT","name":"surcharge_age_tier","nullable":false,"description":null},{"type":"NUMBER","name":"rate_surcharge","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Daily long-term FBA storage fee charges with historical data.","fetchPeriods":[{"type":"INITIAL","numberOfDays":730},{"type":"RECURRING_DAILY","numberOfDays":30}],"sources":["connections","raw_sp_api_report_fba_fulfillment_longterm_storage_fee_charges"],"containsPii":false},{"id":"13b0fdeaffb6d9c697e0e9942aabc1b0a2ed409ba611860e0beb9776b9e54f2d","name":"FBA Reimbursements","tableName":"amazon_fba_reimbursements","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"DATE","name":"approval_date","nullable":false,"description":null},{"type":"TEXT","name":"reimbursement_id","nullable":false,"description":null},{"type":"TEXT","name":"case_id","nullable":false,"description":null},{"type":"TEXT","name":"amazon_order_id","nullable":false,"description":null},{"type":"TEXT","name":"reason","nullable":false,"description":"GeneralAdjustment / Lost_Outbound / Payment_Retraction / Damaged_Warehouse / FeeCorrection / CustomerReturn / Reimbursement_Reversal / Lost_Warehouse  / Lost_Inbound / or empty"},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"fnsku","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"product_name","nullable":false,"description":null},{"type":"TEXT","name":"condition","nullable":false,"description":"NewItem / UsedGood / UsedVeryGood / UsedAcceptable / UsedPoor / UsedLikeNew"},{"type":"TEXT","name":"currency_unit","nullable":false,"description":"Currency code."},{"type":"NUMBER","name":"amount_per_unit","nullable":false,"description":null},{"type":"NUMBER","name":"amount_total","nullable":false,"description":null},{"type":"NUMBER","name":"quantity_reimbursed_cash","nullable":false,"description":null},{"type":"NUMBER","name":"quantity_reimbursed_inventory","nullable":false,"description":null},{"type":"NUMBER","name":"quantity_reimbursed_total","nullable":false,"description":null},{"type":"TEXT","name":"original_reimbursement_id","nullable":false,"description":null},{"type":"TEXT","name":"original_reimbursement_type","nullable":true,"description":"Damaged_Warehouse / Lost_Inbound / CustomerReturn / Lost_Warehouse / or empty"}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Daily FBA reimbursements with historical data.","fetchPeriods":[{"type":"INITIAL","numberOfDays":730},{"type":"RECURRING_DAILY","numberOfDays":30}],"sources":["connections","raw_sp_api_report_fba_reimbursements"],"containsPii":false},{"id":"27c6fc0ec69648b5fed4612dbd9ccdfdeaaca6787f8f985c01266e4dc11f9038","name":"Returns (FBA & FBM)","tableName":"amazon_returns","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_return_tracking_id","nullable":true,"description":"Available only for FBM returns."},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"amazon_order_id","nullable":false,"description":null},{"type":"DATE","name":"order_date","nullable":true,"description":"Available only for FBM returns."},{"type":"DATE","name":"date","nullable":false,"description":"Amazon return request date."},{"type":"TEXT","name":"amazon_return_request_status","nullable":false,"description":"'Approved', 'Closed' or 'PendingApproval'"},{"type":"TEXT","name":"amazon_return_rmaid","nullable":true,"description":"Available only for FBM returns."},{"type":"TEXT","name":"amazon_return_seller_rmaid","nullable":true,"description":"Available only for FBM returns."},{"type":"NUMBER","name":"amazon_return_label_cost","nullable":true,"description":"Available only for FBM returns."},{"type":"TEXT","name":"amazon_return_carrier","nullable":true,"description":"Available only for FBM returns."},{"type":"TEXT","name":"amazon_return_label_to_be_paid_by","nullable":true,"description":"'Seller' or 'Customer'."},{"type":"LOGIC","name":"amazon_order_is_prime","nullable":true,"description":"Available only for FBA returns."},{"type":"NUMBER","name":"amazon_return_refunded_amount","nullable":true,"description":"Available only for FBM returns."},{"type":"TEXT","name":"amazon_return_reason","nullable":false,"description":"Return reason enum."},{"type":"TEXT","name":"amazon_fulfillment_channel","nullable":false,"description":"'FBA' or 'FBM'"},{"type":"TEXT","name":"amazon_fulfillment_channel_id","nullable":true,"description":"Available only for FBA returns."},{"type":"TEXT","name":"amazon_license_plate_number","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Data about all returns (FBA & FBM).","fetchPeriods":[{"type":"INITIAL","numberOfDays":60},{"type":"RECURRING_DAILY","numberOfDays":60}],"sources":["connections","raw_sp_api_report_fba_fulfillment_customer_returns","raw_sp_api_report_flat_file_returns_data_by_return_date"],"containsPii":false},{"id":"2610a531e0170a7857c3edbc1d5b3dd5a7abf63ba7fbbb1997fce3e9a7421438","name":"Seller Feedback","tableName":"amazon_seller_feedback","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":"Date the feedback was left."},{"type":"TEXT","name":"amazon_order_id","nullable":false,"description":null},{"type":"NUMBER","name":"buyer_rating","nullable":false,"description":"Buyer star rating from 1 to 5."},{"type":"TEXT","name":"buyer_comments","nullable":true,"description":null},{"type":"TEXT","name":"buyer_email","nullable":true,"description":null},{"type":"TEXT","name":"seller_response","nullable":true,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Negative and neutral (one to three stars) feedback left for the seller by buyers, including star rating, comments, and optional seller response.","fetchPeriods":[{"type":"INITIAL","numberOfDays":60},{"type":"RECURRING_DAILY","numberOfDays":60}],"sources":["connections","raw_sp_api_report_seller_feedback_data"],"containsPii":false},{"id":"7076aeafd23f0805afb91c4ecef994d7a0d2e796e06852391bc28de680e71aaa","name":"Coupon Performance","tableName":"amazon_coupon_performance","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"campaign_id","nullable":false,"description":null},{"type":"TEXT","name":"campaign_name","nullable":true,"description":null},{"type":"TEXT","name":"vendor_code","nullable":true,"description":null},{"type":"LOGIC","name":"is_subscribe_and_save","nullable":true,"description":null},{"type":"TEXT","name":"budget_type","nullable":true,"description":null},{"type":"NUMBER","name":"campaign_total_clips","nullable":true,"description":null},{"type":"NUMBER","name":"campaign_total_redemptions","nullable":true,"description":null},{"type":"TEXT","name":"currency_code","nullable":true,"description":null},{"type":"TEXT","name":"coupon_id","nullable":false,"description":null},{"type":"TEXT","name":"coupon_name","nullable":true,"description":null},{"type":"TEXT","name":"website_message","nullable":true,"description":null},{"type":"DATE","name":"start_date_time","nullable":true,"description":null},{"type":"DATE","name":"end_date_time","nullable":true,"description":null},{"type":"LOGIC","name":"is_once_per_customer","nullable":true,"description":null},{"type":"NUMBER","name":"clips","nullable":true,"description":null},{"type":"NUMBER","name":"redemptions","nullable":true,"description":null},{"type":"NUMBER","name":"budget","nullable":true,"description":null},{"type":"NUMBER","name":"total_discount","nullable":true,"description":null},{"type":"NUMBER","name":"budget_spent","nullable":true,"description":null},{"type":"NUMBER","name":"budget_remaining","nullable":true,"description":null},{"type":"NUMBER","name":"budget_percentage_used","nullable":true,"description":null},{"type":"TEXT","name":"asin","nullable":false,"description":null},{"type":"TEXT","name":"discount_type","nullable":true,"description":null},{"type":"NUMBER","name":"discount_amount","nullable":true,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Amazon coupon campaign performance with coupon-level clips, redemptions, budget usage, and ASIN-level discount details.","fetchPeriods":[{"type":"INITIAL","numberOfDays":720},{"type":"RECURRING_DAILY","numberOfDays":30}],"sources":["connections","raw_sp_api_report_coupon_performance"],"containsPii":false},{"id":"8a1c593aeb0211c8ded1c3d073639d15e6a0a88c63076d3894502f2d585a1eae","name":"Promotion Performance","tableName":"amazon_promotion_performance","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"promotion_id","nullable":false,"description":null},{"type":"TEXT","name":"promotion_name","nullable":true,"description":null},{"type":"TEXT","name":"vendor_code","nullable":true,"description":null},{"type":"TEXT","name":"merchant_id","nullable":true,"description":null},{"type":"TEXT","name":"promotion_type","nullable":true,"description":null},{"type":"TEXT","name":"promotion_status","nullable":true,"description":null},{"type":"TEXT","name":"funding_agreement_id","nullable":true,"description":null},{"type":"NUMBER","name":"glance_views","nullable":true,"description":null},{"type":"NUMBER","name":"units_sold","nullable":true,"description":null},{"type":"NUMBER","name":"amount_spent","nullable":true,"description":null},{"type":"TEXT","name":"amount_spent_currency","nullable":true,"description":null},{"type":"NUMBER","name":"revenue","nullable":true,"description":null},{"type":"TEXT","name":"revenue_currency","nullable":true,"description":null},{"type":"DATE","name":"start_date_time","nullable":true,"description":null},{"type":"DATE","name":"end_date_time","nullable":true,"description":null},{"type":"DATE","name":"created_date_time","nullable":true,"description":null},{"type":"DATE","name":"last_updated_date_time","nullable":true,"description":null},{"type":"TEXT","name":"asin","nullable":false,"description":null},{"type":"TEXT","name":"product_name","nullable":true,"description":null},{"type":"NUMBER","name":"product_glance_views","nullable":true,"description":null},{"type":"NUMBER","name":"product_units_sold","nullable":true,"description":null},{"type":"NUMBER","name":"product_amount_spent","nullable":true,"description":null},{"type":"TEXT","name":"product_amount_spent_currency","nullable":true,"description":null},{"type":"NUMBER","name":"product_revenue","nullable":true,"description":null},{"type":"TEXT","name":"product_revenue_currency","nullable":true,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Amazon promotion performance with promotion-level and product-level metrics including glance views, units sold, spend, and revenue.","fetchPeriods":[{"type":"INITIAL","numberOfDays":720},{"type":"RECURRING_DAILY","numberOfDays":30}],"sources":["connections","raw_sp_api_report_promotion_performance"],"containsPii":false},{"id":"57036be081231374d01a690532d8353061bcc494ec29bae1397d55678688ef81","name":"Seller Account Health Metrics","tableName":"amazon_seller_performance","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"seller_account_status","nullable":false,"description":null},{"type":"TEXT","name":"seller_late_shipping_rate_30d_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_late_shipping_rate_30d_value","nullable":false,"description":null},{"type":"NUMBER","name":"seller_late_shipping_rate_30d_target_less_than","nullable":false,"description":null},{"type":"NUMBER","name":"seller_late_shipping_rate_30d_order_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_invoice_defect_rate_7d_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_invoice_defect_rate_7d_value","nullable":false,"description":null},{"type":"NUMBER","name":"seller_invoice_defect_rate_7d_target_less_than","nullable":false,"description":null},{"type":"TEXT","name":"seller_invoice_defect_rate_7d_invoice_defect_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_invoice_defect_rate_7d_invoice_defect_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_invoice_defect_rate_7d_missing_invoice_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_invoice_defect_rate_7d_missing_invoice_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_invoice_defect_rate_7d_late_invoice_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_invoice_defect_rate_7d_late_invoice_count","nullable":false,"description":null},{"type":"NUMBER","name":"seller_invoice_defect_rate_7d_order_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_order_defect_rate_fba_60d_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_order_defect_rate_fba_60d_value","nullable":false,"description":null},{"type":"NUMBER","name":"seller_order_defect_rate_fba_60d_target_less_than","nullable":false,"description":null},{"type":"TEXT","name":"seller_order_defect_rate_fba_60d_order_with_defects_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_order_defect_rate_fba_60d_order_with_defects_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_order_defect_rate_fba_60d_claims_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_order_defect_rate_fba_60d_claims_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_order_defect_rate_fba_60d_chargebacks_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_order_defect_rate_fba_60d_chargeback_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_order_defect_rate_fba_60d_negative_feedback_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_order_defect_rate_fba_60d_negative_feedback_count","nullable":false,"description":null},{"type":"NUMBER","name":"seller_order_defect_rate_fba_60d_order_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_order_defect_rate_fbm_60d_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_order_defect_rate_fbm_60d_value","nullable":false,"description":null},{"type":"NUMBER","name":"seller_order_defect_rate_fbm_60d_target_less_than","nullable":false,"description":null},{"type":"TEXT","name":"seller_order_defect_rate_fbm_60d_order_with_defects_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_order_defect_rate_fbm_60d_order_with_defects_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_order_defect_rate_fbm_60d_claims_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_order_defect_rate_fbm_60d_claims_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_order_defect_rate_fbm_60d_chargebacks_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_order_defect_rate_fbm_60d_chargeback_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_order_defect_rate_fbm_60d_negative_feedback_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_order_defect_rate_fbm_60d_negative_feedback_count","nullable":false,"description":null},{"type":"NUMBER","name":"seller_order_defect_rate_fbm_60d_order_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_on_time_delivery_rate_30d_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_on_time_delivery_rate_30d_value","nullable":false,"description":null},{"type":"NUMBER","name":"seller_on_time_delivery_rate_30d_target_greater_than","nullable":false,"description":null},{"type":"NUMBER","name":"seller_on_time_delivery_rate_30d_shipment_count_with_valid_tracking","nullable":false,"description":null},{"type":"NUMBER","name":"seller_on_time_delivery_rate_30d_on_time_delivery_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_valid_tracking_rate_30d_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_valid_tracking_rate_30d_value","nullable":false,"description":null},{"type":"NUMBER","name":"seller_valid_tracking_rate_30d_target_greater_than","nullable":false,"description":null},{"type":"NUMBER","name":"seller_valid_tracking_rate_30d_shipment_count","nullable":false,"description":null},{"type":"NUMBER","name":"seller_valid_tracking_rate_30d_valid_tracking_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_pre_fulfillment_cancellation_rate_7d_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_pre_fulfillment_cancellation_rate_7d_value","nullable":false,"description":null},{"type":"NUMBER","name":"seller_pre_fulfillment_cancellation_rate_7d_target_less_than","nullable":false,"description":null},{"type":"NUMBER","name":"seller_pre_fulfillment_cancellation_rate_7d_order_count","nullable":false,"description":null},{"type":"NUMBER","name":"seller_pre_fulfillment_cancellation_rate_7d_cancellation_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_account_health_rating_6m_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_account_health_rating_6m_score","nullable":false,"description":null},{"type":"TEXT","name":"seller_listing_policy_violations_6m_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_listing_policy_violations_6m_target_equals","nullable":false,"description":null},{"type":"NUMBER","name":"seller_listing_policy_violations_6m_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_product_authenticity_customer_complaints_6m_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_product_authenticity_customer_complaints_6m_target_equals","nullable":false,"description":null},{"type":"NUMBER","name":"seller_product_authenticity_customer_complaints_6m_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_product_condition_customer_complaints_6m_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_product_condition_customer_complaints_6m_target_equals","nullable":false,"description":null},{"type":"NUMBER","name":"seller_product_condition_customer_complaints_6m_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_product_safety_customer_complaints_6m_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_product_safety_customer_complaints_6m_target_equals","nullable":false,"description":null},{"type":"NUMBER","name":"seller_product_safety_customer_complaints_6m_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_received_intellectual_property_complaints_6m_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_received_intellectual_property_complaints_6m_target_equals","nullable":false,"description":null},{"type":"NUMBER","name":"seller_received_intellectual_property_complaints_6m_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_restricted_product_policy_violations_6m_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_restricted_product_policy_violations_6m_target_equals","nullable":false,"description":null},{"type":"NUMBER","name":"seller_restricted_product_policy_violations_6m_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_suspected_intellectual_property_policy_violations_6m_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_suspected_intellectual_property_policy_violations_6m_target_equals","nullable":false,"description":null},{"type":"NUMBER","name":"seller_suspected_intellectual_property_policy_violations_6m_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_food_and_product_safety_issues_6m_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_food_and_product_safety_issues_6m_target_equals","nullable":false,"description":null},{"type":"NUMBER","name":"seller_food_and_product_safety_issues_6m_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_customer_product_reviews_policy_violations_6m_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_customer_product_reviews_policy_violations_6m_target_equals","nullable":false,"description":null},{"type":"NUMBER","name":"seller_customer_product_reviews_policy_violations_6m_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_other_policy_violations_6m_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_other_policy_violations_6m_target_equals","nullable":false,"description":null},{"type":"NUMBER","name":"seller_other_policy_violations_6m_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_documents_requests_6m_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_documents_requests_6m_target_equals","nullable":false,"description":null},{"type":"NUMBER","name":"seller_documents_requests_6m_count","nullable":false,"description":null},{"type":"NUMBER","name":"seller_policy_violations_6m_warning_count","nullable":false,"description":null},{"type":"TEXT","name":"seller_unit_on_time_delivery_rate_14d_status","nullable":false,"description":null},{"type":"NUMBER","name":"seller_unit_on_time_delivery_rate_14d_value","nullable":false,"description":null},{"type":"NUMBER","name":"seller_unit_on_time_delivery_rate_14d_target_greater_than","nullable":false,"description":null},{"type":"NUMBER","name":"seller_unit_on_time_delivery_rate_14d_on_time_delivery_count","nullable":false,"description":null},{"type":"NUMBER","name":"seller_unit_on_time_delivery_rate_14d_total_unit_count","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Data about seller account health status (latest date is current). Use *_target_less_than_* as threshold for the metric.","fetchPeriods":[{"type":"RECURRING_DAILY","numberOfDays":1}],"sources":["connections","raw_sp_api_report_v2_seller_performance"],"containsPii":false},{"id":"8772614caff9e14bdbe33f4631877f4ac921e84eecbc49a38497840122ae1ab5","name":"Search Engagement by ASIN (Monthly)","tableName":"amazon_child_product_search_performance_per_month","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"NUMBER","name":"search_impression_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_impression_median_price_value","nullable":false,"description":null},{"type":"TEXT","name":"search_impression_median_price_currency","nullable":false,"description":"Currency code."},{"type":"NUMBER","name":"search_click_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_click_rate","nullable":false,"description":null},{"type":"NUMBER","name":"search_clicked_median_price","nullable":false,"description":null},{"type":"NUMBER","name":"search_cart_add_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_cart_added_median_price_value","nullable":false,"description":null},{"type":"TEXT","name":"search_cart_added_median_price_currency","nullable":false,"description":"Currency code."},{"type":"NUMBER","name":"search_purchase_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_search_traffic_sales_value","nullable":false,"description":null},{"type":"TEXT","name":"search_search_traffic_sales_currency","nullable":false,"description":"Currency code."},{"type":"NUMBER","name":"search_conversion_rate","nullable":false,"description":null},{"type":"NUMBER","name":"search_purchase_median_price_value","nullable":false,"description":null},{"type":"TEXT","name":"search_purchase_median_price_currency","nullable":false,"description":"Currency code."},{"type":"NUMBER","name":"search_one_day_shipping_impression_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_two_day_shipping_impression_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_one_day_shipping_click_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_two_day_shipping_click_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_one_day_shipping_cart_add_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_two_day_shipping_cart_add_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_one_day_shipping_purchase_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_two_day_shipping_purchase_count","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":"First day of the month the data refers to. Represents an aggregated monthly snapshot. Data availability can lag, so use MAX(date) for the most recent month."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Monthly search engagement metrics for child ASINs (organic + ads).","fetchPeriods":[{"type":"INITIAL","numberOfDays":365},{"type":"RECURRING_WEEKLY","numberOfDays":90}],"sources":["connections","raw_sp_api_report_brand_analytics_search_catalog_performance"],"containsPii":false},{"id":"732dac689a6545697c2f2e36c61b2c9e93187053bcce2999914183c6f490df27","name":"Settlements & P&L Components","tableName":"amazon_settlements_with_cogs","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":"Date of the settlement. May be different from the order date. This column is used for the from/to filters on Export creation."},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"settlement_type","nullable":false,"description":"ORDER, REFUND or OTHER."},{"type":"TEXT","name":"amazon_order_id","nullable":false,"description":null},{"type":"TEXT","name":"merchant_order_id","nullable":false,"description":"Private seller order id."},{"type":"DATE","name":"order_date","nullable":false,"description":"Date of the order if the row is related to an order. This it preffered column for calculating profit over period of time. May be the same or up to 30 days later than the date of the settlement date."},{"type":"NUMBER","name":"quantity","nullable":false,"description":"Quantity of the item in the order."},{"type":"TEXT","name":"currency","nullable":false,"description":"Currency code."},{"type":"NUMBER","name":"total_fees","nullable":false,"description":"Sum of all fees in the row. Equals to \"total\" - \"item_price\"."},{"type":"NUMBER","name":"total","nullable":false,"description":"Sum of all amounts in the row. May be a negative number."},{"type":"NUMBER","name":"fba_per_unit_fulfillment_fee","nullable":false,"description":null},{"type":"NUMBER","name":"referral_fee","nullable":false,"description":null},{"type":"NUMBER","name":"fba_storage_fee","nullable":false,"description":null},{"type":"NUMBER","name":"missing_from_inbound_clawback","nullable":false,"description":null},{"type":"NUMBER","name":"long_term_storage_fee","nullable":false,"description":null},{"type":"NUMBER","name":"coupon_redemption_fee","nullable":false,"description":null},{"type":"NUMBER","name":"liquidations_brokerage_fee","nullable":false,"description":null},{"type":"NUMBER","name":"compensated_clawback","nullable":false,"description":null},{"type":"NUMBER","name":"customer_return_hrr_unit_fee","nullable":false,"description":null},{"type":"NUMBER","name":"fba_disposal_fee","nullable":false,"description":null},{"type":"NUMBER","name":"subscription_fee","nullable":false,"description":null},{"type":"NUMBER","name":"awd_processing_fee","nullable":false,"description":null},{"type":"NUMBER","name":"awd_transportation_fee","nullable":false,"description":null},{"type":"NUMBER","name":"warehouse_damage_exception","nullable":false,"description":null},{"type":"NUMBER","name":"adjustment_fba_per_unit_fulfillment_fee","nullable":false,"description":null},{"type":"NUMBER","name":"free_replacement_refund_items","nullable":false,"description":null},{"type":"NUMBER","name":"warehouse_lost","nullable":false,"description":null},{"type":"NUMBER","name":"warehouse_damage","nullable":false,"description":null},{"type":"NUMBER","name":"liquidations_revenue","nullable":false,"description":null},{"type":"NUMBER","name":"reversal_reimbursement","nullable":false,"description":null},{"type":"NUMBER","name":"missing_from_inbound","nullable":false,"description":null},{"type":"NUMBER","name":"item_price","nullable":false,"description":null},{"type":"NUMBER","name":"item_shipping_fee","nullable":false,"description":null},{"type":"NUMBER","name":"item_tax","nullable":false,"description":null},{"type":"NUMBER","name":"item_shipping_tax","nullable":false,"description":null},{"type":"NUMBER","name":"item_gift_wrap_tax","nullable":false,"description":null},{"type":"NUMBER","name":"item_shipping_chargeback","nullable":false,"description":null},{"type":"NUMBER","name":"item_digital_services_fee","nullable":false,"description":null},{"type":"NUMBER","name":"item_gift_wrap_fee","nullable":false,"description":null},{"type":"NUMBER","name":"item_gift_wrap_chargeback","nullable":false,"description":null},{"type":"NUMBER","name":"fba_inbound_convenience_fee","nullable":false,"description":null},{"type":"NUMBER","name":"warehouse_lost_manual","nullable":false,"description":null},{"type":"NUMBER","name":"fee_adjustment","nullable":false,"description":null},{"type":"NUMBER","name":"a_to_z_guarantee_refunds","nullable":false,"description":null},{"type":"NUMBER","name":"amazon_fees","nullable":false,"description":"Sum of all other Amazon account fees."},{"type":"NUMBER","name":"commingling_vat","nullable":false,"description":null},{"type":"NUMBER","name":"liquidations_other","nullable":false,"description":null},{"type":"NUMBER","name":"digital_services_fee","nullable":false,"description":null},{"type":"NUMBER","name":"fba_transportation_fee","nullable":false,"description":null},{"type":"NUMBER","name":"item_withheld_tax","nullable":false,"description":null},{"type":"NUMBER","name":"promotion_item_price","nullable":false,"description":null},{"type":"NUMBER","name":"promotion_tax_discount","nullable":false,"description":null},{"type":"NUMBER","name":"promotion_shipping","nullable":false,"description":null},{"type":"NUMBER","name":"promotion_fee","nullable":false,"description":null},{"type":"NUMBER","name":"order_other","nullable":false,"description":null},{"type":"NUMBER","name":"order_retrocharge","nullable":false,"description":null},{"type":"NUMBER","name":"cost_of_advertising","nullable":false,"description":null},{"type":"NUMBER","name":"refund_retrocharge","nullable":false,"description":null},{"type":"NUMBER","name":"refund_item_withheld_tax","nullable":false,"description":null},{"type":"NUMBER","name":"refund_shipping","nullable":false,"description":null},{"type":"NUMBER","name":"refund_shipping_promotion","nullable":false,"description":null},{"type":"NUMBER","name":"refund_tax","nullable":false,"description":null},{"type":"NUMBER","name":"refund_shipping_tax","nullable":false,"description":null},{"type":"NUMBER","name":"refund_promotion_tax_discount","nullable":false,"description":null},{"type":"NUMBER","name":"refund_remote_fulfillment_credit","nullable":false,"description":null},{"type":"NUMBER","name":"refund_restocking_fee","nullable":false,"description":null},{"type":"NUMBER","name":"refund_item_gift_wrap_fee","nullable":false,"description":null},{"type":"NUMBER","name":"refund_digital_services_fee","nullable":false,"description":null},{"type":"NUMBER","name":"refund_other","nullable":false,"description":null},{"type":"NUMBER","name":"refunded_amount","nullable":false,"description":null},{"type":"NUMBER","name":"refunded_referral_fee","nullable":false,"description":null},{"type":"NUMBER","name":"refund_commission","nullable":false,"description":null},{"type":"NUMBER","name":"shipping_label_purchase","nullable":false,"description":null},{"type":"NUMBER","name":"shipping_label_purchase_for_return","nullable":false,"description":null},{"type":"NUMBER","name":"removal_complete","nullable":false,"description":null},{"type":"NUMBER","name":"fba_inventory_reimbursement_re_evaluation","nullable":false,"description":null},{"type":"NUMBER","name":"fba_inbound_placement_service_fee","nullable":false,"description":null},{"type":"NUMBER","name":"fba_customer_return_per_unit_fee","nullable":false,"description":null},{"type":"NUMBER","name":"fba_inbound_transportation_fee","nullable":false,"description":null},{"type":"NUMBER","name":"fba_inbound_transportation_program_fee","nullable":false,"description":null},{"type":"NUMBER","name":"awd_processing_fee","nullable":false,"description":null},{"type":"NUMBER","name":"awd_storage_fee","nullable":false,"description":null},{"type":"NUMBER","name":"awd_transportation_fee","nullable":false,"description":null},{"type":"NUMBER","name":"awd_processing_fee_discount","nullable":false,"description":null},{"type":"NUMBER","name":"awd_storage_fee_discount","nullable":false,"description":null},{"type":"NUMBER","name":"awd_transportation_fee_discount","nullable":false,"description":null},{"type":"NUMBER","name":"fba_other","nullable":false,"description":null},{"type":"NUMBER","name":"promotion","nullable":false,"description":null},{"type":"NUMBER","name":"goodwill","nullable":false,"description":null},{"type":"NUMBER","name":"other","nullable":false,"description":null},{"type":"NUMBER","name":"cogs_item_value","nullable":false,"description":"Cost of Goods Sold per item."},{"type":"NUMBER","name":"cogs_shipping_value","nullable":false,"description":"Shipping cost per item."},{"type":"NUMBER","name":"cogs_total_value","nullable":false,"description":"Total COGS per item."},{"type":"TEXT","name":"cogs_currency","nullable":false,"description":"Currency code for COGS."},{"type":"TEXT","name":"item_supplier_name","nullable":true,"description":"Supplier name for the item COGS, if provided in COGS upload."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Settlements per date, SKU/ASIN and order including P&L components and cost of goods sold. All columns other than \"total\" express single type of cost/fees/income/etc. Expenses are negative values (make sure to standardize this when comparing with other tables).","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","raw_amazon_cogs","raw_sp_api_report_listings_data","raw_sp_api_report_orders","raw_sp_api_report_settlements"],"containsPii":false},{"id":"81aa5b4cc248bb70de405b9ff9d51290b9232f84570d76ba2a1289b67b6595fb","name":"Search Query Performance (SQP) by ASIN (Weekly)","tableName":"amazon_child_product_organic_search_ranks_per_week","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":"First day of the week the data refers to. Represents an aggregated weekly snapshot. Data availability can lag, so use MAX(date) for the most recent week."},{"type":"TEXT","name":"search_query","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_volume","nullable":false,"description":"Total search volume for this search query across all ASINs. Each row for the same date and search query will have the same value. Do not sum it for the same date."},{"type":"NUMBER","name":"search_query_total_impression_count","nullable":false,"description":"Total impression count for this search query across all ASINs. Each row for the same date and search query will have the same value. Do not sum it for the same date."},{"type":"NUMBER","name":"child_asin_organic_search_rank","nullable":false,"description":"Organic search rank for the child ASIN for this search query relative to other search terms of the same ASIN, not a general rank, ie. more than one ASIN may have the same rank on the same search query. Min. 1, Max. 100."},{"type":"NUMBER","name":"child_asin_impression_count","nullable":false,"description":null},{"type":"NUMBER","name":"child_asin_click_count","nullable":false,"description":null},{"type":"NUMBER","name":"child_asin_median_click_price_value","nullable":false,"description":null},{"type":"TEXT","name":"child_asin_median_click_price_currency","nullable":false,"description":null},{"type":"NUMBER","name":"child_asin_add_to_cart_count","nullable":false,"description":null},{"type":"NUMBER","name":"child_asin_purchase_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_purchase_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_purchase_rate","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_same_day_shipping_purchase_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_one_day_shipping_purchase_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_two_day_shipping_purchase_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_click_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_click_rate","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_same_day_shipping_click_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_one_day_shipping_click_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_two_day_shipping_click_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_cart_add_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_cart_add_rate","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_same_day_shipping_cart_add_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_one_day_shipping_cart_add_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_two_day_shipping_cart_add_count","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Weekly organic search performance for child ASINs.","fetchPeriods":[{"type":"INITIAL","numberOfDays":28},{"type":"RECURRING_WEEKLY","numberOfDays":7,"shiftDays":7}],"sources":["connections","raw_sp_api_report_brand_analytics_search_query_weekly"],"containsPii":false},{"id":"df4160ff8e1add239172a69ebd6c8abfec7116ee4a17720983757b1b55599830","name":"Search Query Performance (SQP) by ASIN (Monthly)","tableName":"amazon_child_product_organic_search_ranks_per_month","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":"First day of the month the data refers to. Represents an aggregated monthly snapshot. Data availability can lag, so use MAX(date) for the most recent month."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"search_query","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_volume","nullable":false,"description":"Total search volume for this search query across all ASINs. Each row for the same date and search query will have the same value. Do not sum it for the same date."},{"type":"NUMBER","name":"search_query_total_impression_count","nullable":false,"description":"Total impression count for this search query across all ASINs. Each row for the same date and search query will have the same value. Do not sum it for the same date."},{"type":"NUMBER","name":"child_asin_organic_search_rank","nullable":false,"description":"Organic search rank for the child ASIN for this search query relative to other search terms of the same ASIN, not a general rank, ie. more than one ASIN may have the same rank on the same search query. Min. 1, Max. 100."},{"type":"NUMBER","name":"child_asin_impression_count","nullable":false,"description":null},{"type":"NUMBER","name":"child_asin_click_count","nullable":false,"description":null},{"type":"NUMBER","name":"child_asin_median_click_price_value","nullable":false,"description":null},{"type":"TEXT","name":"child_asin_median_click_price_currency","nullable":false,"description":null},{"type":"NUMBER","name":"child_asin_add_to_cart_count","nullable":false,"description":null},{"type":"NUMBER","name":"child_asin_purchase_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_purchase_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_purchase_rate","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_same_day_shipping_purchase_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_one_day_shipping_purchase_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_two_day_shipping_purchase_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_click_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_click_rate","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_same_day_shipping_click_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_one_day_shipping_click_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_two_day_shipping_click_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_cart_add_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_cart_add_rate","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_same_day_shipping_cart_add_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_one_day_shipping_cart_add_count","nullable":false,"description":null},{"type":"NUMBER","name":"search_query_total_two_day_shipping_cart_add_count","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Monthly organic search performance for child ASINs.","fetchPeriods":[{"type":"INITIAL","numberOfDays":90,"shiftDays":30},{"type":"RECURRING_MONTHLY","numberOfDays":30,"shiftDays":30}],"sources":["connections","raw_sp_api_report_brand_analytics_search_query_performance"],"containsPii":false},{"id":"8723a9f82b37438b5224867ac182d2e773bea12532b9f5ad2930811a6f219f90","name":"Repeat Purchase Performance","tableName":"amazon_repeat_purchase_report","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"NUMBER","name":"number_of_orders","nullable":false,"description":null},{"type":"NUMBER","name":"number_of_unique_customers","nullable":false,"description":null},{"type":"NUMBER","name":"repeat_customers_score_total","nullable":false,"description":"If this field is >0, it indicates that repeat customers made purchases."},{"type":"NUMBER","name":"repeat_purchase_revenue_amount","nullable":false,"description":null},{"type":"TEXT","name":"repeat_purchase_revenue_currency","nullable":false,"description":null},{"type":"NUMBER","name":"repeat_purchase_revenue_score_total","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":"First day of the month the data refers to."}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Monthly repeat purchase performance per child_asin. Use \"repeat_customers_score_total\" column to identify if there were repeat customers.","fetchPeriods":[{"type":"INITIAL","numberOfDays":365},{"type":"RECURRING_WEEKLY","numberOfDays":90}],"sources":["connections","raw_sp_api_report_brand_analytics_repeat_purchase"],"containsPii":false},{"id":"21aa739348f0c2d2dcebd1215736d082e346ef9cdd69b6ef509464f1cd249b0b","name":"Market Basket Co-Purchase (Monthly)","tableName":"amazon_market_basket_by_child_asin","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"purchased_with_child_asin","nullable":false,"description":null},{"type":"NUMBER","name":"purchased_with_rank","nullable":false,"description":null},{"type":"NUMBER","name":"purchased_with_combination_score","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":"First day of the month the data refers to."}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Monthly market basket analysis per child ASIN.","fetchPeriods":[{"type":"INITIAL","numberOfDays":365},{"type":"RECURRING_WEEKLY","numberOfDays":90}],"sources":["connections","raw_sp_api_report_brand_analytics_market_basket_by_month"],"containsPii":false},{"id":"d8f74544e6a856dfb6ab916ae57310fa11a74d237c00c0b20a72bfd8d0a26ce8","name":"Brand Analytics Search Terms (Daily)","tableName":"amazon_brand_analytics_search_terms_daily","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"DATE","name":"date","nullable":false,"description":"Reporting date for the daily snapshot. Data availability can lag, so use MAX(date) for the most recent day."},{"type":"DATE","name":"start_date","nullable":true,"description":"Start date of the reporting period."},{"type":"DATE","name":"end_date","nullable":true,"description":"End date of the reporting period."},{"type":"TEXT","name":"department_name","nullable":false,"description":"Amazon browse department name for the search term."},{"type":"TEXT","name":"search_term","nullable":false,"description":"Customer search query."},{"type":"NUMBER","name":"search_frequency_rank","nullable":true,"description":"Search frequency rank for the search term (lower is more popular)."},{"type":"TEXT","name":"clicked_asin","nullable":false,"description":"Child ASIN that received clicks for this search term."},{"type":"NUMBER","name":"click_share_rank","nullable":true,"description":"Click share rank of the clicked ASIN among ASINs for this search term."},{"type":"NUMBER","name":"click_share","nullable":true,"description":"Click share percentage of the clicked ASIN for this search term."},{"type":"NUMBER","name":"conversion_share","nullable":true,"description":"Conversion share percentage of the clicked ASIN for this search term."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":false,"description":"Daily Brand Analytics search terms report with top clicked ASINs, click share, and conversion share per marketplace.","fetchPeriods":[{"type":"INITIAL","numberOfDays":14},{"type":"RECURRING_DAILY","numberOfDays":1}],"sources":["connections","raw_sp_api_report_brand_analytics_search_terms_daily"],"containsPii":false},{"id":"e49e59add0303062bc38d972142c4d156b59e8deb3ce05526e8cce827095e1ba","name":"Brand Analytics Search Terms (Weekly)","tableName":"amazon_brand_analytics_search_terms_weekly","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"DATE","name":"date","nullable":false,"description":"First day of the week the data refers to. Represents an aggregated weekly snapshot. Data availability can lag, so use MAX(date) for the most recent week."},{"type":"DATE","name":"start_date","nullable":true,"description":"Start date of the reporting period."},{"type":"DATE","name":"end_date","nullable":true,"description":"End date of the reporting period."},{"type":"TEXT","name":"department_name","nullable":false,"description":"Amazon browse department name for the search term."},{"type":"TEXT","name":"search_term","nullable":false,"description":"Customer search query."},{"type":"NUMBER","name":"search_frequency_rank","nullable":true,"description":"Search frequency rank for the search term (lower is more popular)."},{"type":"TEXT","name":"clicked_asin","nullable":false,"description":"Child ASIN that received clicks for this search term."},{"type":"NUMBER","name":"click_share_rank","nullable":true,"description":"Click share rank of the clicked ASIN among ASINs for this search term."},{"type":"NUMBER","name":"click_share","nullable":true,"description":"Click share percentage of the clicked ASIN for this search term."},{"type":"NUMBER","name":"conversion_share","nullable":true,"description":"Conversion share percentage of the clicked ASIN for this search term."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":false,"description":"Weekly Brand Analytics search terms report with top clicked ASINs, click share, and conversion share per marketplace.","fetchPeriods":[{"type":"INITIAL","numberOfDays":56},{"type":"RECURRING_WEEKLY","numberOfDays":7,"shiftDays":7}],"sources":["connections","raw_sp_api_report_brand_analytics_search_terms_weekly"],"containsPii":false},{"id":"ac6a07d258e44bd72f5ce8edc55d715650607617a4ed42b1459a416e6fb5e412","name":"Brand Analytics Search Terms (Monthly)","tableName":"amazon_brand_analytics_search_terms_monthly","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"DATE","name":"date","nullable":false,"description":"First day of the month the data refers to. Represents an aggregated monthly snapshot. Data availability can lag, so use MAX(date) for the most recent month."},{"type":"DATE","name":"start_date","nullable":true,"description":"Start date of the reporting period."},{"type":"DATE","name":"end_date","nullable":true,"description":"End date of the reporting period."},{"type":"TEXT","name":"department_name","nullable":false,"description":"Amazon browse department name for the search term."},{"type":"TEXT","name":"search_term","nullable":false,"description":"Customer search query."},{"type":"NUMBER","name":"search_frequency_rank","nullable":true,"description":"Search frequency rank for the search term (lower is more popular)."},{"type":"TEXT","name":"clicked_asin","nullable":false,"description":"Child ASIN that received clicks for this search term."},{"type":"NUMBER","name":"click_share_rank","nullable":true,"description":"Click share rank of the clicked ASIN among ASINs for this search term."},{"type":"NUMBER","name":"click_share","nullable":true,"description":"Click share percentage of the clicked ASIN for this search term."},{"type":"NUMBER","name":"conversion_share","nullable":true,"description":"Conversion share percentage of the clicked ASIN for this search term."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":false,"description":"Monthly Brand Analytics search terms report with top clicked ASINs, click share, and conversion share per marketplace.","fetchPeriods":[{"type":"INITIAL","numberOfDays":365},{"type":"RECURRING_MONTHLY","numberOfDays":30,"shiftDays":30}],"sources":["connections","raw_sp_api_report_brand_analytics_search_terms_monthly"],"containsPii":false},{"id":"68d2de238e8d1a47bc56a981a99d54558507b0bafb1e09f1b3e95fb7750a17a8","name":"Product Catalog by ASIN","tableName":"amazon_products_by_child_asin","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"parent_asin","nullable":false,"description":null},{"type":"TEXT","name":"amazon_product_type","nullable":false,"description":null},{"type":"TEXT","name":"product_name","nullable":false,"description":null},{"type":"TEXT","name":"product_root_category_name","nullable":false,"description":null},{"type":"TEXT","name":"product_node_category_name","nullable":false,"description":null},{"type":"NUMBER","name":"product_root_best_selling_rank","nullable":false,"description":null},{"type":"NUMBER","name":"product_node_best_selling_rank","nullable":false,"description":null},{"type":"TEXT","name":"product_brand","nullable":false,"description":null},{"type":"TEXT","name":"product_color","nullable":false,"description":null},{"type":"TEXT","name":"product_model_number","nullable":false,"description":null},{"type":"DATE","name":"product_release_date","nullable":false,"description":null},{"type":"TEXT","name":"product_size","nullable":false,"description":null},{"type":"TEXT","name":"product_style","nullable":false,"description":null},{"type":"TEXT","name":"product_bullet_point_1","nullable":false,"description":null},{"type":"TEXT","name":"product_bullet_point_2","nullable":false,"description":null},{"type":"TEXT","name":"product_bullet_point_3","nullable":false,"description":null},{"type":"TEXT","name":"product_bullet_point_4","nullable":false,"description":null},{"type":"TEXT","name":"product_bullet_point_5","nullable":false,"description":null},{"type":"TEXT","name":"product_description","nullable":false,"description":null},{"type":"TEXT","name":"product_image_url","nullable":false,"description":null},{"type":"TEXT","name":"product_url","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Catalog data for all child products (ASINs). Includes searchable text columns.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["refined_products_by_child_asin"],"containsPii":false},{"id":"0e1ea34395ebb2b2658f4636d7fbdb9381d985eabeaea87aafa49335a92ff551","name":"Product Catalog by ASIN (Raw JSON)","tableName":"amazon_products_raw","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"parent_asin","nullable":false,"description":null},{"type":"TEXT","name":"amazon_product_type","nullable":false,"description":null},{"type":"JSON","name":"attributes","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"classifications","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"dimensions","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"identifiers","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"images","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"TEXT","name":"product_type","nullable":false,"description":null},{"type":"JSON","name":"sales_ranks","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"summaries","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"relationships","nullable":true,"description":"Same as JSON payload from Amazon SP API."}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Raw catalog payload projected per child ASIN and marketplace. Recommended for advanced use cases. For most use cases, use the \"amazon_products_by_child_asin\" table instead. For AI agents: each row from this table has a lot of data, consider downloading it to file and not directly to the context.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["refined_products_by_child_asin"],"containsPii":false},{"id":"6cdde992a36bdedb6fbd17bbcd294941dbf55ac504302db9b232dc0887f1598a","name":"Sellers & Vendors Context","tableName":"amazon_sellers_and_vendors_context","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"connection_context_id","nullable":false,"description":"DataDoe connection context identifier. Falls back to connection_id when no explicit context is set."},{"type":"TEXT","name":"connection_context_name","nullable":false,"description":"DataDoe connection context display name. Falls back to connection_name or connection_id when no explicit context name is set."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"selling_partner_id","nullable":true,"description":"Amazon selling partner identifier from the connection."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":false,"description":"Connection context mapping for all Amazon integrations. One row per connection with seller/vendor context identifiers, connection IDs (Seller Central, Vendor Central, Ads), selling partner ID, marketplace seller ID, ads profile ID and marketplace. Use to resolve seller_or_vendor_id and join across datasets.","fetchPeriods":[],"sources":["connections"],"containsPii":false},{"id":"8dd5813be06d8679ce99c1e0b09a998c8332efda20a2abc9eaa8787f81c2a064","name":"Cost of Goods Sold (COGS)","tableName":"amazon_cogs","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"DATE","name":"from","nullable":false,"description":null},{"type":"NUMBER","name":"cost_item_value","nullable":false,"description":null},{"type":"NUMBER","name":"cost_item_shipping_value","nullable":false,"description":null},{"type":"TEXT","name":"cost_currency","nullable":false,"description":null},{"type":"TEXT","name":"item_supplier_name","nullable":true,"description":"Supplier name for the item COGS, if provided in COGS upload."}],"userManaged":true,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Detailed data about cost of goods sold (COGS) per SKU.","fetchPeriods":[],"sources":["connections","raw_amazon_cogs"],"containsPii":false},{"id":"88e554542fab92541ca2423f3a230813ad57bb3e156207038fb3f7169b9e879d","name":"Order Details PII","tableName":"amazon_orders_details","type":"SELLER_CENTRAL","columns":[{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_order_id","nullable":false,"description":null},{"type":"DATE","name":"amazon_order_updated_at","nullable":false,"description":null},{"type":"TEXT","name":"amazon_order_status","nullable":true,"description":null},{"type":"TEXT","name":"buyer_email","nullable":true,"description":"Hashed email address of the buyer. Same value across all orders from the same buyer; NULL for FBA orders. Non-null values are a safe grouping key for customer identity, retention, repeat purchase and CLV analysis."},{"type":"TEXT","name":"buyer_name","nullable":true,"description":null},{"type":"TEXT","name":"buyer_company_name","nullable":true,"description":null},{"type":"TEXT","name":"buyer_purchase_order_number","nullable":true,"description":null},{"type":"TEXT","name":"recipient_name","nullable":true,"description":null},{"type":"TEXT","name":"recipient_company_name","nullable":true,"description":null},{"type":"TEXT","name":"recipient_address_line1","nullable":true,"description":null},{"type":"TEXT","name":"recipient_address_line2","nullable":true,"description":null},{"type":"TEXT","name":"recipient_address_line3","nullable":true,"description":null},{"type":"TEXT","name":"recipient_city","nullable":true,"description":null},{"type":"TEXT","name":"recipient_district_or_county","nullable":true,"description":null},{"type":"TEXT","name":"recipient_state_or_region","nullable":true,"description":null},{"type":"TEXT","name":"recipient_municipality","nullable":true,"description":null},{"type":"TEXT","name":"recipient_postal_code","nullable":true,"description":null},{"type":"TEXT","name":"recipient_country_code","nullable":true,"description":null},{"type":"TEXT","name":"recipient_phone","nullable":true,"description":null},{"type":"TEXT","name":"recipient_address_type","nullable":true,"description":null},{"type":"JSON","name":"recipient_extended_fields","nullable":true,"description":null},{"type":"JSON","name":"order_items_gift_messages","nullable":true,"description":null},{"type":"JSON","name":"order_items_customized_urls","nullable":true,"description":null},{"type":"DATE","name":"order_date","nullable":false,"description":"Duplicate of date column. Prefer to use date column for date filtering."}],"userManaged":false,"isPremium":true,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Order-level customer and shipping PII details. An extension of `amazon_order_items_with_cogs` table.","fetchPeriods":[{"type":"CONTINUOUS"}],"dataAvailability":{"type":"REAL_TIME","description":"Data is available up to 1 hour after the order is fetched."},"sources":["connections","raw_sp_api_orders_details_pii"],"containsPii":true},{"id":"8723a9f82b37438b5224867ac182d2e773bea12532b9f5ad2930811a6f219f90","name":"Repeat Purchase Performance","tableName":"amazon_repeat_purchase_report","type":"VENDOR_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"NUMBER","name":"number_of_orders","nullable":false,"description":null},{"type":"NUMBER","name":"number_of_unique_customers","nullable":false,"description":null},{"type":"NUMBER","name":"repeat_customers_score_total","nullable":false,"description":"If this field is >0, it indicates that repeat customers made purchases."},{"type":"NUMBER","name":"repeat_purchase_revenue_amount","nullable":false,"description":null},{"type":"TEXT","name":"repeat_purchase_revenue_currency","nullable":false,"description":null},{"type":"NUMBER","name":"repeat_purchase_revenue_score_total","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":"First day of the month the data refers to."}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Monthly repeat purchase performance per child_asin. Use \"repeat_customers_score_total\" column to identify if there were repeat customers.","fetchPeriods":[{"type":"INITIAL","numberOfDays":365},{"type":"RECURRING_WEEKLY","numberOfDays":90}],"sources":["connections","raw_sp_api_report_brand_analytics_repeat_purchase"],"containsPii":false},{"id":"21aa739348f0c2d2dcebd1215736d082e346ef9cdd69b6ef509464f1cd249b0b","name":"Market Basket Co-Purchase (Monthly)","tableName":"amazon_market_basket_by_child_asin","type":"VENDOR_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"purchased_with_child_asin","nullable":false,"description":null},{"type":"NUMBER","name":"purchased_with_rank","nullable":false,"description":null},{"type":"NUMBER","name":"purchased_with_combination_score","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":"First day of the month the data refers to."}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Monthly market basket analysis per child ASIN.","fetchPeriods":[{"type":"INITIAL","numberOfDays":365},{"type":"RECURRING_WEEKLY","numberOfDays":90}],"sources":["connections","raw_sp_api_report_brand_analytics_market_basket_by_month"],"containsPii":false},{"id":"d8f74544e6a856dfb6ab916ae57310fa11a74d237c00c0b20a72bfd8d0a26ce8","name":"Brand Analytics Search Terms (Daily)","tableName":"amazon_brand_analytics_search_terms_daily","type":"VENDOR_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"DATE","name":"date","nullable":false,"description":"Reporting date for the daily snapshot. Data availability can lag, so use MAX(date) for the most recent day."},{"type":"DATE","name":"start_date","nullable":true,"description":"Start date of the reporting period."},{"type":"DATE","name":"end_date","nullable":true,"description":"End date of the reporting period."},{"type":"TEXT","name":"department_name","nullable":false,"description":"Amazon browse department name for the search term."},{"type":"TEXT","name":"search_term","nullable":false,"description":"Customer search query."},{"type":"NUMBER","name":"search_frequency_rank","nullable":true,"description":"Search frequency rank for the search term (lower is more popular)."},{"type":"TEXT","name":"clicked_asin","nullable":false,"description":"Child ASIN that received clicks for this search term."},{"type":"NUMBER","name":"click_share_rank","nullable":true,"description":"Click share rank of the clicked ASIN among ASINs for this search term."},{"type":"NUMBER","name":"click_share","nullable":true,"description":"Click share percentage of the clicked ASIN for this search term."},{"type":"NUMBER","name":"conversion_share","nullable":true,"description":"Conversion share percentage of the clicked ASIN for this search term."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":false,"description":"Daily Brand Analytics search terms report with top clicked ASINs, click share, and conversion share per marketplace.","fetchPeriods":[{"type":"INITIAL","numberOfDays":14},{"type":"RECURRING_DAILY","numberOfDays":1}],"sources":["connections","raw_sp_api_report_brand_analytics_search_terms_daily"],"containsPii":false},{"id":"e49e59add0303062bc38d972142c4d156b59e8deb3ce05526e8cce827095e1ba","name":"Brand Analytics Search Terms (Weekly)","tableName":"amazon_brand_analytics_search_terms_weekly","type":"VENDOR_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"DATE","name":"date","nullable":false,"description":"First day of the week the data refers to. Represents an aggregated weekly snapshot. Data availability can lag, so use MAX(date) for the most recent week."},{"type":"DATE","name":"start_date","nullable":true,"description":"Start date of the reporting period."},{"type":"DATE","name":"end_date","nullable":true,"description":"End date of the reporting period."},{"type":"TEXT","name":"department_name","nullable":false,"description":"Amazon browse department name for the search term."},{"type":"TEXT","name":"search_term","nullable":false,"description":"Customer search query."},{"type":"NUMBER","name":"search_frequency_rank","nullable":true,"description":"Search frequency rank for the search term (lower is more popular)."},{"type":"TEXT","name":"clicked_asin","nullable":false,"description":"Child ASIN that received clicks for this search term."},{"type":"NUMBER","name":"click_share_rank","nullable":true,"description":"Click share rank of the clicked ASIN among ASINs for this search term."},{"type":"NUMBER","name":"click_share","nullable":true,"description":"Click share percentage of the clicked ASIN for this search term."},{"type":"NUMBER","name":"conversion_share","nullable":true,"description":"Conversion share percentage of the clicked ASIN for this search term."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":false,"description":"Weekly Brand Analytics search terms report with top clicked ASINs, click share, and conversion share per marketplace.","fetchPeriods":[{"type":"INITIAL","numberOfDays":56},{"type":"RECURRING_WEEKLY","numberOfDays":7,"shiftDays":7}],"sources":["connections","raw_sp_api_report_brand_analytics_search_terms_weekly"],"containsPii":false},{"id":"ac6a07d258e44bd72f5ce8edc55d715650607617a4ed42b1459a416e6fb5e412","name":"Brand Analytics Search Terms (Monthly)","tableName":"amazon_brand_analytics_search_terms_monthly","type":"VENDOR_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"DATE","name":"date","nullable":false,"description":"First day of the month the data refers to. Represents an aggregated monthly snapshot. Data availability can lag, so use MAX(date) for the most recent month."},{"type":"DATE","name":"start_date","nullable":true,"description":"Start date of the reporting period."},{"type":"DATE","name":"end_date","nullable":true,"description":"End date of the reporting period."},{"type":"TEXT","name":"department_name","nullable":false,"description":"Amazon browse department name for the search term."},{"type":"TEXT","name":"search_term","nullable":false,"description":"Customer search query."},{"type":"NUMBER","name":"search_frequency_rank","nullable":true,"description":"Search frequency rank for the search term (lower is more popular)."},{"type":"TEXT","name":"clicked_asin","nullable":false,"description":"Child ASIN that received clicks for this search term."},{"type":"NUMBER","name":"click_share_rank","nullable":true,"description":"Click share rank of the clicked ASIN among ASINs for this search term."},{"type":"NUMBER","name":"click_share","nullable":true,"description":"Click share percentage of the clicked ASIN for this search term."},{"type":"NUMBER","name":"conversion_share","nullable":true,"description":"Conversion share percentage of the clicked ASIN for this search term."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":false,"description":"Monthly Brand Analytics search terms report with top clicked ASINs, click share, and conversion share per marketplace.","fetchPeriods":[{"type":"INITIAL","numberOfDays":365},{"type":"RECURRING_MONTHLY","numberOfDays":30,"shiftDays":30}],"sources":["connections","raw_sp_api_report_brand_analytics_search_terms_monthly"],"containsPii":false},{"id":"68d2de238e8d1a47bc56a981a99d54558507b0bafb1e09f1b3e95fb7750a17a8","name":"Product Catalog by ASIN","tableName":"amazon_products_by_child_asin","type":"VENDOR_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"parent_asin","nullable":false,"description":null},{"type":"TEXT","name":"amazon_product_type","nullable":false,"description":null},{"type":"TEXT","name":"product_name","nullable":false,"description":null},{"type":"TEXT","name":"product_root_category_name","nullable":false,"description":null},{"type":"TEXT","name":"product_node_category_name","nullable":false,"description":null},{"type":"NUMBER","name":"product_root_best_selling_rank","nullable":false,"description":null},{"type":"NUMBER","name":"product_node_best_selling_rank","nullable":false,"description":null},{"type":"TEXT","name":"product_brand","nullable":false,"description":null},{"type":"TEXT","name":"product_color","nullable":false,"description":null},{"type":"TEXT","name":"product_model_number","nullable":false,"description":null},{"type":"DATE","name":"product_release_date","nullable":false,"description":null},{"type":"TEXT","name":"product_size","nullable":false,"description":null},{"type":"TEXT","name":"product_style","nullable":false,"description":null},{"type":"TEXT","name":"product_bullet_point_1","nullable":false,"description":null},{"type":"TEXT","name":"product_bullet_point_2","nullable":false,"description":null},{"type":"TEXT","name":"product_bullet_point_3","nullable":false,"description":null},{"type":"TEXT","name":"product_bullet_point_4","nullable":false,"description":null},{"type":"TEXT","name":"product_bullet_point_5","nullable":false,"description":null},{"type":"TEXT","name":"product_description","nullable":false,"description":null},{"type":"TEXT","name":"product_image_url","nullable":false,"description":null},{"type":"TEXT","name":"product_url","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Catalog data for all child products (ASINs). Includes searchable text columns.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["refined_products_by_child_asin"],"containsPii":false},{"id":"0e1ea34395ebb2b2658f4636d7fbdb9381d985eabeaea87aafa49335a92ff551","name":"Product Catalog by ASIN (Raw JSON)","tableName":"amazon_products_raw","type":"VENDOR_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"parent_asin","nullable":false,"description":null},{"type":"TEXT","name":"amazon_product_type","nullable":false,"description":null},{"type":"JSON","name":"attributes","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"classifications","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"dimensions","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"identifiers","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"images","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"TEXT","name":"product_type","nullable":false,"description":null},{"type":"JSON","name":"sales_ranks","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"summaries","nullable":true,"description":"Same as JSON payload from Amazon SP API."},{"type":"JSON","name":"relationships","nullable":true,"description":"Same as JSON payload from Amazon SP API."}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Raw catalog payload projected per child ASIN and marketplace. Recommended for advanced use cases. For most use cases, use the \"amazon_products_by_child_asin\" table instead. For AI agents: each row from this table has a lot of data, consider downloading it to file and not directly to the context.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["refined_products_by_child_asin"],"containsPii":false},{"id":"38bf00dd3a174c214a8450350ce9ec8cc27e612b2f699575787106f6a21db5b2","name":"Weekly Customer Demand","tableName":"amazon_vendor_forecasting","type":"VENDOR_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"start_forecasting_date","nullable":false,"description":"Start date of the week for which the forecast is made in YYYY-MM-DD format."},{"type":"TEXT","name":"end_forecasting_date","nullable":false,"description":"End date of the week for which the forecast is made in YYYY-MM-DD format."},{"type":"TEXT","name":"selling_program","nullable":false,"description":"The selling program associated with the ASIN. Available values: RETAIL"},{"type":"NUMBER","name":"weekly_forecast_mean_expected_customer_demand_units","nullable":false,"description":"Mean forecasted units demand for the week."},{"type":"NUMBER","name":"weekly_forecast_70_confidence_level_customer_demand_units","nullable":false,"description":"70% confidence level forecasted units demand for the week."},{"type":"NUMBER","name":"weekly_forecast_80_confidence_level_customer_demand_units","nullable":false,"description":"80% confidence level forecasted units demand for the week."},{"type":"NUMBER","name":"weekly_forecast_90_confidence_level_customer_demand_units","nullable":false,"description":"90% confidence level forecasted units demand for the week."},{"type":"DATE","name":"date","nullable":false,"description":"Date of forecast generation. Use MAX(date) for the latest forecast."}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Forecast for weekly demand/sales per child ASIN. Table includes current and historical forecasts. Use the latest avaivble date by default","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","raw_sp_api_report_vendor_forecasting_retail"],"containsPii":false},{"id":"875ac0f7400a8a3932ec8141e6b6c226a156ef2cedf3a1779e8f81781c0dd00a","name":"Sales, Traffic & Inventory by ASIN & Date","tableName":"amazon_vendor_sales_traffic_and_inventory_by_child_and_date","type":"VENDOR_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"NUMBER","name":"glance_views","nullable":false,"description":null},{"type":"NUMBER","name":"net_pure_product_margin","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_customer_returns","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_shipped_cogs","nullable":false,"description":null},{"type":"TEXT","name":"manufacturing_retail_shipped_cogs_currency","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_shipped_revenue","nullable":false,"description":null},{"type":"TEXT","name":"manufacturing_retail_shipped_revenue_currency","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_shipped_units","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_customer_returns","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_shipped_cogs","nullable":false,"description":null},{"type":"TEXT","name":"sourcing_retail_shipped_cogs_currency","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_shipped_revenue","nullable":false,"description":null},{"type":"TEXT","name":"sourcing_retail_shipped_revenue_currency","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_shipped_units","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_vendor_confirmation_rate","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_net_received_inventory_cost","nullable":false,"description":null},{"type":"TEXT","name":"manufacturing_retail_net_received_inventory_cost_currency","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_net_received_inventory_units","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_open_purchase_order_units","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_average_vendor_lead_time_days","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_sell_through_rate","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_unfilled_customer_ordered_units","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_sellable_on_hand_inventory_cost","nullable":false,"description":null},{"type":"TEXT","name":"manufacturing_retail_sellable_on_hand_inventory_cost_currency","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_sellable_on_hand_inventory_units","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_unsellable_on_hand_inventory_cost","nullable":false,"description":null},{"type":"TEXT","name":"manufacturing_retail_unsellable_on_hand_inventory_cost_currency","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_unsellable_on_hand_inventory_units","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_aged_90_plus_days_sellable_inventory_cost","nullable":false,"description":null},{"type":"TEXT","name":"manufacturing_retail_aged_90_plus_days_sellable_inventory_cost_currency","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_aged_90_plus_days_sellable_inventory_units","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_unhealthy_inventory_cost","nullable":false,"description":null},{"type":"TEXT","name":"manufacturing_retail_unhealthy_inventory_cost_currency","nullable":false,"description":null},{"type":"NUMBER","name":"manufacturing_retail_unhealthy_inventory_units","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_vendor_confirmation_rate","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_net_received_inventory_cost","nullable":false,"description":null},{"type":"TEXT","name":"sourcing_retail_net_received_inventory_cost_currency","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_net_received_inventory_units","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_open_purchase_order_units","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_average_vendor_lead_time_days","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_sell_through_rate","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_unfilled_customer_ordered_units","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_sellable_on_hand_inventory_cost","nullable":false,"description":null},{"type":"TEXT","name":"sourcing_retail_sellable_on_hand_inventory_cost_currency","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_sellable_on_hand_inventory_units","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_unsellable_on_hand_inventory_cost","nullable":false,"description":null},{"type":"TEXT","name":"sourcing_retail_unsellable_on_hand_inventory_cost_currency","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_unsellable_on_hand_inventory_units","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_aged_90_plus_days_sellable_inventory_cost","nullable":false,"description":null},{"type":"TEXT","name":"sourcing_retail_aged_90_plus_days_sellable_inventory_cost_currency","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_aged_90_plus_days_sellable_inventory_units","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_unhealthy_inventory_cost","nullable":false,"description":null},{"type":"TEXT","name":"sourcing_retail_unhealthy_inventory_cost_currency","nullable":false,"description":null},{"type":"NUMBER","name":"sourcing_retail_unhealthy_inventory_units","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Daily sales, traffic and inventory metrics per child ASIN.","fetchPeriods":[{"type":"INITIAL","numberOfDays":735,"shiftDays":4},{"type":"RECURRING_DAILY","numberOfDays":14,"shiftDays":4}],"sources":["connections","raw_sp_api_report_vendor_inventory_manufacturing_retail","raw_sp_api_report_vendor_inventory_sourcing_retail","raw_sp_api_report_vendor_net_pure_product_margin","raw_sp_api_report_vendor_sales_manufacturing_retail","raw_sp_api_report_vendor_sales_sourcing_retail","raw_sp_api_report_vendor_traffic"],"containsPii":false},{"id":"6deb661209df982eaba69d8624bbd9b31d112a67163fc45f02bb3bc1958a9ca7","name":"Real-Time Sales by ASIN & Hour","tableName":"amazon_vendor_real_time_sales","type":"VENDOR_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"asin","nullable":false,"description":null},{"type":"DATE","name":"start_time","nullable":false,"description":"Start of the hourly reporting window."},{"type":"DATE","name":"end_time","nullable":false,"description":"End of the hourly reporting window."},{"type":"DATE","name":"date","nullable":false,"description":"UTC calendar day of start_time. Use for date filtering."},{"type":"NUMBER","name":"ordered_units","nullable":false,"description":null},{"type":"NUMBER","name":"ordered_revenue","nullable":false,"description":null},{"type":"TEXT","name":"ordered_revenue_currency","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Hourly ordered units and revenue per ASIN.","fetchPeriods":[{"type":"INITIAL","numberOfDays":28,"shiftDays":4},{"type":"RECURRING_DAILY","numberOfDays":3,"shiftDays":4},{"type":"RECURRING_MONTHLY","numberOfDays":28,"shiftDays":4}],"sources":["connections","raw_sp_api_report_vendor_real_time_sales"],"containsPii":false},{"id":"25b8d04247fe4b4c096d3f58bbb577fd41c23c4c9da93bd232134a468c2fde9d","name":"Real-Time Traffic by ASIN & Hour","tableName":"amazon_vendor_real_time_traffic","type":"VENDOR_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"asin","nullable":false,"description":null},{"type":"DATE","name":"start_time","nullable":false,"description":"Start of the hourly reporting window."},{"type":"DATE","name":"end_time","nullable":false,"description":"End of the hourly reporting window."},{"type":"DATE","name":"date","nullable":false,"description":"UTC calendar day of start_time. Use for date filtering."},{"type":"NUMBER","name":"glance_views","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Hourly glance views per ASIN.","fetchPeriods":[{"type":"INITIAL","numberOfDays":28,"shiftDays":4},{"type":"RECURRING_DAILY","numberOfDays":3,"shiftDays":4},{"type":"RECURRING_MONTHLY","numberOfDays":28,"shiftDays":4}],"sources":["connections","raw_sp_api_report_vendor_real_time_traffic"],"containsPii":false},{"id":"a56e22527075e070599d6d314d30eba4a0ad7474192df1b61ce74ba424d19b7f","name":"Real-Time Inventory by ASIN & Hour","tableName":"amazon_vendor_real_time_inventory","type":"VENDOR_CENTRAL","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"asin","nullable":false,"description":null},{"type":"DATE","name":"start_time","nullable":false,"description":"Start of the hourly reporting window."},{"type":"DATE","name":"end_time","nullable":false,"description":"End of the hourly reporting window."},{"type":"DATE","name":"date","nullable":false,"description":"UTC calendar day of start_time. Use for date filtering."},{"type":"NUMBER","name":"highly_available_inventory_units","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Hourly highly available inventory units per ASIN.","fetchPeriods":[{"type":"INITIAL","numberOfDays":28,"shiftDays":4},{"type":"RECURRING_DAILY","numberOfDays":3,"shiftDays":4},{"type":"RECURRING_MONTHLY","numberOfDays":28,"shiftDays":4}],"sources":["connections","raw_sp_api_report_vendor_real_time_inventory"],"containsPii":false},{"id":"6cdde992a36bdedb6fbd17bbcd294941dbf55ac504302db9b232dc0887f1598a","name":"Sellers & Vendors Context","tableName":"amazon_sellers_and_vendors_context","type":"VENDOR_CENTRAL","columns":[{"type":"TEXT","name":"connection_context_id","nullable":false,"description":"DataDoe connection context identifier. Falls back to connection_id when no explicit context is set."},{"type":"TEXT","name":"connection_context_name","nullable":false,"description":"DataDoe connection context display name. Falls back to connection_name or connection_id when no explicit context name is set."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"selling_partner_id","nullable":true,"description":"Amazon selling partner identifier from the connection."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":false,"description":"Connection context mapping for all Amazon integrations. One row per connection with seller/vendor context identifiers, connection IDs (Seller Central, Vendor Central, Ads), selling partner ID, marketplace seller ID, ads profile ID and marketplace. Use to resolve seller_or_vendor_id and join across datasets.","fetchPeriods":[],"sources":["connections"],"containsPii":false},{"id":"d0017e92fb089c2c8c3fe65f81d08666ecb4fe937ffbce9969ce2fc7d28c805c","name":"Ad Performance by ASIN & Date","tableName":"amazon_ads_performance_by_child_asin_and_date","type":"AMAZON_ADS","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":"Single date may repeat."},{"type":"TEXT","name":"product_name","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_type","nullable":false,"description":"SPONSORED_DISPLAY / SPONSORED_PRODUCTS (no SPONSORED_BRANDS)"},{"type":"TEXT","name":"ad_portfolio_id","nullable":true,"description":"Portfolio ID for SPONSORED_PRODUCTS campaigns. For SPONSORED_DISPLAY this field is always NULL."},{"type":"TEXT","name":"ad_portfolio_name","nullable":true,"description":"Portfolio name for SPONSORED_PRODUCTS campaigns. For SPONSORED_DISPLAY this field is always NULL."},{"type":"NUMBER","name":"ad_sales_same_sku","nullable":false,"description":null},{"type":"NUMBER","name":"ad_clicks","nullable":false,"description":null},{"type":"NUMBER","name":"ad_impressions","nullable":false,"description":null},{"type":"NUMBER","name":"ad_spend","nullable":false,"description":null},{"type":"NUMBER","name":"ad_units_sold_same_sku","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_same_sku","nullable":false,"description":null},{"type":"NUMBER","name":"ad_campaign_budget_amount","nullable":false,"description":"Total campaign budget."},{"type":"TEXT","name":"ad_campaign_budget_type","nullable":true,"description":"DAILY_BUDGET / LIFETIME_BUDGET or NULL."},{"type":"TEXT","name":"ad_campaign_budget_currency","nullable":false,"description":"Currency code."},{"type":"TEXT","name":"ad_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_id","nullable":true,"description":"Campaign ID for SPONSORED_PRODUCTS campaigns. Null for SPONSORED_DISPLAY."},{"type":"TEXT","name":"ad_campaign_name","nullable":true,"description":"Campaign name for SPONSORED_PRODUCTS campaigns. Null for SPONSORED_DISPLAY."},{"type":"TEXT","name":"ad_campaign_status","nullable":true,"description":"Campaign status for SPONSORED_PRODUCTS campaigns. Null for SPONSORED_DISPLAY."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Ads performance metrics per child ASIN and date for Sponsored Products and Sponsored Display campaigns. For cumulative (not per-ASIN data use amazon_ads_performance_by_campaign_by_date. Use this one only if per-ASIN data is required.","fetchPeriods":[{"type":"INITIAL","numberOfDays":60},{"type":"RECURRING_DAILY","numberOfDays":21},{"type":"RECURRING_MONTHLY","numberOfDays":49}],"dataAvailability":{"type":"INTRADAY","description":"Intraday updates are available when source data changes during the day.","refreshAt":"1pm"},"sources":["connections","raw_ads_api_report_advertised_products_sd","raw_ads_api_report_advertised_products_sp","refined_products_by_child_asin"],"containsPii":false},{"id":"08cdc77d3dc24a7651553e2e926f598188c66172f64cd6512265900af6073a6c","name":"Ad Performance by Campaign & Date","tableName":"amazon_ads_performance_by_campaign_by_date","type":"AMAZON_ADS","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_type","nullable":false,"description":"SPONSORED_DISPLAY / SPONSORED_PRODUCTS / SPONSORED_BRANDS"},{"type":"NUMBER","name":"ad_clicks","nullable":false,"description":null},{"type":"NUMBER","name":"ad_sales","nullable":false,"description":"Attributed ad sales (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_impressions","nullable":false,"description":null},{"type":"NUMBER","name":"ad_spend","nullable":false,"description":null},{"type":"NUMBER","name":"ad_units_sold","nullable":false,"description":"Attributed ad units sold (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_orders","nullable":false,"description":"Attributed ad orders (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"TEXT","name":"ad_campaign_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_name","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_status","nullable":false,"description":null},{"type":"NUMBER","name":"ad_campaign_budget_amount","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_budget_type","nullable":true,"description":"DAILY_BUDGET / LIFETIME_BUDGET or NULL."},{"type":"TEXT","name":"ad_campaign_budget_currency","nullable":false,"description":null},{"type":"NUMBER","name":"ad_gross_impressions","nullable":false,"description":null},{"type":"NUMBER","name":"ad_invalid_impressions","nullable":false,"description":null},{"type":"NUMBER","name":"ad_invalid_impression_rate","nullable":false,"description":null},{"type":"NUMBER","name":"ad_gross_click_throughs","nullable":false,"description":null},{"type":"NUMBER","name":"ad_invalid_click_throughs","nullable":false,"description":null},{"type":"NUMBER","name":"ad_invalid_click_through_rate","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":true,"description":"Ads performance metrics per campaign and date.","fetchPeriods":[{"type":"INITIAL","numberOfDays":56},{"type":"RECURRING_DAILY","numberOfDays":21},{"type":"RECURRING_MONTHLY","numberOfDays":49}],"dataAvailability":{"type":"INTRADAY","description":"Intraday updates are available when source data changes during the day.","refreshAt":"1pm"},"sources":["connections","raw_ads_api_report_campaign_sd","raw_ads_api_report_campaign_sp","raw_ads_api_report_gross_and_invalid_traffic_sb","raw_ads_api_report_gross_and_invalid_traffic_sd","raw_ads_api_report_gross_and_invalid_traffic_sp","raw_ads_api_report_legacy_campaign_sb_all"],"containsPii":false},{"id":"bbba3d213ac78ccbaf22cfa68eecb3f475641f49da26d51d1ac36446310051e3","name":"Keyword Targeting Performance","tableName":"amazon_ads_targeting_by_campaign_by_date","type":"AMAZON_ADS","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"ad_targeting_text","nullable":false,"description":null},{"type":"TEXT","name":"ad_targeting_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_keyword_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_keyword","nullable":false,"description":"Advertised keyword (user-friendly)."},{"type":"TEXT","name":"ad_keyword_expression","nullable":false,"description":null},{"type":"TEXT","name":"ad_keyword_status","nullable":false,"description":null},{"type":"TEXT","name":"ad_match_type","nullable":false,"description":null},{"type":"TEXT","name":"ad_matched_target_asin","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_name","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_type","nullable":false,"description":null},{"type":"TEXT","name":"ad_portfolio_id","nullable":true,"description":"Portfolio ID for SPONSORED_PRODUCTS campaigns. For SPONSORED_BRANDS and SPONSORED_DISPLAY this field is always NULL."},{"type":"TEXT","name":"ad_portfolio_name","nullable":true,"description":"Portfolio name for SPONSORED_PRODUCTS campaigns. For SPONSORED_BRANDS and SPONSORED_DISPLAY this field is always NULL."},{"type":"TEXT","name":"ad_campaign_status","nullable":false,"description":null},{"type":"NUMBER","name":"ad_campaign_budget_amount","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_budget_type","nullable":true,"description":null},{"type":"TEXT","name":"ad_campaign_budget_currency","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_name","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders","nullable":false,"description":"Attributed ad orders (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_orders_same_sku","nullable":false,"description":null},{"type":"NUMBER","name":"ad_units_sold_click","nullable":false,"description":null},{"type":"NUMBER","name":"ad_sales","nullable":false,"description":"Attributed ad sales (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_spend","nullable":false,"description":null},{"type":"NUMBER","name":"ad_impressions","nullable":false,"description":null},{"type":"NUMBER","name":"ad_clicks","nullable":false,"description":null},{"type":"NUMBER","name":"ad_top_of_search_impression_share","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Keyword targeting data per campaign and date.","fetchPeriods":[{"type":"INITIAL","numberOfDays":56},{"type":"RECURRING_DAILY","numberOfDays":21},{"type":"RECURRING_MONTHLY","numberOfDays":49}],"sources":["connections","raw_ads_api_report_legacy_targeting_sb_all","raw_ads_api_report_targeting_sd","raw_ads_api_report_targeting_sp"],"containsPii":false},{"id":"e94e9671989ce4aa2814ac729807c7ddcc1cc47a71ebcd75d9fe661ed80335be","name":"Search Term Performance (Ads)","tableName":"amazon_ads_search_terms_by_campaign_by_date","type":"AMAZON_ADS","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"ad_targeting_text","nullable":false,"description":null},{"type":"TEXT","name":"ad_keyword_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_keyword","nullable":false,"description":null},{"type":"TEXT","name":"ad_keyword_status","nullable":false,"description":null},{"type":"TEXT","name":"ad_search_term","nullable":false,"description":null},{"type":"TEXT","name":"ad_search_term_no","nullable":false,"description":"Identifier for de-duplication of search terms."},{"type":"TEXT","name":"ad_match_type","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_name","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_type","nullable":false,"description":"SPONSORED_BRANDS or SPONSORED_PRODUCTS."},{"type":"TEXT","name":"ad_portfolio_id","nullable":true,"description":"Portfolio ID for SPONSORED_PRODUCTS campaigns. For SPONSORED_BRANDS this field is always NULL."},{"type":"TEXT","name":"ad_portfolio_name","nullable":true,"description":"Portfolio name for SPONSORED_PRODUCTS campaigns. For SPONSORED_BRANDS this field is always NULL."},{"type":"TEXT","name":"ad_campaign_status","nullable":false,"description":null},{"type":"NUMBER","name":"ad_campaign_budget_amount","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_budget_type","nullable":true,"description":null},{"type":"TEXT","name":"ad_campaign_budget_currency","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_name","nullable":false,"description":null},{"type":"NUMBER","name":"ad_units_sold_click","nullable":false,"description":null},{"type":"NUMBER","name":"ad_sales","nullable":false,"description":"Attributed ad sales (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_orders","nullable":false,"description":"Attributed ad orders (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_orders_same_sku","nullable":false,"description":null},{"type":"NUMBER","name":"ad_spend","nullable":false,"description":null},{"type":"NUMBER","name":"ad_impressions","nullable":false,"description":null},{"type":"NUMBER","name":"ad_clicks","nullable":false,"description":null},{"type":"NUMBER","name":"ad_click_through_rate","nullable":false,"description":null},{"type":"NUMBER","name":"ad_keyword_bid","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Performance data about search terms matched to advertised keywords.","fetchPeriods":[{"type":"INITIAL","numberOfDays":60},{"type":"RECURRING_DAILY","numberOfDays":21},{"type":"RECURRING_MONTHLY","numberOfDays":49}],"sources":["connections","raw_ads_api_report_legacy_search_term_sb_all","raw_ads_api_report_search_term_sp"],"containsPii":false},{"id":"3d720918e6b132db7d3b6edfb912428256b79d3cfba20f5bd2617037bf0cc5ef","name":"Ad Placement Performance (Sponsored Brands and Sponsored Products)","tableName":"amazon_ads_placement_by_campaign_by_date","type":"AMAZON_ADS","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_type","nullable":false,"description":"SPONSORED_BRANDS or SPONSORED_PRODUCTS"},{"type":"TEXT","name":"ad_campaign_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_name","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_status","nullable":false,"description":null},{"type":"TEXT","name":"ad_placement_classification","nullable":false,"description":null},{"type":"NUMBER","name":"ad_impressions","nullable":false,"description":null},{"type":"NUMBER","name":"ad_viewable_impressions","nullable":false,"description":null},{"type":"NUMBER","name":"ad_clicks","nullable":false,"description":null},{"type":"NUMBER","name":"ad_spend","nullable":false,"description":null},{"type":"NUMBER","name":"ad_sales","nullable":false,"description":"Attributed ad sales (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_sales_same_sku","nullable":false,"description":null},{"type":"NUMBER","name":"ad_sales_new_to_brand_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_sales_new_to_brand_14d_percentage","nullable":false,"description":null},{"type":"NUMBER","name":"ad_units_sold","nullable":false,"description":"Attributed ad units sold (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_units_sold_new_to_brand_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_units_sold_new_to_brand_14d_percentage","nullable":false,"description":null},{"type":"NUMBER","name":"ad_campaign_budget_amount","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_budget_type","nullable":true,"description":null},{"type":"TEXT","name":"ad_campaign_budget_currency","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders","nullable":false,"description":"Attributed ad orders (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_orders_clicks_only","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_same_sku","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_new_to_brand_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_new_to_brand_14d_percentage","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_new_to_brand_14d_rate","nullable":false,"description":null},{"type":"NUMBER","name":"ad_viewability_rate","nullable":false,"description":null},{"type":"NUMBER","name":"ad_view_click_through_rate","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_complete_views","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_first_quartile_views","nullable":false,"description":null},{"type":"NUMBER","name":"ad_branded_searches","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video5_second_views","nullable":false,"description":null},{"type":"NUMBER","name":"ad_branded_searches_clicks","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_unmutes","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_third_quartile_views","nullable":false,"description":null},{"type":"NUMBER","name":"ad_detail_page_views_clicks","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_midpoint_views","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_5_second_view_rate","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Placement performance for SPONSORED_BRANDS and SPONSORED_PRODUCTS campaigns.","fetchPeriods":[{"type":"INITIAL","numberOfDays":56},{"type":"RECURRING_DAILY","numberOfDays":28},{"type":"RECURRING_MONTHLY","numberOfDays":56}],"sources":["connections","raw_ads_api_report_campaign_placement_sp","raw_ads_api_report_legacy_placement_sb_all"],"containsPii":false},{"id":"0dd6cbf08cefd9a67f6dd262de499b5cc512e1440da09091eaa47a07db879795","name":"Sponsored Brands Ad Performance","tableName":"amazon_ads_sponsored_brands_by_ad_by_date","type":"AMAZON_ADS","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"ad_id","nullable":false,"description":null},{"type":"NUMBER","name":"ad_impressions","nullable":false,"description":null},{"type":"NUMBER","name":"ad_spend","nullable":false,"description":null},{"type":"NUMBER","name":"ad_sales","nullable":false,"description":"Attributed ad sales (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_sales_same_sku","nullable":false,"description":null},{"type":"NUMBER","name":"ad_units_sold","nullable":false,"description":"Attributed ad units sold (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_clicks","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders","nullable":false,"description":"Attributed ad orders (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_orders_same_sku","nullable":false,"description":null},{"type":"NUMBER","name":"ad_campaign_budget_amount","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_budget_type","nullable":true,"description":null},{"type":"TEXT","name":"ad_campaign_budget_currency","nullable":false,"description":null},{"type":"NUMBER","name":"ad_new_to_brand_sales_clicks","nullable":false,"description":null},{"type":"NUMBER","name":"ad_viewability_rate","nullable":false,"description":null},{"type":"NUMBER","name":"ad_new_to_brand_sales_percentage","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_status","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_name","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_id","nullable":false,"description":null},{"type":"NUMBER","name":"ad_new_to_brand_purchases_percentage","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_complete_views","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_first_quartile_views","nullable":false,"description":null},{"type":"NUMBER","name":"ad_new_to_brand_purchases_rate","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video5_second_views","nullable":false,"description":null},{"type":"NUMBER","name":"ad_new_to_brand_purchases","nullable":false,"description":null},{"type":"NUMBER","name":"ad_branded_searches_clicks","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_id","nullable":false,"description":null},{"type":"NUMBER","name":"ad_new_to_brand_sales","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_unmutes","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_third_quartile_views","nullable":false,"description":null},{"type":"NUMBER","name":"ad_new_to_brand_units_sold","nullable":false,"description":null},{"type":"NUMBER","name":"ad_viewable_impressions","nullable":false,"description":null},{"type":"NUMBER","name":"ad_detail_page_views_clicks","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_midpoint_views","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_5_second_view_rate","nullable":false,"description":null},{"type":"NUMBER","name":"ad_new_to_brand_units_sold_percentage","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_name","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Performance for SPONSORED_BRANDS ads per ad per date.","fetchPeriods":[{"type":"INITIAL","numberOfDays":56},{"type":"RECURRING_DAILY","numberOfDays":21},{"type":"RECURRING_MONTHLY","numberOfDays":49}],"sources":["connections","raw_ads_api_report_legacy_ad_sb_all"],"containsPii":false},{"id":"7c1ba29e52b0e7b23d559d1e4647e65a05147374fe70d27b32dcc88177593b66","name":"Ad Group Performance","tableName":"amazon_ads_by_ad_group_by_date","type":"AMAZON_ADS","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_name","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_name","nullable":false,"description":null},{"type":"NUMBER","name":"ad_add_to_lists_clicks_only","nullable":false,"description":null},{"type":"NUMBER","name":"ad_branded_searches_clicks_only","nullable":false,"description":null},{"type":"NUMBER","name":"ad_campaign_budget_amount","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_budget_type","nullable":true,"description":null},{"type":"TEXT","name":"ad_campaign_budget_currency","nullable":false,"description":null},{"type":"NUMBER","name":"ad_clicks","nullable":false,"description":null},{"type":"NUMBER","name":"ad_spend","nullable":false,"description":null},{"type":"NUMBER","name":"ad_impressions","nullable":false,"description":null},{"type":"NUMBER","name":"ad_detail_page_views_clicks_only","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders","nullable":false,"description":"Attributed ad orders (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_orders_new_to_brand_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_new_to_brand_14d_clicks_only","nullable":false,"description":null},{"type":"NUMBER","name":"ad_units_sold","nullable":false,"description":"Attributed ad units sold (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_units_sold_new_to_brand_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_five_second_view_rate","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_five_second_views","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_complete_views","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_first_quartile_views","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_midpoint_views","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_third_quartile_views","nullable":false,"description":null},{"type":"NUMBER","name":"ad_video_unmutes","nullable":false,"description":null},{"type":"NUMBER","name":"ad_viewability_rate","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_type","nullable":false,"description":null},{"type":"NUMBER","name":"ad_sales","nullable":false,"description":"Attributed ad sales (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS)."},{"type":"NUMBER","name":"ad_sales_new_to_brand_14d","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Performance for ad groups in SPONSORED_BRANDS and SPONSORED_DISPLAY campaigns.","fetchPeriods":[{"type":"INITIAL","numberOfDays":56},{"type":"RECURRING_DAILY","numberOfDays":21},{"type":"RECURRING_MONTHLY","numberOfDays":49}],"sources":["connections","raw_ads_api_report_ad_group_sd","raw_ads_api_report_legacy_ad_group_sb_all"],"containsPii":false},{"id":"90b696e336f05b1a7f1684519cbaa63052a8e6452ede2d66aa41bfa92dfcfec3","name":"Ad Campaigns (raw)","tableName":"amazon_ads_campaigns_raw","type":"AMAZON_ADS","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"TEXT","name":"ad_campaign_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_name","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_type","nullable":true,"description":"SPONSORED_DISPLAY / SPONSORED_PRODUCTS / SPONSORED_BRANDS"},{"type":"TEXT","name":"ad_portfolio_id","nullable":true,"description":null},{"type":"TEXT","name":"ad_portfolio_name","nullable":true,"description":null},{"type":"DATE","name":"ad_campaign_start_date","nullable":true,"description":null},{"type":"DATE","name":"ad_campaign_end_date","nullable":true,"description":null},{"type":"DATE","name":"ad_campaign_updated_at_utc","nullable":false,"description":null},{"type":"DATE","name":"ad_campaign_created_at_utc","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_state","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_delivery_status","nullable":false,"description":null},{"type":"JSON","name":"ad_campaign_delivery_reasons","nullable":true,"description":"Same as JSON payload from Amazon Ads API."},{"type":"TEXT","name":"ad_campaign_brand_entity_id","nullable":true,"description":null},{"type":"TEXT","name":"ad_campaign_optimization_bid_strategy","nullable":true,"description":null},{"type":"JSON","name":"ad_campaign_optimization_placement_bid_adjustments","nullable":true,"description":"Placement bid adjustments from campaign optimization settings. Same as JSON payload from Amazon Ads API."},{"type":"JSON","name":"ad_campaign_optimization_shopper_segment_bid_adjustment","nullable":true,"description":"Shopper segment bid adjustment from campaign optimization settings. Same as JSON payload from Amazon Ads API."},{"type":"JSON","name":"ad_campaign_optimization_shopper_cohort_bid_adjustment","nullable":true,"description":"Shopper cohort bid adjustment from campaign optimization settings. Same as JSON payload from Amazon Ads API."},{"type":"JSON","name":"ad_campaign_budget_caps","nullable":true,"description":"Same as JSON payload from Amazon Ads API."},{"type":"TEXT","name":"ad_campaign_targeting_settings","nullable":true,"description":null},{"type":"TEXT","name":"ad_campaign_cost_type","nullable":true,"description":null},{"type":"JSON","name":"ad_campaign_tags","nullable":true,"description":"Same as JSON payload from Amazon Ads API."}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Snapshots of Amazon Ads campaign configuration and settings. Rows are identified by campaign, ad product, and state.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","raw_ads_api_export_campaigns"],"containsPii":false},{"id":"4ce1ac7e86bf8900ebeb2fd716e8538184fb75794ba3072136beb43be515a256","name":"Ad Groups (raw)","tableName":"amazon_ads_ad_groups_raw","type":"AMAZON_ADS","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"TEXT","name":"ad_group_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_name","nullable":true,"description":null},{"type":"TEXT","name":"ad_campaign_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_type","nullable":false,"description":"SPONSORED_DISPLAY / SPONSORED_PRODUCTS / SPONSORED_BRANDS"},{"type":"TEXT","name":"ad_group_creative_type","nullable":true,"description":null},{"type":"DATE","name":"ad_group_updated_at_utc","nullable":false,"description":null},{"type":"DATE","name":"ad_group_created_at_utc","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_state","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_delivery_status","nullable":false,"description":null},{"type":"JSON","name":"ad_group_delivery_reasons","nullable":true,"description":"Same as JSON payload from Amazon Ads API."},{"type":"NUMBER","name":"ad_group_default_bid","nullable":true,"description":null},{"type":"TEXT","name":"ad_group_bid_currency_code","nullable":true,"description":null},{"type":"TEXT","name":"ad_group_optimization_goal","nullable":true,"description":null},{"type":"TEXT","name":"ad_group_optimization_kpi","nullable":true,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Snapshots of Amazon Ads ad group configuration and settings. Rows are identified by ad group and ad product.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","raw_ads_api_export_ad_groups"],"containsPii":false},{"id":"d78c8d084a149700169a6acec6fc7c76c06849a4ee60e376eeb4b77e12c81595","name":"Ads (raw)","tableName":"amazon_ads_ads_raw","type":"AMAZON_ADS","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"TEXT","name":"ad_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_name","nullable":true,"description":null},{"type":"TEXT","name":"ad_group_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_type","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_type","nullable":false,"description":"SPONSORED_DISPLAY / SPONSORED_PRODUCTS / SPONSORED_BRANDS"},{"type":"TEXT","name":"ad_version_id","nullable":true,"description":null},{"type":"DATE","name":"ad_updated_at_utc","nullable":false,"description":null},{"type":"DATE","name":"ad_created_at_utc","nullable":false,"description":null},{"type":"TEXT","name":"ad_state","nullable":false,"description":null},{"type":"TEXT","name":"ad_delivery_status","nullable":false,"description":null},{"type":"JSON","name":"ad_delivery_reasons","nullable":true,"description":"Same as JSON payload from Amazon Ads API."},{"type":"TEXT","name":"ad_creative_headline","nullable":true,"description":null},{"type":"TEXT","name":"ad_creative_brand_name","nullable":true,"description":null},{"type":"TEXT","name":"ad_creative_landing_page_type","nullable":true,"description":null},{"type":"TEXT","name":"ad_creative_landing_page_url","nullable":true,"description":null},{"type":"TEXT","name":"ad_creative_brand_logo_asset_id","nullable":true,"description":null},{"type":"TEXT","name":"ad_creative_brand_logo_asset_version","nullable":true,"description":null},{"type":"NUMBER","name":"ad_creative_brand_logo_top","nullable":true,"description":null},{"type":"NUMBER","name":"ad_creative_brand_logo_left","nullable":true,"description":null},{"type":"NUMBER","name":"ad_creative_brand_logo_width","nullable":true,"description":null},{"type":"NUMBER","name":"ad_creative_brand_logo_height","nullable":true,"description":null},{"type":"JSON","name":"ad_creative_products","nullable":true,"description":"Same as JSON payload from Amazon Ads API."},{"type":"JSON","name":"ad_creative_custom_images","nullable":true,"description":"Same as JSON payload from Amazon Ads API."},{"type":"JSON","name":"ad_creative_videos","nullable":true,"description":"Same as JSON payload from Amazon Ads API."},{"type":"JSON","name":"ad_creative_cards","nullable":true,"description":"Same as JSON payload from Amazon Ads API."}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Snapshots of Amazon Ads ad configuration and creative settings. Rows are identified by ad, ad product, and ad type.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","raw_ads_api_export_ads"],"containsPii":false},{"id":"bd819066dbd89514f573530c0f1463fc6b37881a79b2fa010dcd1d9f5afdf213","name":"Ad Targets (raw)","tableName":"amazon_ads_targets_raw","type":"AMAZON_ADS","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"TEXT","name":"ad_target_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_id","nullable":true,"description":null},{"type":"TEXT","name":"ad_campaign_id","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_type","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_type","nullable":false,"description":"SPONSORED_DISPLAY / SPONSORED_PRODUCTS / SPONSORED_BRANDS"},{"type":"LOGIC","name":"ad_target_negative","nullable":true,"description":null},{"type":"DATE","name":"ad_target_updated_at_utc","nullable":false,"description":null},{"type":"DATE","name":"ad_target_created_at_utc","nullable":false,"description":null},{"type":"TEXT","name":"ad_target_state","nullable":false,"description":null},{"type":"TEXT","name":"ad_target_delivery_status","nullable":false,"description":null},{"type":"TEXT","name":"ad_target_delivery_reasons","nullable":true,"description":null},{"type":"NUMBER","name":"ad_target_bid","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_currency_code","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_match_type","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_keyword","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_native_language_keyword","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_native_language_locale","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_product_category_id","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_product_category_resolved","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_product_brand","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_product_brand_resolved","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_product_genre","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_product_price_less_than","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_product_price_greater_than","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_product_rating_less_than","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_product_rating_greater_than","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_product_age_range","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_product_age_range_resolved","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_product_prime_shipping_eligible","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_asin","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_event","nullable":true,"description":null},{"type":"NUMBER","name":"ad_target_lookback","nullable":true,"description":null},{"type":"TEXT","name":"ad_target_audience_id","nullable":true,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Snapshots of Amazon Ads targeting configuration (keywords, product targets, audiences). Rows are identified by target and ad product.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","raw_ads_api_export_targets"],"containsPii":false},{"id":"7dca257b8f728ceacaed3bb4d4830dd530858d073392455fb43a3ec579b0f947","name":"Ad Purchased Products","tableName":"amazon_ads_purchased_products","type":"AMAZON_ADS","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_type","nullable":false,"description":"SPONSORED_DISPLAY / SPONSORED_PRODUCTS"},{"type":"TEXT","name":"ad_campaign_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_name","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_name","nullable":false,"description":null},{"type":"TEXT","name":"currency_code","nullable":true,"description":null},{"type":"TEXT","name":"ad_purchased_asin","nullable":false,"description":null},{"type":"TEXT","name":"ad_keyword_id","nullable":true,"description":"Null for SPONSORED_DISPLAY"},{"type":"TEXT","name":"ad_target_id","nullable":true,"description":"Null for SPONSORED_DISPLAY"},{"type":"TEXT","name":"ad_keyword","nullable":true,"description":"Null for SPONSORED_DISPLAY"},{"type":"TEXT","name":"ad_match_type","nullable":true,"description":"Null for SPONSORED_DISPLAY"},{"type":"TEXT","name":"ad_targeting_text","nullable":true,"description":"Null for SPONSORED_DISPLAY"},{"type":"TEXT","name":"ad_keyword_type","nullable":true,"description":"Null for SPONSORED_DISPLAY"},{"type":"TEXT","name":"ad_portfolio_id","nullable":true,"description":"Null for SPONSORED_DISPLAY"},{"type":"TEXT","name":"ad_targeting_expression","nullable":true,"description":"Null for SPONSORED_DISPLAY"},{"type":"TEXT","name":"ad_promoted_asin","nullable":true,"description":null},{"type":"TEXT","name":"ad_promoted_sku","nullable":true,"description":null},{"type":"NUMBER","name":"ad_keyword_no","nullable":true,"description":null},{"type":"NUMBER","name":"ad_orders","nullable":true,"description":"Attributed ad orders (14d for SPONSORED_PRODUCTS and Null for SPONSORED_DISPLAY)."},{"type":"NUMBER","name":"ad_orders_other_sku","nullable":true,"description":"Attributed ad orders where SKU is different from promoted one (14d for SPONSORED_PRODUCTS and SPONSORED_DISPLAY)."},{"type":"NUMBER","name":"ad_sales","nullable":true,"description":"Attributed ad sales (14d for SPONSORED_PRODUCTS, Null for SPONSORED_DISPLAY)."},{"type":"NUMBER","name":"ad_sales_other_sku","nullable":true,"description":"Attributed ad sales where SKU is different from promoted one (14d for SPONSORED_PRODUCTS and SPONSORED_DISPLAY)."},{"type":"NUMBER","name":"ad_units_sold","nullable":true,"description":"Attributed ad units sold (14d for SPONSORED_PRODUCTS and Null for SPONSORED_DISPLAY)."},{"type":"NUMBER","name":"ad_units_sold_other_sku","nullable":true,"description":"Attributed ad units sold where SKU is different from promoted one (14d for SPONSORED_PRODUCTS and SPONSORED_DISPLAY)."}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Attributed purchases of other ASINs from Sponsored Products and Sponsored Display campaigns.","fetchPeriods":[{"type":"INITIAL","numberOfDays":60},{"type":"RECURRING_DAILY","numberOfDays":21},{"type":"RECURRING_MONTHLY","numberOfDays":49}],"dataAvailability":{"type":"INTRADAY","description":"Intraday updates are available when source data changes during the day.","refreshAt":"1pm"},"sources":["connections","raw_ads_api_report_purchased_products_sd","raw_ads_api_report_purchased_products_sp"],"containsPii":false},{"id":"36596ff85ecdded5d4b949bf7c0bbd9bc88398dc4a5ec8c3db88ab010fbe6f3c","name":"Negative Keywords","tableName":"amazon_ads_negative_keywords","type":"AMAZON_ADS","columns":[{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"marketplace_country_code","nullable":false,"description":"ISO country code for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"marketplace_country_name","nullable":false,"description":"Human-readable country name for the marketplace (derived from marketplace_id)."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_campaign_type","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_id","nullable":true,"description":"Null for SPONSORED_PRODUCTS campaigns before 2026-07-01."},{"type":"TEXT","name":"ad_keyword_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_keyword_text","nullable":false,"description":null},{"type":"TEXT","name":"ad_match_type","nullable":false,"description":null},{"type":"TEXT","name":"ad_keyword_state","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"defaultDataset":false,"enabled":true,"rowCountBilling":true,"description":"Negative keywords for campaigns.","fetchPeriods":[{"type":"CONTINUOUS"}],"sources":["connections","refined_ads_negative_keywords"],"containsPii":false},{"id":"6cdde992a36bdedb6fbd17bbcd294941dbf55ac504302db9b232dc0887f1598a","name":"Sellers & Vendors Context","tableName":"amazon_sellers_and_vendors_context","type":"AMAZON_ADS","columns":[{"type":"TEXT","name":"connection_context_id","nullable":false,"description":"DataDoe connection context identifier. Falls back to connection_id when no explicit context is set."},{"type":"TEXT","name":"connection_context_name","nullable":false,"description":"DataDoe connection context display name. Falls back to connection_name or connection_id when no explicit context name is set."},{"type":"TEXT","name":"seller_or_vendor_id","nullable":false,"description":"DataDoe connection context identifier for the seller or vendor."},{"type":"TEXT","name":"seller_or_vendor_name","nullable":false,"description":"DataDoe connection context display name for the seller or vendor."},{"type":"TEXT","name":"selling_partner_id","nullable":true,"description":"Amazon selling partner identifier from the connection."},{"type":"TEXT","name":"marketplace_seller_id","nullable":true,"description":"Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID."},{"type":"TEXT","name":"amazon_ads_profile_id","nullable":true,"description":"Amazon Ads profile identifier."},{"type":"TEXT","name":"marketplace_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."}],"userManaged":false,"isPremium":false,"defaultDataset":true,"enabled":true,"rowCountBilling":false,"description":"Connection context mapping for all Amazon integrations. One row per connection with seller/vendor context identifiers, connection IDs (Seller Central, Vendor Central, Ads), selling partner ID, marketplace seller ID, ads profile ID and marketplace. Use to resolve seller_or_vendor_id and join across datasets.","fetchPeriods":[],"sources":["connections"],"containsPii":false}],"recommendedSources":[]}