Google Ads | Search Query Performance Standard Dataset

Below are the measures and dimensions that Alight Analytics considers standard for the Google Ads Search Query Performance 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 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 Dimension The Customer ID
Campaign Dimension The Campaign name
Campaign ID Dimension The ID of the Campaign
Ad Group Dimension The name of the AdGroup
Ad Group ID Dimension The ID of the Ad Group
Keyword Dimension The text of the keyword (at most 80 characters and 10 words).
Keyword Id Dimension The ID of the keyword
Query Dimension The search term.
Query Match Type Dimension Match type of the keyword that triggered the ad, including variants.
Device Dimension Device to which metrics apply.
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.

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
Impressions Whole Number Count of how often your ad has appeared on a search results page or website on the Google Network
Conversions Float The number of conversions for all conversion actions that you have opted into optimization
Conversion Value Float The sum of conversions values for all conversions
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
Cross Device Conversions Float Conversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are also included in 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
Top Impression Percentage Float The percent of your ad impressions that are shown anywhere above the organic search results.
Absolute Top Impression Percentage Float The percent of your ad impressions that are shown as the very first ad 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.

 

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.