Below are the measures and dimensions Alight Analytics considers standard for Google Ads - Campaign dataset. There is a one day lag on Google Ads and data is pulled for the previous 31 days.
This dataset can be automatically activated without a ticket through Dataset Activation.
Field Name |
Type |
Description |
Report Date |
Date |
The date the activity occurred. |
Account Currency Code |
Dimension |
The currency of the account. |
Account Descriptive Name |
Dimension |
The descriptive name of the Customer account. |
External Customer ID |
Whole Number |
The Customer ID. |
Campaign ID |
Dimension |
The Campaign ID. |
Campaign |
Dimension |
The Campaign name. |
Campaign Status |
Dimension |
The Campaign status. |
Ad Group |
Dimension |
The Ad Group name. |
Ad Group Status |
Dimension |
Status of the ad group. |
Network |
Dimension |
The network type. |
Device |
Dimension |
Computers, mobile devices with full browsers, and tablets with full browsers |
Customer Descriptive Name |
Dimension |
The descriptive name of the customer. |
Budget ID |
Dimension |
The Budget ID. |
Daily Budget |
Dimension |
Reflects the entire shared budget. |
Total Budget |
Dimension |
The total budget amount of the campaign, if set in the Google Ads UI. |
Recommended Budget |
Dimension |
The recommended budget amount. |
Has Recommended Budget |
True/False |
Is there a recommended budget for the campaign? |
Is Budget Explicitly Shared |
True/False |
If the budget is shared or if it is for a specific campaign. |
Label ID |
Dimension |
List of label IDs. |
Labels |
Dimension |
List of label names. |
Period |
Dimension |
The timeframe for spending the budget. |
Impressions |
Whole Number |
Count of how often your ad has appeared on a search results page or website on the Google Network. |
Clicks |
Whole Number |
The number of clicks. |
Cost |
Currency |
The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. |
Content Budget Lost Impression Share |
Decimal |
The estimated percent of times that your ad was eligible to show, but didn’t because your budget was too low. |
Content Impression Share |
Decimal |
The impressions received divided by the estimated number of impressions eligible to receive. |
Content Rank Lost Impression Share |
Decimal |
The estimated number of impressions that your ads didn’t receive due to poor ad rank. |
Average Position |
Decimal |
Your ad's position relative to those of other advertisers. |
All Conversions |
Decimal |
Best estimate of the total number of conversions that Google Ads drives. |
All Conversion Value |
Decimal |
The total value of all of your conversions, including those that are estimated. |
Conversion Name |
Dimension |
The name of the conversion. |
Conversion Value |
Currency |
The sum of conversion values for all conversions. |
Conversions |
Whole Number |
The number of conversions for all conversion actions that you have opted into optimization. |
View-Through Conversions |
Whole Number |
The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (e.g. clicking on) another ad. |
Video Views |
Whole Number |
The number of times people watched or engaged with your video ad |
Absolute Top Impression Percentage |
Decimal Fraction |
Percentage of ad impressions shown as the first ad above the organic search results. |
Search Absolute Top Impression Share |
Dimension |
Impressions received at the absolute top location divided by the estimated number of impressions the ad was eligible to receive in that location. |
Search Absolute Top Impression Share Measure |
Decimal Fraction |
The same field as above converted to a decimal. Field values that are <10% have been converted to .1. |
Search Top Impression Share |
Decimal Fraction |
Impressions received anywhere above the organic search results, compared to the estimated number of impressions the ad was eligible to receive in that location. |
Top Impression Percentage |
Decimal Fraction |
Percentage of ad impressions shown anywhere above the organic search results. |
Insert Date |
DateTime |
Internal use: when the row was inserted in the table |
ChannelMix Profile |
Dimension |
When needed, distinguishes between Google Ads accounts – Contents defined by Alight. |
Comments
Please sign in to leave a comment.