Google Ads | Search Query Standard Dataset

Below are the fields Alight Analytics considers standard for Google Ads - Search Query dataset. There is a one day lag on Google Ads and data is pulled for the previous 30 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 Descriptive Name

Dimension

The descriptive name of the Customer account

External Customer ID

Whole Number

The Customer ID

Campaign

Dimension

The Campaign name

Campaign ID

Dimension

The Campaign ID

Ad Group

Dimension

The Ad Group name

Ad Group ID

Dimension

The Ad Group ID

Keyword Dimension The keyword text (criteria)

Keyword ID

Dimension

The Keyword ID

Query

Dimension

The search term used

Query Match Type

Dimension Match type of the keyword that triggered the ad, including variants

Device

Dimension

Device

Network

Dimension

The network type

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

Currency

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

All Conversions

Float

Best estimate of the total number of conversions that Google Ads drives. Includes website, cross-device, and phone call conversions

All Conversion Value

Float

The total value of all of your conversions, including those that are estimated

Video Views

Whole Number

The number of times your video ads were viewed

Video Quartile 100%

Percent

Percentage of impressions where the viewer watched all of your video

Video Quartile 75%

Percent

Percentage of impressions where the viewer watched 75% of your video

Video Quartile 50%

Percent

Percentage of impressions where the viewer watched 50% of your video

Video Quartile 25%

Percent

Percentage of impressions where the viewer watched 25% of your video

Insert Date

Dimension

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.