# Adgroup & Searchterm Reports

### Ad Group

​Table Name: google\_source\_data.ad\_group

| Column Name                                       | Data Type | Description                                                                                                   |
| ------------------------------------------------- | --------- | ------------------------------------------------------------------------------------------------------------- |
| account\_id                                       | Integer   | Intentwise account Id                                                                                         |
| account\_name                                     | String    | Display Name                                                                                                  |
| customer\_id                                      | String    | Google ads account customer Id                                                                                |
| ad\_group\_id                                     | Integer   | Primary ad group identifier; join key to performance reports.                                                 |
| ad\_group\_name                                   | String    | Human label for the ad group; used by analysts and in exports.                                                |
| ad\_group\_status                                 | String    | Status (ENABLED, PAUSED, etc.); indicates if the ad group is active.                                          |
| ad\_group\_type                                   | String    | Ad group type (search standard, display, shopping, etc.); defines what kinds of ads/criteria are allowed.     |
| ad\_rotation\_mode                                | String    | Ad rotation setting; impacts how frequently ads are served relative to each other.                            |
| tracking\_url\_template                           | String    | Ad group-level tracking template; important where tracking is overridden below the campaign.                  |
| final\_url\_suffix                                | String    | Ad group URL suffix; helps ensure consistent tracking parameters.                                             |
| cost\_per\_click\_bid\_micros                     | Integer   | Base CPC bid; key lever for controlling traffic at ad group level (manual or target overrides).               |
| cost\_per\_mille\_bid\_micros                     | Integer   | Base CPM bid if applicable; needed for display/video with impression-based bidding.                           |
| cost\_per\_view\_bid\_micros                      | Integer   | Base CPV bid; relevant for video campaigns.                                                                   |
| target\_cost\_per\_acquisition\_micros            | Integer   | Target CPA at ad group level (if supported); used when overriding campaign-level bidding signals.             |
| target\_return\_on\_ad\_spend                     | Numeric   | Target ROAS at ad group level; similar override for automated bidding.                                        |
| effective\_target\_cost\_per\_acquisition\_micros | Integer   | Resolved target CPA considering overrides; what actually applies.                                             |
| effective\_target\_cost\_per\_acquisition\_source | String    | Where the effective target CPA comes from (campaign vs ad group); useful for debugging bidding configuration. |
| effective\_target\_return\_on\_ad\_spend          | Numeric   | Resolved ROAS target applied to this ad group.                                                                |
| effective\_target\_return\_on\_ad\_spend\_source  | String    | Source of the effective ROAS target.                                                                          |
| campaign\_id                                      | Integer   | Parent campaign identifier; ties ad group structure to campaign structure.                                    |
| download\_date                                    | Date      | Date on which the data was downloaded                                                                         |
| cost\_per\_click\_bid\_amount                     | Numeric   | maximum amount willing to pay for a single click                                                              |
| cost\_per\_mille\_bid\_amount                     | Numeric   | cost\_per\_mille\_bid\_amount                                                                                 |
| cost\_per\_view\_bid\_amount                      | Numeric   | cost\_per\_view\_bid\_amount                                                                                  |
| target\_cost\_per\_acquisition\_amount            | Numeric   | target\_cost\_per\_acquisition\_amount                                                                        |
| effective\_target\_cost\_per\_acquisition\_amount | Numeric   | effective\_target\_cost\_per\_acquisition\_amount                                                             |

### Ad Group Ad

​Table Name: google\_source\_data.ad\_group\_ad

| Column Name                       | Data Type | Description                                                                                                 |
| --------------------------------- | --------- | ----------------------------------------------------------------------------------------------------------- |
| account\_id                       | Integer   | Intentwise account Id                                                                                       |
| account\_name                     | String    | Display Name                                                                                                |
| customer\_id                      | String    | Google ads account customer Id                                                                              |
| ad\_id                            | Integer   | Unique ad identifier; join key with performance and asset reports.                                          |
| ad\_name                          | String    | Ad name; helpful backend label usable in reporting.                                                         |
| ad\_status                        | String    | Ad status (ENABLED, PAUSED, DISAPPROVED, etc.); indicates serving eligibility.                              |
| ad\_type                          | String    | Ad type (responsive search ad, expanded text ad, etc.); influences capabilities and metrics interpretation. |
| ad\_strength                      | String    | Ad strength rating; helps identify ads needing improvement.                                                 |
| added\_by\_google\_ads            | Boolean   | Whether ad was auto-created by Google; important for governance and experiments.                            |
| system\_managed\_resource\_source | String    | Indicates system-managed origin; used for separating auto-optimized assets.                                 |
| policy\_review\_status            | String    | Policy review state; helps see which ads are under review.                                                  |
| policy\_approval\_status          | String    | Policy approval state; required for compliance monitoring.                                                  |
| final\_urls                       | String    | Landing page URLs specified at ad level; central for content and tracking audits.                           |
| final\_url\_suffix                | String    | Ad group URL suffix; helps ensure consistent tracking parameters.                                           |
| tracking\_url\_template           | String    | Ad group-level tracking template; important where tracking is overridden below the campaign.                |
| display\_url                      | String    | Display URL; used in creatives and for brand consistency checks.                                            |
| responsive\_search\_ad\_path1     | String    | First path component; used to evaluate and standardize RSA URL paths.                                       |
| responsive\_search\_ad\_path2     | String    | Second path component; similar purpose as path1.                                                            |
| ad\_group\_id                     | Integer   | Primary ad group identifier; join key to performance reports.                                               |
| campaign\_id                      | Integer   | Parent campaign identifier; ties ad group structure to campaign structure.                                  |
| download\_date                    | Date      | Date on which the data was downloaded                                                                       |

### Ad Group Ad Asset

​Table Name: google\_source\_data.ad\_group\_ad\_asset

| Column Name                          | Data Type | Description                                                                                      |
| ------------------------------------ | --------- | ------------------------------------------------------------------------------------------------ |
| account\_id                          | Integer   | Intentwise account Id                                                                            |
| account\_name                        | String    | Display Name                                                                                     |
| customer\_id                         | String    | Google ads account customer Id                                                                   |
| ad\_group\_ad\_asset\_resource\_name | String    | Unique key for the ad–asset relationship; identifies each usage instance.                        |
| field\_type                          | String    | Field slot (headline, description, etc.); clarifies where the asset appears.                     |
| performance\_label                   | String    | System performance label; hints at how well the asset is working historically.                   |
| pinned\_field                        | String    | If set, indicates the asset is pinned to a particular position; important for creative strategy. |
| source                               | String    | Origin of the asset (e.g. advertiser vs auto-created); aids governance and attribution.          |
| enabled                              | Boolean   | Whether this asset usage is enabled; determines if it can serve.                                 |
| asset\_review\_status                | String    | Review state for policy; required for compliance workflows.                                      |
| asset\_approval\_status              | String    | Approval outcome; shows if the asset is allowed to serve.                                        |
| asset\_id                            | Integer   | Asset identifier; supports de-duplication and cross-ad usage analysis.                           |
| asset\_name                          | String    | Asset name; helps recognize creatives.                                                           |
| asset\_type                          | String    | Type (image, text, video); important for asset library categorization.                           |
| text\_asset\_text                    | String    | Text content for text assets; used for copy audits.                                              |
| image\_asset\_url                    | String    | Image URL; useful for cataloging and reviewing creatives.                                        |
| youtube\_video\_id                   | String    | YouTube video ID; needed when auditing video assets and linking to YouTube.                      |
| ad\_id                               | Integer   | Unique ad identifier; join key with performance and asset reports.                               |
| ad\_group\_id                        | Integer   | Primary ad group identifier; join key to performance reports.                                    |
| campaign\_id                         | Integer   | Parent campaign identifier; ties ad group structure to campaign structure.                       |
| download\_date                       | Date      | Date on which the data was downloaded                                                            |

### Ad Group Ad Asset Combination Report

​Table Name: google\_source\_data.ad\_group\_ad\_asset\_combination\_report

| Column Name    | Data Type | Description                                                                                             |
| -------------- | --------- | ------------------------------------------------------------------------------------------------------- |
| account\_id    | Integer   | Intentwise account Id                                                                                   |
| account\_name  | String    | Display Name                                                                                            |
| customer\_id   | String    | Google ads account customer Id                                                                          |
| report\_date   | Date      | Daily segmentation for asset combination impressions.                                                   |
| served\_assets | String    | List/encoding of assets in the combination; main dimension describing which asset mix was used.         |
| ad\_id         | Integer   | Unique ad identifier; join key with performance and asset reports.                                      |
| ad\_group\_id  | Integer   | Primary ad group identifier; join key to performance reports.                                           |
| campaign\_id   | Integer   | Parent campaign identifier; ties ad group structure to campaign structure.                              |
| impressions    | Integer   | Number of times this combination was shown; helps determine which combos get traffic and test coverage. |
| download\_date | Date      | Date on which the data was downloaded                                                                   |

### Ad Group Ad Asset Report

​Table Name: google\_source\_data.ad\_group\_ad\_asset\_report

| Column Name                       | Data Type | Description                                                                                             |
| --------------------------------- | --------- | ------------------------------------------------------------------------------------------------------- |
| account\_id                       | Integer   | Intentwise account Id                                                                                   |
| account\_name                     | String    | Display Name                                                                                            |
| customer\_id                      | String    | Google ads account customer Id                                                                          |
| report\_date                      | Date      | Daily segmentation for asset combination impressions.                                                   |
| ad\_id                            | Integer   | Unique ad identifier; join key with performance and asset reports.                                      |
| asset\_id                         | Integer   | Asset identifier; supports de-duplication and cross-ad usage analysis.                                  |
| field\_type                       | String    | Field slot (headline, description, etc.); clarifies where the asset appears.                            |
| performance\_label                | String    | System performance label; hints at how well the asset is working historically.                          |
| ad\_group\_id                     | Integer   | Primary ad group identifier; join key to performance reports.                                           |
| campaign\_id                      | Integer   | Parent campaign identifier; ties ad group structure to campaign structure.                              |
| clicks                            | Integer   | Clicks attributed to the asset in that ad context.                                                      |
| impressions                       | Integer   | Number of times this combination was shown; helps determine which combos get traffic and test coverage. |
| click\_through\_rate              | Numeric   | Engagement rate for the asset; higher CTR assets are usually preferred.                                 |
| average\_cost\_per\_click         | Integer   | Average CPC when this asset is present; helps evaluate cost dynamics of particular assets.              |
| cost\_micros                      | Integer   | Spend associated with the asset display.                                                                |
| conversions                       | Numeric   | Conversions attributed to the asset; shows its impact on outcomes.                                      |
| cost\_per\_conversion             | Numeric   | Asset-level efficiency metric.                                                                          |
| conversions\_value                | Numeric   | Value generated with that asset; required for ROAS by asset.                                            |
| all\_conversions                  | Numeric   | Extended conversion count.                                                                              |
| all\_conversions\_value           | Numeric   | Extended conversion value.                                                                              |
| download\_date                    | Date      | Date on which the data was downloaded                                                                   |
| cost\_amount                      | Numeric   | cost\_amount                                                                                            |
| average\_cost\_per\_click\_amount | Numeric   | average\_cost\_per\_click\_amount                                                                       |
| device                            | String    | device                                                                                                  |
| ad\_network\_type                 | String    | ad\_network\_type                                                                                       |

### Ad Group Ad Report

​Table Name: google\_source\_data.ad\_group\_ad\_report

| Column Name                           | Data Type | Description                                                                                                                        |
| ------------------------------------- | --------- | ---------------------------------------------------------------------------------------------------------------------------------- |
| account\_id                           | Integer   | Intentwise account Id                                                                                                              |
| account\_name                         | String    | Display Name                                                                                                                       |
| customer\_id                          | String    | Google ads account customer Id                                                                                                     |
| ad\_id                                | Integer   | Unique ad identifier; join key with performance and asset reports.                                                                 |
| ad\_group\_id                         | Integer   | Primary ad group identifier; join key to performance reports.                                                                      |
| campaign\_id                          | Integer   | Parent campaign identifier; ties ad group structure to campaign structure.                                                         |
| report\_date                          | Date      | Daily segmentation for asset combination impressions.                                                                              |
| clicks                                | Integer   | Clicks attributed to the asset in that ad context.                                                                                 |
| impressions                           | Integer   | Number of times this combination was shown; helps determine which combos get traffic and test coverage.                            |
| click\_through\_rate                  | Numeric   | Engagement rate for the asset; higher CTR assets are usually preferred.                                                            |
| average\_cost\_per\_click             | Integer   | Average CPC when this asset is present; helps evaluate cost dynamics of particular assets.                                         |
| cost\_micros                          | Integer   | Spend associated with the asset display.                                                                                           |
| conversions                           | Numeric   | Conversions attributed to the asset; shows its impact on outcomes.                                                                 |
| conversions\_value                    | Numeric   | Value generated with that asset; required for ROAS by asset.                                                                       |
| cost\_per\_conversion                 | Numeric   | Asset-level efficiency metric.                                                                                                     |
| all\_conversions                      | Numeric   | Extended conversion count.                                                                                                         |
| absolute\_top\_impression\_percentage | Numeric   | Share of impressions in very top position; indicates premium placement and helps explain cost/performance differences between ads. |
| download\_date                        | Date      | Date on which the data was downloaded                                                                                              |
| cost\_amount                          | Numeric   | cost\_amount                                                                                                                       |
| average\_cost\_per\_click\_amount     | Numeric   | average\_cost\_per\_click\_amount                                                                                                  |
| device                                | String    | device                                                                                                                             |
| ad\_network\_type                     | String    | ad\_network\_type                                                                                                                  |

### Ad Group Audience Report

​Table Name: google\_source\_data.ad\_group\_audience\_report

| Column Name                         | Data Type | Description                                                                                             |
| ----------------------------------- | --------- | ------------------------------------------------------------------------------------------------------- |
| account\_id                         | Integer   | Intentwise account Id                                                                                   |
| account\_name                       | String    | Display Name                                                                                            |
| customer\_id                        | String    | Google ads account customer Id                                                                          |
| report\_date                        | Date      | Daily segmentation for asset combination impressions.                                                   |
| download\_date                      | Date      | Date on which the data was downloaded                                                                   |
| audience\_criterion\_resource\_name | String    | Unique identifier for the ad group audience view; dimension for each ad group–audience pair.            |
| criterion\_id                       | Integer   | Criterion ID of the audience; used for managing the audience target.                                    |
| ad\_group\_id                       | Integer   | Primary ad group identifier; join key to performance reports.                                           |
| campaign\_id                        | Integer   | Parent campaign identifier; ties ad group structure to campaign structure.                              |
| clicks                              | Integer   | Clicks attributed to the asset in that ad context.                                                      |
| impressions                         | Integer   | Number of times this combination was shown; helps determine which combos get traffic and test coverage. |
| click\_through\_rate                | Numeric   | Engagement rate for the asset; higher CTR assets are usually preferred.                                 |
| average\_cost\_per\_click           | Integer   | Average CPC when this asset is present; helps evaluate cost dynamics of particular assets.              |
| cost\_micros                        | Integer   | Spend associated with the asset display.                                                                |
| conversions                         | Numeric   | Conversions attributed to the asset; shows its impact on outcomes.                                      |
| cost\_per\_conversion               | Numeric   | Asset-level efficiency metric.                                                                          |
| conversions\_value                  | Numeric   | Value generated with that asset; required for ROAS by asset.                                            |
| all\_conversions                    | Numeric   | Extended conversion count.                                                                              |
| all\_conversions\_value             | Numeric   | Extended conversion value.                                                                              |
| cost\_amount                        | Numeric   | cost\_amount                                                                                            |
| average\_cost\_per\_click\_amount   | Numeric   | average\_cost\_per\_click\_amount                                                                       |
| device                              | String    | device                                                                                                  |
| ad\_network\_type                   | String    | ad\_network\_type                                                                                       |

### Ad Group Performance Report

​Table Name: google\_source\_data.ad\_group\_performance\_report

| Column Name                           | Data Type | Description                                                                                             |
| ------------------------------------- | --------- | ------------------------------------------------------------------------------------------------------- |
| account\_id                           | Integer   | Intentwise account Id                                                                                   |
| account\_name                         | String    | Display Name                                                                                            |
| customer\_id                          | String    | Google ads account customer Id                                                                          |
| ad\_group\_id                         | Integer   | Primary ad group identifier; join key to performance reports.                                           |
| campaign\_id                          | Integer   | Parent campaign identifier; ties ad group structure to campaign structure.                              |
| report\_date                          | Date      | Daily segmentation for asset combination impressions.                                                   |
| download\_date                        | Date      | Date on which the data was downloaded                                                                   |
| clicks                                | Integer   | Clicks attributed to the asset in that ad context.                                                      |
| impressions                           | Integer   | Number of times this combination was shown; helps determine which combos get traffic and test coverage. |
| click\_through\_rate                  | Numeric   | Engagement rate for the asset; higher CTR assets are usually preferred.                                 |
| average\_cost\_per\_click             | Integer   | Average CPC when this asset is present; helps evaluate cost dynamics of particular assets.              |
| cost\_micros                          | Integer   | Spend associated with the asset display.                                                                |
| conversions                           | Numeric   | Conversions attributed to the asset; shows its impact on outcomes.                                      |
| cost\_per\_conversion                 | Numeric   | Asset-level efficiency metric.                                                                          |
| conversions\_value                    | Numeric   | Value generated with that asset; required for ROAS by asset.                                            |
| all\_conversions\_value               | Numeric   | Extended conversion value.                                                                              |
| search\_impression\_share             | Numeric   | Search coverage per ad group; highlights where structure-level constraints limit reach.                 |
| search\_rank\_lost\_impression\_share | Numeric   | Indicates how much reach is lost due to ad rank (quality/bids) at the ad group level.                   |
| all\_conversions                      | Numeric   | Extended conversion count.                                                                              |
| cost\_amount                          | Numeric   | cost\_amount                                                                                            |
| average\_cost\_per\_click\_amount     | Numeric   | average\_cost\_per\_click\_amount                                                                       |
| device                                | String    | device                                                                                                  |
| ad\_network\_type                     | String    | ad\_network\_type                                                                                       |

### DSA Search Term Report

​Table Name: google\_source\_data.dsa\_search\_term\_report

<table><thead><tr><th width="340">Column Name</th><th width="150">Data Type</th><th width="583">Description</th></tr></thead><tbody><tr><td>account_id</td><td>Integer</td><td>Intentwise account Id</td></tr><tr><td>account_name</td><td>String</td><td>Display Name</td></tr><tr><td>customer_id</td><td>String</td><td>Google ads account customer Id</td></tr><tr><td>report_date</td><td>Date</td><td>Daily segmentation for asset combination impressions. </td></tr><tr><td>download_date</td><td>Date</td><td>Date on which the data was downloaded</td></tr><tr><td>search_term</td><td>String</td><td>User query text that triggered DSA; central to understanding DSA-matched intents. </td></tr><tr><td>headline</td><td>String</td><td>Dynamically generated headline; helps validate DSA content relevance. </td></tr><tr><td>landing_page</td><td>String</td><td>Final URL used; useful for auditing which pages are being promoted. </td></tr><tr><td>ad_group_id</td><td>Integer</td><td>Primary ad group identifier; join key to performance reports. </td></tr><tr><td>campaign_id</td><td>Integer</td><td>Parent campaign identifier; ties ad group structure to campaign structure. </td></tr><tr><td>clicks</td><td>Integer</td><td>Clicks attributed to the asset in that ad context. </td></tr><tr><td>impressions</td><td>Integer</td><td>Number of times this combination was shown; helps determine which combos get traffic and test coverage. </td></tr><tr><td>click_through_rate</td><td>Numeric</td><td>Engagement rate for the asset; higher CTR assets are usually preferred. </td></tr><tr><td>average_cost_per_click</td><td>Integer</td><td>Average CPC when this asset is present; helps evaluate cost dynamics of particular assets. </td></tr><tr><td>cost_micros</td><td>Integer</td><td>Spend associated with the asset display. </td></tr><tr><td>conversions</td><td>Numeric</td><td>Conversions attributed to the asset; shows its impact on outcomes. </td></tr><tr><td>cost_per_conversion</td><td>Numeric</td><td>Asset-level efficiency metric. </td></tr><tr><td>conversions_value</td><td>Numeric</td><td>Value generated with that asset; required for ROAS by asset. </td></tr><tr><td>all_conversions</td><td>Numeric</td><td>Extended conversion count. </td></tr><tr><td>all_conversions_value</td><td>Numeric</td><td>Extended conversion value. </td></tr><tr><td>cost_amount</td><td>Numeric</td><td>cost_amount</td></tr><tr><td>average_cost_per_click_amount</td><td>Numeric</td><td>average_cost_per_click_amount</td></tr></tbody></table>

### Geographic View Report

​Table Name: google\_source\_data.geographic\_view\_report

| Column Name                       | Data Type | Description                                                                                             |
| --------------------------------- | --------- | ------------------------------------------------------------------------------------------------------- |
| account\_id                       | Integer   | Intentwise account Id                                                                                   |
| account\_name                     | String    | Display Name                                                                                            |
| customer\_id                      | Integer   | Google ads account customer Id                                                                          |
| campaign\_id                      | Integer   | Parent campaign identifier; ties ad group structure to campaign structure.                              |
| report\_date                      | Date      | Daily segmentation for asset combination impressions.                                                   |
| download\_date                    | Date      | Date on which the data was downloaded                                                                   |
| country\_criterion\_id            | Integer   | country\_criterion\_id                                                                                  |
| location\_type                    | String    | location\_type                                                                                          |
| geo\_target\_state                | String    | geo\_target\_state                                                                                      |
| geo\_target\_province             | String    | geo\_target\_province                                                                                   |
| geo\_target\_region               | String    | geo\_target\_region                                                                                     |
| geo\_target\_city                 | String    | geo\_target\_city                                                                                       |
| geo\_target\_metro                | String    | geo\_target\_metro                                                                                      |
| device                            | String    | device                                                                                                  |
| ad\_network\_type                 | String    | ad\_network\_type                                                                                       |
| clicks                            | Integer   | Clicks attributed to the asset in that ad context.                                                      |
| impressions                       | Integer   | Number of times this combination was shown; helps determine which combos get traffic and test coverage. |
| click\_through\_rate              | Numeric   | Engagement rate for the asset; higher CTR assets are usually preferred.                                 |
| average\_cost\_per\_click         | Integer   | Average CPC when this asset is present; helps evaluate cost dynamics of particular assets.              |
| average\_cost\_per\_click\_amount | Numeric   | average\_cost\_per\_click\_amount                                                                       |
| cost\_micros                      | Integer   | Spend associated with the asset display.                                                                |
| cost\_amount                      | Numeric   | cost\_amount                                                                                            |
| conversions                       | Numeric   | Conversions attributed to the asset; shows its impact on outcomes.                                      |
| conversions\_value                | Numeric   | Value generated with that asset; required for ROAS by asset.                                            |
| cost\_per\_conversion             | Numeric   | Asset-level efficiency metric.                                                                          |
| all\_conversions                  | Numeric   | Extended conversion count.                                                                              |
| all\_conversions\_value           | Numeric   | Extended conversion value.                                                                              |

### Paid Organic Searchterm Report

​Table Name: google\_source\_data.paid\_organic\_search\_term\_report

| Column Name          | Data Type | Description                                                                                             |
| -------------------- | --------- | ------------------------------------------------------------------------------------------------------- |
| account\_id          | Integer   | Intentwise account Id                                                                                   |
| account\_name        | String    | Display Name                                                                                            |
| customer\_id         | String    | Google ads account customer Id                                                                          |
| report\_date         | Date      | Daily segmentation for asset combination impressions.                                                   |
| download\_date       | Date      | Date on which the data was downloaded                                                                   |
| search\_term         | String    | User query text that triggered DSA; central to understanding DSA-matched intents.                       |
| campaign\_id         | Integer   | Parent campaign identifier; ties ad group structure to campaign structure.                              |
| ad\_group\_id        | Integer   | Primary ad group identifier; join key to performance reports.                                           |
| clicks               | Integer   | Clicks attributed to the asset in that ad context.                                                      |
| impressions          | Integer   | Number of times this combination was shown; helps determine which combos get traffic and test coverage. |
| organic\_clicks      | Integer   | Clicks from organic listings; shows SEO contribution for that term.                                     |
| organic\_impressions | Integer   | Organic impressions; indicates organic visibility strength.                                             |
| organic\_queries     | Integer   | Number of organic search queries; helps approximate organic demand.                                     |
| combined\_clicks     | Integer   | Total clicks from both paid and organic; used for overall search presence impact.                       |
| combined\_queries    | Integer   | Total queries where you had either paid or organic presence; helps assess overall reach.                |
| device               | String    | device                                                                                                  |

### Searchterm Report

​Table Name: google\_source\_data.search\_term\_report

| Column Name                           | Data Type | Description                                                                                                                        |
| ------------------------------------- | --------- | ---------------------------------------------------------------------------------------------------------------------------------- |
| account\_id                           | Integer   | Intentwise account Id                                                                                                              |
| account\_name                         | String    | Display Name                                                                                                                       |
| customer\_id                          | String    | Google ads account customer Id                                                                                                     |
| report\_date                          | Date      | Daily segmentation for asset combination impressions.                                                                              |
| download\_date                        | Date      | Date on which the data was downloaded                                                                                              |
| search\_term                          | String    | User query text that triggered DSA; central to understanding DSA-matched intents.                                                  |
| search\_term\_status                  | String    | Eligibility status of the search term; indicates whether the term is currently reportable/actionable.                              |
| search\_term\_match\_type             | String    | Match type relationship between query and keyword; helps tune match types and understand intent broadness.                         |
| keyword\_text                         | String    | Text of the display keyword; main dimension analysts care about.                                                                   |
| ad\_group\_id                         | Integer   | Primary ad group identifier; join key to performance reports.                                                                      |
| campaign\_id                          | Integer   | Parent campaign identifier; ties ad group structure to campaign structure.                                                         |
| clicks                                | Integer   | Clicks attributed to the asset in that ad context.                                                                                 |
| impressions                           | Integer   | Number of times this combination was shown; helps determine which combos get traffic and test coverage.                            |
| click\_through\_rate                  | Numeric   | Engagement rate for the asset; higher CTR assets are usually preferred.                                                            |
| average\_cost\_per\_click             | Integer   | Average CPC when this asset is present; helps evaluate cost dynamics of particular assets.                                         |
| cost\_micros                          | Integer   | Spend associated with the asset display.                                                                                           |
| conversions                           | Numeric   | Conversions attributed to the asset; shows its impact on outcomes.                                                                 |
| cost\_per\_conversion                 | Numeric   | Asset-level efficiency metric.                                                                                                     |
| conversions\_value                    | Numeric   | Value generated with that asset; required for ROAS by asset.                                                                       |
| all\_conversions                      | Numeric   | Extended conversion count.                                                                                                         |
| absolute\_top\_impression\_percentage | Numeric   | Share of impressions in very top position; indicates premium placement and helps explain cost/performance differences between ads. |
| cost\_amount                          | Numeric   | cost\_amount                                                                                                                       |
| average\_cost\_per\_click\_amount     | Numeric   | average\_cost\_per\_click\_amount                                                                                                  |
| device                                | String    | device                                                                                                                             |
| ad\_network\_type                     | String    | ad\_network\_type                                                                                                                  |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.intentwise.com/iac-source-data/data-models/google-source-data/adgroup-and-searchterm-reports.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.