google_ad_metrics contains daily performance metrics for individual Google Ads, providing detailed visibility into campaign, ad group, and ad-level activity. The table includes spend, impressions, clicks, conversions, engagement metrics, budgets, and ad attributes, enabling granular analysis of advertising performance, efficiency, and conversion outcomes. It supports optimization and ROI reporting across Google Ads campaigns and creatives.
Table | google_ad_metrics |
Description | Contains ad-level daily metrics for Google Ads campaigns |
Granularity (Composite key that uniquely identifies a row) | ad_id, campaign_id, date |
Column Details:
Column Name | Description | Data Type |
date | Date for which the ad metrics correspond to | DATE |
google_ad_account_name | Name of the Google Ads account (connection name from Firestore) | STRING |
currency | Currency code for cost values (e.g. USD) | STRING |
campaign_group_id | Campaign Group ID as found in Google Ads | STRING |
campaign_group_name | Campaign Group Name as found in Google Ads | STRING |
campaign_group_status | Campaign Group Status (e.g. ENABLED, PAUSED) | STRING |
campaign_id | Campaign ID as found in the source system | STRING |
campaign_name | Campaign Name as found in the source system | STRING |
campaign_type | Campaign Type (e.g. DEMAND_GEN, SEARCH) | STRING |
campaign_status | Campaign Status (e.g. ENABLED, PAUSED) | STRING |
daily_budget | Daily budget set for the campaign. Standardized to reporting currency (USD) | NUMERIC |
total_budget | Total/lifetime budget set for the campaign. Standardized to reporting currency (USD) | NUMERIC |
campaign_start_date | Start date of the campaign | DATE |
campaign_end_date | End date of the campaign | DATE |
ad_group_id | Ad Group ID as found in Google Ads | STRING |
ad_group_name | Ad Group Name as found in Google Ads | STRING |
ad_group_type | Ad Group Type (e.g. SEARCH_STANDARD) | STRING |
ad_group_status | Ad Group Status (e.g. ENABLED, PAUSED) | STRING |
ad_id | Ad ID as found in the source system | STRING |
ad_type | Ad Type (e.g. RESPONSIVE_SEARCH_AD) | STRING |
ad_keywords | Keywords associated with the ad | STRING |
ad_headline | Ad headline text | STRING |
ad_status | Ad Status (e.g. ENABLED, PAUSED) | STRING |
cost | Amount spent on the ad for the date. Standardized to reporting currency (USD) | NUMERIC |
impressions | Number of ad impressions for the date | NUMERIC |
clicks | Number of ad clicks for the date | NUMERIC |
click_through_rate | Ratio of clicks to impressions (clicks / impressions) | FLOAT |
average_cpm | Average cost per 1000 impressions (cost / impressions * 1000) | FLOAT |
average_cpc | Average cost per click (cost / clicks) | FLOAT |
conversions | Number of conversions attributed to the ad for the date | NUMERIC |
conversion_rate | Ratio of conversions to clicks (conversions / clicks) | FLOAT |
interactions | Number of interactions with the ad for the date | NUMERIC |
cost_per_conversion | Average cost per conversion (cost / conversions) | FLOAT |
pending_marketing_qualified | Count of Pending Marketing Qualification conversion actions for the ad+date | NUMERIC |
marketing_qualified_sales_untouched | Count of Marketing Qualified Sales Untouched conversion actions for the ad+date | NUMERIC |
sales_pursuing | Count of Sales Pursuing conversion actions for the ad+date | NUMERIC |
cost_per_marketing_qualified | Cost per Pending Marketing Qualified conversion (cost / pending_marketing_qualified) | FLOAT |
final_url | Final destination URL of the ad | STRING |
ad_text | Raw ad object (reserved for future use) | STRING |
match_type | Keyword match type (reserved for future use) | STRING |
created_at | Time at which the record was created in UTC | TIMESTAMP |
updated_at | Time at which the record was last updated UTC | TIMESTAMP |