Choose your rows

Which rows you can add, in which order, and how to get combinations such as territories and markets in one report.

Rows group the data down the page. Add as many as you need: each new row nests inside the one above it, such as each retailer inside its territory.

Add a row

Click + Add under the rows on the left and pick a row. Any row can go first.

The add row menu listing Markets, Packaging, Products, Retailer Owners, Retailers, SKUs and Territories

To remove a row, hover over its card and click the red delete icon.

Only the last row matters

Each row you add limits the next one. The Playground only checks the row directly above, so after Territories you can only add Retailers or SKUs.

A Territories row card with the add row menu open, offering only Retailers and SKUs

After this row……you can add next
TerritoriesRetailers, SKUs
MarketsProducts, Retailers, Publishers
RetailersMarkets, Retailer Owners, Territories, SKUs, Packaging, Products, Publishers, PerfectPage Metrics
Retailer OwnersRetailers
ProductsMarkets, SKUs, Packaging, PerfectPage Metrics
SKUsProducts, Territories, Packaging, PerfectPage Metrics
PackagingProducts, SKUs, Retailers
PublishersProducts, SKUs
PerfectPage MetricsNothing: it is always the last row

A row you have already used doesn't appear in the menu again.

Example: territories and markets

You can't add Markets straight after Territories, or Territories straight after Markets. Go through Retailers instead: Territories → Retailers → Markets.

This follows how the data is organised. A market is a category such as PlayStation or Audio, and each retailer belongs to one territory, so retailers link the two.

Three row cards in order: Territories, Retailers and Markets

After Retailers, the menu offers every row that can follow it:

The add row menu after a Retailers row, listing Markets, Packaging, Products, Retailer Owners, SKUs, Publishers and PerfectPage Metrics

PerfectPage Metrics rows

PerfectPage Metrics is greyed out unless the report type is Overall score. It is always the last row. If you change the report type afterwards, the PerfectPage Metrics row and its score filters are removed. See report types.

Rows and the column

A dimension can't be a row and the column at the same time. With Territories and Retailers as rows, for example, the column menu only offers Date, Product and SKU. See choose a column.

Sort each row

Each row card has two settings:

  • Order: Ascending or Descending
  • Sort by: Name, or Value to sort by the numbers in the report

Sort by Value has no effect for the Availability, Lost buy box, Tag and Voucher report types, because their cells aren't numbers. Those rows sort by name instead.

Add rows in a valid order

You can drag rows to reorder them, but dragging isn't checked against the rules above. A report reordered into an invalid order, such as Markets → Territories → Retailers, may not show the data you expect. To change the order, remove the rows and add them again in a valid order.

Last updated