Google Ads | Keyword Standard Dataset

Below are the fields Alight Analytics considers standard for Google Ads - Keyword dataset. There is a one day lag on Google Ads and data is pulled for the previous 31 days. 

The keyword dataset will only include ads that run on the Google Search Network. Ads that run on the Google Display Network are not included because those ads do not have related keywords.

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 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

Dimension

The Campaign name.

Campaign ID

Dimension

The Campaign ID.

Campaign Status

Dimension

The Campaign status.

Ad Group

Dimension

The Ad Group name.

Ad Group ID

Dimension

The Ad Group ID.

Ad Group Status

Dimension

Status of the ad group.

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.

Keyword

Dimension

The keyword text (criteria).

Device

Dimension

Device

Keyword ID

Dimension

The Keyword ID.

Keyword Match Type

Dimension

The match type for the Keyword.

Clicks

Whole Number

The number of clicks.

Impressions

Whole Number

Count of how often your ad has appeared on a search results page or website on the Google Network.

Cost

Float

The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.

Conversions

Float

The number of conversions for all conversion actions that you have opted into optimization.

Conversion Value

Float

The sum of conversion values for all conversions.

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.

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 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 AdWords accounts – Contents defined by Alight.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.