[{"id":"8723a9f82b","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":"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,"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}]},{"id":"21aa739348","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":"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,"description":"Monthly market basket analysis per child ASIN.","fetchPeriods":[{"type":"INITIAL","numberOfDays":365},{"type":"RECURRING_WEEKLY","numberOfDays":90}]},{"id":"401ffcd7e5","name":"Sales & Traffic by ASIN & Date","tableName":"amazon_sales_and_traffic_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":"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":"DATE","name":"date","nullable":false,"description":"Single date may occur multiple times."},{"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."}],"userManaged":false,"isPremium":false,"description":"Sales and traffic metrics per child ASIN and date.","fetchPeriods":[{"type":"INITIAL","numberOfDays":60},{"type":"RECURRING_DAILY","numberOfDays":4},{"type":"RECURRING_MONTHLY","numberOfDays":30,"shiftDays":4}]},{"id":"89b27535d2","name":"Order Line Items","tableName":"amazon_order_items_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_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"amazon_order_id","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"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":"order_updated_at","nullable":false,"description":null},{"type":"TEXT","name":"order_status","nullable":false,"description":"'Pending', 'Shipped' or 'Cancelled'"},{"type":"TEXT","name":"fulfillment_channel","nullable":false,"description":"'Amazon' or 'Merchant'"},{"type":"TEXT","name":"order_channel","nullable":false,"description":"'MOBILEAPP', 'WEBSITE' or 'OTHER'"},{"type":"TEXT","name":"ship_service_level","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":"item_status","nullable":false,"description":"'Unshipped', 'Shipping', 'Shipped' or 'Canceled'"},{"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":"TEXT","name":"buyer_email","nullable":true,"description":"Hashed email address of the buyer. Same value across all orders from the same buyer; NULL if absent. Non-null values are a safe grouping key for customer identity, retention, repeat purchase and CLV analysis."},{"type":"LOGIC","name":"order_is_prime","nullable":false,"description":null},{"type":"LOGIC","name":"order_is_premium","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":"Single date may occur multiple times."},{"type":"DATE","name":"order_date","nullable":false,"description":"Duplicate of date column. Prefer to use date column for date filtering."},{"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."}],"userManaged":false,"isPremium":false,"description":"Log of all orders per order id and order item. Aggregate this table to get order level data.","fetchPeriods":[{"type":"INITIAL","numberOfDays":730},{"type":"RECURRING_DAILY","numberOfDays":28}]},{"id":"68d2de238e","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":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"parent_asin","nullable":false,"description":null},{"type":"TEXT","name":"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,"description":"Catalog data for all child products (ASINs). Includes searchable text columns.","fetchPeriods":[{"type":"CONTINUOUS"}]},{"id":"0e1ea34395","name":"Product Catalog by ASIN (Raw JSON)","tableName":"amazon_products_raw","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"parent_asin","nullable":false,"description":null},{"type":"TEXT","name":"product_type","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":"productType","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":"JSON","name":"salesRanks","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,"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"}]},{"id":"6ea445cdc4","name":"Listings (Raw JSON)","tableName":"amazon_listings_raw","type":"SELLER_CENTRAL","columns":[{"type":"TEXT","name":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"parent_asin","nullable":false,"description":null},{"type":"TEXT","name":"product_type","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":"productType","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":"JSON","name":"salesRanks","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,"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"}]},{"id":"ba689c05d7","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":"listingId","nullable":false,"description":"Unique identifier for the listing, not the SKU."},{"type":"TEXT","name":"sku","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":"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."}],"userManaged":false,"isPremium":false,"description":"Data about own listings.","fetchPeriods":[{"type":"CONTINUOUS"}]},{"id":"d190d57b01","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":"shipment_id","nullable":false,"description":null},{"type":"TEXT","name":"order_id","nullable":true,"description":null},{"type":"TEXT","name":"external_reference_id","nullable":true,"description":null},{"type":"TEXT","name":"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":"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,"description":"AWD inbound shipments by shipment id.","fetchPeriods":[{"type":"CONTINUOUS"}]},{"id":"b7080fc32e","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":"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,"description":"AWD inbound shipment line items by shipment id and line item number.","fetchPeriods":[{"type":"CONTINUOUS"}]},{"id":"cedb259753","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":"order_id","nullable":false,"description":null},{"type":"TEXT","name":"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,"description":"AWD replenishment orders by order id.","fetchPeriods":[{"type":"CONTINUOUS"}]},{"id":"85aeada68a","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":"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":"shipment_id","nullable":true,"description":null},{"type":"TEXT","name":"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,"description":"AWD replenishment order line items by order id and line item number.","fetchPeriods":[{"type":"CONTINUOUS"}]},{"id":"2a81389e42","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_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"country_code","nullable":false,"description":null},{"type":"TEXT","name":"asin","nullable":false,"description":null},{"type":"TEXT","name":"sku","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,"description":"Daily inventory data for all FBA listings per country.","fetchPeriods":[{"type":"RECURRING_DAILY","numberOfDays":1}]},{"id":"44fc5ba0ce","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":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"sku","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":"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":"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":null},{"type":"NUMBER","name":"reserved_fc_transfer","nullable":false,"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,"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}]},{"id":"d7716dee8f","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":"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_code","nullable":false,"description":"Currency code."}],"userManaged":false,"isPremium":false,"description":"Daily overage fee charges based on FBA storage usage limits.","fetchPeriods":[{"type":"INITIAL","numberOfDays":1},{"type":"RECURRING_DAILY","numberOfDays":1}]},{"id":"829e34f54e","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":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"fnsku","nullable":false,"description":null},{"type":"TEXT","name":"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,"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}]},{"id":"6a6e14526d","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":"DATE","name":"date","nullable":false,"description":null},{"type":"TEXT","name":"fnsku","nullable":false,"description":null},{"type":"TEXT","name":"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,"description":"Daily FBA ledger details with per-event inventory movements, references, and reconciliation quantities.","fetchPeriods":[{"type":"INITIAL","numberOfDays":56},{"type":"RECURRING_DAILY","numberOfDays":7}]},{"id":"316ea56bca","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":"child_asin","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":"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,"description":"Daily FBA storage fee charges with historical data.","fetchPeriods":[{"type":"INITIAL","numberOfDays":-1},{"type":"RECURRING_DAILY","numberOfDays":1}]},{"id":"4e67eb700f","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":"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":"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":"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,"description":"Daily long-term FBA storage fee charges with historical data.","fetchPeriods":[{"type":"INITIAL","numberOfDays":730},{"type":"RECURRING_DAILY","numberOfDays":30}]},{"id":"13b0fdeaff","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":"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,"description":"Daily FBA reimbursements with historical data.","fetchPeriods":[{"type":"INITIAL","numberOfDays":730},{"type":"RECURRING_DAILY","numberOfDays":30}]},{"id":"27c6fc0ec6","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_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"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":"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":"amazon_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."}],"userManaged":false,"isPremium":false,"description":"Data about all returns (FBA & FBM).","fetchPeriods":[{"type":"INITIAL","numberOfDays":60},{"type":"RECURRING_DAILY","numberOfDays":60}]},{"id":"57036be081","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_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"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,"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}]},{"id":"8772614caf","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":"child_asin","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":"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,"description":"Monthly search engagement metrics for child ASINs (organic + ads).","fetchPeriods":[{"type":"INITIAL","numberOfDays":365},{"type":"RECURRING_WEEKLY","numberOfDays":90}]},{"id":"732dac689a","name":"Settlements & P&L Components","tableName":"amazon_settlements_with_cogs","type":"SELLER_CENTRAL","columns":[{"type":"DATE","name":"date","nullable":false,"description":"Single date may occur multiple times."},{"type":"DATE","name":"order_date","nullable":false,"description":"Date of the order if the row is related to an order. May be different from the date of the settlement."},{"type":"TEXT","name":"settlement_type","nullable":false,"description":"ORDER, REFUND or OTHER."},{"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":"sku","nullable":false,"description":null},{"type":"TEXT","name":"child_asin","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":"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":"TEXT","name":"merchant_order_id","nullable":false,"description":"Private seller order id."},{"type":"TEXT","name":"currency","nullable":false,"description":"Currency code."},{"type":"NUMBER","name":"total","nullable":false,"description":"Sum of all amounts in the row. May be a negative number. To determine value of fees subtract \"item_price\" from this amount."},{"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":"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":"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":"fba_awd_processing_fee","nullable":false,"description":null},{"type":"NUMBER","name":"fba_awd_storage_fee","nullable":false,"description":null},{"type":"NUMBER","name":"fba_awd_transportation_fee","nullable":false,"description":null},{"type":"NUMBER","name":"fba_awd_processing_fee_discount","nullable":false,"description":null},{"type":"NUMBER","name":"fba_awd_storage_fee_discount","nullable":false,"description":null},{"type":"NUMBER","name":"fba_awd_transportation_fee_discount","nullable":false,"description":null},{"type":"NUMBER","name":"fba_other","nullable":false,"description":null},{"type":"NUMBER","name":"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":"promotion","nullable":false,"description":null},{"type":"NUMBER","name":"goodwill","nullable":false,"description":null},{"type":"NUMBER","name":"refund_commission","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}],"userManaged":false,"isPremium":false,"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"}]},{"id":"57a0cb319c","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":"DATE","name":"date","nullable":false,"description":"Each combination of marketplace, connection, child ASIN, SKU and date has a single row."},{"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":"ad_sales_14d","nullable":false,"description":"14-day attributed ad sales."},{"type":"NUMBER","name":"ad_spend","nullable":false,"description":"Attributed ad spend."},{"type":"NUMBER","name":"ad_orders_14d","nullable":false,"description":"14-day attributed ad orders."},{"type":"NUMBER","name":"ad_clicks","nullable":false,"description":"Attributed ad clicks."},{"type":"NUMBER","name":"ad_impressions","nullable":false,"description":"Attributed ad impressions."}],"userManaged":false,"isPremium":true,"description":"Daily profit and cost breakdown per SKU and child ASIN based on shipped orders, settlements fees, COGS and ads spend.","fetchPeriods":[{"type":"CONTINUOUS"}]},{"id":"81aa5b4cc2","name":"Organic Search Ranks 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":"child_asin","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":"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":"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."}],"userManaged":false,"isPremium":false,"description":"Weekly organic search performance for child ASINs.","fetchPeriods":[{"type":"INITIAL","numberOfDays":28},{"type":"RECURRING_WEEKLY","numberOfDays":7,"shiftDays":7}]},{"id":"df4160ff8e","name":"Organic Search Ranks 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":"child_asin","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":"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":"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,"description":"Monthly organic search performance for child ASINs.","fetchPeriods":[{"type":"INITIAL","numberOfDays":90,"shiftDays":30},{"type":"RECURRING_MONTHLY","numberOfDays":30,"shiftDays":30}]},{"id":"8dd5813be0","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":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"sku","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":"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}],"userManaged":true,"isPremium":false,"description":"Detailed data about cost of goods sold (COGS) per SKU.","fetchPeriods":[]},{"id":"88e554542f","name":"Order Details PII","tableName":"amazon_orders_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_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"amazon_order_id","nullable":false,"description":null},{"type":"DATE","name":"order_updated_at","nullable":false,"description":null},{"type":"TEXT","name":"order_status","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_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":"date","nullable":false,"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":false,"description":"Order-level customer and shipping PII details. An extension of `amazon_order_items_with_cogs` table.","fetchPeriods":[{"type":"CONTINUOUS"}]},{"id":"8723a9f82b","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":"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,"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}]},{"id":"21aa739348","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":"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,"description":"Monthly market basket analysis per child ASIN.","fetchPeriods":[{"type":"INITIAL","numberOfDays":365},{"type":"RECURRING_WEEKLY","numberOfDays":90}]},{"id":"38bf00dd3a","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_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"type":"TEXT","name":"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,"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"}]},{"id":"875ac0f740","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":"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},{"type":"DATE","name":"date","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"description":"Daily sales, traffic and inventory metrics per child ASIN.","fetchPeriods":[{"type":"INITIAL","numberOfDays":735,"shiftDays":4},{"type":"RECURRING_DAILY","numberOfDays":14,"shiftDays":4}]},{"id":"d0017e92fb","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":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"sku","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":"child_asin","nullable":false,"description":null},{"type":"TEXT","name":"sku","nullable":false,"description":null},{"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":"NUMBER","name":"ad_sales_14d","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_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_14d","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_id","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":"DATE","name":"date","nullable":false,"description":"Single date may repeat."}],"userManaged":false,"isPremium":false,"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}]},{"id":"08cdc77d3d","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_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"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_14d","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_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_14d","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_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_gross_click_throughs","nullable":false,"description":null},{"type":"NUMBER","name":"ad_invalid_click_throughs","nullable":false,"description":null},{"type":"NUMBER","name":"ad_invalid_impression_rate","nullable":false,"description":null},{"type":"NUMBER","name":"ad_invalid_click_through_rate","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"description":"Ads performance metrics per campaign and date.","fetchPeriods":[{"type":"INITIAL","numberOfDays":56},{"type":"RECURRING_DAILY","numberOfDays":21},{"type":"RECURRING_MONTHLY","numberOfDays":49}]},{"id":"bbba3d213a","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_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"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_status","nullable":false,"description":null},{"type":"TEXT","name":"ad_matched_target_asin","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_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_group_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_name","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_units_sold_click_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_sales_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_same_sku_14d","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_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_keyword","nullable":false,"description":"Advertised keyword (user-friendly)."},{"type":"TEXT","name":"ad_keyword_expression","nullable":false,"description":null},{"type":"TEXT","name":"ad_match_type","nullable":false,"description":null},{"type":"NUMBER","name":"ad_top_of_search_impression_share","nullable":false,"description":null},{"type":"TEXT","name":"ad_targeting_id","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"description":"Keyword targeting data per campaign and date.","fetchPeriods":[{"type":"INITIAL","numberOfDays":56},{"type":"RECURRING_DAILY","numberOfDays":21},{"type":"RECURRING_MONTHLY","numberOfDays":49}]},{"id":"e94e967198","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_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"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_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":"NUMBER","name":"ad_clicks","nullable":false,"description":null},{"type":"NUMBER","name":"ad_impressions","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_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_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_group_id","nullable":false,"description":null},{"type":"TEXT","name":"ad_group_name","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_units_sold_click_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_sales_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_same_sku_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_spend","nullable":false,"description":null},{"type":"NUMBER","name":"ad_keyword_bid","nullable":false,"description":null},{"type":"NUMBER","name":"ad_click_through_rate","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"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}]},{"id":"3d720918e6","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_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"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_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_sales_14d_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_14d","nullable":false,"description":null},{"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_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_14d_clicks_only","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_14d_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},{"type":"DATE","name":"date","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"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}]},{"id":"0dd6cbf08c","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_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"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_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_sales_14d_same_sku","nullable":false,"description":null},{"type":"NUMBER","name":"ad_units_sold_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_clicks","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_orders_14d_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},{"type":"DATE","name":"date","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"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}]},{"id":"7c1ba29e52","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_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"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_14d","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_clicks_only","nullable":false,"description":null},{"type":"NUMBER","name":"ad_units_sold_14d","nullable":false,"description":null},{"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_14d","nullable":false,"description":null},{"type":"NUMBER","name":"ad_sales_new_to_brand_14d","nullable":false,"description":null},{"type":"DATE","name":"date","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"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}]},{"id":"36596ff85e","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_id","nullable":false,"description":"Amazon provided ID that represents a specific country where the Seller or Vendor operates."},{"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."},{"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},{"type":"DATE","name":"date","nullable":false,"description":null}],"userManaged":false,"isPremium":false,"description":"Negative keywords for campaigns.","fetchPeriods":[{"type":"CONTINUOUS"}]}]