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 |