data dictionary - Seller Labs: Amazon Seller Software and Platform

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 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 Information about listings for sale on a venue, including listing_sku, title, and price. Daily ~1 day Active
orders Top-level order information including order time, customer name, address (as available), and email address. Every few hours Near real-time Active
order_items 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 Groups of transactions called settlements — the amounts ultimately deposited into your bank account. Every few hours Near real-time Active
transaction_types 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 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 Inventory information from warehouses and fulfillment centers. 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 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. Daily ~1 day Active
inventory_ledger_history Historical log of the inventory ledger. Daily ~1 day Active
amazon_sales_ranks Sales ranking of ASINs within root and child product categories. Daily ~1 day Active
amazon_traffic Data from Seller Central’s Business Reports — sessions, page views, orders, and unit session percentages. Daily ~2 days Active
fba_reimbursements_data Reimbursements issued to sellers in the FBA program. Daily ~1 day Active
fba_monthly_storage_fees Overview of FBA storage fee charges incurred for storing products in Amazon’s fulfillment centers. Daily ~1 day Active
aged_inventory_storage_fees Storage fees for aging inventory including SKU, product info, volume, charges, and surcharge rates. Daily ~1 day Active
fba_removal_order_detail Detailed data on FBA removal orders including order status, item details, dates, quantities, fees, and currency. Daily ~1 day Active
fba_fee_preview Estimated FBA fees including referral fees, order handling, pick and pack, and more. Daily ~1 day Active
returns Returns of FBA purchases. Daily ~1 day Active
daily_sales_api_revenue SKU-level sales data retrieved through the Sales API. Daily Near real-time Active
sent_messages_custom Historical log of custom messages sent to buyers. Daily Near real-time Active
sent_messages_rar Historical log of Request a Review messages sent to buyers. Daily Near real-time Active
search_query_performance Amazon Brand Analytics Search Query Performance (SQP) data — weekly metrics showing how customers discover and interact with products in Amazon search. Weekly (Tuesdays) Up to ~1 week Active
search_query_performance_by_month Amazon Brand Analytics Search Query Performance (SQP) data — monthly metrics with clean full-month boundaries for trending analysis. 3× per month Up to ~1 week Active

Advertising Data

Table Name Description Update Frequency Typical Amazon Lag Status
portfolios Campaigns grouped together and linked to a distinct Advertiser Account. Twice a day Near real-time Active
campaigns High-level campaign information including ID, name, and daily budget. Twice a day Near real-time Active
campaign_performance Daily performance metrics for campaigns. Twice a day ~2-3 days Active
campaign_placement_performance Daily campaign metrics split by ad placement. Twice a day ~2-3 days Active
adgroups Ad group information including name and default bid. Twice a day Near real-time Active
adgroup_performance Daily performance metrics for ad groups. Twice a day ~2-3 days Active
product_ads Product ad information including listing_sku and ASIN. Twice a day Near real-time Active
product_ad_performance Daily performance metrics for product ads. Daily ~2-3 days Active
keywords Keyword information including ID, keyword text, and match type. Twice a day Near real-time Active
keyword_performance Daily performance metrics for keywords. Twice a day ~2-3 days Active
search_term_performance Daily report of the actual customer search terms that triggered your ads. Twice a day ~2-3 days Active
search_term_performance_v2 A streamlined version of the search term report. Daily ~2-3 days Active
purchased_products_by_keyword Performance details for ASINs purchased after clicking a keyword-triggered ad. Daily ~2-3 days Active
purchased_products_by_target Performance details for ASINs purchased after clicking a target-triggered ad. Daily ~2-3 days Active
auto_targeting_performance Performance data for Amazon’s automatic targeting. Daily ~2-3 days Active
targeting_performance Detailed insights into specific targeting strategy performance. Daily ~2-3 days Active
sb_purchased_products_by_date 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 Hourly advertising traffic data from Amazon Marketing Stream. Real-time Near real-time Active
ams_hourly_conversions Hourly advertising conversion data from Amazon Marketing Stream. Real-time ~1-2 days Active
product_reviews Product reviews left by consumers. Daily ~1 day Active
seller_feedback Buyer feedback about the seller experience. Daily ~1 day Active
fba_inventory_history 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 Venue-level advertising data compiled from several reports. Varies ~2-3 days Active
sl_daily_sku_ad SKU-level advertising data compiled from several reports. Varies ~2-3 days Active
sl_daily_sku_profit SKU-level sales and profit data compiled from several reports. Varies Same day (partial) Active
sl_daily_venue_profit Venue-level sales and profit data compiled from several reports. Varies Same day (partial) Active
sl_date_template Date reference table containing every day starting from 2022-01-01. Varies — Active
sl_hourly_ams_pivot Venue-level AMS data. Varies ~1-2 days Active
sl_hourly_ams_sku_pivot SKU-level AMS data. Varies ~1-2 days Active
sl_transactions_pivot Financial data built by Seller Labs as the equivalent of Amazon’s Unified Transaction Report. Daily Near real-time Active

Deprecated

Table Name Description Update Frequency Typical Amazon Lag Status
sns_performance_data Daily performance metrics for Subscribe & Save subscriptions. Daily — Deprecated
sns_forecast_data Projected Subscribe & Save data. Daily — Deprecated
inventory Inventory information from warehouses and fulfillment centers. Daily — Deprecated
fba_inventory_age Inventory age data. Every few days — Deprecated
fba_inventory_health Inventory health data. Every few days — Deprecated
unified_transactions Alpha-phase table. Daily — Deprecated