Working with tables

Updated: 8/19/2026

Tables are the most common way to reach individual items in gas: posts, videos, campaigns, ad sets, media mentions or subject ratings. They work the same way everywhere, so whatever you learn on one page works on all the others too. This article describes every table control and, at the end, explains what a table remembers and where you set its default view.

Before you start

A table always shows data for the period selected in the page header and for the profile selected in the profile switcher above the table. When you change the period or the profile, the table loads again. The Refresh button in the page header forces a new load at any time.

The controls differ depending on the size of your screen:

On a computer you see the whole table and the whole button bar above it.
On a tablet the table is shown as well, but less important columns hide themselves depending on the window width, and the export and print buttons are not shown.
On a phone a list of cards is shown instead of the table, where one card is one row. It is described in the section Tables on a phone.

Sorting by a column

Click a column name in the table header. The rows are sorted in ascending order, that is from the smallest number or from the beginning of the alphabet, and an arrow appears next to the column name.
A second click on the same name reverses the sorting to descending, that is from the largest.
A third click cancels the sorting and the table returns to its default order.

You can also sort by several columns at once: first sort the table by the first column, then hold the Shift key and click the name of the second column. The second column then decides the order of rows that have the same value in the first column.

The column menu offers the same thing. Hover over the column header, click the three-dot icon and choose Sort ascending, Sort descending or Clear sorting.

Sorting is not available for some columns, for example for the Campaigns and Destination columns. Clicking their header therefore does nothing.

Filtering

A filter limits the table to the rows that match the condition you enter.

Hover over the header of the column you want to filter by.
Click the funnel icon that appears in the header. The filter box opens.
Choose a condition and enter a value. The table filters itself about half a second after you finish typing, you do not have to confirm anything.
Close the box by clicking anywhere outside it. As long as the filter is active, the funnel icon next to the header stays highlighted.

The conditions on offer differ according to the type of column:

Text column: Contains, Does not contain, Equals, Does not equal, Begins with, Ends with, Blank, Not blank.
Number column: Equals, Does not equal, Greater than, Less than, Greater than or equal to, Less than or equal to, Between (you fill in the From and To fields), Blank, Not blank.
Date column: Equals, Before, After, Between.
Selection from a list: a checkbox list of existing values with a Search... field and a (Select all) option. This is how the Campaigns and Destination columns are filtered, for example.
Yes or no column: the options Selected, Not selected and Both.

Below the first condition there is usually a second one with an AND and OR switch, so you can combine two conditions in a single column. Filters from different columns apply at the same time.

You cancel a filter with the Clear button right inside the filter box. Some tables also have a button with a crossed-out funnel icon in the bar above the table (tooltip Clear filters), which cancels the filters in all columns at once. That button appears only when at least one filter is active.

A filter applies to the whole table, not only to the page currently shown. The summary row at the bottom and the number of rows found are recalculated according to the filter as well.

Selecting and hiding columns

In the bar above the table, click the Columns button.
A list of all columns with checkboxes opens. Clicking a name turns the column on or off. The menu stays open, so you can switch several columns one after another.
If the table has more than six columns, there is a search field at the top of the menu where you type part of a column name.
The Show all columns option turns on all columns at once.
The Reset columns option returns the table to its original state: the default columns, their default order and their default widths.

the expanded Columns menu with checkboxes and the Show all columns and Reset columns options

Some columns are hidden the very first time you open the page, because they would not all fit on the screen. When you cannot see a column in a table, look for it here first.

Column width and order

You change the width by hovering over the vertical line between two column names, pressing the left mouse button and dragging to the left or to the right.
You change the order by grabbing a column name with the mouse and dragging it to another place in the table header.
The column menu (the three-dot icon in the header) also offers the options Autosize this column and Autosize all columns, which calculate the width from the content, and the Pin column option with the choices Pin left, Pin right and No pin. A pinned column stays visible even when you scroll the table sideways.

In a few tables the column widths and order are fixed and cannot be changed, for example in the subject ratings overview in the tourism module.

Summary row

Most tables have a bold row right at the bottom with the label Summary and a number in brackets. The number says how many rows in total match the filters you have set. The number columns contain the totals for all those rows, not only for the page currently shown. In text columns the summary row stays empty. The row is pinned to the bottom edge of the table, so you see it while scrolling too.

Paging and loading more

Most tables are split into pages. Below the table there is a bar with information about the rows shown, with the buttons First page, Previous page, Next page and Last page, and with the Page size: option. By default there are 15 rows on a page, and you can switch to 30, 60, 120 or 240.

Some tables are not paged, for example the tables in the campaign detail or in the destination comparison. There the rows scroll vertically inside the table and more of them load gradually as you scroll down.

Fullscreen view

In the bar above the table, click the button with the outward-pointing arrows icon; hovering over it shows the tooltip Enter fullscreen.
The table expands across the whole screen and the surrounding interface is hidden. The sorting, the filters and the displayed columns stay as they were.
You go back with the same button, which now has the tooltip Exit fullscreen, or with the Esc key.

Export and print

The bar above the table contains three buttons with icons whose tooltip appears when you hover over them: Export CSV, Export Excel and Print. They are shown only on a computer, in a sufficiently wide browser window.

Click Export CSV or Export Excel.
In the window that opens, choose the scope. The All rows option exports all rows regardless of paging; with large tables this takes a while. Without it, whatever is currently loaded in the table is exported. The All columns option also exports the columns you have hidden; without it, only the columns you can see are exported.
Click Export. The file is downloaded to your computer.

the export window with the All rows and All columns options and the Export button

Printing works in a similar way. With the Print button, or with the keyboard shortcut Ctrl+P (Cmd+P on a Mac), you open a window with the options All columns and Show full text and wrap lines, and you confirm with the Print button. The All rows option is not available for printing, because a browser cannot print an extensive table; use the export to CSV or Excel for complete data. Before the browser print window opens, the message Preparing data for printing appears, let it finish.

What a table remembers

Table settings are saved automatically, there is no save button here. They are saved in two different places, though, and it is good to know the difference.

In the browser you are working in, and separately for each table, these are remembered:

which columns are shown and which are hidden,
the order and widths of the columns,
the sorting,
the filters you have set.

These settings stay in place even after you close the browser and after you sign out. But they do not travel with you: on another computer, in another browser, in a private window or after you clear your browser data, you will see the table in its default form. They are not passed on to colleagues at all, everyone has their own.

Only for the duration of one visit the number of the page you were on is remembered. When you click through from the table into a detail and come back, you are on the same page. After you close the browser, the table starts from the first page again.

With your user account only the Show table in full width setting, described below, is saved. That one follows you on every device you sign in on.

If you want to show a colleague exactly what you see, send them an export or a printout to PDF. The table settings themselves are not passed on by a link or by signing in.

The default table view in your profile

Open Settings → User profile → Table view.
Tick the Show table in full width option.
The option is saved immediately, there is no save button here.

With the option turned on, pages with a table expand across the whole width of the window instead of the usual column in the middle. It is useful for tables with many columns and on a wide monitor.

You can also reach the same option straight from the table: the cog button in the bar above the table (tooltip Table view settings) opens the same setting in a small window.

Tables on a phone

On a phone a list of cards is shown instead of the table. One card is one row and shows the most important figures. The controls are adapted to touch:

At the top there are the Sorting and Filters buttons. They open a panel where you choose the column and the sorting direction, or set the filters, and confirm with the Apply button.
The filters you have set are shown as tags below the buttons. The cross on a tag removes one filter, the Clear button in the filter panel cancels all of them.
More records load by themselves as you scroll down.
Tapping a card opens the detail of that item, if the item has one.
Selecting columns, changing widths, exporting, printing and the fullscreen view are not available on a phone. Use a computer for that.

Even on a phone, gas remembers the sorting and filters you have set for each list separately, in the same browser.

Common problems

The table is empty even though there should be data in it

Most often a filter from earlier has stayed in it. Filters are remembered and apply even after you close the browser and after you sign out. Go through the column headers and look for a highlighted funnel icon, open it and click Clear. The second common cause is a selected period in which no items were created, try widening it.

A column I used to see has disappeared

The column is most likely only hidden. Open the Columns button and turn it on. On a tablet, less important columns also hide themselves depending on the window width, so on a wider screen or after you turn the tablet to landscape they will appear. If you are not sure what all you have changed in the table, use Columns → Reset columns.

The column order and widths have gone back to their original state

The table layout is saved in the browser in which you set it up. On another computer, in another browser, in a private window or after you clear your browser data, the table returns to its default form. It behaves the same way after you click Reset columns.

After switching the customer account the table is empty or sorted differently

The table remembers the layout, sorting and filters for itself, not per customer account. A filter set with one customer account therefore applies after you switch to another one, where no row may match it. Check the funnel icons in the column headers and clear the filters.

On a phone I see cards instead of a table

That is intended. A table with many columns does not fit on a phone display, so gas shows a list of cards with touch controls. You will see the full table on a tablet in landscape or on a computer.

I cannot see the export and print buttons

They are shown on a computer and only when the browser window is wide enough. They are not available to you on a phone or a tablet. If you cannot see them on a computer, try maximising the browser window, or reducing the page zoom (the Ctrl key and minus).

The table takes a long time to load

Loading takes longer when a long period is selected, when there are many profiles at once or when the page is large (120 or 240 rows). Shorten the period, choose a smaller page size or narrow the table with a filter. Ticking the All rows option during export also tends to be slow, because absolutely all the data has to load before the download.

The summary row does not match what I see on the page

The Summary row counts for the whole table with the filters taken into account, not for the page currently shown. When you want a total for only part of the data, narrow the table with a filter and the summary will be recalculated.

The export downloaded fewer rows than I expect

The All rows option was not ticked in the export window, so only what was loaded in the table was exported. Run the export again and tick the option.

The exported file has different columns than I expected

Without the All columns option, exactly the columns you have shown in the table are exported. With that option, all of them are exported including the hidden ones. The column with the control buttons never makes it into the export, because it contains no value.