Name: Seller Labs Data Hub Data Dictionary
Creator: Seller Labs

Data Dictionary – Seller Labs AI Query Builder

Update Frequency is not data freshness. The Update Frequency column shows how often Seller Labs syncs each table — not how current Amazon’s data is. Amazon publishes most reports on its own delay, shown in the Typical Amazon Lag column: the realistic most-recent date you can expect. That lag is set by Amazon’s reporting pipeline — no tool, including manual report downloads, can retrieve traffic, advertising, or search-term data faster than Amazon releases it.

Marketplace Data

Table Name	Description	Update Frequency	Typical Amazon Lag	Status
venues 17 columns venue_idtypenamemarketplace_namestore_namemerchant_idmarketplace_idadvertising_profile_idcurrencycurrency_symbolcreated_tsdefault_venuetimezonewebsitestatuslocation_idlocation_display	A unique combination of a Seller Account on a specific Marketplace. For example, a seller on both Amazon.com and Amazon.ca has two separate venues. All financial amounts for a venue are in the same currency.	Real-time	Near real-time	Active
listings 18 columns venue_idactivelisting_skuasinparent_asincost_of_goods_productsales_pricebrand_nametitleshort_namesl_product_groupfnskucreated_tsmodified_tsimage_urlvenue_catalog_idquantity_availablelisting_id	Information about listings for sale on a venue, including listing_sku, title, and price.	Daily	~1 day	Active
orders 14 columns order_idvenue_idvenue_order_idtypecreated_tsmodified_tsstatusship_cityship_stateship_zipship_countrytotalbuyer_emailbuyer_language	Top-level order information including order time, customer name, address (as available), and email address.	Every few hours	Near real-time	Active
order_items 23 columns order_idvenue_order_idtypeorder_item_idvenue_idstatuscreated_tsmodified_tslisting_skufulfillment_channeltitlequantityprice_itemprice_shippingprice_taxprice_otherprice_discountprice_allextended_price_allcarriertracking_numberestimated_arrival_datesubscribe_and_save	Detail about each item purchased in an order — SKU, description, pricing, and shipping info such as carrier, tracking number, and delivery date.	Every few hours	Near real-time	Active
settlements 11 columns settlement_idvenue_settlement_idvenue_idmerchant_idstatusstart_tsend_tstotalcurrencyconverted_totalconverted_currency	Groups of transactions called settlements — the amounts ultimately deposited into your bank account.	Every few hours	Near real-time	Active
transaction_types 2 columns eventtype	Data about various transaction events, types, and categorization. Seller Labs has identified more than 150 transaction types across all clients.	Every few hours	Near real-time	Active
transactions 11 columns venue_idsettlement_idsourcecreated_tsorder_idlisting_skupivot_columneventtypedetailamount	Detailed financial information about every transaction that occurs in your connected Amazon marketplace.	Every few hours	Near real-time	Active

Amazon-Specific Data

Table Name	Description	Update Frequency	Typical Amazon Lag	Status
fba_inventory 30 columns report_tsreport_datevenue_idlisting_skuasincost_of_productafn_total_quantityafn_fulfillable_quantityafn_warehouse_quantityafn_reserved_quantityafn_unsellable_quantityafn_inbound_working_quantityafn_inbound_shipped_quantityafn_inbound_receiving_quantityreserved_qtyreserved_customerordersreserved_fc_transfersreserved_fc_processingafn_researching_quantityafn_reserved_future_supplyafn_future_supply_buyableper_unit_volumeconditionfnskuafn_listing_existsmfn_listing_existsmfn_fulfillable_quantitymerchant_idlocation_idlocation_name	Inventory information from warehouses and fulfillment centers. Primarily location + SKU + quantity. Note: `product_name` and `your_price` are not available in this table — join to the `listings` table on `listing_sku` to retrieve the product `title` and `sales_price`.	Twice a day	~1 day	Active
fba_inventory_planning 50 columns venue_idsnapshot_tsmerchant_idregionlisting_skufnskuasininv_conditionavailablepending_removal_quantityinventory_age_0_to_90_daysinventory_age_91_to_180_daysinventory_age_181_to_270_daysinventory_age_271_to_365_daysinventory_age_365_plus_dayscurrencyquantity_to_be_charged_ltsf_9_monthprojected_ltsf_9_monthquantity_to_be_charged_ltsf_12_monthestimated_ltsf_next_chargeunits_shipped_t7units_shipped_t30units_shipped_t60units_shipped_t90alertyour_pricesales_pricelowest_price_new_plus_shippinglowest_price_usedrecommended_actionhealthy_inventory_levelrecommended_sales_pricerecommended_sale_duration_daysrecommended_removal_quantityestimated_cost_savings_of_recommended_actionssell_throughitem_volumevolume_unit_measurementstorage_typestorage_volumemarketplaceproduct_groupsales_rankdays_of_supplyestimated_excess_quantityweeks_of_cover_t30no_sale_last_6_monthsreserved_quantityunfulfillable_quantitycreated_ts	Inventory at Amazon’s fulfillment centers with sellable quantity, units aged 3+, 6+, 9+, and 12+ months, weeks of cover, and Amazon-provided restock recommendations. Useful for estimating long-term storage fees and identifying overstock.	Daily	~1 day	Active
inventory_ledger_history 25 columns datevenue_idlisting_skutotal_quantityending_warehouse_balancestarting_warehouse_balancein_transit_between_warehousesreceiptscustomer_shipmentscustomer_returnsvendor_returnswarehouse_transfer_in_outfoundlostdamageddisposedother_eventsunknown_eventsdispositionasintitlefnskulocation_idlocationmerchant_id	Historical log of the inventory ledger.	Daily	~1 day	Active
amazon_sales_ranks 8 columns idasinvenue_idcategory_namebest_sellers_page_urlnode_typerankingcreated_ts	Sales ranking of ASINs within root and child product categories.	Daily	~1 day	Active
amazon_traffic 23 columns venue_iddateparent_asinchild_asintitlesessionssessions_b2bsession_percentagesession_percentage_b2bpage_viewspage_views_b2bpage_views_percentagepage_views_percentage_b2bbuy_box_percentagebuy_box_percentage_b2bunits_orderedunits_ordered_b2bunit_session_percentageunit_session_percentage_b2bordered_product_salesordered_product_sales_b2btotal_order_itemstotal_order_items_b2b	Data from Seller Central’s Business Reports — sessions, page views, orders, and unit session percentages. Aligns with the “Detail Page Sales and Traffic By Child Item” report. Requires the Brand Analytics role to be granted to Seller Labs.	Daily	~2 days	Active
fba_reimbursements_data 22 columns idvenue_idcreated_tsreport_tsapproval_datereimbursement_idcase_idamazon_order_idreasonlisting_skufnskuasinproduct_nameconditioncurrency_unitamount_per_unitamount_totalquantity_reimbursed_cashquantity_reimbursed_inventoryquantity_reimbursed_totaloriginal_reimbursement_idoriginal_reimbursement_type	Reimbursements issued to sellers in the FBA program. Includes type, amount, relevant dates, and reason — helpful for tracking compensation for losses, damages, or overcharges.	Daily	~1 day	Active
fba_monthly_storage_fees 33 columns venue_idcreated_tssnapshot_datelisting_skuasinfnskuproduct_namefulfillment_centercountry_codelongest_sidemedian_sideshortest_sidemeasurement_unitsweightweight_unitsitem_volumevolume_unitsproduct_size_tieraverage_quantity_on_handaverage_quantity_pending_removalestimated_total_item_volumestorage_utilization_ratiostorage_utilization_ratio_unitsbase_rateutilization_surcharge_ratecurrencyestimated_monthly_storage_feedangerous_goods_storage_typeeligible_for_inventory_discountqualifies_for_inventory_discounttotal_incentive_fee_amountbreakdown_incentive_fee_amountaverage_quantity_customer_orders	Overview of FBA storage fee charges incurred for storing products in Amazon’s fulfillment centers.	Daily	~1 day	Active
aged_inventory_storage_fees 21 columns venue_idcreated_tssnapshot_datelisting_skufnskuasinproduct_nameconditionper_unit_volumecurrencyvolume_unitcountryqty_chargedamount_chargedsurcharge_age_tierrate_surchargeqty_charged_long_time_range_long_term_storage_feeenrolled_in_small_and_lightlong_time_range_long_term_storage_feeshort_time_range_long_term_storage_feeqty_charged_short_time_range_long_term_storage_fee	Storage fees for aging inventory including SKU, product info, volume, charges, and surcharge rates. Formerly called Long Term Storage Fees.	Daily	~1 day	Active
fba_removal_order_detail 18 columns idvenue_idrequest_datelast_updated_datecreated_tsorder_idorder_typeorder_statuslisting_skufnskudispositionrequested_quantitycancelled_quantitydisposed_quantityshipped_quantityin_process_quantityremoval_feecurrency	Detailed data on FBA removal orders including order status, item details (SKU, ASIN, FNSKU), dates, quantities, fees, and currency.	Daily	~1 day	Active
fba_fee_preview 27 columns venue_idreport_tslisting_skufnskuasinamazon_storeproduct_groupbrand_namefulfilled_byyour_pricesales_pricelongest_sidemedian_sideshortest_sidelength_and_girthunit_of_dimensionitem_package_weightunit_of_weightproduct_size_tiercurrencyestimated_fee_totalestimated_referral_fee_per_unitestimated_variable_closing_feeestimated_order_handling_fee_per_orderestimated_pick_pack_fee_per_unitestimated_weight_handling_fee_per_unitexpected_fulfillment_fee_per_unit	Estimated FBA fees including referral fees, order handling, pick and pack, and more. Useful for projecting costs of Amazon’s FBA services.	Daily	~1 day	Active
returns 15 columns order_idvenue_idreturn_tsreturn_idreturn_costcarriertracking_numberasinlisting_skutitlereason_codetypequantitycustomer_commentdisposition	Returns of FBA purchases.	Daily	~1 day	Active
daily_sales_api_revenue 7 columns venue_iddateunit_countorder_item_countorder_countaverage_unit_price_amounttotal_sales_amount	SKU-level sales data retrieved through the Sales API.	Daily	Near real-time	Active
sent_messages_custom 15 columns venue_ididmessage_idorder_idupdated_tsdatestatustosubjectmessageopened_tsunsubscribed_tsfeedback_left_tsreview_left_tsarchived	Historical log of custom messages sent to buyers.	Daily	Near real-time	Active
sent_messages_rar 6 columns order_idvenue_idstatusscheduled_tsforcelast_attempted_ts	Historical log of Request a Review messages sent to buyers.	Daily	Near real-time	Active
search_query_performance 45 columns idvenue_idmodified_tsstart_dateend_dateasinsearch_querysearch_query_scoresearch_query_volumetotal_query_impression_countasin_impression_countasin_impression_sharetotal_click_counttotal_click_rateasin_click_countasin_click_sharetotal_median_click_price_amounttotal_median_click_price_currency_codeasin_median_click_price_amountasin_median_click_price_currency_codetotal_same_day_shipping_click_counttotal_one_day_shipping_click_counttotal_two_day_shipping_click_counttotal_cart_add_counttotal_cart_add_rateasin_cart_add_countasin_cart_add_sharetotal_median_cart_add_price_amounttotal_median_cart_add_price_currency_codeasin_median_cart_add_price_amountasin_median_cart_add_price_currency_codetotal_same_day_shipping_cart_add_counttotal_one_day_shipping_cart_add_counttotal_two_day_shipping_cart_add_counttotal_purchase_counttotal_purchase_rateasin_purchase_countasin_purchase_sharetotal_median_purchase_price_amounttotal_median_purchase_price_currency_codeasin_median_purchase_price_amountasin_median_purchase_price_currency_codetotal_same_day_shipping_purchase_counttotal_one_day_shipping_purchase_counttotal_two_day_shipping_purchase_count	Amazon Brand Analytics Search Query Performance (SQP) data — weekly metrics showing how customers discover and interact with your products in Amazon search, including top search terms, rankings, click share, and conversion share.	Weekly (Tuesdays)	Up to ~1 week	Active
search_query_performance_by_month 45 columns idvenue_idmodified_tsstart_dateend_dateasinsearch_querysearch_query_scoresearch_query_volumetotal_query_impression_countasin_impression_countasin_impression_sharetotal_click_counttotal_click_rateasin_click_countasin_click_sharetotal_median_click_price_amounttotal_median_click_price_currency_codeasin_median_click_price_amountasin_median_click_price_currency_codetotal_same_day_shipping_click_counttotal_one_day_shipping_click_counttotal_two_day_shipping_click_counttotal_cart_add_counttotal_cart_add_rateasin_cart_add_countasin_cart_add_sharetotal_median_cart_add_price_amounttotal_median_cart_add_price_currency_codeasin_median_cart_add_price_amountasin_median_cart_add_price_currency_codetotal_same_day_shipping_cart_add_counttotal_one_day_shipping_cart_add_counttotal_two_day_shipping_cart_add_counttotal_purchase_counttotal_purchase_rateasin_purchase_countasin_purchase_sharetotal_median_purchase_price_amounttotal_median_purchase_price_currency_codeasin_median_purchase_price_amountasin_median_purchase_price_currency_codetotal_same_day_shipping_purchase_counttotal_one_day_shipping_purchase_counttotal_two_day_shipping_purchase_count	Amazon Brand Analytics Search Query Performance (SQP) data — monthly metrics with clean full-month boundaries for trending analysis alongside weekly data. Historic data available up to 17 months back. Updated 3× per month: the 1st, 15th, and last day of the month.	3× per month	Up to ~1 week	Active

Advertising Data

Table Name	Description	Update Frequency	Typical Amazon Lag	Status
portfolios 11 columns venue_idportfolio_idnamebudget_amountbudget_policybudget_start_datebudget_end_datestatecreated_tsmodified_tsserving_status	Campaigns grouped together and linked to a distinct Advertiser Account.	Twice a day	Near real-time	Active
campaigns 20 columns venue_idcampaign_idportfolio_idnamecampaign_typetargeting_typead_formatstatedaily_budgetstart_dateend_datecreated_tsmodified_tsserving_statustarget_acosshort_namebudget_typespending_policybid_optimizationtactic	High-level campaign information including ID, name, and daily budget.	Twice a day	Near real-time	Active
campaign_performance 34 columns venue_idcurrencycampaign_idnamecurrent_statecampaign_typetargeting_typeshort_nameportfolio_namedatemodified_tsimpressionsclickscostunits_sold_1dunits_sold_7dunits_sold_14dunits_sold_30dattributed_sales_1dattributed_sales_7dattributed_sales_30dattributed_sales_matchattributed_sales_1d_same_skuattributed_sales_7d_same_skuattributed_sales_30d_same_skuattributed_conversions_1dattributed_conversions_7dattributed_conversions_30dattributed_conversions_1d_same_skuattributed_conversions_7d_same_skuattributed_conversions_30d_same_skuattributed_conversions_14d_new_to_brandunits_sold_14d_new_to_brandattributed_sales_14d_new_to_brand	Daily performance metrics for campaigns.	Twice a day	~2-3 days	Active
campaign_placement_performance 39 columns venue_idcurrencycampaign_idnamecurrent_statecampaign_typetargeting_typeshort_nameportfolio_namedatemodified_tsplacementimpressionsclickscostunits_sold_1dunits_sold_7dunits_sold_14dunits_sold_30dattributed_sales_1dattributed_sales_7dattributed_sales_14dattributed_sales_30dattributed_sales_matchattributed_sales_1d_same_skuattributed_sales_7d_same_skuattributed_sales_14d_same_skuattributed_sales_30d_same_skuattributed_conversions_1dattributed_conversions_7dattributed_conversions_14dattributed_conversions_30dattributed_conversions_1d_same_skuattributed_conversions_7d_same_skuattributed_conversions_14d_same_skuattributed_conversions_30d_same_skuattributed_conversions_14d_new_to_brandunits_sold_14d_new_to_brandattributed_sales_14d_new_to_brand	Daily campaign metrics split by ad placement (Top of Search, Product Pages, etc.). Unknown placements are excluded.	Twice a day	~2-3 days	Active
adgroups 13 columns venue_idcampaign_idcampaign_namecampaign_typecampaign_targeting_typeadgroup_idtypenamedefault_bidstatecreated_tsmodified_tsserving_status	Ad group information including name and default bid.	Twice a day	Near real-time	Active
adgroup_performance 35 columns venue_idcurrencycampaign_idcampaign_namecampaign_typecampaign_targeting_typeportfolio_nameadgroup_idtypenamecurrent_statedatemodified_tsimpressionsclickscostunits_sold_1dunits_sold_7dunits_sold_14dunits_sold_30dattributed_sales_1dattributed_sales_7dattributed_sales_30dattributed_sales_1d_same_skuattributed_sales_7d_same_skuattributed_sales_30d_same_skuattributed_conversions_1dattributed_conversions_7dattributed_conversions_30dattributed_conversions_1d_same_skuattributed_conversions_7d_same_skuattributed_conversions_30d_same_skuattributed_conversions_14d_new_to_brandunits_sold_14d_new_to_brandattributed_sales_14d_new_to_brand	Daily performance metrics for ad groups.	Twice a day	~2-3 days	Active
product_ads 16 columns venue_idcampaign_idcampaign_namecampaign_typecampaign_targeting_typeadgroup_idadgroup_typeadgroup_nameproduct_ad_idlisting_skuasinad_typecurrent_statecreated_tsmodified_tsserving_status	Product ad information including listing_sku and ASIN.	Twice a day	Near real-time	Active
product_ad_performance 36 columns venue_idcurrencycampaign_idcampaign_namecampaign_typecampaign_targeting_typeportfolio_nameadgroup_idadgroup_typeadgroup_nameproduct_ad_idlisting_skuasinad_typecurrent_statedatemodified_tsimpressionsclickscostunits_sold_1dunits_sold_7dunits_sold_14dunits_sold_30dattributed_sales_1dattributed_sales_7dattributed_sales_30dattributed_sales_1d_same_skuattributed_sales_7d_same_skuattributed_sales_30d_same_skuattributed_conversions_1dattributed_conversions_7dattributed_conversions_30dattributed_conversions_1d_same_skuattributed_conversions_7d_same_skuattributed_conversions_30d_same_sku	Daily performance metrics for product ads.	Daily	~2-3 days	Active
keywords 15 columns venue_idkeyword_idcampaign_idcampaign_namecampaign_typecampaign_targeting_typeadgroup_idadgroup_namestatekeywordmatch_typebidcreated_tsmodified_tsserving_status	Keyword information including ID, keyword text, and match type.	Twice a day	Near real-time	Active
keyword_performance 37 columns venue_idcurrencycampaign_idcampaign_namecampaign_typecampaign_targeting_typeportfolio_nameadgroup_idadgroup_namekeyword_idkeyword_textmatch_typecurrent_statedatemodified_tsimpressionsclickscostunits_sold_1dunits_sold_7dunits_sold_14dunits_sold_30dattributed_sales_1dattributed_sales_7dattributed_sales_30dattributed_sales_1d_same_skuattributed_sales_7d_same_skuattributed_sales_30d_same_skuattributed_conversions_1dattributed_conversions_7dattributed_conversions_30dattributed_conversions_1d_same_skuattributed_conversions_7d_same_skuattributed_conversions_30d_same_skuattributed_conversions_14d_new_to_brandunits_sold_14d_new_to_brandattributed_sales_14d_new_to_brand	Daily performance metrics for keywords.	Twice a day	~2-3 days	Active
search_term_performance 38 columns venue_idcurrencycampaign_idcampaign_namecampaign_typecampaign_targeting_typeportfolio_nameadgroup_idadgroup_namekeyword_idkeywordkeyword_textmatch_typetarget_idtarget_definitioncurrent_statesearch_termdatemodified_tsimpressionsclickscostunits_sold_1dunits_sold_7dunits_sold_14dunits_sold_30dattributed_sales_1dattributed_sales_7dattributed_sales_30dattributed_sales_1d_same_skuattributed_sales_7d_same_skuattributed_sales_30d_same_skuattributed_conversions_1dattributed_conversions_7dattributed_conversions_30dattributed_conversions_1d_same_skuattributed_conversions_7d_same_skuattributed_conversions_30d_same_sku	Daily report of the actual customer search terms that triggered your ads, with spend, clicks, sales, and conversions for each term. Covers both keyword and product-targeting campaigns, and includes the campaign, ad group, and portfolio names so you can see at a glance where each search term spent money. This is the long-history version with the most descriptive detail.	Twice a day	~2-3 days	Active
search_term_performance_v2 33 columns venue_idcampaign_idcampaign_typecampaign_targeting_typekeyword_or_target_idtargeting_match_typesource_typematch_typecurrent_statesearch_termkeyword_texttargeting_typedatemodified_tsimpressionsclickscostunits_sold_1dunits_sold_7dunits_sold_14dunits_sold_30dattributed_sales_1dattributed_sales_7dattributed_sales_30dattributed_sales_1d_same_skuattributed_sales_7d_same_skuattributed_sales_30d_same_skuattributed_conversions_1dattributed_conversions_7dattributed_conversions_30dattributed_conversions_1d_same_skuattributed_conversions_7d_same_skuattributed_conversions_30d_same_sku	A streamlined version of the search term report with the same daily spend, clicks, sales, and conversion metrics. It’s built for faster queries and reflects Amazon’s current targeting model, where keywords and product targets are handled together. Recommended for current reporting; use search_term_performance if you need the campaign and portfolio names.	Daily	~2-3 days	Active
purchased_products_by_keyword 42 columns datevenue_idcampaign_idcampaign_nameadgroup_idadgroup_nameportfolio_idkeyword_idkeyword_textkeyword_typematch_typeasinother_asinlisting_skucurrencypurchases_1dpurchases_7dpurchases_14dpurchases_30dpurchases_other_sku_1dpurchases_other_sku_7dpurchases_other_sku_14dpurchases_other_sku_30dsales_1dsales_7dsales_14dsales_30dattributed_units_ordered_1dattributed_units_ordered_7dattributed_units_ordered_14dattributed_units_ordered_30dattributed_units_ordered_1d_other_skuattributed_units_ordered_7d_other_skuattributed_units_ordered_14d_other_skuattributed_units_ordered_30d_other_skuattributed_sales_1d_other_skuattributed_sales_7d_other_skuattributed_sales_14d_other_skuattributed_sales_30d_other_skukindle_edition_normalized_pagesRead_14dkindle_edition_normalized_pages_royalties_14dcreated_ts	Performance details for ASINs not specifically targeted but purchased after a shopper clicked on a keyword-triggered ad.	Daily	~2-3 days	Active
purchased_products_by_target 42 columns datevenue_idcampaign_idcampaign_nameadgroup_idadgroup_nameportfolio_idtarget_idtargeting_texttargeting_typematch_typeasinother_asinlisting_skucurrencypurchases_1dpurchases_7dpurchases_14dpurchases_30dpurchases_other_sku_1dpurchases_other_sku_7dpurchases_other_sku_14dpurchases_other_sku_30dsales_1dsales_7dsales_14dsales_30dattributed_units_ordered_1dattributed_units_ordered_7dattributed_units_ordered_14dattributed_units_ordered_30dattributed_units_ordered_1d_other_skuattributed_units_ordered_7d_other_skuattributed_units_ordered_14d_other_skuattributed_units_ordered_30d_other_skuattributed_sales_1d_other_skuattributed_sales_7d_other_skuattributed_sales_14d_other_skuattributed_sales_30d_other_skukindleEditionNormalizedPagesRead14dkindleEditionNormalizedPagesRoyalties14dcreated_ts	Performance details for ASINs not specifically targeted but purchased after a shopper clicked on a target-triggered ad.	Daily	~2-3 days	Active
auto_targeting_performance 34 columns venue_idcurrencycampaign_idcampaign_nameportfolio_nameadgroup_idadgroup_nametarget_idtargeting_typeauto_targeting_typedatebidimpressionsclickscostunits_sold_1dunits_sold_7dunits_sold_14dunits_sold_30dattributed_sales_1dattributed_sales_7dattributed_sales_30dattributed_sales_1d_same_skuattributed_sales_7d_same_skuattributed_sales_30d_same_skuattributed_conversions_1dattributed_conversions_7dattributed_conversions_30dattributed_conversions_1d_same_skuattributed_conversions_7d_same_skuattributed_conversions_30d_same_skuattributed_conversions_14d_new_to_brandunits_sold_14d_new_to_brandattributed_sales_14d_new_to_brand	Performance data for Amazon’s automatic targeting — impressions, clicks, conversions, and sales for auto-targeted ads.	Daily	~2-3 days	Active
targeting_performance 33 columns venue_idcurrencycampaign_idcampaign_nameportfolio_nameadgroup_idadgroup_nametarget_idtargeting_typedatebidimpressionsclickscostunits_sold_1dunits_sold_7dunits_sold_14dunits_sold_30dattributed_sales_1dattributed_sales_7dattributed_sales_30dattributed_sales_1d_same_skuattributed_sales_7d_same_skuattributed_sales_30d_same_skuattributed_conversions_1dattributed_conversions_7dattributed_conversions_30dattributed_conversions_1d_same_skuattributed_conversions_7d_same_skuattributed_conversions_30d_same_skuattributed_conversions_14d_new_to_brandunits_sold_14d_new_to_brandattributed_sales_14d_new_to_brand	Detailed insights into specific targeting strategy performance — impressions, clicks, conversions, and sales data.	Daily	~2-3 days	Active
sb_purchased_products_by_date 20 columns venue_iddatecampaign_budget_currency_codecampaign_namecampaign_idadgroup_nameattribution_typepurchased_asinproduct_nameproduct_categorysales_14dorders_14dunits_sold_14dnew_to_brand_sales_14dnew_to_brand_purchases_14dnew_to_brand_units_sold_14dnew_to_brand_sales_percentage_14dnew_to_brand_purchases_percentage_14dnew_to_brand_units_sold_percentage_14dcreated_ts	Records of products purchased as a result of Sponsored Brands ad campaigns, sorted by date.	Daily	~2-3 days	Active

Other Reports

Table Name	Description	Update Frequency	Typical Amazon Lag	Status
ams_hourly_traffic 21 columns guidvenue_idcampaign_idcampaign_namecampaign_typedatehouradgroup_idadgroup_namead_idasinlisting_skukeyword_idkeyword_textmatch_typeplacementgenerated_tsstored_tsimpressionsclickscost	Hourly advertising traffic data (impressions, clicks, cost) from Amazon Marketing Stream (FEAD). Contact Customer Success to enable.	Real-time	Near real-time	Active
ams_hourly_conversions 42 columns guidvenue_idcampaign_idcampaign_namecampaign_typedatehouradgroup_idadgroup_namead_idasinlisting_skukeyword_idkeyword_textmatch_typeplacementgenerated_tsstored_tsattributed_conversions_1dattributed_conversions_7dattributed_conversions_14dattributed_conversions_30dattributed_conversions_1d_same_skuattributed_conversions_7d_same_skuattributed_conversions_14d_same_skuattributed_conversions_30d_same_skuattributed_sales_1dattributed_sales_7dattributed_sales_14dattributed_sales_30dattributed_sales_1d_same_skuattributed_sales_7d_same_skuattributed_sales_14d_same_skuattributed_sales_30d_same_skuattributed_units_ordered_1dattributed_units_ordered_7dattributed_units_ordered_14dattributed_units_ordered_30dattributed_units_ordered_1d_same_skuattributed_units_ordered_7d_same_skuattributed_units_ordered_14d_same_skuattributed_units_ordered_30d_same_sku	Hourly advertising conversion data from Amazon Marketing Stream (FEAD).	Real-time	~1-2 days	Active
product_reviews 13 columns venue_ididasinreviewIdreviewertitlebodydatestar_ratingtotal_voteshelpful_votessourcereviewer_id	Product reviews left by consumers. Affects search rankings and buying decisions.	Daily	~1 day	Active
seller_feedback 13 columns venue_idratingcommentsbuyerdateorder_idvenue_order_idon_timeas_describedcustomer_servicestatussuppressedmodified	Buyer feedback about the seller experience. Can affect your ability to win the Buy Box.	Daily	~1 day	Active
fba_inventory_history 29 columns report_tsreport_datevenue_idlisting_skuasinproduct_namecost_of_productafn_total_quantityafn_fulfillable_quantityafn_warehouse_quantityafn_reserved_quantityafn_unsellable_quantityafn_inbound_working_quantityafn_inbound_shipped_quantityafn_inbound_receiving_quantityafn_researching_quantityafn_reserved_future_supplyafn_future_supply_buyableper_unit_volumeyour_priceconditionfnskufba_inventory_activeafn_listing_existsmfn_listing_existsmfn_fulfillable_quantitymerchant_idlocation_idlocation_name	A historical log of all FBA inventory snapshots.	Daily	~1 day	Active

Seller Labs Custom Tables

Table Name	Description	Update Frequency	Typical Amazon Lag	Status
sl_daily_ad_pivot 7 columns datevenue_idad_spendclicksimpressionsattributed_sales_30dattributed_conversions_30d	Venue-level advertising data compiled from several different reports.	Varies	~2-3 days	Active
sl_daily_sku_ad 8 columns datelisting_skuvenue_idad_spendclicksimpressionsattributed_sales_30dattributed_conversions_30d	SKU-level advertising data compiled from several different reports.	Varies	~2-3 days	Active
sl_daily_sku_profit 19 columns datelisting_skuvenue_idcost_of_goods_productunits_soldunits_returnedsalesrefunds_salesshipping_revenuegift_wrap_revenueregulatory_fee_revenuefba_feesreferral_feeother_expensestotal_payoutmonthly_storageais_chargesponsored_product_chargeprofit	SKU-level sales and profit data compiled from several different reports.	Varies	Same day (partial)	Active
sl_daily_venue_profit 12 columns datevenue_idsales_api_total_salessku_economic_revenuepayoutcogsordersunitsais_chargemonthly_storagepost_ad_gross_profitsku_economic_profit	Venue-level sales and profit data compiled from several different reports.	Varies	Same day (partial)	Active
sl_date_template 5 columns dateyearmonthweekday	Date reference table containing every day starting from 2022-01-01.	Varies	—	Active
sl_hourly_ams_pivot 32 columns venue_idcampaign_iddateday_of_weekhourimpressionsclickscostattributed_conversions_1dattributed_conversions_7dattributed_conversions_14dattributed_conversions_30dattributed_conversions_1d_same_skuattributed_conversions_7d_same_skuattributed_conversions_14d_same_skuattributed_conversions_30d_same_skuattributed_sales_1dattributed_sales_7dattributed_sales_14dattributed_sales_30dattributed_sales_1d_same_skuattributed_sales_7d_same_skuattributed_sales_14d_same_skuattributed_sales_30d_same_skuattributed_units_ordered_1dattributed_units_ordered_7dattributed_units_ordered_14dattributed_units_ordered_30dattributed_units_ordered_1d_same_skuattributed_units_ordered_7d_same_skuattributed_units_ordered_14d_same_skuattributed_units_ordered_30d_same_sku	Venue-level AMS (Amazon Marketing Stream) data.	Varies	~1-2 days	Active
sl_hourly_ams_sku_pivot 33 columns venue_idcampaign_idlisting_skudateday_of_weekhourimpressionsclickscostattributed_conversions_1dattributed_conversions_7dattributed_conversions_14dattributed_conversions_30dattributed_conversions_1d_same_skuattributed_conversions_7d_same_skuattributed_conversions_14d_same_skuattributed_conversions_30d_same_skuattributed_sales_1dattributed_sales_7dattributed_sales_14dattributed_sales_30dattributed_sales_1d_same_skuattributed_sales_7d_same_skuattributed_sales_14d_same_skuattributed_sales_30d_same_skuattributed_units_ordered_1dattributed_units_ordered_7dattributed_units_ordered_14dattributed_units_ordered_30dattributed_units_ordered_1d_same_skuattributed_units_ordered_7d_same_skuattributed_units_ordered_14d_same_skuattributed_units_ordered_30d_same_sku	SKU-level AMS (Amazon Marketing Stream) data.	Varies	~1-2 days	Active
sl_transactions_pivot 35 columns venue_idtransaction_tstransaction_ts_marketplacevenue_settlement_idevent_typetransaction_typesvenue_order_idlisting_skulisting_titlequantitymarketplaceaccount_typefulfillment_channelorder_cityorder_stateorder_postaltax_collection_modelproduct_revenueproduct_revenue_taxshipping_revenueshipping_revenue_taxgift_wrap_revenuegift_wrap_revenue_taxregulatory_fee_revenueregulatory_fee_revenue_taxpromotional_discountpromotional_discount_taxmarketplace_tax_withheldselling_feesfba_feesother_transaction_feesothertotal_payoutcost_of_goods_productprofit	Financial data built by Seller Labs as the equivalent of Amazon’s Unified Transaction Report. How it reconciles ›	Daily	Near real-time	Active

Deprecated

Table Name	Description	Update Frequency	Typical Amazon Lag	Status
sns_performance_data Column data not available for this table.	Daily performance metrics for Subscribe & Save subscriptions. Deprecated by Amazon on December 11, 2025.	Daily	—	Deprecated
sns_forecast_data Column data not available for this table.	Projected Subscribe & Save data. Deprecated by Amazon on December 11, 2025.	Daily	—	Deprecated
inventory Column data not available for this table.	Inventory information from warehouses and fulfillment centers. Replaced by fba_inventory. Deprecated November 2023.	Daily	—	Deprecated
fba_inventory_age Column data not available for this table.	Inventory age data — sellable quantity and units aged 3+, 6+, 9+, 12+ months. Combined with fba_inventory_health into fba_inventory_planning. Deprecated January 2023.	Every few days	—	Deprecated
fba_inventory_health Column data not available for this table.	Inventory health data showing weeks of cover available. Combined with fba_inventory_age into fba_inventory_planning. Deprecated January 2023.	Every few days	—	Deprecated
unified_transactions Column data not available for this table.	Alpha-phase table. Replaced by sl_transactions_pivot. Replaced October 2023.	Daily	—	Deprecated

No tables match your search.