Skip to main content
Both the Ads Table and Generic Table share the same column-level and layout behavior. This article covers the elements that appear in a full-size table widget and what each one means. The Small table works differently — see its article.

​
Metric column controls

Hover on a column header — a small dropdown icon appears. The options in the menu depend on the column type.

​
Numeric columns

For metric columns that hold numbers (Spend, Clicks, CTR, ROAS, and so on), the dropdown has five options:
  • Sort ascending — smallest to largest.
  • Sort descending — largest to smallest.
  • Display as a column graph — toggle the inline horizontal indicator inside the cell. See Column graph indicator below.
  • Conditional formatting — apply Excel-style coloring rules to the column. See Conditional formatting.
  • Remove — remove the column from the widget.

​
String columns

For text columns like Campaign name or Ad name, the dropdown has three options:
  • Sort ascending.
  • Sort descending.
  • Remove.
Column graph and conditional formatting only apply to numeric columns and aren’t shown for string columns. Sort is per-widget and persists with the dashboard.

​
Column graph indicator

The “column graph” referenced here is an inline indicator drawn inside each cell of a table column — not the Column chart widget, which is a separate chart type.
Selected numeric columns render a horizontal bar behind the value in each cell. The bar length is proportional to the row’s value versus the largest visible value for that column, so standout rows are easy to spot. Toggle Display as a column graph from the column dropdown.

​
Conditional formatting

Conditional formatting applies Excel-style coloring rules to a numeric column. Open it from the column dropdown → Conditional formatting. Two modes:

​
Single color

Color cells that meet a condition.
  • Apply to — the column the rule applies to (defaults to the column the dropdown was opened from, for example, CPC).
  • Condition — a comparison operator (for example, >) and a value (for example, 600).
  • Target — where the color is applied:
    • Background color — fills the cell background.
    • Text color — colors the cell’s number.
    • Background + Text color — both at once.
  • Color — the color for the selected target(s).
For example, apply to CPC, condition > 600, Target Background color, red — every CPC cell above 600 renders with a red background.

​
Color scale

Color cells on a gradient from a low anchor to a high anchor.
  • Apply to — the column the rule applies to.
  • Target — where the gradient is applied: Background color, Text color, or Background + Text color.
  • Minpoint — the low anchor. Pick Number and enter a value; assign a color.
  • Midpoint — an optional middle anchor. Set to None to skip, or Number with a value and color.
  • Maxpoint — the high anchor. Pick Number and enter a value; assign a color.
Cells render on a gradient between the anchors. Cells outside the range clamp to the nearest anchor’s color. To clear a rule, open Conditional formatting again and click Clear formatting.
Conditional formatting is user-defined coloring. It’s different from the Ads Table’s Setting targets, which uses blue/red based on metric directionality.
Conditional formatting renders on transposed tables (Switch rows/columns enabled) the same way it does on normal tables. In Shareable Views and Snapshots, the Conditional formatting controls are hidden so viewers can’t change the rules — but the rules themselves still render.

​
Column widths

Two ways to resize columns:

​
Drag a single column

Drag the vertical divider between two column headers to resize that column freely. Or double-click the right edge of a column header to fit that one column to its longest visible value (including the header text).

​
Reset all columns at once

At the bottom-right of the widget, two buttons are always visible:
  • Fit all columns to content — every column resizes to fit the widest visible value in that column.
  • Make all columns same width — every column is set to the same width, regardless of content.
Both apply to metric and breakdown columns. Column widths persist when the dashboard is saved.

​
Others row

If a widget has a row limit (from a filter, a breakdown cap, or the widget’s default limit), rows beyond the limit are grouped into an Others row so the visible totals still reconcile against the widget’s total.

​
Save behavior

Sort selections, dropdown toggles, conditional-formatting rules, and column widths save automatically when the dropdown closes or when Conditional formatting is applied. Persist changes to the dashboard by clicking Save dashboard — otherwise the changes revert when the dashboard reloads. For refresh cadences and time-zone behavior across sources, see Time zones & data freshness.

​
Next steps

Ads Table

Row hierarchy, Show total row + Source aggregations, targets, and Status.

Generic Table

Non-advertising data sources with Totals.

Small table

Lightweight single-breakdown, single-metric widget.

Breakdowns

How breakdowns work in general.