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.
In the example below, the rows containing campaigns 124 and 125 would be filtered, as they don’t meet the 50-user aggregation requirement.
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
- A constant (used to label the filtered row summary), set to "Filtered row summary" in the
|Filtered row summary||51|
To add a filtered row summary to a query:
- Identify the column that you would like to aggregate.
- Click + Add rule under "Filtered row summary" in the right-hand-side of the query editor.
- Enter the name of the column you would like to aggregate in the Column name field.
- Select Sum from the dropdown. If the sum falls below aggregation thresholds, the filtered row summary will be dropped.
- Optionally, add an identifier for the filtered row summary using a constant. Your constant must be a valid data type for your chosen row.
- Enter the name of the column in the Column name field.
- Select Constant from the "Datatype" dropdown menu.
- Enter an identifier for the row in the Specify constant field.