AdGroupId
|
The ID of the AdGroup.
Type | Long |
Display Name | Ad group ID |
XML Attribute | adGroupID |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
AverageCpc
|
The total cost of all clicks divided by the total number of clicks received.
Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.
Type | Money |
Display Name | Avg. CPC |
XML Attribute | avgCPC |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | False |
|
AverageCpm
|
Average Cost-per-thousand impressions (CPM).
Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.
Type | Money |
Display Name | Avg. CPM |
XML Attribute | avgCPM |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | False |
|
CampaignId
|
The ID of the Campaign.
Type | Long |
Display Name | Campaign ID |
XML Attribute | campaignID |
Behavior | Attribute |
Filterable | True |
Supports Zero Impressions | False |
|
Clicks
|
The number of clicks.
Type | Long |
Display Name | Clicks |
XML Attribute | clicks |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | False |
|
ConversionRate
|
The number of conversions divided by total clicks that can be tracked to conversions. Percentage returned as "x.xx%".
To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN . This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.
Type | Double |
Display Name | Conv. rate |
XML Attribute | convRate |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | False |
|
Conversions
|
The number of conversions for all conversion actions that you have opted into optimization. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00).
To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN . This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.
Type | Double |
Display Name | Conversions |
XML Attribute | conversions |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | False |
|
ConversionValue
|
The sum of conversion values for all conversions. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00).
To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN . This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.
Type | Double |
Display Name | Total conv. value |
XML Attribute | totalConvValue |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | False |
|
Cost
|
The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.
Type | Money |
Display Name | Cost |
XML Attribute | cost |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | False |
|
CostPerConversion
|
The Cost attributable to conversion-tracked clicks divided by the number of conversions.
Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.
Type | Money |
Display Name | Cost / conv. |
XML Attribute | costConv |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | False |
|
Ctr
|
The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). Percentage returned as "x.xx%".
To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN . This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.
Type | Double |
Display Name | CTR |
XML Attribute | ctr |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | False |
|
Date
|
The date formatted as yyyy-MM-dd.
Type | Date |
Display Name | Day |
XML Attribute | day |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
|
DayOfWeek
|
The name of the day of the week, e.g., "Monday".
Type | DayOfWeek |
Display Name | Day of week |
XML Attribute | dayOfWeek |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
Predicate values / display values
MONDAY | Monday |
TUESDAY | Tuesday |
WEDNESDAY | Wednesday |
THURSDAY | Thursday |
FRIDAY | Friday |
SATURDAY | Saturday |
SUNDAY | Sunday |
|
Impressions
|
Count of how often your ad has appeared on a search results page or website on the Google Network.
Type | Long |
Display Name | Impressions |
XML Attribute | impressions |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | False |
|
Month
|
The first day of the month, formatted as yyyy-MM-dd.
Type | String |
Display Name | Month |
XML Attribute | month |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
|
MonthOfYear
|
The name of the month of the year, e.g., "December".
Type | MonthOfYear |
Display Name | Month of Year |
XML Attribute | monthOfYear |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
Predicate values / display values
JANUARY | January |
FEBRUARY | February |
MARCH | March |
APRIL | April |
MAY | May |
JUNE | June |
JULY | July |
AUGUST | August |
SEPTEMBER | September |
OCTOBER | October |
NOVEMBER | November |
DECEMBER | December |
|
Quarter
|
The first day of the quarter, formatted as yyyy-MM-dd. Uses the calendar year for quarters, e.g., the second quarter of 2014 starts on 2014-04-01.
Type | String |
Display Name | Quarter |
XML Attribute | quarter |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
|
ValuePerConversion
|
The total value of your conversions divided by the total number of conversions. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00).
To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN . This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.
Type | Double |
Display Name | Value / conv. |
XML Attribute | valueConv |
Behavior | Metric |
Filterable | True |
Supports Zero Impressions | False |
|
Week
|
The date for the Monday of the week, formatted as yyyy-MM-dd.
Type | String |
Display Name | Week |
XML Attribute | week |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
|
Year
|
The year, formatted as yyyy.
Type | Integer |
Display Name | Year |
XML Attribute | year |
Behavior | Segment |
Filterable | True |
Supports Zero Impressions | False |
|