The shared building blocks used by every sheet function: accepted values for each parameter, and every period format.
Parameters
Accepted values for every parameter used by the sheet functions. Parameters are positional – leave one blank to skip it, and leave optional filters blank to include everything.
| Parameter | Accepted values |
|---|---|
| account | Enter the account nickname or Amazon account id. DRAGON_ASIN2SKU, DRAGON_ATTRIBUTES, DRAGON_BSR_RANK, DRAGON_BUYBOX, DRAGON_BUYBOX_DETAILS, DRAGON_CATALOG, DRAGON_CATALOG_ISSUES, DRAGON_FINANCE, DRAGON_FINANCE_DETAILS, DRAGON_INBOUND_FBA, DRAGON_INVENTORY, DRAGON_INVENTORY_DETAILS, DRAGON_INVENTORY_LEDGER, DRAGON_INVENTORY_LOCATION, DRAGON_INVENTORY_RESTOCK, DRAGON_KEYWORD_DETAILS, DRAGON_KEYWORD_LIST, DRAGON_LISTINGS, DRAGON_OOS_RATE, DRAGON_ORDERS, DRAGON_OVERAGE_FEES, DRAGON_PPC_ADGROUPS, DRAGON_PPC_CAMPAIGNS, DRAGON_PPC_CROSS_ASIN_PURCHASES, DRAGON_PPC_NEGATIVES, DRAGON_PPC_PRODUCTS, DRAGON_PPC_SEARCH_TERMS, DRAGON_PPC_TARGETS, DRAGON_REIMBURSEMENTS, DRAGON_RETURNS, DRAGON_SALES_COUNT, DRAGON_SALES_TOTALS, DRAGON_SELLER_PERFORMANCE, DRAGON_SETTLEMENT_ITEMS, DRAGON_SETTLEMENT_LIST, DRAGON_SETTLEMENTS, DRAGON_SKU2ASIN, DRAGON_SQP, DRAGON_SQP_LIST, DRAGON_STORAGE_FEES, DRAGON_STRANDED, DRAGON_SUPPRESSED |
| ad group | Enter a value to filter by this field, or leave empty to include all values. |
| ad type | SP, SB, SD, ALL (DRAGON_PPC_ADGROUPS, DRAGON_PPC_CAMPAIGNS, DRAGON_PPC_CROSS_ASIN_PURCHASES, DRAGON_PPC_NEGATIVES, DRAGON_PPC_PRODUCTS, DRAGON_PPC_TARGETS); SP, SB, ALL (DRAGON_PPC_SEARCH_TERMS) |
| alert | LOW_STOCK, OUT_OF_STOCK |
| amount type | Filter settlement rows by Amazon amount type. Leave empty to include all amount types. |
| asin | Enter one ASIN, several ASINs, a cell range, or INDIRECT() pointing to a list of ASINs. |
| ASIN | Enter one ASIN, several ASINs, a cell range, or INDIRECT() pointing to a list of ASINs. |
| ASIN/SKU | Enter one ASIN/SKU, several values, a cell range, or INDIRECT() pointing to a list. DRAGON_BSR_RANK, DRAGON_FINANCE, DRAGON_FINANCE_DETAILS, DRAGON_INBOUND_FBA, DRAGON_INVENTORY, DRAGON_INVENTORY_DETAILS, DRAGON_INVENTORY_LEDGER, DRAGON_INVENTORY_LOCATION, DRAGON_INVENTORY_RESTOCK, DRAGON_LISTINGS, DRAGON_OOS_RATE, DRAGON_ORDERS, DRAGON_REIMBURSEMENTS, DRAGON_RETURNS, DRAGON_SALES_COUNT, DRAGON_SALES_TOTALS, DRAGON_SQP, DRAGON_SQP_LIST, DRAGON_STORAGE_FEES, DRAGON_STRANDED, DRAGON_SUPPRESSED |
| attributes | Add extra listing attributes to the output, such as color, size, or material. |
| basis | ITEM, SHIPMENT (DRAGON_INBOUND_FBA); ASIN, SKU (DRAGON_OOS_RATE, DRAGON_SALES_COUNT, DRAGON_SALES_TOTALS); CAMPAIGN, PLACEMENT (DRAGON_PPC_CAMPAIGNS); CROSS_ASIN, PURCHASED, ADVERTISED, CAMPAIGN (DRAGON_PPC_CROSS_ASIN_PURCHASES); PRODUCT, CAMPAIGN (DRAGON_PPC_PRODUCTS); SEARCH_TERM, TARGET, CAMPAIGN (DRAGON_PPC_SEARCH_TERMS); TARGET, CAMPAIGN, ADGROUP (DRAGON_PPC_TARGETS) |
| brand | Filter by brand name. Leave empty to include all brands. |
| campaign | Enter a value to filter by this field, or leave empty to include all values. |
| columns | Choose which output columns to show. Leave empty to use default columns. Some functions support groups such as compact or all. Columns are evaluated left to right; field/group adds columns and -field/-group removes them. Some summary functions support none or - to suppress identity columns. DRAGON_ASIN2SKU, DRAGON_BSR_RANK, DRAGON_BUYBOX, DRAGON_BUYBOX_DETAILS, DRAGON_CATALOG, DRAGON_CATALOG_ISSUES, DRAGON_FINANCE, DRAGON_FINANCE_DETAILS, DRAGON_INBOUND_FBA, DRAGON_INVENTORY, DRAGON_INVENTORY_DETAILS, DRAGON_INVENTORY_LEDGER, DRAGON_INVENTORY_LOCATION, DRAGON_INVENTORY_RESTOCK, DRAGON_KEYWORD_DETAILS, DRAGON_KEYWORD_LIST, DRAGON_LISTINGS, DRAGON_OOS_RATE, DRAGON_ORDERS, DRAGON_OVERAGE_FEES, DRAGON_PPC_ADGROUPS, DRAGON_PPC_CAMPAIGNS, DRAGON_PPC_CROSS_ASIN_PURCHASES, DRAGON_PPC_NEGATIVES, DRAGON_PPC_PRODUCTS, DRAGON_PPC_SEARCH_TERMS, DRAGON_PPC_TARGETS, DRAGON_REIMBURSEMENTS, DRAGON_RETURNS, DRAGON_SALES_COUNT, DRAGON_SALES_TOTALS, DRAGON_SELLER_PERFORMANCE, DRAGON_SETTLEMENT_ITEMS, DRAGON_SETTLEMENT_LIST, DRAGON_SETTLEMENTS, DRAGON_SKU2ASIN, DRAGON_SQP, DRAGON_SQP_LIST, DRAGON_STORAGE_FEES, DRAGON_STRANDED, DRAGON_SUPPRESSED |
| condition | Filter by Amazon condition, such as new_new. Leave empty to include all conditions. |
| destination FC | Filter by destination fulfillment center code, such as CLT2 or LAX9. |
| disposition | total, sellable, incoming, reserved, unsellable, researching, available (DRAGON_INVENTORY); SELLABLE, DEFECTIVE, CUSTOMER_DAMAGED, WAREHOUSE_DAMAGED, CARRIER_DAMAGED, DISTRIBUTOR_DAMAGED (DRAGON_INVENTORY_LEDGER); SELLABLE, DEFECTIVE, CUSTOMER_DAMAGED, WAREHOUSE_DAMAGED (DRAGON_INVENTORY_LOCATION); SELLABLE, DEFECTIVE, CUSTOMER_DAMAGED, CARRIER_DAMAGED (DRAGON_RETURNS) |
| eligibility | NATIONAL, NONE |
| event | SHIPMENTEVENTLIST, REFUNDEVENTLIST, SERVICEFEEEVENTLIST, ADJUSTMENTEVENTLIST, GUARANTEECLAIMEVENTLIST, PRODUCTADSPAYMENTEVENTLIST, CHARGEBACKEVENTLIST, DEBTRECOVERY, MISCELLANEOUSLEDGERADJUSTMENT, SELLERPOWEREDCOUPON, TRANSFER |
| event type | RECEIPTS, SHIPMENTS, ADJUSTMENTS, CUSTOMERRETURNS, VENDORRETURNS, WHSETRANSFERS |
| FC | Filter by fulfillment center code, such as CLT2 or LAX9. |
| filter | Enter a value to filter by this field, or leave empty to include all values. |
| fulfillment | FBA, FBM (DRAGON_ASIN2SKU, DRAGON_BSR_RANK, DRAGON_BUYBOX, DRAGON_BUYBOX_DETAILS, DRAGON_INVENTORY, DRAGON_ORDERS, DRAGON_SALES_COUNT, DRAGON_SALES_TOTALS, DRAGON_SKU2ASIN); FBA, FBM, PARENT (DRAGON_LISTINGS) |
| fulfillment status | Filter orders by fulfillment status. Use ALL, ALL_BUT_CANCELLED, PENDING, SHIPPED, CANCELLED, or similar Amazon status values. |
| keyword | Filter by one tracked keyword. Leave empty to include all tracked keywords. |
| kind | AMOUNT, CHARGE, FEE, TAX_WITHHELD |
| language | Enter a value to filter by this field, or leave empty to include all values. |
| level | CAMPAIGN, ADGROUP, ALL |
| marketplace | Marketplace country code, such as US, UK, CA, MX, DE, FR, IT, ES, JP, or AU. Leave it blank to use this sheet's default marketplace (Extensions > SellerDragon > Default Marketplace). With no default, blank means every marketplace, except sales, sales count, BSR rank, keyword and PPC functions, which need one marketplace. DRAGON_ASIN2SKU, DRAGON_ATTRIBUTES, DRAGON_BSR_RANK, DRAGON_BUYBOX, DRAGON_BUYBOX_DETAILS, DRAGON_CATALOG, DRAGON_CATALOG_ISSUES, DRAGON_FINANCE, DRAGON_FINANCE_DETAILS, DRAGON_INBOUND_FBA, DRAGON_INVENTORY, DRAGON_INVENTORY_DETAILS, DRAGON_INVENTORY_LEDGER, DRAGON_INVENTORY_LOCATION, DRAGON_INVENTORY_RESTOCK, DRAGON_KEYWORD_DETAILS, DRAGON_KEYWORD_LIST, DRAGON_LISTINGS, DRAGON_OOS_RATE, DRAGON_ORDERS, DRAGON_OVERAGE_FEES, DRAGON_PPC_ADGROUPS, DRAGON_PPC_CAMPAIGNS, DRAGON_PPC_CROSS_ASIN_PURCHASES, DRAGON_PPC_NEGATIVES, DRAGON_PPC_PRODUCTS, DRAGON_PPC_SEARCH_TERMS, DRAGON_PPC_TARGETS, DRAGON_REIMBURSEMENTS, DRAGON_RETURNS, DRAGON_SALES_COUNT, DRAGON_SALES_TOTALS, DRAGON_SELLER_PERFORMANCE, DRAGON_SETTLEMENT_ITEMS, DRAGON_SETTLEMENT_LIST, DRAGON_SETTLEMENTS, DRAGON_SKU2ASIN, DRAGON_SQP, DRAGON_SQP_LIST, DRAGON_STORAGE_FEES, DRAGON_STRANDED, DRAGON_SUPPRESSED |
| match type | EXACT, PHRASE, ALL |
| metric | accountHealthRating, customerProductReviewsPolicyViolations, documentRequests, foodAndProductSafetyIssues, invoiceDefectRate, lateShipmentRate, lateShipmentRateList, listingPolicyViolations, onTimeDeliveryRate, orderDefectRate, otherPolicyViolations, preFulfillmentCancellationRate, productAuthenticityCustomerComplaints, productConditionCustomerComplaints, productSafetyCustomerComplaints, receivedIntellectualPropertyComplaints, restrictedProductPolicyViolations, suspectedIntellectualPropertyViolations, unitOnTimeDeliveryRate, validTrackingRate |
| offer source | Filter buy box detail rows by offer source, such as featured or lowest_priced. Leave empty to include all offer sources. |
| order ID | Filter by one or more Amazon order IDs. In finance details, this shows all finance lines for one order. |
| period | Choose the date range. See the period reference below for accepted formats and examples. DRAGON_BSR_RANK, DRAGON_FINANCE, DRAGON_FINANCE_DETAILS, DRAGON_INBOUND_FBA, DRAGON_INVENTORY, DRAGON_INVENTORY_LEDGER, DRAGON_INVENTORY_LOCATION, DRAGON_KEYWORD_DETAILS, DRAGON_KEYWORD_LIST, DRAGON_OOS_RATE, DRAGON_ORDERS, DRAGON_OVERAGE_FEES, DRAGON_PPC_ADGROUPS, DRAGON_PPC_CAMPAIGNS, DRAGON_PPC_CROSS_ASIN_PURCHASES, DRAGON_PPC_PRODUCTS, DRAGON_PPC_SEARCH_TERMS, DRAGON_PPC_TARGETS, DRAGON_REIMBURSEMENTS, DRAGON_RETURNS, DRAGON_SALES_COUNT, DRAGON_SALES_TOTALS, DRAGON_SETTLEMENT_ITEMS, DRAGON_SETTLEMENT_LIST, DRAGON_SETTLEMENTS, DRAGON_SQP, DRAGON_SQP_LIST, DRAGON_STORAGE_FEES, DRAGON_STRANDED, DRAGON_SUPPRESSED |
| period view | TOTAL, DAY, WEEK, MONTH (DRAGON_PPC_ADGROUPS, DRAGON_PPC_CAMPAIGNS, DRAGON_PPC_CROSS_ASIN_PURCHASES, DRAGON_PPC_PRODUCTS, DRAGON_PPC_SEARCH_TERMS, DRAGON_PPC_TARGETS); DAY, WEEK, MONTH, QUARTER, YEAR, TOTAL (DRAGON_SALES_COUNT, DRAGON_SALES_TOTALS) |
| rank type | group, product |
| reason | CUSTOMERRETURN, CUSTOMERSERVICEISSUE, DAMAGED_WAREHOUSE, LOST_WAREHOUSE, REIMBURSEMENT_REVERSAL (DRAGON_REIMBURSEMENTS); APPAREL_STYLE, APPAREL_TOO_LARGE, APPAREL_TOO_SMALL, DAMAGED_BY_CARRIER, DAMAGED_BY_FC, DEFECTIVE, DID_NOT_LIKE_COLOR, DID_NOT_LIKE_FABRIC, FOUND_BETTER_PRICE, JEWELRY_TOO_LARGE, JEWELRY_TOO_SMALL, MISSED_ESTIMATED_DELIVERY, MISSING_PARTS, NEVER_ARRIVED, NO_REASON_GIVEN, NOT_AS_DESCRIBED, NOT_COMPATIBLE, ORDERED_WRONG_ITEM, QUALITY_UNACCEPTABLE, SWITCHEROO, UNAUTHORIZED_PURCHASE, UNDELIVERABLE_REFUSED, UNDELIVERABLE_UNKNOWN, UNWANTED_ITEM (DRAGON_RETURNS) |
| recommended action | Filter by Amazon recommendation text, such as CREATE SHIPPING PLAN or NO ACTION REQUIRED. |
| report ID | Filter by report ID from DRAGON_SQP_LIST. |
| search query | Filter by search query text. Leave empty to include all search queries. |
| search term | Enter a value to filter by this field, or leave empty to include all values. |
| settlement ID | Filter by one or more settlement IDs. |
| severity | ERROR, WARNING |
| shipment ID | Filter by one or more inbound shipment IDs. |
| SKU | Enter one SKU, several SKUs, a cell range, or INDIRECT() pointing to a list of SKUs. |
| state | ACTIVE, PAUSED, ARCHIVED, ALL (DRAGON_PPC_ADGROUPS, DRAGON_PPC_CAMPAIGNS, DRAGON_PPC_NEGATIVES, DRAGON_PPC_TARGETS); ALL (DRAGON_PPC_PRODUCTS) |
| status | WORKING, READY_TO_SHIP, SHIPPED, IN_TRANSIT, DELIVERED, CHECKED_IN, RECEIVING, CLOSED, CANCELLED (DRAGON_INBOUND_FBA); GREAT, GOOD, FAIR, BAD (DRAGON_SELLER_PERFORMANCE) |
| storage type | Filter by storage type when Amazon provides one. Leave empty to include all storage types. |
| target | Enter a value to filter by this field, or leave empty to include all values. |
| target type | ALL, KEYWORD, PRODUCT, CATEGORY, THEME |
| type | Filter by type. Leave empty to include all types. |
| view | TOTAL, ASIN, SKU (DRAGON_OOS_RATE); DETAILS, SUMMARY, TOTAL (DRAGON_SALES_COUNT, DRAGON_SALES_TOTALS) |
Periods
Every accepted format for period and dates parameters. Spaces work in most values, so last 30 days equals last_30_days.
| Format | How it works |
|---|---|
| How periods work | A period is whole days in the time zone of the marketplace. Both the first and the last day are always included. Upper or lower case does not matter. |
| Single days | today, yesterday, 2d ago (the day before yesterday), or a date such as 2026-05-01. |
| Rolling periods | Use a number plus d, days, weeks or months for a window that ends today. Examples: 7d, 30d, last 12 weeks, last 6 months. previous 30 days is the 30 days before last 30 days. |
| Calendar periods | this week, this month, this quarter, this year run from the start of the period to today. last week, last month, last quarter, last year are the last completed one. Fixed periods: 2026-05 (a month), 2026 (a year), 2026Q1 (a quarter). A plain number is always a year, never days. |
| Year-ago periods | last week year ago and last month year ago are that calendar period one year earlier. same day last week, same day last month, same day last year are single days. For a window that ends on one of those days, use ending: 7d ending same day last year, 30d ending same day last month. |
| From..to | Two periods with two dots between them: from the first day of the left one to the last day of the right one. Examples: 2026-01-01..today, last month..yesterday, 2025Q4..2026Q1. Leave one side empty for an open end: ..yesterday If today is 2026-10-18, last month..yesterday is 2026-09-01 to 2026-10-17. |
| Ending on a day | Any period followed by ending and a single day. Ends the period on that day instead of today: a number of days is counted back from that day, a calendar period is cut off there. 7d ending 2d ago = 7 days, leaving out today and yesterday. this month ending yesterday = this month without today. 30d ending yesterday = the 30 days up to yesterday. If today is 2026-10-18, 7d ending 2d ago is 2026-10-10 to 2026-10-16, and this month ending yesterday is 2026-10-01 to 2026-10-17. |