Sponsored Brands
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.
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
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
| 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 AMAZONWRITES SHEET |
| Edit SB campaigns | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. | LIVE ON AMAZONWRITES SHEET |
| Delete SB campaigns | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. | LIVE ON AMAZONWRITES 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 AMAZONWRITES SHEET |
| Edit SB ad groups | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. | LIVE ON AMAZONWRITES SHEET |
| Delete SB ad groups | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. | LIVE ON AMAZONWRITES 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 AMAZONWRITES SHEET |
| Edit SB ads | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. | LIVE ON AMAZONWRITES SHEET |
| Delete SB ads | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. | LIVE ON AMAZONWRITES 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 AMAZONWRITES SHEET |
| Edit SB targets | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. | LIVE ON AMAZONWRITES SHEET |
| Delete SB targets | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. | LIVE ON AMAZONWRITES 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 AMAZONWRITES 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 AMAZONWRITES SHEET |
| Delete SB negatives | 删除所选 | PERMANENTLY archive ticked negatives — v1 delete = archive. | LIVE ON AMAZONWRITES 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 AMAZONWRITES SHEET |
| Edit SB ad associations | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. | LIVE ON AMAZONWRITES SHEET |
| Delete SB ad associations | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. | LIVE ON AMAZONWRITES SHEET |
| Setup SB Associations Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). | WRITES SHEET |
Prefer to ask an agent?
The same entities are available over MCP — see the Ads section of the tool reference.