> For the complete documentation index, see [llms.txt](https://docs.intentwise.com/iac-source-data/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.intentwise.com/iac-source-data/data-models/google-source-data/adgroup-and-searchterm-reports.md). # 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
Column NameData TypeDescription
account_idIntegerIntentwise account Id
account_nameStringDisplay Name
customer_idStringGoogle ads account customer Id
report_dateDateDaily segmentation for asset combination impressions.
download_dateDateDate on which the data was downloaded
search_termStringUser query text that triggered DSA; central to understanding DSA-matched intents.
headlineStringDynamically generated headline; helps validate DSA content relevance.
landing_pageStringFinal URL used; useful for auditing which pages are being promoted.
ad_group_idIntegerPrimary ad group identifier; join key to performance reports.
campaign_idIntegerParent campaign identifier; ties ad group structure to campaign structure.
clicksIntegerClicks attributed to the asset in that ad context.
impressionsIntegerNumber of times this combination was shown; helps determine which combos get traffic and test coverage.
click_through_rateNumericEngagement rate for the asset; higher CTR assets are usually preferred.
average_cost_per_clickIntegerAverage CPC when this asset is present; helps evaluate cost dynamics of particular assets.
cost_microsIntegerSpend associated with the asset display.
conversionsNumericConversions attributed to the asset; shows its impact on outcomes.
cost_per_conversionNumericAsset-level efficiency metric.
conversions_valueNumericValue generated with that asset; required for ROAS by asset.
all_conversionsNumericExtended conversion count.
all_conversions_valueNumericExtended conversion value.
cost_amountNumericcost_amount
average_cost_per_click_amountNumericaverage_cost_per_click_amount
### 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 |