Zero metrics in search results
When you execute a query, you may encounter metrics for entities that are zero. This could be because:
- The entities are ineligible for display.
- They could have been paused within the report's date range.
With query results, you often want to obtain information about how your campaigns are performing. In this context, zero metrics may not be desirable. To produce a more useful report, you can explicitly exclude zero metrics.
Exclude zero metrics with a predicate
A predicate is an expression that evaluates to TRUE
, FALSE
, or UNKNOWN
.
They are used in the search condition of the WHERE
clauses in Google Ads Query Language
.
The following query demonstrates how to explicitly remove zero metrics with a predicate:
SELECT
campaign
.
id
,
metrics
.
impressions
FROM
campaign
WHERE
metrics
.
impressions
>
0
Exclude zero metrics by segmenting
Zero metrics are always excluded when segmenting a report, provided all selected metrics are zero (see below ).
Segmenting a report is done by including any segments
field in the search
query. For example, if you segment a report by segments.date
, metrics are
broken down with one row for each date. Dates with no metrics are not returned
in such a report.
For the following query, the report won't include zero metric rows:
SELECT
campaign
.
name
,
metrics
.
impressions
,
segments
.
date
FROM
campaign
WHERE
segments
.
date
DURING
LAST_30_DAYS
Returned rows with zero metrics
Rows whose selected metrics are all zero won't be returned.
For example:
SELECT
ad_group_criterion
.
criterion_id
,
metrics
.
impressions
,
metrics
.
clicks
,
metrics
.
conversions
,
segments
.
date
FROM
keyword_view
WHERE
segments
.
date
BETWEEN
< date1
>
AND
< date2
>
The resulting report won't contain any rows in which all three selected metrics are zero.
In situations where you retrieve data older than the retention period , the resulting report won't contain any rows for data older than the retention period. All account data, including performance metrics, billing information and historical reports, are retained for a period of 11 years.
