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 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.
headline	String	Dynamically generated headline; helps validate DSA content relevance.
landing_page	String	Final URL used; useful for auditing which pages are being promoted.
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

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