# How to Download Amazon PPC Reports in Google Sheets (https://sellersheetai.com/guides/download-amazon-ppc-reports-in-google-sheets)

> Download and analyze Amazon Sponsored Products advertising reports directly in Google Sheets. Create reports, track status, and get campaign, keyword, targeting, and search term data — all from the SellerSheet sidebar.



## Introduction [#introduction]

Analyzing Amazon PPC performance means logging into Seller Central, navigating to Campaign Manager, selecting date ranges, choosing report types, waiting for downloads, and then copy-pasting data into spreadsheets. For multiple report types or multiple stores, this becomes a daily time sink.

SellerSheet's **Ads Reports** feature lets you request and download Amazon Sponsored Products advertising reports directly into Google Sheets. Fill in your store, report type, and date range — then click two buttons in the sidebar to queue the report and retrieve the data.

This guide covers the full workflow: setting up the **Ads Reports** sheet, choosing from **10 report types** (campaigns, keywords, targeting, search terms, and more), and downloading the results into dedicated spreadsheets for analysis.

1. **Set up the sheet** — store, report type, dates.
2. **Create Reports** — queue them on Amazon's servers.
3. **Get Reports** — download the completed data.
4. **Analyze** — full metrics in Sheets.

## Prerequisites [#prerequisites]

* **Store connected:** connect your Amazon store under **Settings → Stores & Marketplaces** in the [SellerSheet app](https://sellersheetai.com/home).
* **Advertising authorized:** authorize Amazon Advertising API access for your store. This is a separate authorization from the SP-API store authorization.
* **Sidebar installed:** install the SellerSheet add-on in Google Sheets. See [Install & first sync](/help/sheets/install).
* **Active PPC campaigns:** you need active or historical Sponsored Products campaigns to generate reports.

## Setting up the Ads Reports sheet [#setting-up-the-ads-reports-sheet]

<Callout title="The problem">
  In Seller Central, downloading PPC reports means navigating Campaign Manager, selecting report types one at a time, waiting for each to generate, then downloading CSVs and importing them into your spreadsheet. For multiple report types across multiple stores, this takes a significant amount of time every week.
</Callout>

The **Ads Reports** sheet is where you define what reports you want. Each row represents one report request. You fill in the store, report type, and date range — then the sidebar handles the rest.

\[\[TODO: screenshot the Ads Reports sheet with the sidebar (retake — the old one showed a real store and spreadsheet)]]

### Ads Reports columns [#ads-reports-columns]

* **Store:** your store ref with country code (e.g. `myStore-US`).
* **Name:** the report type name. Must match one of the [supported report types](#available-report-types).
* **Start Date:** beginning of the reporting period.
* **End Date:** end of the reporting period.
* **Report ID:** *(auto-filled)* Amazon's unique identifier for the queued report.
* **Status:** *(auto-filled)* current status — `PENDING` or `COMPLETED`.
* **Report Sheet:** *(auto-filled)* hyperlink to the generated spreadsheet with full report data.
* **Report Folder:** *(auto-filled)* Google Drive folder where the report spreadsheet is saved.

To set up a report request, fill in a row with:

1. **Store** — select your store (e.g. `myStore-US`).
2. **Name** — enter the exact report type name (see [Available report types](#available-report-types) below).
3. **Start Date** — the first day of data you want.
4. **End Date** — the last day of data you want.

<Callout title="Pro tip: batch multiple reports">
  Add multiple rows for different report types and date ranges. **Create Reports** processes all rows at once, so you can queue a campaign summary, keyword report, and search term report in a single click.
</Callout>

## Step 1: Create Reports [#step-1-create-reports]

After filling in your report rows, open the SellerSheet sidebar, go to the **Ads** tab and its [Reports](/help/sheets/ads/reports) panel, and click **Create Reports**.

SellerSheet sends each report request to Amazon's Advertising API. For each row it:

1. Validates that **Store**, **Name**, **Start Date**, and **End Date** are filled in.
2. Constructs the full report configuration (columns, filters, groupBy, timeUnit) based on the report type name.
3. Sends the request to Amazon.
4. Writes the returned **Report ID** and **Status** back to the sheet.

Most reports start with status `PENDING` while Amazon generates the data. Some small reports may complete immediately and show `COMPLETED`.

<Callout type="warn" title="Report name must be exact">
  The **Name** column must exactly match one of the supported report type names (e.g. `SponsoredProductsTargetingSummaryReport`). Misspellings or unsupported names will fail. See the [full list below](#available-report-types).
</Callout>

## Step 2: Get Reports [#step-2-get-reports]

Once your reports have a **Report ID**, click **Get Reports** in the sidebar. SellerSheet checks the status of each pending report:

* **If COMPLETED:** downloads the full report data, creates a new Google Spreadsheet in your Drive, populates it with headers and all data rows, and writes a clickable hyperlink to the **Report Sheet** column.
* **If still PENDING:** updates the status. Wait a few minutes and click **Get Reports** again.

The generated spreadsheet contains every metric Amazon provides for the report type — impressions, clicks, spend, sales, ACOS, ROAS, and more, depending on the [report type](#available-report-types).

<Callout title="Pro tip: report generation time">
  Amazon typically generates advertising reports within 1–5 minutes. If a report is still `PENDING`, wait a few minutes and click **Get Reports** again. Rows that already have a **Report Sheet** link are automatically skipped.
</Callout>

## Available report types [#available-report-types]

SellerSheet supports **10 Sponsored Products report types**. Each covers different dimensions and time granularities. Use the exact **Name** in the table below when filling in your Ads Reports sheet.

| Report Name                                            | Time Unit | What It Covers                                                  |
| ------------------------------------------------------ | --------- | --------------------------------------------------------------- |
| `SponsoredProductsCampaignsSummaryReport`              | Summary   | Campaign-level performance summary                              |
| `SponsoredProductsCampaignsWithPlacementSummaryReport` | Summary   | Campaign performance broken down by ad placement                |
| `SponsoredProductsCampaignsWithAdGroupDailyReport`     | Daily     | Campaign and ad group level daily metrics                       |
| `SponsoredProductsKeywordsSummaryReport`               | Summary   | Keyword-level performance summary                               |
| `SponsoredProductsKeywordsAndTargetingSummaryReport`   | Summary   | Combined keywords and targeting performance                     |
| `SponsoredProductsTargetingSummaryReport`              | Summary   | Targeting-level performance (product targeting, auto targeting) |
| `SponsoredProductsSearchTermSummaryReport`             | Summary   | Search term performance and customer query analysis             |
| `SponsoredProductsAdvertisedProductDailyReport`        | Daily     | Daily performance for each advertised product (ASIN/SKU)        |
| `SponsoredProductsPurchasedProductDailyReport`         | Daily     | Products actually purchased through ad clicks (attribution)     |
| `SponsoredProductsGrossAndInvalidTrafficDailyReport`   | Daily     | Gross vs invalid traffic tracking and click quality             |

### Summary vs daily reports [#summary-vs-daily-reports]

* **Summary:** aggregated data for the entire date range. One row per campaign/keyword/targeting. Best for period-over-period comparisons.
* **Daily:** one row per day per entity. Best for trend analysis and identifying daily performance fluctuations.

## Report metrics [#report-metrics]

Each report spreadsheet contains 30–60 columns depending on the report type. Key metrics include:

| Category    | Metrics                                                                            |
| ----------- | ---------------------------------------------------------------------------------- |
| Traffic     | impressions, clicks, clickThroughRate, costPerClick                                |
| Spend       | cost, spend                                                                        |
| Conversions | purchases (1d/7d/14d/30d attribution windows), unitsSoldClicks                     |
| Revenue     | sales (1d/7d/14d/30d attribution windows)                                          |
| Efficiency  | acosClicks (7d/14d), roasClicks (7d/14d)                                           |
| Dimensions  | campaignName, adGroupName, keyword, targeting, advertisedAsin, purchasedAsin, date |

## Example workflow [#example-workflow]

Here's a typical workflow for pulling weekly PPC reports:

1. **Add report rows** to the Ads Reports sheet:

   | Store      | Name                                     | Start Date | End Date   |
   | ---------- | ---------------------------------------- | ---------- | ---------- |
   | myStore-US | SponsoredProductsCampaignsSummaryReport  | 2025-07-01 | 2025-07-07 |
   | myStore-US | SponsoredProductsSearchTermSummaryReport | 2025-07-01 | 2025-07-07 |
   | myStore-US | SponsoredProductsTargetingSummaryReport  | 2025-07-01 | 2025-07-22 |

2. **Click Create Reports** in the sidebar — all 3 reports are queued simultaneously. Report IDs and statuses appear in the sheet.

3. **Wait 1–5 minutes** for Amazon to generate the reports.

4. **Click Get Reports** — completed reports get a clickable link in the Report Sheet column. Click any link to open the full data in a new spreadsheet.

## Quick reference [#quick-reference]

| What You Need               | Action                             | Result                                      |
| --------------------------- | ---------------------------------- | ------------------------------------------- |
| Queue reports on Amazon     | **Create Reports**                 | Report ID + Status filled in                |
| Download completed data     | **Get Reports**                    | New spreadsheet with full report data       |
| Campaign-level overview     | Use `CampaignsSummaryReport`       | Spend, sales, ACOS per campaign             |
| Keyword optimization        | Use `KeywordsSummaryReport`        | Performance per keyword and match type      |
| Discover new keywords       | Use `SearchTermSummaryReport`      | Customer search queries that triggered ads  |
| Product-level ASIN analysis | Use `AdvertisedProductDailyReport` | Daily metrics per advertised ASIN/SKU       |
| Attribution analysis        | Use `PurchasedProductDailyReport`  | Which products customers actually purchased |

## Tips for PPC analysis [#tips-for-ppc-analysis]

* **Weekly routine:** set up the same report rows each week with updated dates. Create Reports on Monday morning, Get Reports a few minutes later, and you have last week's data ready to analyze.
* **Multiple stores:** add rows for different stores in the same sheet. Each row targets the store specified in the Store column, so you can pull reports for all your marketplaces at once.
* **Search term mining:** use the `SearchTermSummaryReport` to find high-converting customer search queries, then add them as exact match keywords to your campaigns.
* **ACOS tracking:** the `CampaignsSummaryReport` gives you ACOS (acosClicks7d/14d) and ROAS (roasClicks7d/14d) per campaign — perfect for identifying campaigns that need bid adjustments.
* **Placement analysis:** use `CampaignsWithPlacementSummaryReport` to see how your ads perform in Top of Search vs Rest of Search vs Product Pages. Adjust placement modifiers based on this data.

Every button of the panel is listed on [Ads → Reports](/help/sheets/ads/reports).