1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Drag to adjust the number of frozen columns
Table Name
Friendly Name
Period
Backfill
Example columns
coupon_performance_asins
Coupon Performance ASINs
Daily
2 years
asin, coupon id, discount, discount type
coupon_performance_summary
Coupon Performance Summary
Daily
2 years
marketplace id, coupon id, merchant id, total discount, clips, budget spent, sales
inventory_age
Inventory age (FBA)
Snapshot
Snapshot
snapshot date, ASIN, condition, sellable quantity, removals, quantity by age band, LTSF forecasts
inventory_all_listings
Inventory listings (FBA + MFN)
Snapshot
Snapshot
item name, SKU, price, quantity, condition, ASIN, status, fulfillment channel
inventory_ledger_detail
Inventory Ledger Details
Daily
1 year
date, asin, msku, product title, event type, quantity, fulfillment center, disposition, reason, country, unreconciled quantity, reconciled quantity
inventory_ledger_summary
Inventory Ledger Summary
Daily
1 year
date, id, fnsku, asin, msku, receipts, lost, found, damaged, disposed, unknown events, location, starting warehouse balance, ending warehouse balance, customer shipments, warehouse transfer in out
inventory_reserved_inventory
Reserved inventory
Daily
Snapshot
asin, product name, reserved qty broken down by order/processing/transfer
inventory_reserved_inventory_api
Reserved inventory
Daily
Snapshot
asin, product name, reserved qty broken down by order/processing/transfer
inventory_restock_inventory
Restock inventory
Daily
Snapshot
snapshot date, SKU, ASIN, condition, price, units, days of supply, inventory threshold, utilization, max ship qty
inventory_restock_inventory_api
Restock inventory
Daily
Snapshot
snapshot date, SKU, ASIN, condition, price, units, days of supply, inventory threshold, utilization, max ship qty
inventory_shipping_queue_contents
Shipping Queue: Contents
Daily
1 year
id, title, asin, shipment id, status, units expected, units received
inventory_shipping_queue_summary
Shipping Queue: Summary
Daily
1 year
id, skus, status, shipment id, status, units expected, units received
order_fulfillment_api
Order Fulfillment
90 days
amazon order ID, order status, fulfillment channel, asin, price, tax, shipping, SKU, quantity
order_report_fulfilled_by_amazon_api
Order Report Fulfilled By Amazon
Daily
30 days
purchase date, amazon order ID, fulfillment channel, city, state, zip, country, sku, ASIN, principal price
payments_fee_preview
Fee Payments Preview
Daily
Snapshot
sku, product name. product group, your price, estimated fee total, current fee category, future fee category
payments_monthly_storage_fees
Monthly Storage Fees
Monthly
1 year
asin, fulfillment_center, longest_side, median_side, shortest_side, weight, item_volume, storage_rate
pl_ledger_table
Seller Profit Toolkit - Ledger Table
Daily
2 years
date_time, apl category, description, amount, line item, line source, quantity, order ID, settlement ID
promotion_performance_details
Promotion Performance Details
Daily
2 years
marketplace id, promotion name, asin, units, revenue
promotion_performance_summary
Promotion Performance Summary
Daily
2 years
marketplace id, promotion name, units, spend, revenue, promotion creation date
removals_removal_shipment_details
Removal Shipment Details
Daily
1 year
request date, shipment date, carrier, shipped quantity, tracking number, removal order type
returns_customer_returns
FBA Customer Returns
Snapshot
Snapshot
return date, order ID, SKU, ASIN, quantity, fulfillment center, disposition, reason, status
returns_fba_inventory
Manage FBA Inventory
Daily
Snapshot
date, ASIN, condition, price, MFN quantity, AFN quantity (unsellable, reserved, fulfillable, inbound, shipped, receiving)
returns_report
MFN Customer Returns
Daily
2 years
asin, order id, return reason, resolution, Safe-T claim reimbursement amount, refunded amount
sales_and_traffic_detail_sales_traffic_by_child_item
Sales and traffic by Child ASIN
Daily
2 years
date, ASIN, sessions, page views, buy box %, units, OPS
sales_and_traffic_detail_sales_traffic_by_sku
Sales and traffic by SKU
Daily
2 years
date, ASIN, SKU, sessions, page views, buy box %, units, OPS
sales_customer_shipment_sales
Customer shipments
Daily
1 year
id, sku, asin, amazon order id, customer ship date, fufillment center id, quantity, product amount, shipping amount, ship to city, ship to state, ship to postal code
settlement_report
Settlement Report
Daily
2 years
posted date, settlement id, settlement start date, settlement end date, deposit date, transaction type, order id, fulfillment` id
sns_forecasting
Subscribe & Save Forecasting
Weekly
Snapshot
snapshot_date, asin, sku, scheduled-sns-units-week-1, scheduled-sns-units-week-2, scheduled-sns-units-week-3
subscription_and_save
Subscribe & save
Snapshot
1 year
snapshot date, offer state, SKU, ASIN, OOS rate, SNS sale price, discount, units shipped
transactions_invoiced
Transactions (invoiced/B2B)
Daily
2 years
date, order ID, settlement ID, quantity, marketplace, fulfillment, sales, credits, fees
transactions_standard_orders
Transactions (standard orders/Retail)
Daily
2 years
date, order ID, settlement ID, quantity, marketplace, fulfillment, sales, credits, fees
31 records

Alert

Lorem ipsum
Okay