Ads Table

The Ads Table shows paid ad performance in a row-by-row breakdown. It’s the workhorse widget for daily campaign analysis.

​

When to use an Ads Table

For paid ad data — for example, Meta Ads, Google Ads, TikTok Ads, LinkedIn Ads, or any other paid advertising data source. Once added, the Ads Table auto-populates with every connected ad account by default. For non-advertising data (analytics, e-commerce, CRM, spreadsheets, organic social, public), use the Generic Table.

​

Configure an Ads Table

​

Mandatory fields

Widget changes save automatically when the settings panel closes. Persist changes to the dashboard by clicking Save dashboard.

​

Optional fields

• Widget filter — filter this widget’s data without changing dashboard-wide filters. See Filters.
• Period — override the dashboard’s date range for this widget only. See Date ranges.
• Hide metric value — hide rows whose values fall at or below configurable thresholds. See the Hide metric value section.
• Show total row — toggle the Source aggregations row that summarizes visible metrics. See the Show total row section.
• Switch rows/columns — transposes the table so breakdowns become columns and metrics become rows.

​

Row hierarchy

Rows unfold in the order breakdowns are configured. For an Ads Table, the default order is Channel → Campaign → Ad set → Ad:

• Clicking a channel row opens its campaigns.
• Clicking a campaign row opens its ad sets.
• Clicking an ad set row opens its ads.

Change the order in the widget settings by dragging breakdowns. For more on how breakdowns work in general, see Breakdowns.

​

Show total row

Toggle Show total row in the widget settings to surface the Source aggregations row — a per-column summary at the top of the table that aggregates each metric at the highest level each channel supports. Different ad platforms provide data at different levels of granularity due to API constraints. When multiple channels appear in the same Ads Table, the Source aggregations row reflects those per-channel limits — so the aggregated total may not equal the plain sum of visible rows. Hover the info icon next to Source aggregations to see the per-channel aggregation level for the current widget.

​

Hide metric value

Hide metric value removes rows whose values reach a configured threshold. It’s useful for stripping out zero-spend rows or clearing noise from long tables. Two ways to configure:

• Preset (Hide: Value = 0) — enable the checkbox next to any of three metrics (Ad Spend, Impressions, Link Clicks) to hide rows with a value of 0 for that metric.
• Custom thresholds — pick a metric (Ad Spend, Impressions, or Link Clicks), choose a comparison operator (default ≤), and enter a value. Rows matching the condition are hidden.

Both blocks can be combined.

​

Setting targets

Set per-cell targets on the following metrics: CTR, View rate, CPC, CPV, CPM. Actual values compare against the target and render in color:

• Blue — the value meets or beats the target (good).
• Red — the value misses the target (bad).

The direction of “meets or beats” depends on the metric’s natural directionality:

• Metrics where lower is better (CPC, CPV, CPM) — value ≤ target is blue; value > target is red.
• Metrics where higher is better (CTR, View rate) — value ≥ target is blue; value < target is red.

For a dedicated widget that tracks progress against a target over time, see Goal widget.

​

Status column

Campaign status is available as a Status column, reflecting the ad platform’s own status (for example, Active, Paused, Ended). For channels that support campaign control from the dashboard, the row actions can turn campaigns on or off directly. See Campaign control.

​

Blended and converted data sources

The Ads Table supports both blended and converted data sources alongside standard ad accounts.

• Blended data sources — a single blend definition that reconciles two or more sources into one combined dataset (for example, blending Meta Ads with GA4 sessions). The Ads Table treats a blended source like any other ad account.
• Converted data sources — a non-ad source (for example, a Google Sheets tab or a CSV) that has been mapped into an ad-account-shaped schema. Once converted, it appears in the Ads Table’s data source picker.

For setup, see Data blending and Data conversion.

​

Multiple tables per dashboard

A dashboard can hold any number of Ads Tables. Common patterns:

• One Ads Table per channel, for side-by-side comparison.
• One Ads Table showing spend for the last 7 days, another showing conversions.
• One Ads Table for evergreen campaigns, another for promotional ones — separated by widget filters.

​

Reading and column controls

Column sort, in-cell value bars, conditional formatting, and column widths are described in Reading & interpreting tables.

​

Exporting

Every widget exposes an export menu in its header. See Exporting widget data for CSV email delivery, PDF export, and Google Sheets auto-update links.

​

Widget styling

Global widget style settings — font, border, background, and color themes — apply to every widget through the Dashboard style settings. On top of those, Ads Table widgets have style options unique to this widget type:

• Table border — outer border color (HEX) and weight for the table.
• Data font — HEX color used for cell values.
• Table header — background color (HEX) and font color (HEX) for the header row.
• KPI colors — the background colors used to render conditional formatting bands on numeric cells. Three states are configurable independently:
  • Normal — default cell color.
  • Good — value meets or exceeds the “good” threshold.
  • Warn — value falls in the mid-range band.
  Recoloring the KPI states changes only the visual — the thresholds themselves are set per-metric in the metric’s conditional formatting rules.
• Date display format — how each date breakdown renders in header labels and cells. Each breakdown level (Daily, Weekly Mon-start, Weekly Sun-start, Monthly, Quarterly) has its own format picker.

​

Troubleshooting