# Sponsored Brands (https://sellersheetai.com/help/sheets/ads/sb)

> List, create, edit and archive Sponsored Brands campaigns, ad groups, ads, ad associations, targets and negatives from sheets.



The **Sponsored Brands** panel manages SB advertising with one sheet per entity: campaigns, ad groups, ads, ad associations, targets and negatives.

\[\[TODO: screenshot ads/sb]]

## How every ads sheet works [#how-every-ads-sheet-works]

* **Setup … Sheet** creates or resets the header block; data rows are not touched.
* **List …** fetches entities with the row-4 filters (by default ENABLED and PAUSED). On SB Targets, the Negative filter splits negatives from bidding targets.
* **Create …** sends the rows with the required ✎ fields and an EMPTY ID column; new IDs are written back.
* **Edit …** pushes the changes of the ticked rows only. **Delete …** archives the ticked rows on Amazon — it cannot be undone.
* **Load …** drills down from the clicked row (campaign → ad groups or targets, ad group → ads or targets, ad → ad associations).

## Negatives [#negatives]

SB negatives are ad-group level only (Level AD_GROUP with an ad group). **Resolve Brand IDs** looks a plain brand name up on Amazon and rewrites it as `Name (id)` before you create brand negatives.

## Every button [#every-button]

| Button | 中文 | What it does | Effect |
|---|---|---|---|
| List SB campaigns | 列出 | Fetch SB campaigns using the row-4 filters. Default shows active only (ENABLED+PAUSED). | WRITES SHEET |
| Load Ad Groups | 加载广告组 | Drill down: click a campaign row first — this filters the SB Ad Groups sheet to that campaign and lists them. | WRITES SHEET |
| Load Targets | 加载投放 | Drill down: click a campaign row first — this filters the SB Targets sheet to that campaign and lists them. | WRITES SHEET |
| Create SB campaigns | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. | LIVE ON AMAZON, WRITES SHEET |
| Edit SB campaigns | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. | LIVE ON AMAZON, WRITES SHEET |
| Delete SB campaigns | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. | LIVE ON AMAZON, WRITES SHEET |
| Setup SB campaigns Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). | WRITES SHEET |
| List SB ad groups | 列出 | Fetch SB ad groups using the row-4 filters. Default shows active only (ENABLED+PAUSED). | WRITES SHEET |
| Load Ads | 加载广告 | Drill down: click a ad group row first — this filters the SB Ads sheet to that ad group and lists them. | WRITES SHEET |
| Load Targets | 加载投放 | Drill down: click a ad group row first — this filters the SB Targets sheet to that ad group and lists them. | WRITES SHEET |
| Create SB ad groups | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. | LIVE ON AMAZON, WRITES SHEET |
| Edit SB ad groups | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. | LIVE ON AMAZON, WRITES SHEET |
| Delete SB ad groups | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. | LIVE ON AMAZON, WRITES SHEET |
| Setup SB ad groups Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). | WRITES SHEET |
| List SB ads | 列出 | Fetch SB ads using the row-4 filters. Default shows active only (ENABLED+PAUSED). | WRITES SHEET |
| Load Ad Associations | 加载广告关联 | Drill down: click a ad row first — this filters the SB Ad Associations sheet to that ad and lists them. | WRITES SHEET |
| Create SB ads | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. | LIVE ON AMAZON, WRITES SHEET |
| Edit SB ads | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. | LIVE ON AMAZON, WRITES SHEET |
| Delete SB ads | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. | LIVE ON AMAZON, WRITES SHEET |
| Setup SB ads Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). | WRITES SHEET |
| List SB targets | 列出 | Fetch SB targets using the row-4 filters. Default shows active only (ENABLED+PAUSED). Use the Negative filter (TRUE/FALSE/ALL) to split negatives from bidding targets. | WRITES SHEET |
| Create SB targets | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. | LIVE ON AMAZON, WRITES SHEET |
| Edit SB targets | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. | LIVE ON AMAZON, WRITES SHEET |
| Delete SB targets | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. | LIVE ON AMAZON, WRITES SHEET |
| Setup SB targets Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). | WRITES SHEET |
| List SB negatives | 列出 | Pull ALL SB negatives (keyword · product · brand, ad-group level) for the store, filtered by row-4 Campaign / State. Names from Ads Names. | WRITES SHEET |
| Create SB negatives | 创建 | Create from rows with NO Target ID. Per-type gate first; SB is ad-group level only (Level=AD_GROUP + an Ad Group required). | LIVE ON AMAZON, WRITES SHEET |
| Resolve Brand IDs | 解析品牌 ID | For ticked BRAND rows with a plain name, look up the brand via Amazon and rewrite as 'Name (id)'. | WRITES SHEET |
| Edit SB negatives | 编辑所选 | Push State (ENABLED/PAUSED) changes for ticked rows. | LIVE ON AMAZON, WRITES SHEET |
| Delete SB negatives | 删除所选 | PERMANENTLY archive ticked negatives — v1 delete = archive. | LIVE ON AMAZON, WRITES SHEET |
| Setup SB Negatives Sheet | 设置表格 | Create or reset the SB Negatives tab. | WRITES SHEET |
| List SB ad associations | 列出 | Fetch SB ad associations using the row-4 filters. Default shows active only (ENABLED+PAUSED). | WRITES SHEET |
| Create SB ad associations | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. | LIVE ON AMAZON, WRITES SHEET |
| Edit SB ad associations | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. | LIVE ON AMAZON, WRITES SHEET |
| Delete SB ad associations | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. | LIVE ON AMAZON, WRITES SHEET |
| Setup SB Associations Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). | WRITES SHEET |

## Prefer to ask an agent? [#prefer-to-ask-an-agent]

The same entities are available over MCP — see the Ads section of the [tool reference](/docs/mcp-api/tools).
