Filtering data

To filter data in the report, use the Filter structure. Each filter consists of a set of criteria for selecting data. Filters are combined with AND, so the report shows data that meets all the filter criteria. A filter consists of three parameters:

  • Field — Which field to compare the values of.

  • Operator — How to compare.

  • Values — An array of symbols to compare with.

For example, to make the report only show rows that have more than 10 conversions, use the filter

"Filter": [{
  "Field": "Conversions",
  "Operator": "GREATER_THAN",
  "Values": ["10"]
}]

The table below shows how operators correspond to fields.

Field name Operators allowed
AdNetworkType EQUALS, IN
CampaignId
CampaignType
AdFormat EQUALS, IN, NOT_EQUALS, NOT_IN
AdGroupId
AdId
Age 1
AudienceTargetId 2
CarrierType
ClickType
CriteriaType
CriterionType
Device
DynamicTextAdTargetId 2
ExternalNetworkName
Gender
LocationOfPresenceId
MatchType
MobilePlatform
Placement
RlAdjustmentId 3
Slot
SmartAdTargetId 2
TargetingLocationId
Clicks EQUALS, IN, GREATER_THAN, LESS_THAN
Conversions
ImpressionReach
Impressions
AvgClickPosition GREATER_THAN, LESS_THAN
AvgCpc 4
AvgCpm 4
AvgImpressionFrequency
AvgImpressionPosition
AvgPageviews
AvgTrafficVolume
BounceRate
ConversionRate
Cost 4
CostPerConversion 4
Ctr
GoalsRoi
ImpressionShare
Profit 4
Revenue 4
WeightedCtr
WeightedImpressions
Keyword 2 EQUALS, IN, NOT_EQUALS, NOT_IN, STARTS_WITH_IGNORE_CASE, STARTS_WITH_ANY_IGNORE_CASE, DOES_NOT_START_WITH_IGNORE_CASE, DOES_NOT_START_WITH_ALL_IGNORE_CASE
MatchedKeyword
Query