Google Ads | Campaign Standard Dataset
ChannelMix
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.
NOTE: The "Customer Descriptive Name" and "Account Descriptive Name" fields have been combined by Google Ads. Both are now represented as the "Account Descriptive Name" field in the standard Google Ads datasets in ChannelMix.
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. NOTE: The "Customer Descriptive Name" and "Account Descriptive Name" fields have been combined by Google Ads. Both are now represented as the "Account Descriptive Name" field in the standard Google Ads datasets in ChannelMix. |
|
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. |
|
Network |
Dimension |
The network type. |
|
Campaign Advertising Channel Type |
Dimension |
The primary serving target for ads within the campaign. |
|
Campaign Advertising Channel Sub-Type |
Dimension |
Optional refinement to Campaign Advertising Channel Type. Must be a valid sub-type of the parent channel type. |
|
Device |
Dimension |
Computers, mobile devices with full browsers, and tablets with full browsers |
|
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 |
Float |
The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. |
|
Content Budget Lost Impression Share |
Float |
The estimated percent of times that your ad was eligible to show, but didn’t because your budget was too low. |
|
Content Impression Share |
Float |
The impressions received divided by the estimated number of impressions eligible to receive. |
|
Content Rank Lost Impression Share |
Float |
The estimated number of impressions that your ads didn’t receive due to poor ad rank. |
|
Average Position |
Float |
Your ad's position relative to those of other advertisers. |
|
All Conversions |
Float |
Best estimate of the total number of conversions that Google Ads drives. |
|
All Conversion Value |
Float |
The total value of all of your conversions, including those that are estimated. |
|
Conversion Value |
Float |
The sum of conversion values for all conversions. |
|
Conversions |
Float |
The number of conversions for all conversion actions that you have opted into optimization. |
|
View-Through Conversions |
Float |
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 |
Float |
Percentage of ad impressions shown as the first ad above the organic search results. |
|
Search Absolute Top Impression Share |
Float |
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 |
Float |
The same field as above converted to a decimal. Field values that are <10% have been converted to .1. |
|
Search Top Impression Share |
Float |
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 |
Float |
Percentage of ad impressions shown anywhere above the organic search results. |
|
Insert Date |
Timestamp |
Internal use: when the row was inserted in the table |
|
ChannelMix Profile |
Dimension |
When needed, distinguishes between Google Ads accounts – Contents defined by Alight. |