Campaign & Performance Reports

Campaign

​Table Name: google_source_data.campaign

Column Name	Data Type	Description
account_id	Integer	Intentwise account Id
account_name	String	Display Name
customer_id	String	Google ads account customer Id
campaign_id	Integer	Parent campaign identifier; ties ad group structure to campaign structure.
download_date	Date	Date on which the data was downloaded
campaign_name	String	Human-readable campaign label; critical for analyst-facing reporting.
campaign_status	String	Lifecycle status (ENABLED, PAUSED, etc.); indicates whether the campaign is currently serving or not.
serving_status	String	More granular serving information (e.g. LIMITED BY BUDGET); highlights issues affecting delivery.
experiment_type	String	Indicates if the campaign is part of an experiment; needed for interpreting performance data correctly.
optimization_score	Numeric	Google’s optimization score; helps to flag campaigns with room for best practice improvements.
budget_amount_micros	Integer	Associated budget amount; central for budget management and pacing.
bidding_strategy_type	String	Bid strategy (e.g. TARGET CPA, MANUAL CPC); core to understanding how bids are set.
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.
advertising_channel_type	String	Channel (SEARCH, DISPLAY, SHOPPING, etc.); top-level dimension for strategy and allowed settings.
advertising_channel_sub_type	String	Subtype (e.g. SMART SHOPPING, PERFORMANCE MAX); provides even finer context.
positive_geo_target_type	String	Geo targeting behavior (people in, interested in, etc.); crucial for geo strategy analysis.
start_date	String	Planned start date; helpful for lifecycle management and cohorting.
end_date	String	Planned end date; used for scheduling and ensuring no unintended stops.
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.
target_google_search	Boolean	Boolean; signals whether Google Search is included for the campaign.
target_search_network	Boolean	Boolean; indicates inclusion of Search Network partners.
target_content_network	Boolean	Boolean; indicates if Display Network content is targeted.
budget_amount	Numeric	budget_amount
target_cost_per_acquisition_amount	Numeric	target_cost_per_acquisition_amount

Campaign Performance Report

​Table Name: google_source_data.campaign_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
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.
value_per_conversion	Numeric	Average conversion value; helps evaluate lead quality or order size.
all_conversions	Numeric	Extended conversion count.
all_conversions_value	Numeric	Extended conversion value.
search_impression_share	Numeric	Search coverage per ad group; highlights where structure-level constraints limit reach.
search_budget_lost_impression_share	Numeric	Portion of missed impressions due to budget limits; shows if more budget could capture more traffic.
search_rank_lost_impression_share	Numeric	Indicates how much reach is lost due to ad rank (quality/bids) at the ad group level.
current_model_attributed_conversions_value_per_cost	Numeric	Model-based ROAS metric; helps evaluate profitability and bidding strategy effectiveness.
average_order_value_micros	Integer	Average order value; useful for ecommerce to understand the type of customers/carts a campaign attracts.
cost_of_goods_sold_micros	Integer	Cost basis for sold items; enables margin-based performance analysis instead of revenue-only.
cross_sell_revenue_micros	Integer	Revenue from cross-sell activity; evaluates how campaigns drive additional product sales.
cross_sell_units_sold	Numeric	Number of units sold as cross-sell; complements cross-sell revenue for understanding behavior.
average_cart_size	Numeric	Average items per order; helps assess basket-building ability of the campaign.
cost_amount	Numeric	cost_amount
average_cost_per_click_amount	Numeric	average_cost_per_click_amount
average_order_value_amount	Numeric	average_order_value_amount
cost_of_goods_sold_amount	Numeric	cost_of_goods_sold_amount
cross_sell_revenue_amount	Numeric	cross_sell_revenue_amount
device	String	device
ad_network_type	String	ad_network_type

Conversion Performance Report

​Table Name: google_source_data.conversion_performance_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
conversion_action_name	String	conversion_action_name
conversion_action_category	String	conversion_action_category
conversion_action	String	conversion_action
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.
all_conversions	Numeric	Extended conversion count.
all_conversions_value	Numeric	Extended conversion value.
view_through_conversions	Numeric	Conversions occurring after an impression with no click; important for display where view-through is frequent.

Product Group Report

​Table Name: google_source_data.product_group_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
listing_group_type	String	Node type in the product group tree (e.g. subdivision or unit); needed to understand product group structure.
product_brand_value	String	Brand rule value at this node; describes brand-based segmentation.
product_condition	String	Product condition (new, used, etc.); important for condition-based bidding.
product_custom_attribute_value	String	Custom attribute value; reflects merchant-specific segmentation logic.
product_item_id_value	String	Item ID rule; identifies individual items when groups are at item level.
cost_per_click_bid_micros	Integer	Base CPC bid; key lever for controlling traffic at ad group level (manual or target overrides).
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
cost_per_click_bid_amount	Numeric	maximum amount willing to pay for a single click
device	String	device
ad_network_type	String	ad_network_type

Shopping Performance Report

​Table Name: google_source_data.shopping_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
report_date	Date	Daily segmentation for asset combination impressions.
download_date	Date	Date on which the data was downloaded
product_item_id	String	Individual product item ID; identifies the specific item in the feed.
product_brand	String	Brand of the product; dimension for brand-level performance and brand portfolio analysis.
product_category_level1	String	Product category hierarchy; used to roll up performance by category tree.
product_category_level2	String	Product category hierarchy; used to roll up performance by category tree.
product_category_level3	String	Product category hierarchy; used to roll up performance by category tree.
product_category_level4	String	product_category_level4
product_category_level5	String	product_category_level5
product_custom_attribute0	String	Merchant-defined attributes (e.g. margin band, seasonality) that help slice performance by custom business groupings.
product_custom_attribute1	String	Merchant-defined attributes (e.g. margin band, seasonality) that help slice performance by custom business groupings.
product_custom_attribute2	String	Merchant-defined attributes (e.g. margin band, seasonality) that help slice performance by custom business groupings.
product_custom_attribute3	String	product_custom_attribute3
product_custom_attribute4	String	product_custom_attribute4
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.
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
product_title	String	product_title
product_channel	String	product_channel
product_condition	String	Product condition (new, used, etc.); important for condition-based bidding.
product_feed_label	String	product_feed_label
product_merchant_id	Integer	product_merchant_id
product_type_l1	String	product_type_l1
product_type_l2	String	product_type_l2
product_type_l3	String	product_type_l3
product_type_l4	String	product_type_l4
product_type_l5	String	product_type_l5

Shopping Product

​Table Name: google_source_data.shopping_product

Column Name	Data Type	Description
account_id	Integer	Intentwise account Id
account_name	String	Display Name
customer_id	String	Google ads account customer Id
download_date	Date	Date on which the data was downloaded
shopping_product_resource_name	String	Unique identifier for the product resource; needed as a stable key.
item_id	String	Merchant-defined item ID; joins to Merchant Center feed and internal product catalog.
merchant_center_id	Integer	ID of the Merchant Center account; important when multiple accounts feed the same Google Ads account.
status	String	Product eligibility status; crucial for detecting products that cannot serve.
issues	String	List of policy/feed issues; used to prioritize fixes that restore serving.
title	String	Product title shown in ads; important for SEO/creative review.
brand	String	Brand attribute; used for brand-level analysis and compliance with brand policies.
price_micros	Integer	Product price; used to check pricing consistency and for margin/price-band segmentation.
currency_code	String	Currency of the price; necessary for multi-country setups.
language_code	String	Language of the product data; helps verify language targeting alignment.
feed_label	String	Feed label (e.g. region or business unit); used to segment products across feeds.
channel	String	Channel (e.g. online, local); indicates where the product can be sold.
condition	String	Condition (new, used, refurbished); important for pricing and expectations.
category_level1	String	Product category hierarchy; useful for taxonomy checks and mapping to business categories.
category_level2	String	Product category hierarchy; useful for taxonomy checks and mapping to business categories.
category_level3	String	Product category hierarchy; useful for taxonomy checks and mapping to business categories.
category_level4	String	Product category hierarchy; useful for taxonomy checks and mapping to business categories.
category_level5	String	Product category hierarchy; useful for taxonomy checks and mapping to business categories.
custom_attribute0	String	Merchant-defined custom attributes; support arbitrary groupings (e.g. season, profitability band, vertical) needed for business-specific analysis.
custom_attribute1	String	Merchant-defined custom attributes; support arbitrary groupings (e.g. season, profitability band, vertical) needed for business-specific analysis.
custom_attribute2	String	Merchant-defined custom attributes; support arbitrary groupings (e.g. season, profitability band, vertical) needed for business-specific analysis.
custom_attribute3	String	Merchant-defined custom attributes; support arbitrary groupings (e.g. season, profitability band, vertical) needed for business-specific analysis.
custom_attribute4	String	Merchant-defined custom attributes; support arbitrary groupings (e.g. season, profitability band, vertical) needed for business-specific analysis.
price_amount	Numeric	price_amount

Topic Report

​Table Name: google_source_data.topic_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
topic_criterion_resource_name	String	Unique identifier for the topic view row; dimension for each topic.
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.
view_through_conversions	Numeric	Conversions occurring after an impression with no click; important for display where view-through is frequent.
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

Webpage View Report

​Table Name: google_source_data.webpage_view_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
topic_criterion_resource_name	String	Unique identifier for the topic view row; dimension for each topic.
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.
view_through_conversions	Numeric	Conversions occurring after an impression with no click; important for display where view-through is frequent.
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
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
webpage_criterion_resource_name	String	Unique identifier of the webpage criterion view; dimension for each targeted webpage rule.
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