Skip to main content

Pivot Tables

Reorder, resize, sort, group and filter every table in Jamloop, and use the pivot table in reporting.

[Reviewer note: confirm the UI steps against the app, add screenshots and the walkthrough video, then delete this line.]

What changed

Every table in Jamloop has been rebuilt, including campaigns, line items, audiences, creatives, locations and reporting. You can now arrange each table the way you work.

In reporting, the multi-dimensional table is now called the pivot table. It's in the same place, and nothing needs to change on your side.

[Walkthrough video]

Arrange columns

  • Reorder: drag a column to a new position.

  • Resize: drag the edge of a column to make it wider or narrower, for example to fit long campaign names.

  • Sort: sort the table on any column.

Group results in the pivot table

In reporting, group dimensions into nested views to see how your results break down without exporting to a spreadsheet.

Example: group by campaign, then by publisher, to see which publishers are driving results within each campaign.

Filter on metrics

Filter rows on metric values, not only on names.

Example: filter cost per checkout to at least $1 to hide the rows where you spent but haven't seen a checkout yet.

Limitations

  • A few metrics can't be grouped yet.

  • Conditional formatting is not included.

FAQs

Where did the multi-dimensional table go?

It's now the pivot table, in the same place in reporting. No action is needed.

Which tables were updated?

All of them, including campaigns, line items, audiences, creatives, locations and reporting.

Why can't I group by a certain metric?

A few metrics can't be grouped yet. Group by a different dimension, or contact support if you need that view.

Did this answer your question?