The 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:
Collecting
To integrate Google Adwords data into Panoply, follow the following steps:
- From the Home page in the Panoply dashboard, click Data Sources. Then, click the Add Data Source button.
- Search for and select Adwords API.
- On the General tab:
- Click Login With Google, select the Google account tied to the data you would like to add to Panoply. Follow the dialog to confirm your access to the data and click Allow.
- Enter the Customer ID
- Choose a Date Range
- Choose an Attribution Window
- Select the reports that you want to import (see the Data Dictionary section for details on the available reports). and then click Collect.
- (Optional) On the Advanced tab you can set the Advanced Options, however, we do not recommend changing advanced options unless you are an experienced Panoply user.
- Destination: The default destination is
adwords_<reportName>
, where<reportName>
is a variable. Each report has its own destination table, prefixed withadwords_
. - Primary Key: The default is built out of fields from each report, as shown here:
- Destination: The default destination is
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 Day |
Display Keyword Performance Report | Campaign ID Base Campaign ID Ad group ID Base Ad group ID Keyword ID Customer ID |
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 |
- Click Save Changes and then click Collect
- 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.
Data Dictionary
In this Panoply integration, the following reports are available:
- Criteria Performance Report
- AdGroup Performance Report
- Ad Performance Report
- Search Query Performance Report
- Display Keyword Performance Report
- Geo Performance Report
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. |
Sample SQL Queries
Finished collecting data? Here are some sample SQL queries to get you started. You can copy these queries and run them in the Workbench in the Panoply platform and also save them as views there. These queries can also be used with an external workbench or in your BI tool.
Sample queries for more source can be seen here
Adwords API - Monthly Breakdown
This query sums the total cost and conversions by month and year from the adgroup_performance_report
.