| Label | Description | Name | Type | Data Type | Tables |
|---|---|---|---|---|---|
| Absolute Top Impression Percentage | absolute_top_impression_percentage | METRIC | NUMBER |
| |
| Account ID | The unique identifier of an account. | account_id | DIMENSION | STRING |
|
| Account Name | The name of the account. | configName | DIMENSION | STRING |
|
| Ad Group Labels | The label for the ad group. | adGroupLabels | DIMENSION | STRING |
|
| Ad ID | The unique identifier of an ad. | ad_id | DIMENSION | STRING |
|
| Ad Labels | The label for the ad. | adLabels | DIMENSION | STRING |
|
| Ad Name | The name of the ad. | ad_name | DIMENSION | STRING |
|
| Ad group ID | The unique identifier of an ad group. | ad_group_id | DIMENSION | STRING |
|
| Ad group Name | The name of an ad group. | adgroup_name | DIMENSION | STRING |
|
| Ad group status | The status of an ad group. | adgroup_status | DIMENSION | STRING |
|
| Ad group type | The type of an ad group. | adgroup_type | DIMENSION | STRING |
|
| Ad rotation | Indicates whether your ads are being optimized or rotated indefinitely. | adRotationMode | DIMENSION | STRING |
|
| Ad status | Whether your ads are approved, disapproved, under review, or in another state. | ad_status | DIMENSION | STRING |
|
| Ad strength | Ranging from “Incomplete” to “Excellent,” this metric measures the relevance, quality, and diversity of your ad copy. | adStrength | DIMENSION | STRING |
|
| Ad type | The type of ad format. | ad_type | DIMENSION | STRING |
|
| Age | Age. | age | DIMENSION | STRING |
|
| All conv. rate | All conversion rate shows how often, on average, an ad interaction leads to a conversion. It’s calculated by dividing the total number of conversions by the total number of ad interactions. | all_conv_rate | METRIC | NUMBER |
|
| All conv. value/click | The average conversion value of each ad interaction. | all_conv_value_per_click | METRIC | NUMBER |
|
| All conv. value/cost | All conversion value per cost measures your return on investment for All conversions. It’s the All conv. value divided by the total cost of all ad interactions. | all_conv_value_per_cost | METRIC | NUMBER |
|
| All conversions | A view of all the conversions that your Google Ads campaigns drive. This column includes any conversion actions that you've chosen not to include in your main "Conversions" column. | all_conversions | METRIC | NUMBER |
|
| All conversions value | The total value of all of your conversions, including advanced sources like cross-device conversions and conversion actions even if the ‘Include’ in Conversions setting is unchecked. | all_conversions_value | METRIC | NUMBER |
|
| Approval Status | After you’ve created an ad or asset, you can check whether it’s been reviewed or not. | approvalStatus | DIMENSION | STRING |
|
| Asset ID | The ID of the asset. | asset_id | DIMENSION | STRING |
|
| Asset Image URL | The URL linking to the image of the asset. | assetImageUrl | DIMENSION | STRING |
|
| Average Time On Site | Total duration of all sessions (in seconds) / number of sessions. Imported from Google Analytics. | average_time_on_site | METRIC | NUMBER |
|
| Avg. CPC | Average cost-per-click is the amount you've paid for your ad divided by its total clicks. | avg_cpc | METRIC | NUMBER |
|
| Avg. CPE | Average cost-per-engagement is the average amount that you've been charged for an ad engagement | avg_cpe | METRIC | NUMBER |
|
| Avg. CPM | Average cost-per-thousand impressions is the average amount that you've been charged for 1,000 impressions. | avg_cpm | METRIC | NUMBER |
|
| Avg. CPV | Average cost-per-view is the average amount you paid each time someone viewed your video ad. It equals the total cost of all views divided by the total number of views. | avg_cpv | METRIC | NUMBER |
|
| Avg. Cost | The average amount you pay per interaction. | avg_cost | METRIC | NUMBER |
|
| Biding Strategy Type | The type of bidding strategy selected. | bidingStrategyType | DIMENSION | STRING |
|
| Bounce Rate | The % of sessions that bounce. | bounce_rate | METRIC | NUMBER |
|
| Budget | The budget for the campaign. | budget | DIMENSION | NUMBER |
|
| Business Category | business_category | DIMENSION | STRING |
| |
| CTR | The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions) | CTR | METRIC | NUMBER |
|
| Campaign ID | The ID of the campaign. | campaign_id | DIMENSION | STRING |
|
| Campaign Labels | Campaign labels. | campaignLabels | DIMENSION | STRING |
|
| Campaign Name | The name of the campaign. | campaign_name | DIMENSION | STRING |
|
| Campaign Status | Your campaign status shows you whether your campaign is running normally, and how to fix any issues. | campaign_status | DIMENSION | STRING |
|
| Campaign type | The type of campaign. | advertisingChannelType | DIMENSION | STRING |
|
| City | City. | city | DIMENSION | STRING |
|
| City ID | The unique identifier for the city. | city_id | DIMENSION | NUMBER |
|
| Click Share | The number of clicks you've received on the search network divided by the estimated maximum number of clicks that you could have received. | search_click_share | METRIC | NUMBER |
|
| Click Type | click_type | DIMENSION | STRING |
| |
| Clicks | When someone clicks your ad, it is counted here. | clicks | METRIC | NUMBER |
|
| Consumer Name | consumer_name | DIMENSION | STRING |
| |
| Conv. rate | Conversion rate shows how often, on average, an ad interaction leads to a conversion. It’s conversions divided by the interactions with your ad | conv_rate | METRIC | NUMBER |
|
| Conv. value/click | Conversion value per click is the average conversion value of your ad interactions. | conv_value_per_click | METRIC | NUMBER |
|
| Conv. value/cost | Conversion value per cost measures your return on investment. It’s the conversion value divided by the total cost of all ad interactions. | conv_value_per_cost | METRIC | NUMBER |
|
| Conversion Action | A conversion action. | conversionActionName | DIMENSION | STRING |
|
| Conversion Category | Breakdown your conversions by installs, in-app actions, etc. You can use this field only with conversions metric. | conversionActionCategory | DIMENSION | STRING |
|
| Conversions | The number of conversions for all conversion actions that you have opted into optimization. | conversions | METRIC | NUMBER |
|
| Conversions By Conversion Date | The number of conversions. When this field is selected with date, the values in date column means the conversion date. | conversions_by_conversion_date | METRIC | NUMBER |
|
| Conversions Value | The value of the conversions for the timeframe reported. | conversions_value | METRIC | NUMBER |
|
| Conversions Value By Conversion Date | conversions_value_by_conversion_date | METRIC | NUMBER |
| |
| Cost | Total cost for the timeframe reported. | cost | METRIC | NUMBER |
|
| Cost if conversion is not zero | Take cost if conversion is not zero | cost_if_conv_not_zero | METRIC | NUMBER |
|
| Cost if video views not zero | Take cost if video views is not zero | cost_if_video_views_not_zero | METRIC | NUMBER |
|
| Cost/all conv. | Shows the average cost of a conversion in All conversions. It's your total cost divided by All conversions. | cost_per_all_conv | METRIC | NUMBER |
|
| Cost/conv. | The average cost of a conversion. It's your cost divided by the number in the Conversions | cost_per_conv | METRIC | NUMBER |
|
| Country | The name of the country. | country | DIMENSION | STRING |
|
| Country Code | The two-letter country code. | countryCode | DIMENSION | STRING |
|
| Country ID | The unique ID for the country. | country_id | DIMENSION | NUMBER |
|
| Cross Device Conversions | Conversions from when a customer clicks on an Google Ads ad on one device, then converts on a different device or browser. | cross_device_conversions | METRIC | NUMBER |
|
| Currency | The currency of the account | currency | DIMENSION | STRING |
|
| Current Model Attributed Conversions | Shows how your historic conversions data would look under the attribution model you've currently selected. | current_model_attributed_conversions | METRIC | NUMBER |
|
| Current Model Attributed Conversions Value | The value of current model attributed conversions. If you use conversion-based bidding, your bid strategies will optimize for these conversions. | current_model_attributed_conversions_value | METRIC | NUMBER |
|
| Data Freshness | dataFreshness | DIMENSION | STRING |
| |
| Data Source | Data source title | dataSource | DIMENSION | STRING |
|
| Data Source Logo | Data source logo | dataSourceLogo | DIMENSION | STRING |
|
| Date | date | DIMENSION | STRING |
| |
| Day Of Month | The dimension that determines how date-based data in a chart is handled. | day_of_month | DIMENSION | STRING |
|
| Day Of Week | The dimension that determines how date-based data in a chart is handled. | day_of_week | DIMENSION | STRING |
|
| Description1 | The Ad's Description Line 1 | description1 | DIMENSION | STRING |
|
| Description2 | The Ad's Description Line 2 | description2 | DIMENSION | STRING |
|
| Device | The device to which metrics apply. | device | DIMENSION | STRING |
|
| Display URL | The Display URL for an ad. | displayUrl | DIMENSION | STRING |
|
| Engagement Rate | Engagement rate is used to measure how often people engage with your ad after it's been shown to them. Use it to help you figure out how effective your ad is. Engagement rate is the number of engagements divided by total impressions. | engagement_rate | METRIC | NUMBER |
|
| Engagements | The number of engagements. | engagements | METRIC | NUMBER |
|
| Final URL | The Final URL for the ad. | finalUrl | DIMENSION | STRING |
|
| First Page CPC | Estimate of the CPC bid required in order to show your ad on the first page of search results. | firstPageCpc | METRIC | NUMBER |
|
| First Position CPC | Estimate of the amount you might need to pay for your ad to be displayed in the first position at the top of the first page of Google search results. | firstPositionCpc | METRIC | NUMBER |
|
| Gender | The gender of the customer. | gender | DIMENSION | STRING |
|
| Gmail Forwards | The number of times your ad was forwarded to someone else as a message. | gmail_forwards | METRIC | NUMBER |
|
| Gmail Saves | The number of times someone has saved your Gmail ad to their inbox as a message. | gmail_saves | METRIC | NUMBER |
|
| Gmail Secondary Clicks | The number of clicks to your landing page on the expanded state of Gmail ads. | gmail_secondary_clicks | METRIC | NUMBER |
|
| Headline1 | The Ad's Headline Line 1 | headline1 | DIMENSION | STRING |
|
| Headline2 | The Ad's Headline Line 2 | headline2 | DIMENSION | STRING |
|
| Headline3 | The Ad's Headline Line 3 | headline3 | DIMENSION | STRING |
|
| Historical Quality Score | The historical quality score. | historical_quality_score | METRIC | NUMBER |
|
| Image | The Ad's image (when applicable). | unified_image | DIMENSION | STRING |
|
| Image URL | The Ad's Image URL (If applicable). | imageUrl | DIMENSION | STRING |
|
| Impressions | Total impressions in the timeframe reported. | impressions | METRIC | NUMBER |
|
| Impressions if video views not zero | Take impressions if video views is not zero | impressions_if_video_views_not_zero | METRIC | NUMBER |
|
| Interaction Rate | 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. | interaction_rate | METRIC | NUMBER |
|
| Interactions | The number of interactions. An interaction is the main user action associated with an ad format. | interactions | METRIC | NUMBER |
|
| Keyword | The keyword that was matched to a search. | keyword | DIMENSION | STRING |
|
| Keyword ID | The ID for the keyword. | keyword_id | DIMENSION | STRING |
|
| Keyword Match Type | The Match Type for a keyword (Broad, Phrase, Exact) | keyword_matchType | DIMENSION | STRING |
|
| Keyword Status | Your keyword status lets you know whether your keywords are active or not. | adGroupCriterionStatus | DIMENSION | STRING |
|
| Labels | Label name for the main object of this row. | labels | DIMENSION | STRING |
|
| Lead Charged Status | lead_charged_status | DIMENSION | STRING |
| |
| Lead ID | lead_id | DIMENSION | STRING |
| |
| Lead Status | lead_status | DIMENSION | STRING |
| |
| Lead Type | lead_type | DIMENSION | STRING |
| |
| Month | The dimension that determines how date-based data in a chart is handled. | month_only | DIMENSION | STRING |
|
| Month Day | The dimension that determines how date-based data in a chart is handled. | month_day | DIMENSION | STRING |
|
| Network | A group of search-related websites where your ads and free product listings can appear. | adNetworkType | DIMENSION | STRING |
|
| Optimization Score | Your optimization score is an estimate from Google Ads of how well your Google Ads account is set to perform. | optimizationScore | DIMENSION | NUMBER |
|
| PMA Is Interpolated? | Used by Power My Analytics to indicate whether lifetime data might be interpolated | isInterpolated | DIMENSION | BOOLEAN |
|
| PMA Maximum Cached Data Date | Used by Power My Analytics to indicate maximum cached data date. | MaxDate | DIMENSION | STRING |
|
| PMA Minimum Cached Data Date | Used by Power My Analytics to indicate minimum cached data date. | MinDate | DIMENSION | STRING |
|
| PMA Payment URL | Used by Power My Analytics to provide URL to activate your account, or to see the billing information. | Payment | STRING |
| |
| PMA Subscription ID | Used by Power My Analytics for billing and user-identification with our support staff. | Subscription | STRING |
| |
| PMA Trial Status | Used by Power My Analytics to show trial as Active, Expired or number of days remaining. | Trial | STRING |
| |
| Percent New Visitors | The percentage of visitors to your site that are new. | percent_new_visitors | METRIC | NUMBER |
|
| Phone Calls | Number of offline phone calls. | phone_calls | METRIC | NUMBER |
|
| Phone Impressions | phone_impressions | METRIC | NUMBER |
| |
| Phone Number | phone_number | METRIC | NUMBER |
| |
| Postal Code | Postal code of target location. | postal_code | DIMENSION | STRING |
|
| Postal Code ID | Postal code ID of target location. | postal_code_id | DIMENSION | NUMBER |
|
| Preview Image URL | The URL of the preview image. | previewImageUrl | DIMENSION | STRING |
|
| Product Brand | The brand of the product. | product_brand | DIMENSION | STRING |
|
| Product Channel | The channel of the product. | product_channel | DIMENSION | STRING |
|
| Product Condition | The condition of the product. | product_condition | DIMENSION | STRING |
|
| Product Country | Resource name of the geo target constant for the country of sale of the product. | product_country | METRIC | NUMBER |
|
| Product Item ID | Item ID of the product. | product_item_id | DIMENSION | STRING |
|
| Product Language | Resource name of the language constant for the language of the product. | product_language | DIMENSION | STRING |
|
| Product Merchant ID | Merchant ID of the product. | product_merchant_id | DIMENSION | STRING |
|
| Product Store ID | Store ID of the product. | product_store_id | DIMENSION | STRING |
|
| Product Title | The product title. | product_title | DIMENSION | STRING |
|
| Product Type L1 | Product type (1st level) | product_type_l1 | DIMENSION | STRING |
|
| Product Type L2 | Product type (2nd level) | product_type_l2 | DIMENSION | STRING |
|
| Product Type L3 | Product type (3rd level) | product_type_l3 | DIMENSION | STRING |
|
| Product Type L4 | Product type (4th level) | product_type_l4 | DIMENSION | STRING |
|
| Product Type L5 | Product type (5th level) | product_type_l5 | DIMENSION | STRING |
|
| Quarter | The dimension that determines how date-based data in a chart is handled. | quarter | DIMENSION | STRING |
|
| Region | Region. | region | DIMENSION | STRING |
|
| Region ID | Users' region ID, derived from their IP address. | region_id | DIMENSION | NUMBER |
|
| Search Exact Match IS | "Search exact match impression share (IS)" is the exact match impressions you've received divided by the estimated number of exact match impressions you were eligible to receive on Google search sites. | search_exact_match_impression_share | METRIC | NUMBER |
|
| Search Impr. share | "Search impression share" is the impressions you’ve received on Google search sites divided by the estimated number of impressions you were eligible to receive. | search_impression_share | METRIC | NUMBER |
|
| Search Lost IS | """Search lost impression share (budget)"" estimates how often your ad didn't show on Google search sites due to low budget." | search_budget_lost_impression_share | METRIC | NUMBER |
|
| Search Lost IS | "Search lost impression share (rank)" estimates how often your ad didn't show on Google search sites due to poor Ad Rank. | search_rank_lost_impression_share | METRIC | NUMBER |
|
| Search Term Match Type | Match type of the keyword that triggered the ad, including variants. | search_term_match_type | DIMENSION | STRING |
|
| Search abs. top IS | "Search absolute top impression share" is the percentage of your Search ad impressions that are shown in the most prominent Search position. | search_absolute_top_impression_share | METRIC | NUMBER |
|
| Search lost abs. top IS | Search lost absolute top impression share (Budget) estimates how often your ad wasn't the very first ad above the organic search results due to low budget. | search_budget_lost_absolute_top_impression_share | METRIC | NUMBER |
|
| Search lost abs. top IS | Search lost absolute top impression share (Budget) estimates how often your ad wasn't the very first ad above the organic search results due to ad rank. | search_rank_lost_absolute_top_impression_share | METRIC | NUMBER |
|
| Search lost top IS | Search lost top impression share (Budget) estimates how often your ad didn't show anywhere above the organic search results due to low budget. | search_budget_lost_top_impression_share | METRIC | NUMBER |
|
| Search lost top IS | Search lost top impression share (rank) estimates how often your ad didn't show anywhere above the organic search results due to poor Ad Rank. | search_rank_lost_top_impression_share | METRIC | NUMBER |
|
| Search term | The search query entered by a user that was matched to the advertiser's ad. | search_term | DIMENSION | STRING |
|
| Search term status | Indicates whether the search term is currently one of your targeted or excluded keywords. | status | DIMENSION | STRING |
|
| Search top IS | Search top impression share (IS) is the impressions you've received in the top location on the search result page divided by the estimated number of impressions you were eligible to receive in the top location. Use this metric to bid on the top page location. | search_top_impression_share | METRIC | NUMBER |
|
| Service Type | service_type | DIMENSION | STRING |
| |
| Serving Status | Ads that can serve to all audiences will be shown as Approved while other serving statuses have the more specific labels Approved (strongly restricted) and Approved (moderately restricted). | servingStatus | DIMENSION | STRING |
|
| Target CPA | The current target CPA set on the Target CPA bidding strategy. | targetCPA | METRIC | NUMBER |
|
| Target ROAS | " The desired revenue per unit of spend". | targetROAS | METRIC | NUMBER |
|
| Top Impression Percentage | top_impression_percentage | METRIC | NUMBER |
| |
| Type | The type of the ad group. | type | DIMENSION | STRING |
|
| Utm Content | Value of the utm_content parameter extracted from the ad destination URL. | utm_content | DIMENSION | STRING |
|
| Utm Medium | Value of the utm_medium parameter extracted from the ad destination URL. | utm_medium | DIMENSION | STRING |
|
| Utm Source | Value of the utm_source parameter extracted from the ad destination URL. | utm_source | DIMENSION | STRING |
|
| Utm Term | Value of the utm_term parameter extracted from the ad destination URL. | utm_term | DIMENSION | STRING |
|
| Value/all conv. | Value per all conversions is approximately how much, on average, each conversion in your All conv. column is worth | value_per_all_conv | METRIC | NUMBER |
|
| Value/conv. | Value per conversion is approximately how much, on average, each of your conversions is worth. It’s the conversion value divided by Conversions. | value_per_conv | METRIC | NUMBER |
|
| Video Quartile P100 Rate | Percentage of impressions where the viewer watched all of your video. | video_quartile_p100_rate | METRIC | NUMBER |
|
| Video Quartile P25 Rate | Percentage of impressions where the viewer watched 25% of your video. | video_quartile_p25_rate | METRIC | NUMBER |
|
| Video Quartile P50 Rate | Percentage of impressions where the viewer watched 50% of your video. | video_quartile_p50_rate | METRIC | NUMBER |
|
| Video Quartile P75 Rate | Percentage of impressions where the viewer watched 75% of your video. | video_quartile_p75_rate | METRIC | NUMBER |
|
| Video Views | The number of times your video ads were viewed. | video_views | METRIC | NUMBER |
|
| View Rate | The percentage of people who watched your video after they first saw the video or thumbnail. It equals the number of views your ad receives divided by the number of impressions | view_rate | METRIC | NUMBER |
|
| View Through Conversions | View-through conversions (“View-through conv.”) are conversions that are recorded when users view (but don’t interact with) an ad and then later convert. These conversions are counted based on a period of time called a view-through conversion window. | view_through_conversions | METRIC | NUMBER |
|
| Week | The dimension that determines how date-based data in a chart is handled. | week | DIMENSION | STRING |
|
| Year | The dimension that determines how date-based data in a chart is handled. | year | DIMENSION | STRING |
|
| Year Month | month | DIMENSION | STRING |
| |
| Year Quarter | The dimension that determines how date-based data in a chart is handled. | year_quarter | DIMENSION | STRING |
|
| Year Week | The dimension that determines how date-based data in a chart is handled. | year_week | DIMENSION | STRING |
|
| utm_campaign | Value of the utm_campaign parameter extracted from the ad destination URL. | utm_campaign | DIMENSION | STRING |
|
Preferred by data-driven businesses
BigQuery
FTP Server
Google Sheets
Looker Studio
Microsoft Excel
MySQL
Power My Analytics API
