Skip to main content

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-…).

Required scope: advertising:read

Grant 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​

OK

Response Headers
    Content-Type