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"]
}]
<Filter>
<Field>Conversions</Field>
<Operator>GREATER_THAN</Operator>
<Values>10</Values>
</Filter>
The table below shows how operators correspond to fields.
Field name | Operators allowed |
---|---|
AdNetworkType | EQUALS, IN |
CampaignId | |
CampaignType | |
ClientLogin 1 | |
AdFormat | EQUALS, IN, NOT_EQUALS, NOT_IN |
AdGroupId | |
AdId | |
Age 2 | |
AudienceTargetId 3 | |
CarrierType | |
ClickType | |
CriteriaType | |
CriterionType | |
Device | |
DynamicTextAdTargetId 3 | |
ExternalNetworkName | |
Gender | |
IncomeGrade | |
LocationOfPresenceId | |
MatchType | |
MobilePlatform | |
Placement | |
RlAdjustmentId 4 | |
Slot | |
SmartAdTargetId 3 | |