Skip to main content

List Unmapped Ad Items

GET 

/api/advertising/unmapped-items

Lists advertised items (ASINs, listings, offers) on selected ad accounts that SKU.io could not match to a product and that had spend in the last 30 days, highest spend first by default. Their spend cannot be attributed to a product until mapped with Map Ad Item to Product.

Required scope: advertising:read

Grant this scope to your token under Settings → Developer → Personal Access Tokens.

Requires the advertising.view permission. Token scope: advertising:read (personal access and OAuth tokens).

Filters (all optional): filter[search] (seller SKU, identifier or campaign name, partial match; restrict with the top-level search_columns / search_strict_columns parameters). Text filters: platform (amazon_ads, ebay, google_ads, walmart_connect, meta_ads, tiktok_ads), account (ad account name), identifier, identifier_type, seller_sku, campaign (campaign name). Numeric filters: ad_account_id, spend_30d, clicks_30d, attributed_sales_30d.

Filter operators. Text filters accept filter[<field>]=value (exact match) or filter[<field>.<operator>]=value with operators contains, does_not_contain, is, is_not, is_one_of, is_not_one_of, starts_with, does_not_start_with, ends_with, does_not_end_with, is_empty, is_not_empty. Numeric filters accept is, is_not, is_one_of, is_not_one_of, greater_than, less_than, greater_than_or_equal, less_than_or_equal, between (comma-separated pair), is_empty, is_not_empty. Unknown filter names are rejected with 400 Bad Request.

filter_groups accepts a base64-encoded JSON filter tree for AND/OR combinations: {"conjunction": "and", "children": [{"type": "condition", "condition": {"column": "<field>.<operator>", "operator": "<operator>", "value": "..."}}, {"type": "group", "group": {"conjunction": "or", "children": [...]}}]}. When it is present it takes precedence over the flat filter[...] parameters.

Sorts: spend_30d, clicks_30d, attributed_sales_30d, identifier, seller_sku, account, platform; prefix with - for descending (default -spend_30d).

Pagination: per_page default 10, max 200; page.

Fields: id (ad item id), ad_account_id, ad_account_name, platform, ad_campaign_id, campaign_name, identifier_type (asin, seller_sku, ebay_listing_id, google_offer_id, meta_retailer_id, tiktok_item_group_id, walmart_item_id), identifier, seller_sku, state (enabled, paused, archived, ended), spend_30d and attributed_sales_30d (tenant currency), clicks_30d.

Request​

Responses​

OK

Response Headers
    Content-Type