Filtered row summary

Rows that aren't adequately aggregated to protect end-user privacy, or don't meet Ads Data Hub's other privacy checks, will be dropped from the results of a given query. You can configure a filtered row summary to return a single row containing constants and sums from dropped rows. This can help prevent discrepancies in your data totals, such as a total impression or total click count.

Example

In the example below, the rows containing campaigns 124 and 125 would be filtered, as they don’t meet the 50-user aggregation requirement.

Campaign ID Users
123 400
124 45
125 6

However, using a filtered row summary, the filtered data can be combined to meet the 50-user aggregation requirement. This example uses a sum to tally filtered data, and a constant to label the row:

  • A sum that aggregates filtered data from the Users column.
  • A constant (used to label the filtered row summary), set to "Filtered row summary" in the Geo column.
Campaign ID Users
Filtered row summary 51
123 400

Setup

To add a filtered row summary to a query:

  1. Identify the column that you would like to aggregate.
  2. Click + Add rule under "Filtered row summary" in the right-hand-side of the query editor.
  3. Enter the name of the column you would like to aggregate in the Column name field.
  4. Select Sum from the dropdown. If the sum falls below aggregation thresholds, the filtered row summary will be dropped.
  5. Optionally, add an identifier for the filtered row summary using a constant. Your constant must be a valid data type for your chosen row.
    1. Enter the name of the column in the Column name field.
    2. Select Constant from the "Datatype" dropdown menu.
    3. Enter an identifier for the row in the Specify constant field.