Sheet functions

Maps ASINs to matching seller SKUs.

Shows listing attribute values wide: one row per ASIN, one column per attribute (color, size, material, and any other attribute Amazon carries for the product type).

Shows product BSR ranking history by ASIN and rank type over a selected period.

Shows ASIN catalog fields such as title, item highlight, brand, product type, seller-maintained names, and listing metadata.

Shows active catalog and listing issues by marketplace and severity, with the date first seen.

Shows dashboard-tracked SERP keyword rank positions over time by ASIN.

Lists dashboard-tracked SERP keywords with last seen date and matching ASIN columns.

Shows seller listing rows with ASIN, SKU, title, fulfillment, status, and optional attributes.

Maps seller SKUs to matching ASINs.

Ad group performance, rolled up from target facts by ad group.

Sponsored Ads campaign performance over a period. Use basis=PLACEMENT to split by placement.

Cross-ASIN purchases attributed to an advertised product.

Negative keywords/targets (structure only – no metrics). level is CAMPAIGN or ADGROUP.

Advertised-product performance with TaCoS, per advertised ASIN. Filter by ASIN.

Customer search-term performance – what shoppers actually typed. Sponsored Products / Brands only.

Keyword/target performance. Default rolls one keyword up across campaigns; basis=CAMPAIGN or ADGROUP splits finer.

Shows current buy box offer data for matching ASINs.

Shows detailed buy box offer rows and pricing signals.

Shows order item rows with local order time, fulfillment, status, quantities, and amounts.

Shows FBA return rows with reason, status, disposition, FC, and customer comments.

Shows units sold by ASIN/SKU, or Amazon summary units with view=SUMMARY.

Shows sales amount totals by ASIN/SKU, or Amazon summary totals with view=SUMMARY.

Shows seller account health and performance metrics by marketplace.

Shows Search Query Performance totals for the selected report, brand, ASINs, queries, and period.

Lists available Search Query Performance report IDs and coverage by ASIN and week.

Shows currently suppressed listing rows with status and reason fields.

Shows inbound FBA shipments per SKU: shipped vs received units, status, destination FC, and product names in one list. Use basis=SHIPMENT for one row per shipment.

Shows SKU inventory quantities over time with dates or period buckets as columns.

Shows latest inventory snapshot details for matching products.

Shows FBA inventory ledger movement rows with event, FC, disposition, and quantities.

Shows current FBA inventory balances by fulfillment center and disposition.

Shows Amazon restock recommendations and inventory planning fields.

Shows FBA out-of-stock rate over a selected period.

Shows FBA overage and storage-related fee rows by period.

Shows monthly FBA storage fee rows by product and marketplace.

Shows stranded FBA inventory rows with status and reason fields.

Summarizes Amazon finance event lines by event, kind, and type.

Shows finance event lines at detail grain for product, order, or transaction audit work.

Shows FBA reimbursement rows by product, reason, marketplace, and period.

Shows raw settlement line items for audit and reconciliation work.

Lists settlement payouts with date, settlement id, amount, and currency.

Summarizes settlement lines into readable groups and explanations.

Returns the full function reference as a table, inside your sheet.