Sheet functions
35 custom functions that pull live Amazon account data into Google Sheets. Get help inside the sheet any time with =DRAGON_HELP(),
or per function with =DRAGON_INVENTORY("help").
Maps ASINs to matching seller SKUs.
DRAGON_BSR_RANKShows product BSR ranking history by ASIN and rank type over a selected period.
DRAGON_CATALOGShows ASIN catalog fields such as title, item highlight, brand, product type, seller-maintained names, and listing metadata.
DRAGON_CATALOG_ISSUESShows active catalog and listing issues by marketplace and severity, with the date first seen.
DRAGON_KEYWORD_DETAILSShows dashboard-tracked SERP keyword rank positions over time by ASIN.
DRAGON_KEYWORD_LISTLists dashboard-tracked SERP keywords with last seen date and matching ASIN columns.
DRAGON_LISTINGSShows seller listing rows with ASIN, SKU, title, fulfillment, status, and optional attributes.
DRAGON_SKU2ASINMaps seller SKUs to matching ASINs.
Shows current buy box offer data for matching ASINs.
DRAGON_BUYBOX_DETAILSShows detailed buy box offer rows and pricing signals.
DRAGON_ORDERSShows order item rows with local order time, fulfillment, status, quantities, and amounts.
DRAGON_RETURNSShows FBA return rows with reason, status, disposition, FC, and customer comments.
DRAGON_SALES_COUNTShows units sold by ASIN/SKU, or Amazon summary units with view=SUMMARY.
DRAGON_SALES_TOTALSShows sales amount totals by ASIN/SKU, or Amazon summary totals with view=SUMMARY.
DRAGON_SELLER_PERFORMANCEShows seller account health and performance metrics by marketplace.
DRAGON_SQPShows Search Query Performance totals for the selected report, brand, ASINs, queries, and period.
DRAGON_SQP_LISTLists available Search Query Performance report IDs and coverage by ASIN and week.
DRAGON_SUPPRESSEDShows 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.
DRAGON_INVENTORYShows SKU inventory quantities over time with dates or period buckets as columns.
DRAGON_INVENTORY_DETAILSShows latest inventory snapshot details for matching products.
DRAGON_INVENTORY_LEDGERShows FBA inventory ledger movement rows with event, FC, disposition, and quantities.
DRAGON_INVENTORY_LOCATIONShows current FBA inventory balances by fulfillment center and disposition.
DRAGON_INVENTORY_RESTOCKShows Amazon restock recommendations and inventory planning fields.
DRAGON_OOS_RATEShows FBA out-of-stock rate over a selected period.
DRAGON_OVERAGE_FEESShows FBA overage and storage-related fee rows by period.
DRAGON_STORAGE_FEESShows monthly FBA storage fee rows by product and marketplace.
DRAGON_STRANDEDShows stranded FBA inventory rows with status and reason fields.
Summarizes Amazon finance event lines by event, kind, and type.
DRAGON_FINANCE_DETAILSShows finance event lines at detail grain for product, order, or transaction audit work.
DRAGON_REIMBURSEMENTSShows FBA reimbursement rows by product, reason, marketplace, and period.
DRAGON_SETTLEMENT_ITEMSShows raw settlement line items for audit and reconciliation work.
DRAGON_SETTLEMENT_LISTLists settlement payouts with date, settlement id, amount, and currency.
DRAGON_SETTLEMENTSSummarizes settlement lines into readable groups and explanations.