AdWords API

AdWords API

Google AdWords API provides direct access to AdWords data. This document provides instructions for integrating Google AdWords data into Panoply through the AdWords API. The following items will be covered:

This article is about integration with the AdWords API. To set up an integration with Google Ads, which goes through Google Analytics, see the Google Ads data integration article.

Google AdWords API Data Integration

To integrate Google AdWords data into Panoply via the AdWords API using default selections, complete the following steps. For more advanced options, complete the following and refer to the subsequent sections for detailed information.

  1. From the Home page in the Panoply dashboard, click Data Sources. Then, click the Add Data Source button.
  2. In the Data Sources – Choose Source Type window, select Adwords API. Adwords API is listed under APIs.
  3. In the Data Sources – Adwords API screen, click Login With Google.
  4. In the Google prompt, select the Google account tied to the data you would like to add to Panoply.
  5. A Google Account Authorization window confirms whether you want to allow Panoply to access your AdWords campaigns. Click Allow to continue.
    If the account access and authorization are confirmed, you will return to the Panoply Data Sources – AdWords API screen.
  6. In the Data Sources – AdWords API screen, enter your Customer ID and click Next.
  7. Select the reports that you want to import (see the Data Model section for details on the available reports), and then click Collect.

On its first run, this data source collects data from the last 31 days. In subsequent runs, it pulls data for 31 days plus the number of days since the last successful run. For example, if it succeeded 10 days ago, a run today will try to pull data from the most recent 41 days.

The Data Sources – AdWords API window will appear grayed out while the data integration is pending. A small green progress bar appears below AdWords API.

You will be prompted to set up the integration of another data source. You can set up multiple data integrations without impacting the ingestion of the already scheduled or pending data integrations.

From the Data Sources main menu, you can monitor the data ingestion status of the scheduled and pending data integrations. Once the data ingestion is complete, you can clean or transform your data in the Tables menu.

Advanced Data Integration Options

Clicking Show next to Advanced will expand the Data Sources - AdWords API window to include Destination, Primary Key, Exclude, Parse string, and Truncate table.

  • Destination - Default is adwords_{reportName}, where {reportName} is a variable. Each report has its own destination table, prefixed with adwords_.

  • Primary Key - Default is built out of fields from each report, as shown here:

Report Fields that create the primary key
Criteria Performance Report Campaign ID
Ad group ID
Keyword ID
Day
AdGroup Performance Report Campaign ID
Ad group ID
Device
Day
Ad Performance Report Campaign ID
Ad group ID
Ad ID
Day
Search Query Performance Report Campaign ID
Ad group ID
Ad ID
Keyword ID
Customer ID
Day
Display Keyword Performance Report Campaign ID
Base Campaign ID
Ad group ID
Base Ad group ID
Keyword ID
Customer ID
Day
Geo Performance Report Campaign ID
City
Country/Territory
Customer ID
Metro area
Most specific location
Region
Ad type
Ad group ID
Ad group state
Network
Network (with search partners)
Day
Device
Location type

Data Model

In this Panoply integration, the following reports are available:

For guidance on selecting reports, see Choosing the Right Report in the AdWords API reporting guide. For an overview of each report type, see Report Types in the AdWords API documentation.

Cost fields are returned in micro currency units (micros). Divide micros by 1,000,000 to get the actual cost. For example, $1.23 will come back as 1230000 (1.23 x 1,000,000).

When filtering on cost fields, provide the value in micros. For example, to return rows where AverageCpc is greater than $1, use WHERE AverageCpc > 1000000.

Criteria Performance Report

The Criteria Performance report includes statistics aggregated at the ad group criteria level, one row per ad group and criteria combination. If other segment fields are used, you may get more than one row per criteria. This is a single attribution report. For more detail, see the AdWords API documentation on the Criteria Performance Report.

Field Description
CampaignId The ID of the Campaign.
AdGroupId The ID of the AdGroup.
Id ID of the main object of this row.
Criteria Descriptive string for the Criterion.
CriteriaType The type of the Criterion.
FinalUrls List of final URLs of the main object of this row. UrlList elements are returned in JSON list format.
Impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
Clicks The number of clicks.
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 AdWords 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.
Date The date formatted as yyyy-MM-dd.
DayOfWeek The name of the day of the week, such as Monday.
Month The first day of the month, formatted as yyyy-MM-dd.
MonthOfYear The name of the month of the year, such as December.
Quarter The first day of the quarter, formatted as yyyy-MM-dd. Uses the calendar year for quarters. For example, the second quarter of 2014 starts on 2014-04-01.
Week The date for the Monday of the week, formatted as yyyy-MM-dd.
Year The year, formatted as yyyy.

AdGroup Performance Report

The Ad Group Performance report includes all statistics aggregated by default at the ad group level, one row per ad group. If other segment fields are used, you may get more than one row per ad group. For more detail, see the AdWords API documentation on the AdGroup Performance Report.

Field Description
AdGroupId The ID of the AdGroup.
AdGroupName The name of the AdGroup.
CampaignId The ID of the Campaign.
CampaignName The name of the Campaign.
Clicks The number of clicks.
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 AdWords 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.
Impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
AccountDescriptiveName The descriptive name of the Customer account.
AdGroupStatus Status of the ad group.
AveragePosition Your ad’s position relative to those of other advertisers. 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.
CampaignStatus The status of the Campaign.
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.
Device Device type where the impression was shown.
SearchImpressionShare The impressions you’ve received on the Search Network divided by the estimated number of impressions you were eligible to receive. A percentage returned as xx.xx%, or the special value < 10%. 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.
SearchRankLostImpressionShare The estimated percentage of impressions on the Search Network that your ads didn’t receive due to poor Ad Rank. A percentage returned as xx.xx%, or the special value > 90%. 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.
Date The date formatted as yyyy-MM-dd.
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.

Ad Performance Report

The Ad Performance report includes all statistics aggregated at the ad level, one row per ad. If other segment fields are used, you may get more than one row per ad. For more detail, see the AdWords API documentation on the Ad Performance Report.

Field Description
Id ID of the main object of this row.
AdGroupId The ID of the AdGroup.
AdGroupName The name of the AdGroup.
AdGroupStatus Status of the ad group.
CampaignId The ID of the Campaign.
AdType The type of the Ad. If the ad’s type is not supported in the report request’s API version, this field will have the value unknown.
CampaignName The name of the Campaign.
CampaignStatus The status of the Campaign.
Headline The ad headline for a TextAd. For other ad types such as TemplateAds, this field will contain a string representation of the key attributes of the ad.
HeadlinePart1 The first part of an expanded text ad headline.
HeadlinePart2 The second part of an expanded text ad headline.
ImageAdUrl Prefix this value with https://tpc.googlesyndication.com/pageadimg/imgad?id= to get the full URL.
LongHeadline The long format of the headline in a responsive display ad.
ShortHeadline The short format of the headline in a responsive display ad.
DisplayUrl Display URL of the Ad.
Description The descriptive text of an expanded text ad or responsive display ad.
Description1 Line 1 description of the Ad.
Description2 Line 2 description of the Ad.
CreativeFinalMobileUrls List of final mobile URLs of the ad. List elements are returned in JSON list format.
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.
Date The date formatted as yyyy-MM-dd.

Search Query Performance Report

The Search Terms report includes all statistics aggregated at the search terms level, one row per combination of search terms. If other segment fields are used, you may get more than one row per combination of search terms. For more detail, see the AdWords API documentation on the Search Query Performance Report.

Field Description
AdGroupId The ID of the AdGroup.
CampaignId The ID of the Campaign.
CreativeId ID of the ad.
ExternalCustomerId The Customer ID.
KeywordId The ID of the Keyword that triggered the ad.
KeywordTextMatchingQuery Keyword that matched the query and triggered the ad.
Query If the string for this attribute is longer than 128 char bytes, the returned result will NOT be a single aggregated row.
QueryTargetingStatus Indicates whether the search term is currently one of your targeted or excluded keywords.
AccountCurrencyCode The currency of the Customer account.
AccountDescriptiveName The descriptive name of the Customer account.
AccountTimeZone Name of the timezone selected for the Customer account. For example: (GMT-05:00) Eastern Time. This field does not reflect the current state of daylight saving time for the timezone.
AdGroupName The name of the AdGroup.
AdGroupStatus Status of the ad group.
CampaignName The name of the Campaign.
CampaignStatus The status of the Campaign.
DestinationUrl Destination URL for the impression.
FinalUrl Final URL of the impressions.
Date The date formatted as yyyy-MM-dd.
Clicks The number of clicks.
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 AdWords 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.
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.
Engagements The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics.
Impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
Interactions The number of interactions. An interaction is the main user action associated with an ad format–clicks for text and shopping ads, views for video ads, and so on.
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.

Display Keyword Performance Report

The Display Keyword Performance report includes all Display Network and YouTube Network statistics aggregated at the keyword level, one row per keyword. If other segment fields are used, you may get more than one row per keyword. For more detail, see the AdWords API documentation on the Display Keyword Performance Report.

Field Description
AdGroupId The ID of the AdGroup.
BaseAdGroupId The ID of base ad group of trial ad groups. For regular ad groups, this is equal to AdGroupId. For campaign-level user lists, this will always be 0.
BaseCampaignId The ID of base campaign of trial campaigns. For regular campaigns, this is equal to CampaignId.
CampaignId The ID of the Campaign.
ExternalCustomerId The Customer ID.
Id ID of the main object of this row.
Date The date formatted as yyyy-MM-dd.
AccountDescriptiveName The descriptive name of the Customer account.
AccountTimeZone Name of the timezone selected for the Customer account. For example: (GMT-05:00) Eastern Time. This field does not reflect the current state of daylight saving time for the timezone.
AccountCurrencyCode The currency of the Customer account.
AdGroupName The name of the AdGroup.
AdGroupStatus Status of the ad group.
CampaignName The name of the Campaign.
CampaignStatus The status of the Campaign.
CpcBid Cost per click bid. Values can be one of: a) a money amount in micros, b) auto: x or auto if AdWords is automatically setting the bid via the chosen bidding strategy, or c) -- if no CPC bid applies to the row. Values can be one of: a) a money amount in micros, b) auto: x or auto if this field is a bid and AdWords 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.
CpcBidSource Source of the CPC bid.
CpmBid CPM (cost per thousand impressions) bid. Values can be one of: a) a money amount in micros, b) auto: x or auto if this field is a bid and AdWords 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.
CpmBidSource Source of the CPM bid.
CpvBid Cost per view bid. Values can be one of: a) a money amount in micros, b) auto: x or auto if this field is a bid and AdWords 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.
CpvBidSource The source of the cost per view bid.
Criteria Descriptive string for the Criterion.
CriteriaDestinationUrl Destination URL of the criterion that triggered ads.
CustomerDescriptiveName The descriptive name of the Customer.
FinalAppUrls List of final app URLs of the main object of this row. List entries will start with one of: a) android-app: (for Android apps) or b) os-app: (for iOS apps). AppUrlList elements are returned in JSON list format.
FinalMobileUrls List of final mobile URLs of the main object of this row. UrlList elements are returned in JSON list format.
FinalUrls List of final URLs of the main object of this row. UrlList elements are returned in JSON list format.
IsNegative Indicates if the criterion for this row is a negative (exclusion) criterion.
IsRestrict A value of true indicates that the criterion type is used for bidding and restricting targeting. A value of false indicates that the criterion type is used only for bidding. This will have the opposite value from that of targetAll for the criteria’s corresponding AdGroup.TargetingSettingDetail. For example, if the TargetingSettingDetail for criterionTypeGroup = PLACEMENT has targetAll = true, then the IsRestrict field will be false for Placement criteria.
Status The status of the main object in this row. For example, in a Campaign Performance Report this will be the status of each row’s Campaign. In an Ad Group Performance Report this will be the status of each row’s AdGroup.
Clicks The number of clicks.
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 AdWords 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.
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.
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.
Engagements The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics.
Impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
Interactions The number of interactions. An interaction is the main user action associated with an ad format–clicks for text and shopping ads, views for video ads, and so on.

Geo Performance Report

The Geo Performance report includes all statistics aggregated at the country/territory level, one row per country/territory. If other segment fields are used, you may get more than one row per country/territory. For more detail, see the AdWords API documentation on the Geo Performance Report.

Field Description
AccountCurrencyCode The currency of the Customer account.
AccountDescriptiveName The descriptive name of the Customer account.
AccountTimeZone Name of the timezone selected for the Customer account. For example: (GMT-05:00) Eastern Time. This field does not reflect the current state of daylight saving time for the timezone.
CampaignId The ID of the Campaign.
CampaignName The name of the Campaign.
CampaignStatus The status of the Campaign.
CityCriteriaId ID of the city Location associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
CountryCriteriaId ID of the country Location associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
CustomerDescriptiveName The descriptive name of the Customer.
ExternalCustomerId The Customer ID.
IsTargetingLocation Indicates whether the row’s location (among all of the locations associated with an impression) was the targeting location for the impressions in that row.
MetroCriteriaId ID of the metro area Location associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
MostSpecificCriteriaId ID of the most specific Location criterion associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
RegionCriteriaId ID of the region Location associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.
AdFormat The underlying media format of the ad. Values can be one of the formats on the Template Ads page, or a MediaType enum.
AdGroupId The ID of the AdGroup.
AdGroupName The name of the AdGroup.
AdGroupStatus Status of the ad group.
AdNetworkType1 First level network type.
AdNetworkType2 Second level network type (includes search partners).
Date The date formatted as yyyy-MM-dd.
Device Device type where the impression was shown.
LocationType The type of location. AREA_OF_INTEREST indicates a location that was searched for, or a location derived from viewed content. LOCATION_OF_PRESENCE is the actual physical location of the user.
AllConversionRate AllConversions divided by total clicks that can be conversion-tracked. This is how often a click on your ad resulted in a conversion. 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.
AllConversions Best estimate of the total number of conversions that AdWords drives. Includes website, cross-device, and phone call 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.
AllConversionValue The total value of all of your conversions, including those that are estimated. 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.
AverageCost The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions. Values can be one of: a) a money amount in micros, b) auto: x or auto if this field is a bid and AdWords 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.
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 AdWords 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.
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 AdWords 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.
AverageCpv The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views. 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.
AveragePosition Your ad’s position relative to those of other advertisers. 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.
Clicks The number of clicks.
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.
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.
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.
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 AdWords 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.
CostPerAllConversion Total cost divided by all conversions. Values can be one of: a) a money amount in micros, b) auto: x or auto if this field is a bid and AdWords 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.
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 AdWords 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.
CrossDeviceConversions Conversions from when a customer clicks on an AdWords ad on one device, then converts on a different device or browser. Cross-device conversions are already included in your AllConversions column. 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.
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.
Impressions Count of how often your ad has appeared on a search results page or website on the Google Network.
InteractionRate How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown. 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.
Interactions The number of interactions. An interaction is the main user action associated with an ad format–clicks for text and shopping ads, views for video ads, and so on.
InteractionTypes The types of interactions that are reflected in the Interactions, InteractionRate, and AverageCost columns.
ValuePerAllConversion The value, on average, of 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.
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.
VideoViewRate The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads. 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.
VideoViews The number of times your video ads were viewed.
ViewThroughConversions The total number of view-through conversions. These happen when a customer sees a Display network ad, then later completes a conversion on your site without interacting with (e.g. clicking on) another ad. This field is formatted using US locale, i.e., using comma , for thousands and dot . for decimals.