Full field catalogue across 22 PMA report types, plus native MCP tools for live optimisation, search term analysis, and write operations.
Grouped by report type. Filter to find a field fast. formula fields are computed — use their component fields in SQL.
| Field name | Label | Type |
|---|---|---|
CTR | CTRformula | NUMBER |
conv_rate | Conv. Rateformula | NUMBER |
interaction_rate | Interaction Rateformula | NUMBER |
engagement_rate | Engagement Rateformula | NUMBER |
view_rate | View Rateformula | NUMBER |
all_conv_rate | All Conv. Rateformula | NUMBER |
avg_cpc | Avg. CPCformula | NUMBER |
avg_cpm | Avg. CPMformula | NUMBER |
avg_cpv | Avg. CPVformula | NUMBER |
cost_per_conv | Cost/Conv.formula | NUMBER |
cost_per_all_conv | Cost/All Conv.formula | NUMBER |
conv_value_per_cost | Conv. Value/Costformula | NUMBER |
value_per_conv | Value/Conv.formula | NUMBER |
store_visits | Store Visitsformula | NUMBER |
all_conversions | All Conversions | NUMBER |
all_conversions_value | All Conversions Value | NUMBER |
clicks | Clicks | NUMBER |
conversions | Conversions | NUMBER |
conversions_by_conversion_date | Conversions By Conversion Date | NUMBER |
conversions_value | Conversions Value | NUMBER |
conversions_value_by_conversion_date | Conversions Value By Conversion Date | NUMBER |
cost | Cost | NUMBER |
cross_device_conversions | Cross Device Conversions | NUMBER |
current_model_attributed_conversions | Current Model Attributed Conversions | NUMBER |
engagements | Engagements | NUMBER |
impressions | Impressions | NUMBER |
interactions | Interactions | NUMBER |
phone_calls | Phone Calls | NUMBER |
search_absolute_top_impression_share | Search abs. top IS | NUMBER |
search_budget_lost_impression_share | Search Lost IS (budget) | NUMBER |
search_click_share | Click Share | NUMBER |
bounce_rate | Bounce Rate | NUMBER |
average_time_on_site | Average Time On Site | NUMBER |
gmail_forwards | Gmail Forwards | NUMBER |
gmail_saves | Gmail Saves | NUMBER |
gmail_secondary_clicks | Gmail Secondary Clicks | NUMBER |
percent_new_visitors | Percent New Visitors | NUMBER |
all_conversions_from_location_asset_store_visits | All Conversions From Location Asset Store Visits | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Account Name | STRING |
account_id | Account ID | STRING |
campaign_id | Campaign ID | STRING |
adNetworkType | Network | STRING |
device | Device | STRING |
date | Date | STRING |
month | Year Month | STRING |
conversionActionCategory | Conversion Category | STRING |
conversionActionName | Conversion Action | STRING |
dataFreshness | Data Freshness | STRING |
dataSource | Data Source | STRING |
MinDate | PMA Minimum Cached Data Date | STRING |
MaxDate | PMA Maximum Cached Data Date | STRING |
isInterpolated | PMA Is Interpolated? | BOOLEAN |
| Field name | Label | Type |
|---|---|---|
CTR | CTRformula | NUMBER |
conv_rate | Conv. Rateformula | NUMBER |
avg_cpc | Avg. CPCformula | NUMBER |
avg_cpm | Avg. CPMformula | NUMBER |
cost_per_conv | Cost/Conv.formula | NUMBER |
all_conversions | All Conversions | NUMBER |
clicks | Clicks | NUMBER |
conversions | Conversions | NUMBER |
conversions_value | Conversions Value | NUMBER |
cost | Cost | NUMBER |
impressions | Impressions | NUMBER |
phone_calls | Phone Calls | NUMBER |
phone_impressions | Phone Impressions | NUMBER |
search_impression_share | Search Impr. Share | NUMBER |
search_exact_match_impression_share | Search Exact Match IS | NUMBER |
search_rank_lost_absolute_top_impression_share | Search lost abs. top IS (rank) | NUMBER |
engagements | Engagements | NUMBER |
interactions | Interactions | NUMBER |
cross_device_conversions | Cross Device Conversions | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Account Name | STRING |
account_id | Account ID | STRING |
ad_group_id | Ad group ID | STRING |
campaign_id | Campaign ID | STRING |
date | Date | STRING |
month | Year Month | STRING |
year | Yearformula | STRING |
quarter | Quarterformula | STRING |
dataFreshness | Data Freshness | STRING |
isInterpolated | PMA Is Interpolated? | BOOLEAN |
| Field name | Label | Type |
|---|---|---|
all_conversions | All Conversions | NUMBER |
all_conversions_value | All Conversions Value | NUMBER |
clicks | Clicks | NUMBER |
conversions | Conversions | NUMBER |
conversions_value | Conversions Value | NUMBER |
cost | Cost | NUMBER |
impressions | Impressions | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Account Name | STRING |
account_id | Account ID | STRING |
asset_id | Asset ID | STRING |
date | Date | STRING |
month | Year Month | STRING |
week | Weekformula | STRING |
year | Yearformula | STRING |
dataFreshness | Data Freshness | STRING |
isInterpolated | PMA Is Interpolated? | BOOLEAN |
| Field name | Label | Type |
|---|---|---|
CTR | CTRformula | NUMBER |
avg_cpc | Avg. CPCformula | NUMBER |
avg_cpm | Avg. CPMformula | NUMBER |
avg_cpv | Avg. CPVformula | NUMBER |
cost_per_conv | Cost/Conv.formula | NUMBER |
all_conversions | All Conversions | NUMBER |
clicks | Clicks | NUMBER |
conversions | Conversions | NUMBER |
conversions_value | Conversions Value | NUMBER |
cost | Cost | NUMBER |
impressions | Impressions | NUMBER |
video_views | Video Views | NUMBER |
video_quartile_p25_rate | Video Quartile P25 Rate | NUMBER |
video_quartile_p50_rate | Video Quartile P50 Rate | NUMBER |
video_quartile_p75_rate | Video Quartile P75 Rate | NUMBER |
video_quartile_p100_rate | Video Quartile P100 Rate | NUMBER |
view_through_conversions | View Through Conversions | NUMBER |
engagements | Engagements | NUMBER |
interactions | Interactions | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Account Name | STRING |
account_id | Account ID | STRING |
ad_group_id | Ad group ID | STRING |
ad_id | Ad ID | STRING |
campaign_id | Campaign ID | STRING |
adNetworkType | Network | STRING |
device | Device | STRING |
date | Date | STRING |
month | Year Month | STRING |
conversionActionCategory | Conversion Category | STRING |
conversionActionName | Conversion Action | STRING |
| Field name | Label | Type |
|---|---|---|
CTR | CTRformula | NUMBER |
avg_cpc | Avg. CPCformula | NUMBER |
cost_per_conv | Cost/Conv.formula | NUMBER |
clicks | Clicks | NUMBER |
conversions | Conversions | NUMBER |
conversions_value | Conversions Value | NUMBER |
cost | Cost | NUMBER |
impressions | Impressions | NUMBER |
historical_quality_score | Historical Quality Score | NUMBER |
firstPageCpc | First Page CPC | NUMBER |
firstPositionCpc | First Position CPC | NUMBER |
search_impression_share | Search Impr. Share | NUMBER |
view_through_conversions | View Through Conversions | NUMBER |
video_views | Video Views | NUMBER |
cross_device_conversions | Cross Device Conversions | NUMBER |
engagements | Engagements | NUMBER |
| Field name | Label | Type |
|---|---|---|
keyword | Keyword | STRING |
keyword_id | Keyword ID | STRING |
keyword_matchType | Keyword Match Type | STRING |
adGroupCriterionStatus | Keyword Status | STRING |
approvalStatus | Approval Status | STRING |
servingStatus | Serving Status | STRING |
labels | Labels | STRING |
ad_group_id | Ad group ID | STRING |
campaign_id | Campaign ID | STRING |
date | Date | STRING |
month | Year Month | STRING |
| Field name | Label | Type |
|---|---|---|
CTR | CTRformula | NUMBER |
avg_cpc | Avg. CPCformula | NUMBER |
cost_per_conv | Cost/Conv.formula | NUMBER |
clicks | Clicks | NUMBER |
conversions | Conversions | NUMBER |
conversions_value | Conversions Value | NUMBER |
cost | Cost | NUMBER |
impressions | Impressions | NUMBER |
all_conversions | All Conversions | NUMBER |
cross_device_conversions | Cross Device Conversions | NUMBER |
view_through_conversions | View Through Conversions | NUMBER |
video_views | Video Views | NUMBER |
engagements | Engagements | NUMBER |
interactions | Interactions | NUMBER |
| Field name | Label | Type |
|---|---|---|
search_term | Search term | STRING |
search_term_match_type | Search Term Match Type | STRING |
status | Search term status | STRING |
keyword | Keyword | STRING |
keyword_matchType | Keyword Match Type | STRING |
ad_group_id | Ad group ID | STRING |
campaign_id | Campaign ID | STRING |
date | Date | STRING |
month | Year Month | STRING |
| Field name | Label | Type |
|---|---|---|
all_conversions | All Conversions | NUMBER |
clicks | Clicks | NUMBER |
conversions | Conversions | NUMBER |
conversions_value | Conversions Value | NUMBER |
cost | Cost | NUMBER |
impressions | Impressions | NUMBER |
engagements | Engagements | NUMBER |
interactions | Interactions | NUMBER |
video_views | Video Views | NUMBER |
video_quartile_p25_rate | Video Quartile P25 Rate | NUMBER |
video_quartile_p100_rate | Video Quartile P100 Rate | NUMBER |
view_through_conversions | View Through Conversions | NUMBER |
cross_device_conversions | Cross Device Conversions | NUMBER |
| Field name | Label | Type |
|---|---|---|
target_url | Placement URL | STRING |
placement_type | Placement Type | STRING |
group_placement_target_url | Group Placement Target | STRING |
ad_group_id | Ad group ID | STRING |
campaign_id | Campaign ID | STRING |
date | Date | STRING |
month | Year Month | STRING |
| Field name | Label | Type |
|---|---|---|
country | Country | STRING |
countryCode | Country Code | STRING |
country_id | Country ID | NUMBER |
configName | Account Name | STRING |
dataFreshness | Data Freshness | STRING |
| Field name | Label | Type |
|---|---|---|
region | Region | STRING |
region_id | Region ID | NUMBER |
countryCode | Country Code | STRING |
configName | Account Name | STRING |
dataFreshness | Data Freshness | STRING |
| Field name | Label | Type |
|---|---|---|
city | City | STRING |
city_id | City ID | NUMBER |
countryCode | Country Code | STRING |
configName | Account Name | STRING |
dataFreshness | Data Freshness | STRING |
| Field name | Label | Type |
|---|---|---|
targetCPA | Target CPA | NUMBER |
targetROAS | Target ROAS | NUMBER |
| Field name | Label | Type |
|---|---|---|
campaign_id | Campaign ID | STRING |
campaign_name | Campaign Name | STRING |
campaign_status | Campaign Status | STRING |
advertisingChannelType | Campaign type | STRING |
bidingStrategyType | Bidding Strategy Type | STRING |
budget | Budget | NUMBER |
optimizationScore | Optimization Score | NUMBER |
campaignLabels | Campaign Labels | STRING |
labels | Labels | STRING |
servingStatus | Serving Status | STRING |
| Field name | Label | Type |
|---|---|---|
ad_group_id | Ad group ID | STRING |
adgroup_name | Ad group name | STRING |
adgroup_status | Ad group status | STRING |
adgroup_type | Ad group type | STRING |
adRotationMode | Ad rotation | STRING |
adGroupLabels | Ad group labels | STRING |
campaign_id | Campaign ID | STRING |
utm_campaign | UTM Campaign | STRING |
utm_medium | UTM Medium | STRING |
utm_source | UTM Source | STRING |
utm_content | UTM Content | STRING |
utm_term | UTM Term | STRING |
| Field name | Label | Type |
|---|---|---|
ad_id | Ad ID | STRING |
ad_name | Ad Name | STRING |
ad_status | Ad status | STRING |
ad_type | Ad type | STRING |
adStrength | Ad strength | STRING |
approvalStatus | Approval Status | STRING |
headline1 | Headline 1 | STRING |
headline2 | Headline 2 | STRING |
description1 | Description 1 | STRING |
description2 | Description 2 | STRING |
displayUrl | Display URL | STRING |
finalUrl | Final URL | STRING |
adLabels | Ad Labels | STRING |
ad_group_id | Ad group ID | STRING |
campaign_id | Campaign ID | STRING |
unified_image | Imageformula | STRING |
| Field name | Label | Type |
|---|---|---|
asset_id | Asset ID | STRING |
asset_name | Asset Name | STRING |
asset_type | Asset Type | STRING |
headline | Headline | STRING |
description | Description | STRING |
description1 | Description 1 | STRING |
description2 | Description 2 | STRING |
callout_text | Callout Text | STRING |
business_name | Business Name | STRING |
header | Header | STRING |
link_text | Link Text | STRING |
cta_type | CTA Type | STRING |
cta_description | CTA Description | STRING |
assetImageUrl | Asset Image URL | STRING |
language | Language | STRING |
app_id | App ID | STRING |
app_store | App Store | STRING |
| Field name | Label | Type |
|---|---|---|
ad_id | Ad ID | STRING |
asset_id | Asset ID | STRING |
asset_type | Asset Type | STRING |
ad_group_id | Ad group ID | STRING |
campaign_id | Campaign ID | STRING |
youtubeImageUrl | YouTube image URL | STRING |
dataFreshness | Data Freshness | STRING |
| Field name | Label | Type |
|---|---|---|
CTR | CTRformula | NUMBER |
avg_cpc | Avg. CPCformula | NUMBER |
cost_per_conv | Cost/Conv.formula | NUMBER |
value_per_conv | Value/Conv.formula | NUMBER |
absolute_top_impression_percentage | Absolute Top Impression Percentage | NUMBER |
all_conversions | All Conversions | NUMBER |
clicks | Clicks | NUMBER |
conversions | Conversions | NUMBER |
conversions_value | Conversions Value | NUMBER |
cost | Cost | NUMBER |
impressions | Impressions | NUMBER |
top_impression_percentage | Top Impression Percentage | NUMBER |
video_views | Video Views | NUMBER |
view_through_conversions | View Through Conversions | NUMBER |
engagements | Engagements | NUMBER |
| Field name | Label | Type |
|---|---|---|
country_id | Country ID | NUMBER |
region_id | Region ID | NUMBER |
city_id | City ID | NUMBER |
type | Type | STRING |
campaign_id | Campaign ID | STRING |
date | Date | STRING |
month | Year Month | STRING |
| Field name | Label | Type |
|---|---|---|
postal_code | Postal Code | STRING |
postal_code_id | Postal Code ID | NUMBER |
countryCode | Country Code | STRING |
configName | Account Name | STRING |
| Field name | Label | Type |
|---|---|---|
all_conversions | All Conversions | NUMBER |
clicks | Clicks | NUMBER |
conversions | Conversions | NUMBER |
conversions_value | Conversions Value | NUMBER |
cost | Cost | NUMBER |
impressions | Impressions | NUMBER |
video_views | Video Views | NUMBER |
video_quartile_p25_rate | Video Quartile P25 Rate | NUMBER |
video_quartile_p50_rate | Video Quartile P50 Rate | NUMBER |
video_quartile_p75_rate | Video Quartile P75 Rate | NUMBER |
video_quartile_p100_rate | Video Quartile P100 Rate | NUMBER |
view_through_conversions | View Through Conversions | NUMBER |
engagements | Engagements | NUMBER |
gmail_forwards | Gmail Forwards | NUMBER |
gmail_saves | Gmail Saves | NUMBER |
| Field name | Label | Type |
|---|---|---|
age | Age | STRING |
ad_group_id | Ad group ID | STRING |
campaign_id | Campaign ID | STRING |
date | Date | STRING |
month | Year Month | STRING |
| Field name | Label | Type |
|---|---|---|
all_conversions | All Conversions | NUMBER |
clicks | Clicks | NUMBER |
conversions | Conversions | NUMBER |
conversions_value | Conversions Value | NUMBER |
cost | Cost | NUMBER |
impressions | Impressions | NUMBER |
video_views | Video Views | NUMBER |
video_quartile_p100_rate | Video Quartile P100 Rate | NUMBER |
view_through_conversions | View Through Conversions | NUMBER |
engagements | Engagements | NUMBER |
| Field name | Label | Type |
|---|---|---|
gender | Gender | STRING |
ad_group_id | Ad group ID | STRING |
campaign_id | Campaign ID | STRING |
date | Date | STRING |
month | Year Month | STRING |
| Field name | Label | Type |
|---|---|---|
avg_cpc | Avg. CPCformula | NUMBER |
cost_per_conv | Cost/Conv.formula | NUMBER |
all_conversions | All Conversions | NUMBER |
clicks | Clicks | NUMBER |
conversions | Conversions | NUMBER |
conversions_value | Conversions Value | NUMBER |
cost | Cost | NUMBER |
impressions | Impressions | NUMBER |
search_absolute_top_impression_share | Search abs. top IS | NUMBER |
search_impression_share | Search Impr. Share | NUMBER |
search_click_share | Click Share | NUMBER |
cross_device_conversions | Cross Device Conversions | NUMBER |
product_country | Product Country | NUMBER |
| Field name | Label | Type |
|---|---|---|
product_title | Product Title | STRING |
product_item_id | Product Item ID | STRING |
product_brand | Product Brand | STRING |
product_type_l1 | Product Type L1 | STRING |
product_type_l2 | Product Type L2 | STRING |
product_channel | Product Channel | STRING |
product_condition | Product Condition | STRING |
product_language | Product Language | STRING |
product_merchant_id | Product Merchant ID | STRING |
click_type | Click Type | STRING |
device | Device | STRING |
campaign_id | Campaign ID | STRING |
ad_group_id | Ad group ID | STRING |
date | Date | STRING |
month | Year Month | STRING |
| Field name | Label | Type |
|---|---|---|
lead_id | Lead ID | STRING |
lead_type | Lead Type | STRING |
lead_status | Lead Status | STRING |
lead_charged_status | Lead Charged Status | STRING |
consumer_name | Consumer Name | STRING |
phone_number | Phone Number | STRING |
business_category | Business Category | STRING |
service_type | Service Type | STRING |
date | Date | STRING |
month | Year Month | STRING |
account_id | Account ID | STRING |
| Field name | Label | Type |
|---|---|---|
recommendation_type | Recommendation Type | STRING |
current_budget_amount | Current Budget Amount | STRING |
recommended_budget_amount | Recommended Budget Amount | STRING |
campaign_id | Campaign ID | STRING |
account_id | Account ID | STRING |
dataFreshness | Data Freshness | STRING |
Tools across mechanic-mcp-server, hedgehog-ads-writer, hedgehog-campaign-builder, and hedgehog-report-engine. Native MCP is the primary tool for live analysis and all write operations.
| Tool | Data points / capability |
|---|---|
campaign_performance | Clicks, impressions, cost, conversions, ROAS, CPC, CTR — live, by campaign. |
ad_group_performance | Ad group-level performance metrics with date range flexibility. |
keyword_performance | Keyword-level stats including quality score, match type, first-page CPC estimates. |
ad_performance | Ad-level metrics: impressions, clicks, conversions, ad strength. |
analyze_search_terms | Search term report with match analysis — identifies negative keyword opportunities. Not available in PMA. |
auction_insights | Overlap rate, outranking share, impression share vs competitors. Not available in PMA. |
impression_share_data | Search IS, Display IS, lost IS (budget vs rank) by campaign. |
conversion_action_performance | Breakdown by individual conversion action type and value. |
change_history | Recent account changes: bids, budgets, status, ad edits — with timestamp and editor. Not available in PMA. |
recommendations | Live Google Ads recommendations with impact estimates. |
performance_by_location | Location-segmented performance data. |
performance_by_device | Desktop, mobile, tablet split. |
performance_by_hour | Hourly segmented performance for bid scheduling decisions. |
performance_by_day_of_week | Day-of-week performance patterns. |
age_gender_performance | Demographic breakdown with conversion data. |
asset_performance | Asset-level performance ratings (Best, Good, Low) for RSAs and PMax. |
pmax_asset_group_performance | Performance Max asset group breakdown — not segmentable in PMA. |
adjust_campaign_budget WRITE | Updates daily or shared budget on a live campaign. |
change_keyword_bid WRITE | Sets CPC bid on a specific keyword. |
add_keywords WRITE | Adds new keywords to an ad group. |
add_negative_keywords WRITE | Adds negative keywords at campaign or ad group level. |
create_rsa_ad WRITE | Creates a new Responsive Search Ad with up to 15 headlines and 4 descriptions. |
set_campaign_status WRITE | Enables or pauses a campaign. |
generate_campaign_plan / execute_campaign_plan | Builds full campaign structures (campaigns, ad groups, keywords, ads) from a brief, then executes in paused state. |