> For the complete documentation index, see [llms.txt](https://docs.sellermagnet.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.sellermagnet.com/ppc-management-beta/ppc-manager-overview/ppc-analytics.md).

# PPC Analytics

Deep-dive into your Amazon PPC performance with interactive charts, keyword tables, product breakdowns, and dayparting heatmaps, all in one view.

{% hint style="info" %}
**Difficulty:** 🔴 Advanced · **Reading time:** \~20 min
{% endhint %}

{% hint style="success" icon="rocket" %}
**Open this page in your dashboard:** [**Go to PPC Analytics \[BETA\] →**](https://dashboard.sellermagnet.com/ppc/analytics)
{% endhint %}

{% hint style="warning" icon="triangle-exclamation" %}
**BETA:** The PPC Manager is currently in beta. Some features may behave unexpectedly or change based on user feedback. Please report any issues at <info@sellermagnet.com>.
{% endhint %}

## 📋 Overview

The **PPC Analytics** page is your central hub for understanding how your Amazon advertising campaigns are performing. It combines **8 key KPIs**, **interactive charts**, and **detailed data tables** to give you a complete picture, from high-level trends to individual keyword performance.

Whether you want to know which keywords are burning cash, which products deliver the best return on ad spend, or what time of day your ads convert best, the Analytics page surfaces all of this in a single view, no spreadsheets required.

**Who can open it:** you need to be logged in, have a project selected, and have an Amazon Ads connection. There is no waitlist for this page. If your plan includes the PPC AI Optimizer but not PPC Manager, controls that belong to PPC Manager can appear greyed out with the label "Upgrade to PPC Manager". That is a plan difference, not an error.

### How the Page Is Laid Out

Below the filter bar the page runs through six sections, in this order:

1. **Performance overview:** the 8 KPI cards, plus a Performance Insights banner when there is something to flag
2. **Revenue trend:** the Performance Trend chart
3. **Campaigns in range:** every campaign, with the campaign modal behind each row
4. **Discovery: keywords & products:** Keyword Performance and Product Performance (with a P\&L view)
5. **Efficiency:** Placement Performance
6. **Timing:** the Hourly Performance Heatmap

The **Jump to section** bar under the filters links to each section (Overview, Revenue trend, Efficiency, Campaigns, Discovery, Timing). Its link order differs slightly from the order on the page; the list above is the on-page order, and this guide follows it.

A dismissible **How to use PPC Analytics** card sits above the filter bar. It has three short bullets: "See where the money goes.", "Compare to last period." and "Act on the page." Dismiss it with the X and it stays dismissed in that browser.

Every section also has a collapsible **How to read this & when to act** bar with two parts, **What this shows.** and **How to act.** These are rules of thumb. Use your own break-even ACoS (see below) as the final judge.

***

## 🔍 Filters

The filter bar at the top applies to the whole page. The heatmap has a few extra controls of its own, described in its section.

| Filter                         | Options                                                                            | Default          |
| ------------------------------ | ---------------------------------------------------------------------------------- | ---------------- |
| **Date Range (UTC)**           | Last 7, 14, 30, 60, 90 or 180 Days, Last 12 Months, or Custom Range                | Last 30 Days     |
| **Campaign**                   | All Campaigns, or one specific campaign                                            | All Campaigns    |
| **Profile**                    | All Marketplaces, or one marketplace profile                                       | All Marketplaces |
| **Ad type**                    | Pills: All, SP (Sponsored Products), SB (Sponsored Brands), SD (Sponsored Display) | All              |
| **Compare to previous period** | Toggle button (see below)                                                          | On               |

Notes on the individual controls:

* **Date Range (UTC):** the label says UTC and its tooltip reads "Dates are in UTC. Your local timezone may differ." The PPC Manager page labels its date range with marketplace time instead, so the same "Last 7 Days" can cover slightly different days on the two pages. Keep that in mind when you compare numbers between them.
* **Custom Range:** choosing it reveals **From** and **To** date inputs. They only accept dates up to 90 days back.
* **Profile:** this select replaces the older Marketplace select, which is hidden. Its first option is **All Marketplaces**. When you pick a profile, a **Set as default** star button appears next to it; clicking it makes that profile the project default ("Set this profile as the project default"). For the profile that already is the default, the button reads "Default profile" and is inactive.
* **Ad type:** these are pills, not a dropdown. Clicking one reloads the page data for that ad type.
* **Compare to previous period:** the button reads "Compare to previous period" when off and "Comparing to previous period" when on. It is **on by default**, and your choice is remembered in the browser. When on, a chip next to it spells out the dates being compared, in the form "{current dates} vs {previous dates}". On narrower windows the same text moves into the button's tooltip. It always compares against the **previous period of equal length**, directly before your range.
* **Refresh:** reloads all the data on the page with the current filters.
* **Export** and **Export KPIs:** see the Export section below.
* **Save as view:** the bookmark button. It asks "Name this view:" (dialog title "Save this view", button "Save view"). Saved views appear as pills under the filter bar; clicking a pill re-applies it and confirms with "Saved view applied." A view stores four filters: Date Range, Campaign, Profile and Ad type.

On narrower windows the filter-bar buttons can show only their icons. Hover over an icon to see its name.

### Filter Best Practices

{% hint style="info" %}
**When to use each date range:**

* **Last 7 days:** Quick pulse check; useful after a bid change to see early results
* **Last 14 days:** Good for A/B comparisons (this week vs. last week)
* **Last 30 days:** Standard analysis window; most statistically reliable
* **Last 60/90 days:** Trend analysis and seasonal pattern detection
* **Last 180 days / Last 12 Months:** Long-run view. The trend chart switches to weekly totals once the range is longer than 120 days
  {% endhint %}

{% hint style="warning" %}
**Marketplace Filter Warning:** When viewing "All Marketplaces" with more than one currency, the money figures behave differently from a single-marketplace view. See "Reading Totals Across Several Currencies" below. For accurate financial analysis, always filter to a single profile.
{% endhint %}

***

## 📊 Key Performance Indicators

> **Rough orientation for beginners:** CTR above 0.5% and CVR above 10% are generally healthy signs. Whether a given ACoS is profitable depends entirely on your margin, so compare it against your own break-even ACoS rather than a fixed number.

At the top of the page, **8 KPI cards** provide an at-a-glance summary for the selected period:

| KPI             | Description                                                          | What "Good" Looks Like                                |
| --------------- | -------------------------------------------------------------------- | ----------------------------------------------------- |
| **Spend**       | Total advertising spend, in the currency of the selected marketplace | Controlled growth aligned with sales                  |
| **Sales**       | Total attributed sales from advertising (organic sales are excluded) | Should grow faster than spend                         |
| **ACoS**        | Advertising Cost of Sale (Spend / Sales x 100)                       | Below your break-even ACoS                            |
| **CPC**         | Cost Per Click (Spend / Clicks)                                      | Depends on niche; lower is better if CVR stays stable |
| **Impressions** | Total number of times your ads were shown                            | Trending upward indicates growing visibility          |
| **Clicks**      | Total clicks received across all campaigns                           | Steady growth with a healthy CTR                      |
| **CTR**         | Click-Through Rate (Clicks / Impressions x 100)                      | 0.3% - 0.5% for SP is typical; above 0.5% is strong   |
| **CVR**         | Conversion Rate (Orders / Clicks x 100)                              | 10% - 15% is solid for most categories                |

### How to Read KPI Cards

Each card displays:

1. **The metric value** for the selected date range
2. **A change chip** compared to the previous equal-length period (shown while **Compare to previous period** is on)
3. **A 14-day sparkline** under the value showing the daily shape: flat means stable, jagged means noisy, sloped means a real trend

The change chip is plain text, with no arrows. It reads **+x.x%** or **-x.x%** for volume and money metrics. For rate metrics (ACoS, CTR and CVR) it shows the change in percentage points instead, such as **+1.25pp**; hover over it to see the previous and current values. A card shows no chip when the previous period's value was zero.

{% hint style="warning" %}
**Common Confusion: the colour tells you good or bad, not the sign.** A chip is **green when the change is an improvement** and **red when it is not**. So a **-3.20pp** chip on ACoS is green, and a **+8.0%** chip on CPC is red. Read it per metric:

* **Green when the number goes up:** Impressions, Clicks, Sales, CTR, CVR
* **Green when the number goes down:** ACoS, CPC
* **Spend** is judged in context: a rise in spend is green. A fall in spend is green only if sales fell by no more than 1.5 times as much as spend did (or sales rose). Otherwise it is red, because you cut spend and lost more sales than you saved.

Always check the direction in context of what each metric means. A green Spend chip only means the change was not a harmful cut; it does not tell you whether extra spend was profitable.
{% endhint %}

> **Pro Tip:** Focus on **ACoS and CVR first**. These two metrics together tell you whether your advertising is profitable (ACoS) and whether your listings are converting traffic into sales (CVR). Impressions and clicks are vanity metrics if they do not lead to conversions.

### Reading Totals Across Several Currencies

If **All Marketplaces** covers more than one currency (for example EUR and GBP), the page cannot simply add the numbers together. Here is what each part of the page does:

**KPI cards.**

* **Impressions, Clicks, CTR and CVR** have no currency and are always shown normally.
* **Spend, Sales, ACoS and CPC** show either a **converted total** or a **dash**. When a currency conversion is available, the cards show your totals converted into your project's base currency at current FX rates, and a small note under the cards says "Converted to {ccy} at {fx\_date} rates." When no conversion is available, the four cards show a dash.
* **Change chips are hidden** on Spend, Sales, ACoS and CPC while several currencies are in view.

**Warning chip.** A chip above the Performance overview section explains the situation and has a **Show per-marketplace breakdown** button (it turns into **Hide per-marketplace breakdown**). It comes in two wordings:

* When the cards are not converted: *"Showing totals across multiple currencies. Per-currency totals are NOT directly comparable; click below to see the breakdown."*
* When the cards are converted: *"Totals above are converted to {base\_ccy} at current FX rates. Amounts below span {n} native currencies ({list}) and are NOT directly comparable to each other; click below to see the breakdown."*

The breakdown opens automatically. It is a small table with the columns **Marketplace**, **Spend**, **Sales**, **ACoS** and **Orders**, each marketplace in its own native currency. If it cannot be built for your selection, it says "Per-marketplace breakdown unavailable for the current selection."

**Trend chart.** The money views (Spend vs Sales, Sales, ROAS, ACoS Trend, CPC Trend) plot converted values when a conversion is available. Without one, the chart shows "Several currencies in view - pick one marketplace to chart money metrics". The volume views (Impressions & Clicks, CTR & CVR, Orders) always draw.

**Product table.** There is no banner here. Each row shows its money in **its own marketplace's currency symbol**, and an ASIN that runs in more than one currency shows a dash instead of Spend and Sales (its tooltip reads "This ASIN runs in multiple currencies - totals are not directly comparable").

**Insights banner, Placement table and Heatmap.** These add money across marketplaces **without converting it**. When the warning chip above is not visible, they carry a note: *"Amounts below span N currencies (list) and are summed nominally - not directly comparable. Filter to one marketplace for accurate totals."* Treat those figures as a rough sense of scale only. The Heatmap shows this note only for money metrics (Sales, Spend, ACoS, CPC).

**Exports.** The Currency column in the Export and Export KPIs files reads MIXED when several currencies are in view.

{% hint style="warning" %}
**For a true P\&L, filter to one profile.** Select a single marketplace in the **Profile** select so every value is in one currency before you make spend or profitability decisions. The P\&L view of the Product table always works per marketplace, in that marketplace's currency.
{% endhint %}

### Performance Insights Banner

When the page has recommendations for the selected range, a dismissible **Performance Insights** banner appears under the KPI cards. It starts with a scope line ("All campaigns in the selected marketplace view" plus the dates) and lists the findings, each with a **Review details** or **Review search terms** link. Dismissing it hides it for 7 days.

### Understanding Your Break-Even ACoS

Before you can judge whether your ACoS is "good" or "bad," you need to know your **break-even ACoS**, the point at which your ad spend exactly equals your profit margin.

**Formula:**

```
Break-Even ACoS = (Product Price - Product Cost - Amazon Fees) / Product Price x 100
```

**Example:** You sell a yoga mat on Amazon DE for EUR 29.99. Your landed cost is EUR 8.00 and Amazon fees (referral + FBA) are EUR 11.00.

```
Break-Even ACoS = (29.99 - 8.00 - 11.00) / 29.99 x 100 = 36.6%
```

Any ACoS below 36.6% means your ads are profitable. Any ACoS above 36.6% means you are losing money on each ad-driven sale.

The **P\&L view** of the Product Performance table (below) calculates a break-even ACoS for each of your advertised products from your real prices, fees and costs.

> **Target ACoS vs. Break-Even ACoS:** Your target ACoS should be *below* your break-even ACoS. How far below depends on your goals. For maximum profit, set it 10-15 points below break-even. For aggressive growth (prioritizing market share), you might accept break-even or slightly above.

***

## Performance Trend Chart

![SellerMagnet PPC Analytics](https://4139654583-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fih2knSvVpBcq5rIeXVjM%2Fuploads%2Fgit-blob-8516516e21bdc3d4e474034555799b9384b9ee34%2Fppc-analytics.png?alt=media)

A dynamic multi-metric chart that lets you switch between **8 views**:

| View                     | Chart Type       | Metrics Displayed                  | When to Use                                                |
| ------------------------ | ---------------- | ---------------------------------- | ---------------------------------------------------------- |
| **Spend vs Sales**       | Dual-line area   | Spend (red) and Sales (green)      | Daily profitability check, are sales outpacing spend?      |
| **Sales**                | Single line      | Ad-attributed sales over time      | Isolate the revenue line without the spend overlay         |
| **ROAS**                 | Single line      | Return on Ad Spend over time       | Track ad efficiency trending up (good) or down             |
| **ACoS Trend**           | Single line      | ACoS percentage over time (orange) | Track optimization progress over weeks/months              |
| **Impressions & Clicks** | Bar + line combo | Impressions (bar) + Clicks (line)  | Monitor visibility and engagement trends                   |
| **CTR & CVR**            | Dual line        | CTR and CVR percentages            | Diagnose listing or targeting issues                       |
| **CPC Trend**            | Single line      | Cost Per Click over time           | Monitor bid competitiveness and market conditions          |
| **Orders**               | Bar chart        | Daily/weekly order volume          | Correlate with promotions, seasonality, or external events |

Switch between views using the **toggle buttons** above the chart. The chart updates instantly without page reload.

**Daily or weekly points:** the chart draws **one point per day for ranges up to 120 days**. For longer ranges (Last 180 Days, Last 12 Months) it groups the data into **ISO weekly totals** (weeks start on Monday), and ACoS, CTR, CVR and CPC are recalculated from those weekly sums. The page's own help drawer says "daily up to 90 days"; the chart itself switches at 120 days. The Export file always stays daily.

**Recent days are drawn dashed.** Today (and, for sales-based lines, the last days still collecting attributed sales, up to 14 days after a click) is shown dashed, with a tooltip noting that it is still settling. Do not read a dip at the right edge of the chart as a real drop.

**Empty chart:** if there is no ad activity for your filters, you see "Why is this chart empty?" with a **Reset to Last 30 Days** button.

### How to Read the Trend Chart Effectively

> **Pro Tip:** Set the date range to **Last 30 days** and switch to the **ACoS Trend** view. A steadily declining ACoS line means your optimizations are working. If ACoS is flat or rising, it is time to review your keyword bids and search term quality.

#### Example: Diagnosing a Sudden ACoS Spike

You notice your ACoS jumped from 22% to 38% on a single day. Here is how to investigate:

{% stepper %}
{% step %}

### Switch to Spend vs Sales view

**Switch to Spend vs Sales view:** Did spend spike or did sales drop?
{% endstep %}

{% step %}

### Switch to CPC Trend

**Switch to CPC Trend:** Did your cost per click increase (more competition)?
{% endstep %}

{% step %}

### Switch to CTR & CVR

**Switch to CTR & CVR:** Did conversion rate drop (listing issue or irrelevant traffic)?
{% endstep %}

{% step %}

### Check the Keyword Performance Table

**Check the Keyword Performance Table** further down the page. Set its sort to **By Spend** and look for keywords with high spend and a red ACoS to find the cause keywords
{% endstep %}

{% step %}

### Cross-reference with Search Terms

**Cross-reference with Search Terms** page. Were there new, irrelevant search terms consuming budget?
{% endstep %}
{% endstepper %}

***

## Campaigns Table

The **Campaigns in range** section lists every campaign in the selected range, aggregated.

**Toolbar:**

* **Search campaigns…** box
* **Campaign focus** select: **All campaigns**, **Spend without sales**, **Spend above sales**, **Enabled with no clicks**
* **Sort** select: **By Spend** (default), **By Sales**, **By Clicks**, **By ACoS** (lowest ACoS first; campaigns without sales come last)
* **Columns** button (see "Choosing Columns" below)
* **Export** menu (see the Export section)

Under the toolbar, a status line shows "{shown} of {total} campaigns" and the note "Uses the selected period and marketplace. Review reporting coverage before changing bids." If your search and focus match nothing, the table says so and offers a **Show all campaigns** button.

| Column          | Description                                                                                                  |
| --------------- | ------------------------------------------------------------------------------------------------------------ |
| **Campaign**    | Campaign name. A country flag comes before the name, and automatic-targeting campaigns carry an **AUTO** tag |
| **Type**        | SP, SB, or SD                                                                                                |
| **State**       | Enabled, Paused, or Archived                                                                                 |
| **Impressions** | Ad impressions                                                                                               |
| **Clicks**      | Clicks received                                                                                              |
| **Spend**       | Advertising spend                                                                                            |
| **Sales**       | Attributed sales                                                                                             |
| **ACoS**        | Advertising Cost of Sale, colour-coded (see "Colour-Coded Metrics")                                          |
| **Orders**      | Number of attributed orders                                                                                  |
| **Review**      | A **Review campaign** button that opens the campaign modal                                                   |

The table itself has no issue flags. The issues for a campaign live inside the modal, on the **Bottlenecks** tab.

### Campaign Modal

Click a row, press Enter on a focused row, or click **Review campaign** to open the campaign detail. It is a **centred modal** (not a side drawer) with **ten tabs**:

| Tab                 | What it covers                                                                                                                                  |
| ------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------- |
| **Overview**        | The campaign summary. It opens with a decision briefing when one is available                                                                   |
| **Performance**     | The campaign's performance over time                                                                                                            |
| **Bottlenecks**     | Rule-based findings under "Issues detected", some with an **Apply fix** button. If nothing is found it says "No additional rule-based findings" |
| **Keywords**        | The campaign's keywords                                                                                                                         |
| **Search Terms**    | The search terms that triggered the campaign's ads                                                                                              |
| **Targets**         | Product-targeting clauses (they apply to AUTO and product-targeting campaigns)                                                                  |
| **Negatives**       | Negative keywords and targets                                                                                                                   |
| **History**         | Recent changes                                                                                                                                  |
| **Rules**           | Rules that apply to the campaign                                                                                                                |
| **Recommendations** | Suggested actions                                                                                                                               |

> **Pro Tip:** Open the campaign modal and read the Overview briefing and the Bottlenecks tab first. They surface the most common fixes, such as raising a budget, pausing a wasted keyword or negating a burned search term, without leaving the Analytics page. One-click fixes only appear when the page's evidence checks pass, so treat a missing button as a reason to review, not as an error.

***

## Keyword Performance Table

The **Discovery: keywords & products** group holds the Keyword and Product tables. The keyword table shows the **Top 50 by selected metric**. There is no pagination, and it is not sortable by every column.

**Toolbar:**

* **Search keywords…** box: a client-side filter over the rows already shown
* **Sort** select: **By Sales** (default), **By Clicks**, **By ACoS**, **By Spend**. Changing it asks for the top 50 by that metric, so the list itself can change
* **Columns** button
* **Export** menu

The info bar for this section describes the list as every keyword that drove clicks in the range.

| Column          | Description                                                                                                                                                                                                                                                                                                                                |
| --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Keyword**     | The keyword text. Product targets that look like ASINs are shown in capitals with an ASIN tag                                                                                                                                                                                                                                              |
| **Match**       | Broad, Phrase, or Exact                                                                                                                                                                                                                                                                                                                    |
| **Impressions** | Number of ad impressions                                                                                                                                                                                                                                                                                                                   |
| **Clicks**      | Number of clicks received                                                                                                                                                                                                                                                                                                                  |
| **Spend**       | Total spend on this keyword                                                                                                                                                                                                                                                                                                                |
| **Sales**       | Attributed sales                                                                                                                                                                                                                                                                                                                           |
| **ACoS**        | Advertising Cost of Sale                                                                                                                                                                                                                                                                                                                   |
| **CTR**         | Click-Through Rate                                                                                                                                                                                                                                                                                                                         |
| **CVR**         | Conversion Rate                                                                                                                                                                                                                                                                                                                            |
| **CPC**         | Cost Per Click                                                                                                                                                                                                                                                                                                                             |
| **Score**       | A chip with a quality score (0-100) and a grade. Tooltip: "Quality score (0-100). Weighted: profitability 30%, CVR 25%, volume 15%, trend 10%, efficiency 10%, revenue impact 10%. Click to sort." Click the **Score** header to sort by score, highest first; click again to flip to lowest first. A dash means no score is available yet |

The Score chip is green at 70 and above, amber from 30 to 69, and red below 30. Hover over a chip to see the six factor values behind it.

### Colour-Coded Metrics

ACoS, CTR, CVR and ROAS cells in the campaign, keyword and product tables are colour-coded with **fixed thresholds**. A tooltip names the tier: Good, Fair or Poor.

| Metric   | Good           | Fair         | Poor       |
| -------- | -------------- | ------------ | ---------- |
| **ACoS** | 20% or lower   | 20% to 35%   | Above 35%  |
| **ROAS** | 3x or higher   | 2x to 3x     | Below 2x   |
| **CTR**  | 0.5% or higher | 0.3% to 0.5% | Below 0.3% |
| **CVR**  | 10% or higher  | 5% to 10%    | Below 5%   |

These thresholds are the same for every account. They are not tied to **your** target ACoS or break-even ACoS, so a "Poor" 36% ACoS can still be profitable on a high-margin product. Judge ACoS against your own break-even.

### Keyword Analysis Workflow

Here is a structured approach to reviewing your keyword performance:

**Step 1: Find Your Winners** Set the sort to **By Sales** (the default) to see your highest-revenue keywords. These are the keywords driving your business. Ensure their bids are competitive and their ACoS is within target.

**Step 2: Find Your Losers** Set the sort to **By Spend**, then scan for keywords with high spend but zero or very low sales. These are burning your budget. Consider lowering bids or adding them as negatives if they are clearly irrelevant.

**Step 3: Find Hidden Opportunities** There is no CVR sort. Instead, scan the **CVR** column for keywords with a strong conversion rate (green) but low **Impressions**, or sort by **Score** to bring well-rounded keywords to the top. Those keywords convert well but may not be getting enough traffic. Consider increasing bids to win more auctions. Because the table lists only the top 50, a keyword that is small on all four sorts will not appear; use the campaign modal's **Keywords** tab or the Search Terms page to look further.

**Step 4: Compare Match Types** There is no match-type filter. Read the **Match** column by eye, or type a match type such as "exact" into the **Search keywords…** box (it matches any text in a row, so it can also catch keywords that contain that word). Typically, Exact match keywords have the lowest ACoS but also the lowest volume, while Broad match drives the most impressions but at a higher ACoS.

> **Pro Tip:** Set the sort to **By Spend** and export the table. The top 20% of keywords by spend typically account for 80% of your total ad spend. Focus your optimization efforts on these high-impact keywords first, small ACoS improvements on high-spend keywords translate into significant savings.

#### Example: Keyword Optimization Decision Matrix

| Scenario                          | Clicks | Sales    | ACoS     | Action                                                                   |
| --------------------------------- | ------ | -------- | -------- | ------------------------------------------------------------------------ |
| High clicks, high sales, low ACoS | 200+   | EUR 500+ | < 20%    | Increase bid to capture more volume                                      |
| High clicks, low sales, high ACoS | 200+   | < EUR 50 | > 40%    | Lower bid by 20-30% or check listing relevance                           |
| Low clicks, high CVR, low ACoS    | < 30   | EUR 100+ | < 15%    | Increase bid significantly, this is a hidden gem                         |
| High spend, zero sales            | 50+    | EUR 0    | Infinite | Add as negative keyword or pause                                         |
| Low impressions, 0 clicks         | < 100  | EUR 0    | N/A      | Increase bid to test; if still no impressions, keyword may be irrelevant |

***

## Product Performance Table

See how individual products perform in your ads. A **Performance / P\&L** switch in the toolbar changes the table between two views.

**Toolbar:**

* **Performance / P\&L** switch
* **Search products…** box
* **Sort** select: **By Sales** (default), **By Clicks**, **By ACoS**, **By Spend** (Performance view only)
* **Columns** button (Performance view only)
* **Export** menu (Performance view) or **Export P\&L** (P\&L view)

### Performance View

| Column          | Description                                                                                                                                        |
| --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- |
| **ASIN**        | The advertised product, with its image, a country flag and the product name underneath. The ASIN is a link: click it to open the product on Amazon |
| **Impressions** | Ad impressions for this product                                                                                                                    |
| **Clicks**      | Clicks received                                                                                                                                    |
| **Spend**       | Advertising spend                                                                                                                                  |
| **Sales**       | Attributed sales                                                                                                                                   |
| **ACoS**        | Advertising Cost of Sale                                                                                                                           |
| **ROAS**        | Return on Ad Spend (Sales / Spend)                                                                                                                 |
| **CTR**         | Click-Through Rate                                                                                                                                 |
| **CVR**         | Conversion Rate                                                                                                                                    |
| **Orders**      | Number of attributed orders                                                                                                                        |

Spend and Sales appear **in each product's own marketplace currency**. See "Reading Totals Across Several Currencies" above for how mixed-currency ASINs are shown.

{% hint style="info" icon="lightbulb" %}
**Pro Tip:** To find your most advertising-efficient products, set the sort to **By ACoS**. It lists the lowest ACoS first (products without sales come last), which is the same order as highest ROAS first. These products earn the most revenue per euro spent on ads. Consider allocating more budget to campaigns promoting them. ROAS is a column, but it is not a sort option.
{% endhint %}

### P\&L View

Click **P\&L** to see the same advertised products as a profit and loss table, one row per product **and marketplace**, in that marketplace's currency. A line above the table states the time window used. **The date range in the filter bar does not apply to this view.** If there are many products, the table shows the products with the most ad spend and says how many. You can narrow it with **Search products…** (by ASIN) and the **Profile** select. The deep link `?products_view=pnl` on the page URL opens the page straight on this view.

| Column                     | Description                                                                                                                                                                      |
| -------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **ASIN**                   | The product, with its country flag. A **Loses money before ads** badge marks products that lose money per unit after Amazon fees, cost of goods and returns, before any ad spend |
| **Spend**                  | Ad spend for the window, with the ACoS underneath                                                                                                                                |
| **Break-even ACoS**        | Contribution per unit divided by the net price: the highest ACoS at which an ad sale still breaks even                                                                           |
| **Contribution / unit**    | Net price minus Amazon fees, cost of goods and shipping, per unit kept, before any ad spend                                                                                      |
| **Contribution after ads** | Contribution per unit times the units kept, minus the ad spend of the same window                                                                                                |
| **Profit / ad order**      | Contribution of the units in one ad order, minus the ad spend per ad order                                                                                                       |
| **Max CPC at break-even**  | The most a click can cost before an ad sale loses money, with "your CPC" shown underneath when known                                                                             |
| **Product TACoS**          | Ad spend divided by all ordered sales of the product in this marketplace                                                                                                         |
| **Organic share**          | Share of the units sold that the ads did not bring                                                                                                                               |
| **Actions**                | **Pause product ad**, **Open campaign** and **Review price** (the last opens the Repricer for that ASIN)                                                                         |

Where a figure cannot be calculated, the cell shows a dash. Hover over it for the reason: "No cost of goods - add it on the Products page" (the dash is a link to that page) or "Price, fees or shipping rate missing for this marketplace".

**Pause product ad** asks you to confirm first. The dialog is titled "Pause this product ad?" and lists the campaigns in that marketplace where the ASIN stops advertising. The campaigns and their other products keep running. Each pause can be **undone from the Activity Log for 24 hours**.

**Export P\&L** downloads the table as CSV or Excel. It adds columns the screen does not show, such as Marketplace, Currency, Net price, Amazon fees, Cost of goods, Shipping and Units sold.

#### Example: Product-Level Budget Allocation

You sell five products on Amazon UK. Here is your product performance:

| Product                    | Spend   | Sales   | ACoS  | ROAS  | Action                                      |
| -------------------------- | ------- | ------- | ----- | ----- | ------------------------------------------- |
| Premium Phone Case (Black) | GBP 120 | GBP 680 | 17.6% | 5.67x | Increase budget: top performer              |
| Premium Phone Case (Blue)  | GBP 95  | GBP 310 | 30.6% | 3.26x | Maintain: acceptable ACoS                   |
| Screen Protector 2-Pack    | GBP 200 | GBP 220 | 90.9% | 1.10x | Reduce budget: nearly unprofitable          |
| Charging Cable (1m)        | GBP 60  | GBP 0   | N/A   | 0x    | Pause ads: listing needs work first         |
| Phone Stand                | GBP 45  | GBP 185 | 24.3% | 4.11x | Increase budget: strong ROAS with low spend |

{% hint style="warning" %}
**Do Not Just Pause Low-Performing Products.** Before cutting ad spend on a product, check if the listing itself is the problem. A product with high clicks but zero sales may need better images, pricing, or bullet points, not fewer ads. Fix the listing first, then re-evaluate ad performance.
{% endhint %}

***

## Placement Performance

Understand where your ads are performing best with a **placement breakdown**:

* **Bar chart:** a clustered bar chart with two bars per placement, **Spend** and **Sales**, so you can compare them side by side
* **Data table:** detailed metrics per placement (Top of Search, Product Pages, Rest of Search):

| Column          | Description                                                                                       |
| --------------- | ------------------------------------------------------------------------------------------------- |
| **Placement**   | Placement name                                                                                    |
| **Impressions** | Ad impressions in this placement                                                                  |
| **% of Impr.**  | This placement's share of all impressions                                                         |
| **Clicks**      | Clicks received                                                                                   |
| **Spend**       | Advertising spend                                                                                 |
| **Sales**       | Attributed sales                                                                                  |
| **% of Sales**  | This placement's share of all sales                                                               |
| **ACoS**        | Calculated from the row's spend and sales; Amazon does not report a placement-level ACoS directly |

There is also a **Columns** button and an **Export** menu in the section header.

A few things to know when reading this section:

* A placement with **fewer than 10 impressions** shows "-" for Spend, Sales and ACoS, with the tooltip "Insufficient data for the period".
* A chip reads "Placement data through {date} (Amazon delivers placement reports with a 2-3 day delay)." Placement data therefore ends a few days before the KPI cards do, so do not expect the two to match for the most recent days.
* A note can appear saying the placement totals were reconciled to campaign spend, so overlapping placement reports do not double-count.

{% hint style="info" icon="circle-info" %}
**What the three placements mean:** **Top of Search** = the ad slots in the search-results header (first row). **Product Pages** = ads on competitors' product detail pages. **Rest of Search** = ad slots lower down and on later pages of search results.
{% endhint %}

> Use placement data to decide where to increase or decrease **placement bid adjustments** in your campaign settings.

### Placement Comparison Guide

| Placement          | Typical Behavior                                 | Optimization Strategy                                                        |
| ------------------ | ------------------------------------------------ | ---------------------------------------------------------------------------- |
| **Top of Search**  | Highest CTR, highest CPC, often best CVR         | Increase bid adjustment if ACoS is below target, this is premium real estate |
| **Product Pages**  | Lower CPC, variable CVR depending on product fit | Good for brand defense and cross-selling; watch ACoS closely                 |
| **Rest of Search** | Lowest CPC, lowest CTR, mixed CVR                | Use as a volume play; reduce bids if ACoS is high                            |

#### Example: Optimizing Placement Bids

You sell premium stainless steel water bottles on Amazon DE. Your placement data shows:

| Placement      | Spend   | Sales     | ACoS  |
| -------------- | ------- | --------- | ----- |
| Top of Search  | EUR 450 | EUR 2,100 | 21.4% |
| Product Pages  | EUR 280 | EUR 620   | 45.2% |
| Rest of Search | EUR 170 | EUR 410   | 41.5% |

**Action:** Top of Search is performing well below your 30% ACoS target, consider increasing the Top of Search placement bid adjustment by 25-50% to capture more of this high-converting traffic. For Product Pages, investigate which competitor product pages are showing your ads and whether those placements are relevant.

> **Pro Tip:** Top of Search placements typically convert 2-3x better than other placements for branded and high-intent keywords. If your Top of Search ACoS is strong, increasing the bid adjustment here is one of the fastest ways to scale profitable ad spend.

***

## Hourly Performance Heatmap (Dayparting)

A **7x24 grid heatmap** visualizing performance by **day of week** and **hour of day**:

* Switch between 6 metrics with the **Metric** pills: **Sales**, **Clicks**, **Spend**, **Impressions**, **ACoS**, **CPC**
* Color intensity indicates performance level (darker = higher value)
* Identify your **best-performing hours** to optimize ad scheduling

This is especially useful for **dayparting strategies**, shifting budget toward your highest-converting time slots.

**Heatmap controls:**

| Control    | Options                                                                                                                  |
| ---------- | ------------------------------------------------------------------------------------------------------------------------ |
| **Metric** | Sales, Clicks, Spend, Impressions, ACoS, CPC                                                                             |
| **Period** | Use Page Date Range (default), This Week, Last Week, This Month, Last Month, Last 90 Days, Last 180 Days, Last 12 Months |
| **Type**   | All, SP, SB, SD                                                                                                          |
| **Scale**  | Linear or Log (your choice is remembered). Log helps when a few cells are far larger than the rest                       |

Changing Period or Type reloads only the heatmap; the rest of the page stays as it is.

### Measured Hours and Estimated Hours

The hours come from **Amazon Marketing Stream**, in each marketplace's local time. A line under the heatmap title says "measured from Amazon Marketing Stream" together with the number of campaign-days behind it.

Where no Marketing Stream data covers your selection, the page **approximates** the hours instead. It spreads each day's totals across the hours using a generic e-commerce traffic curve, shows the warning **Hourly distribution is approximated**, and labels the subtitle "estimated". Treat individual hour cells as illustrative in that case, and do not build a schedule on them.

If there is no hourly data at all, you see **No hourly data yet**: Amazon needs at least one full day of completed reports before the heatmap fills in. For a brand-new account, wait 24-48 hours after the first sync. Otherwise widen the date range or remove campaign filters.

### How to Use the Heatmap for Dayparting

{% stepper %}
{% step %}

### Select "Sales" as the metric

**Select "Sales" as the metric** to see when customers are buying
{% endstep %}

{% step %}

### Select "ACoS" as the metric

**Select "ACoS" as the metric** to see when your ads are most cost-efficient (look for lighter/lower areas)
{% endstep %}

{% step %}

### Compare the two

**Compare the two:** the best time slots have high sales AND low ACoS
{% endstep %}

{% step %}

### Create Bid Rules

**Create Bid Rules** based on your findings, for example, increase bids by 20% during your top-converting hours
{% endstep %}
{% endstepper %}

#### Example: Dayparting for a German Marketplace Seller

You sell kitchen accessories on Amazon DE. Your heatmap reveals:

* **Peak Sales Hours:** Monday-Friday, 19:00-22:00 (after work) and Sunday 10:00-14:00 (weekend browsing)
* **Lowest ACoS:** Tuesday and Wednesday evenings (19:00-21:00): ACoS of 18% vs. your average of 26%
* **Highest ACoS:** Saturday 02:00-06:00: ACoS of 55% (low-intent late-night clicks)

**Action:** Create a bid rule that increases bids by 15% during Tuesday-Wednesday evenings and decreases bids by 25% during Saturday early morning hours. Check the result afterwards in the Activity Log's Result column rather than assuming the change worked.

{% hint style="warning" %}
**Important:** Amazon does not natively support dayparting (time-based bidding). SellerMagnet's Bid Rules feature allows you to simulate dayparting by adjusting bids on a schedule. However, bid changes take effect with a slight delay, so use broad time windows (2-3 hour blocks) rather than trying to optimize by individual hour.
{% endhint %}

***

## Choosing Columns

The Campaigns, Keyword, Product and Placement tables each have a **Columns** button ("Show or hide columns"). You can also right-click a table header. Your choice is saved to your account as your default view ("Saved as your default view"), and a **Reset to default** option restores the standard columns. The table header carries the hint "Right-click the table header to change columns".

***

## 📤 Export

Exports are spread over four places, and every one of them offers **CSV** and **Excel**:

| Where                                                                       | What you get                                                                                                                                                                                                  |
| --------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Export** (filter bar)                                                     | The **daily trend rows** for the current filters: Date, Currency, Impressions, Clicks, Spend, Sales, Orders, ACoS, CTR, CVR, CPC. The file stays daily even when the chart shows weekly totals                |
| **Export KPIs** (filter bar)                                                | **One summary row** for the period: Period Start, Period End, Currency, Impressions, Clicks, Spend, Sales, Orders, ACoS %, CTR %, CVR %, CPC, ROAS                                                            |
| **Export** in the Campaigns, Keyword, Product and Placement section headers | A copy of the **visible rendered table**, with the headers and rows as they are on screen at the moment you click. It follows your current filters, search and sort, and it only covers rows that have loaded |
| **Export P\&L** (P\&L view)                                                 | The product P\&L table, with the extra cost columns described above                                                                                                                                           |

The files contain what the page shows. They do not include campaign or ad group IDs, targeting types or bid amounts. The Currency column reads MIXED when several currencies are in view.

> **Pro Tip:** Set up a monthly export routine. Download Export KPIs and the Keyword and Product tables on the first day of each month for the previous 30 days. Over time, this builds a historical dataset that is invaluable for year-over-year comparisons, seasonal planning, and tracking long-term optimization progress.

***

## 🔄 Illustrative Example: Analytics-Driven Optimization

The figures below are invented to show how the page is meant to be read. They are not measured results and not a forecast.

### Before: Managing PPC Without Analytics

A seller running phone accessories on Amazon DE manages campaigns by checking Seller Central once a week. They adjust bids based on gut feeling and pause keywords that "feel" too expensive.

| Metric                          | Value                  |
| ------------------------------- | ---------------------- |
| Monthly Ad Spend                | EUR 1,200              |
| Monthly Ad Sales                | EUR 3,100              |
| ACoS                            | 38.7%                  |
| Wasted Spend (0-order keywords) | EUR 340 (28% of total) |
| Top-Converting Hours Identified | None                   |
| Keywords Actively Monitored     | \~30 (top of mind)     |

### After: 30 Days Using PPC Analytics

The same seller now reviews the Analytics dashboard three times per week, uses the keyword performance table to cut wasteful spend, and applies dayparting insights from the heatmap.

| Metric                          | Value                  | Change        |
| ------------------------------- | ---------------------- | ------------- |
| Monthly Ad Spend                | EUR 980                | -18%          |
| Monthly Ad Sales                | EUR 3,450              | +11%          |
| ACoS                            | 28.4%                  | -10.3 points  |
| Wasted Spend (0-order keywords) | EUR 85 (8.7% of total) | -75%          |
| Top-Converting Hours Identified | 6 time slots           | From zero     |
| Keywords Actively Monitored     | All 280+               | Full coverage |

{% hint style="success" %}
**What changed:** spend went down while sales went up, so ACoS fell. The point of the example is the method - read the keyword table to find spend without orders, and read the heatmap before changing bids by hour.
{% endhint %}

***

<details>

<summary><strong>⚠️ Common Mistakes to Avoid</strong></summary>

{% hint style="danger" %}

* **Mistake 1: Obsessing Over Daily ACoS Fluctuations** ACoS can swing wildly on any given day due to Amazon's attribution window, low sample sizes, or a single high-value order. Always evaluate ACoS over at least a 7-day window, and ideally 14-30 days, before making optimization decisions.
* **Mistake 2: Ignoring Low-Impression Keywords** Keywords with very few impressions (under 100) are often overlooked, but they can be signals. If a keyword has 50 impressions, 3 clicks, and 2 orders, it has a 66% CVR, that is a keyword worth investing in. Scan the CVR column to find these hidden gems.
* **Mistake 3: Not Filtering by Marketplace** Aggregated data across marketplaces hides important differences. A keyword might have 15% ACoS on Amazon DE but 55% ACoS on Amazon FR. If you only look at the blended number (30%), you miss the fact that FR is dragging your profitability down. Use the Profile select to look at one marketplace at a time.
* **Mistake 4: Treating All Campaign Types the Same** Sponsored Products, Sponsored Brands, and Sponsored Display have fundamentally different purposes and benchmarks. SP is typically for direct-response sales, SB builds brand awareness, and SD targets audiences. Use the Ad type pills when setting expectations and making comparisons.
* **Mistake 5: Reacting to a Single Day of Data** If your CPC doubled on a Tuesday, do not panic and slash all bids on Wednesday. Check if it was an outlier (marketplace event, competitor spike, Amazon glitch). Wait 3-5 days to confirm a trend before making structural changes.
  {% endhint %}

</details>

## 🔧 Troubleshooting

### "My Analytics page shows no data"

{% stepper %}
{% step %}

### Check connection status

**Check connection status:** Go to PPC --> Settings and verify your Amazon Ads account is connected
{% endstep %}

{% step %}

### Check sync status

**Check sync status:** Look for the sync banner at the top of the page ("Syncing your PPC data…"). If it is showing, wait for it to complete
{% endstep %}

{% step %}

### Check date range

**Check date range:** Ensure the selected date range covers a period when you had active campaigns
{% endstep %}

{% step %}

### Check filters

**Check filters:** Set Campaign to All Campaigns, Profile to All Marketplaces and Ad type to All, or use the **Reset to Last 30 Days** button on an empty chart, to rule out overly restrictive filtering
{% endstep %}
{% endstepper %}

### "My KPI numbers don't match Seller Central or the Ads console"

* Attribution windows vary by report and ad product, and recent sales can still be revised. The Sales tooltip says exactly that and notes that organic sales are excluded
* The PPC Manager's Sales tooltip adds that it uses Amazon's 14-day attribution, while the Ads console shows 7-day sales for Sponsored Products seller campaigns. That alone can make a figure differ from the console
* Placement data ends a few days earlier than the KPI cards (Amazon delivers placement reports with a 2-3 day delay)
* This page's date range is in UTC, while the PPC Manager uses marketplace time, so the first and last day of a range can differ
* Click **Refresh** to reload the data and compare again

### "The heatmap looks empty or has very light colors"

* If you see **No hourly data yet**, Amazon needs at least one full day of completed reports. For a brand-new account, wait 24-48 hours after the first sync
* If you see the warning **Hourly distribution is approximated**, no Marketing Stream hours cover your selection, so the cells are estimates
* Widen the date range, remove campaign filters, or try the Scale pill **Log** if a few cells dominate the colors

### "Keywords are missing from the table"

* The table lists keywords that drove clicks in the range, limited to the **Top 50** for the selected sort. Change the sort (By Sales, By Clicks, By ACoS, By Spend) to see a different top 50
* Clear the **Search keywords…** box
* Check that your Campaign, Profile and Ad type filters are not excluding the campaigns containing those keywords

### "Spend and Sales show a dash"

* You are probably viewing All Marketplaces across more than one currency, and no conversion is available. Pick a single marketplace in the **Profile** select, or see "Reading Totals Across Several Currencies" above

***

## Template: Weekly Analytics Review Checklist

Use this checklist every week to stay on top of your PPC performance:

```
Weekly PPC Analytics Review: [Date]
=====================================

1. [ ] Review 8 KPI cards: any significant changes from last week?
2. [ ] Check Spend vs Sales trend: is the gap widening or narrowing?
3. [ ] Review ACoS trend: trending down (good) or up (investigate)?
4. [ ] Keyword table, sorted By Spend: top 10 keywords still on target?
5. [ ] Scan the ACoS column in that list: any keyword above 2x your target ACoS?
6. [ ] Check the Product table (By ACoS, lowest first): any product with ROAS below 1.5x?
7. [ ] Review placement data: Top of Search still outperforming?
8. [ ] Glance at heatmap: any new patterns emerging?
9. [ ] Export data for monthly archive (first week of month only)
10. [ ] Note 2-3 action items for next week:
 - Action 1: _______________
 - Action 2: _______________
 - Action 3: _______________
```

> **Pro Tip:** This review should take 15-20 minutes once you are familiar with the dashboard. Consistency beats intensity, a brief weekly review is far more effective than an exhaustive monthly deep-dive.

***

## ❓ FAQ

<details>

<summary><strong>What attribution model does Amazon use for ad sales?</strong></summary>

Ad sales follow Amazon's own attribution: a sale is credited to an ad when the purchase happens within an attribution window after the click. The window is not the same for every report and ad product. The Sales tooltip on this page says: "Attribution windows vary by report and ad product; recent sales can still be revised. Organic sales are excluded." In the PPC Manager, the Sales tooltip adds that it uses Amazon's 14-day attribution, while the Ads console shows 7-day sales for Sponsored Products seller campaigns. On the trend chart, the most recent days are drawn dashed because they are still collecting attributed sales.

</details>

<details>

<summary><strong>Why is my CVR showing 0% even though I have sales?</strong></summary>

CVR is calculated as Orders / Clicks. If you have very few clicks (e.g., 2 clicks and 1 order = 50% CVR), the number may appear as 0% due to rounding in some views. Increase the date range to accumulate more data.

</details>

<details>

<summary><strong>Can I see data for campaigns that are currently paused?</strong></summary>

Yes. The Analytics page shows historical performance data for all campaigns, including paused and archived ones, as long as the selected date range includes a period when those campaigns were active.

</details>

<details>

<summary><strong>How often is the data updated?</strong></summary>

The page loads fresh data every time you open it, change a filter or click **Refresh**. There is no sync-schedule setting on this page. How current the underlying numbers are depends on when Amazon delivers its reports: placement reports arrive with a 2-3 day delay, and recent sales can still be revised. While a first sync is running, a sync banner at the top shows its progress.

</details>

<details>

<summary><strong>What is the difference between ACoS and ROAS?</strong></summary>

ACoS (Advertising Cost of Sale) = Spend / Sales x 100. ROAS (Return on Ad Spend) = Sales / Spend. They are inverse measures of the same thing. An ACoS of 25% equals a ROAS of 4x. Lower ACoS is better; higher ROAS is better.

</details>

<details>

<summary><strong>Why do my keyword-level sales not add up to my total campaign sales?</strong></summary>

Amazon does not attribute all sales at the keyword level. Some sales (especially for auto campaigns) may be attributed at the campaign or ad group level but not to a specific keyword. The "total" in the KPI cards reflects all attributed sales. The keyword table also shows only the top 50 keywords for the selected sort.

</details>

<details>

<summary><strong>Can I compare two date ranges side by side?</strong></summary>

Partly. The **Compare to previous period** toggle (on by default) compares your selected range with the previous period of equal length, and shows the result as change chips on the KPI cards. Choosing any two arbitrary ranges side by side is not available. For that, export the data for two ranges and compare them in a spreadsheet. We recommend keeping monthly exports for this purpose.

</details>

<details>

<summary><strong>Does the heatmap account for time zones?</strong></summary>

Yes, where it has measured data. The hours come from Amazon Marketing Stream in each marketplace's local time, so they match when customers in that marketplace are actually active. Where no Marketing Stream data covers your selection, the page spreads each day's totals across the hours using a generic traffic curve and shows the warning "Hourly distribution is approximated". Those cells are an estimate, not a measured time zone pattern.

</details>

<details>

<summary><strong>Why do I see dashes instead of Spend and Sales?</strong></summary>

Your view spans more than one currency and no currency conversion is available, so the four money cards (Spend, Sales, ACoS and CPC) are not added up. Select one marketplace in the **Profile** select to see real figures. See "Reading Totals Across Several Currencies" above.

</details>

***

## ➡️ What's Next?

{% content-ref url="/pages/EYVZo8o8rsyLvj6QVN1J" %}
[PPC Search Terms](https://docs.sellermagnet.com/ppc-management-beta/ppc-manager-overview/ppc-search-terms.md)
{% endcontent-ref %}

{% content-ref url="/pages/5gaYA3QhcKl8Rx0EmNCL" %}
[PPC Keyword Research](https://docs.sellermagnet.com/ppc-management-beta/ppc-manager-overview/ppc-keyword-research.md)
{% endcontent-ref %}
