Export Advertising Bulksheet
GET/api/advertising/bulksheets/export
Downloads the campaigns matching the same filters as List Campaigns, each followed by its ad groups, items and targets, as an XLSX or CSV file (advertising-sku-bulksheet-YYYYMMDD-HHMMSS.xlsx or advertising-amazon-bulksheet-…).
advertising:readGrant this scope to your token under Settings → Developer → Personal Access Tokens.
The sku layout has columns: Record Type, Record ID, Platform, Account ID, Account, Campaign ID, Campaign, Campaign Type, Ad Group ID, Ad Group, Entity, Match Type, State, Daily Budget, Bid, Ad Rate %, Target Value, Spend, Sales, ACoS, POAS. The amazon_bulksheet layout uses Amazon's Sponsored Products columns (Product, Entity, Operation, Campaign ID, Ad Group ID, Portfolio ID, Ad ID, Keyword ID, Product Targeting ID, Campaign Name, Ad Group Name, Start Date, End Date, Targeting Type, State, Daily Budget, SKU, ASIN, Ad Group Default Bid, Bid, Keyword Text, Match Type, Bidding Strategy, Product Targeting Expression).
Edit the State, Daily Budget, Bid, Ad Rate % or Target Value cells and upload the file with Import Advertising Bulksheet. Returns 422 when the view has too many rows for one sheet (filter it down).
Requires the advertising.view permission.
Also requires the advertising-manager feature (Advertising Manager plan); without it the endpoint returns 404.
Request
Responses
- 200
- 401
- 403
- 422
- 429
OK
Response Headers
Unauthenticated — the bearer token is missing, revoked, expired, or malformed. Never retry automatically; fix the credential. See the Errors guide.
Forbidden — the token lacks a required scope, the endpoint is not available to API tokens, or the user behind the token lacks the permission. A human must adjust the token scopes or user permissions; do not retry.
Unprocessable Content
Response Headers
Rate limited — platform limit is 1,000 requests/min; individual tokens may carry lower limits. Honor the Retry-After header before retrying. See the Rate Limits guide.