Sponsored Display
List, create, edit and archive Sponsored Display campaigns, ad groups, ads, targets and negatives from sheets.
The Sponsored Display panel manages SD advertising with one sheet per entity: campaigns, ad groups, ads, 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 SD 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 campaign or ad group.
Negatives
SD negatives are product or brand only, at ad-group level (no keyword negatives). Resolve Brand IDs turns a plain brand name into Name (id).
Every button
| Button | 中文 | What it does | Effect |
|---|---|---|---|
| List SD campaigns | 列出 | Fetch SD 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 SD Ad Groups sheet to that campaign and lists them. | WRITES SHEET |
| Load Targets | 加载投放 | Drill down: click a campaign row first — this filters the SD Targets sheet to that campaign and lists them. | WRITES SHEET |
| Create SD campaigns | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. | LIVE ON AMAZONWRITES SHEET |
| Edit SD campaigns | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. | LIVE ON AMAZONWRITES SHEET |
| Delete SD campaigns | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. | LIVE ON AMAZONWRITES SHEET |
| Setup SD campaigns Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). | WRITES SHEET |
| List SD ad groups | 列出 | Fetch SD 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 SD Ads sheet to that ad group and lists them. | WRITES SHEET |
| Load Targets | 加载投放 | Drill down: click a ad group row first — this filters the SD Targets sheet to that ad group and lists them. | WRITES SHEET |
| Create SD 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 SD ad groups | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. | LIVE ON AMAZONWRITES SHEET |
| Delete SD ad groups | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. | LIVE ON AMAZONWRITES SHEET |
| Setup SD ad groups Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). | WRITES SHEET |
| List SD ads | 列出 | Fetch SD ads using the row-4 filters. Default shows active only (ENABLED+PAUSED). | WRITES SHEET |
| Create SD ads | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. | LIVE ON AMAZONWRITES SHEET |
| Edit SD ads | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. | LIVE ON AMAZONWRITES SHEET |
| Delete SD ads | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. | LIVE ON AMAZONWRITES SHEET |
| Setup SD ads Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). | WRITES SHEET |
| List SD targets | 列出 | Fetch SD 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 SD targets | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. | LIVE ON AMAZONWRITES SHEET |
| Edit SD targets | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. | LIVE ON AMAZONWRITES SHEET |
| Delete SD targets | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. | LIVE ON AMAZONWRITES SHEET |
| Setup SD targets Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). | WRITES SHEET |
| List SD negatives | 列出 | Pull ALL SD negatives (product · brand, ad-group level) for the store, filtered by row-4 Campaign / State. | WRITES SHEET |
| Create SD negatives | 创建 | Create from rows with NO Target ID. SD is PRODUCT/BRAND only, ad-group level only (keyword is not offered). | 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 SD negatives | 编辑所选 | Push State (ENABLED/PAUSED) changes for ticked rows. | LIVE ON AMAZONWRITES SHEET |
| Delete SD negatives | 删除所选 | PERMANENTLY archive ticked negatives — v1 delete = archive. | LIVE ON AMAZONWRITES SHEET |
| Setup SD Negatives Sheet | 设置表格 | Create or reset the SD Negatives tab. | WRITES SHEET |
Prefer to ask an agent?
The same entities are available over MCP — see the Ads section of the tool reference.