Google Ads | Search Query Performance Standard Dataset
Brendon Reimer
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. |