PMA vs native MCPs / Google Ads
Paid advertising · data points

Google Ads

Full field catalogue across 22 PMA report types, plus native MCP tools for live optimisation, search term analysis, and write operations.

PMA: google_ads Native MCP: Strong 2 accounts connected 22 report types
In PMA

Historical warehouse for blending

  • 22 report types covering campaigns, ad groups, keywords, search terms, placements, geo, age, gender, shopping, and asset dimensions
  • Long-run historical depth — query any date range without API sampling constraints
  • Cross-channel SQL blending: join Google Ads spend against GA4 conversions or Meta in one query
  • Shopping-specific dimensions: product brand, category L1–L5, custom labels, channel, merchant ID
  • Local Services Ads lead data: lead ID, type, status, charged status, consumer name
Native MCP

Live data, insights, and write operations

  • Search terms, auction insights, and quality score — not available in PMA
  • Change history log for auditing recent account modifications
  • Write operations: adjust budgets, change keyword bids, add/pause keywords, update RSA copy, set campaign status
  • Performance Max asset group breakdown and pMax-specific reporting
  • Real-time recommendations from the Google Ads API
PMA field catalogue

Every queryable field in PMA

Grouped by report type. Filter to find a field fast. formula fields are computed — use their component fields in SQL.

Campaigns insights

report_type: campaigns_insights · 64 metrics · 29 dimensions · showing 50 of 64 metrics and 20 of 29 dimensions retrievable via API
Metrics
Field nameLabelType
CTRCTRformulaNUMBER
conv_rateConv. RateformulaNUMBER
interaction_rateInteraction RateformulaNUMBER
engagement_rateEngagement RateformulaNUMBER
view_rateView RateformulaNUMBER
all_conv_rateAll Conv. RateformulaNUMBER
avg_cpcAvg. CPCformulaNUMBER
avg_cpmAvg. CPMformulaNUMBER
avg_cpvAvg. CPVformulaNUMBER
cost_per_convCost/Conv.formulaNUMBER
cost_per_all_convCost/All Conv.formulaNUMBER
conv_value_per_costConv. Value/CostformulaNUMBER
value_per_convValue/Conv.formulaNUMBER
store_visitsStore VisitsformulaNUMBER
all_conversionsAll ConversionsNUMBER
all_conversions_valueAll Conversions ValueNUMBER
clicksClicksNUMBER
conversionsConversionsNUMBER
conversions_by_conversion_dateConversions By Conversion DateNUMBER
conversions_valueConversions ValueNUMBER
conversions_value_by_conversion_dateConversions Value By Conversion DateNUMBER
costCostNUMBER
cross_device_conversionsCross Device ConversionsNUMBER
current_model_attributed_conversionsCurrent Model Attributed ConversionsNUMBER
engagementsEngagementsNUMBER
impressionsImpressionsNUMBER
interactionsInteractionsNUMBER
phone_callsPhone CallsNUMBER
search_absolute_top_impression_shareSearch abs. top ISNUMBER
search_budget_lost_impression_shareSearch Lost IS (budget)NUMBER
search_click_shareClick ShareNUMBER
bounce_rateBounce RateNUMBER
average_time_on_siteAverage Time On SiteNUMBER
gmail_forwardsGmail ForwardsNUMBER
gmail_savesGmail SavesNUMBER
gmail_secondary_clicksGmail Secondary ClicksNUMBER
percent_new_visitorsPercent New VisitorsNUMBER
all_conversions_from_location_asset_store_visitsAll Conversions From Location Asset Store VisitsNUMBER
Dimensions
Field nameLabelType
configNameAccount NameSTRING
account_idAccount IDSTRING
campaign_idCampaign IDSTRING
adNetworkTypeNetworkSTRING
deviceDeviceSTRING
dateDateSTRING
monthYear MonthSTRING
conversionActionCategoryConversion CategorySTRING
conversionActionNameConversion ActionSTRING
dataFreshnessData FreshnessSTRING
dataSourceData SourceSTRING
MinDatePMA Minimum Cached Data DateSTRING
MaxDatePMA Maximum Cached Data DateSTRING
isInterpolatedPMA Is Interpolated?BOOLEAN

Ad groups insights

report_type: ad_groups_insights · 59 metrics · 26 dimensions · showing 50 of 59 metrics and 20 of 26 dimensions retrievable via API
Metrics
Field nameLabelType
CTRCTRformulaNUMBER
conv_rateConv. RateformulaNUMBER
avg_cpcAvg. CPCformulaNUMBER
avg_cpmAvg. CPMformulaNUMBER
cost_per_convCost/Conv.formulaNUMBER
all_conversionsAll ConversionsNUMBER
clicksClicksNUMBER
conversionsConversionsNUMBER
conversions_valueConversions ValueNUMBER
costCostNUMBER
impressionsImpressionsNUMBER
phone_callsPhone CallsNUMBER
phone_impressionsPhone ImpressionsNUMBER
search_impression_shareSearch Impr. ShareNUMBER
search_exact_match_impression_shareSearch Exact Match ISNUMBER
search_rank_lost_absolute_top_impression_shareSearch lost abs. top IS (rank)NUMBER
engagementsEngagementsNUMBER
interactionsInteractionsNUMBER
cross_device_conversionsCross Device ConversionsNUMBER
Dimensions
Field nameLabelType
configNameAccount NameSTRING
account_idAccount IDSTRING
ad_group_idAd group IDSTRING
campaign_idCampaign IDSTRING
dateDateSTRING
monthYear MonthSTRING
yearYearformulaSTRING
quarterQuarterformulaSTRING
dataFreshnessData FreshnessSTRING
isInterpolatedPMA Is Interpolated?BOOLEAN

Account assets

report_type: account_assets · 7 metrics · 25 dimensions
Metrics
Field nameLabelType
all_conversionsAll ConversionsNUMBER
all_conversions_valueAll Conversions ValueNUMBER
clicksClicksNUMBER
conversionsConversionsNUMBER
conversions_valueConversions ValueNUMBER
costCostNUMBER
impressionsImpressionsNUMBER
Dimensions
Field nameLabelType
configNameAccount NameSTRING
account_idAccount IDSTRING
asset_idAsset IDSTRING
dateDateSTRING
monthYear MonthSTRING
weekWeekformulaSTRING
yearYearformulaSTRING
dataFreshnessData FreshnessSTRING
isInterpolatedPMA Is Interpolated?BOOLEAN

Insights (all-level)

report_type: insights · 48 metrics · 31 dimensions · showing 48 of 48 metrics and 20 of 31 dimensions retrievable via API
Metrics
Field nameLabelType
CTRCTRformulaNUMBER
avg_cpcAvg. CPCformulaNUMBER
avg_cpmAvg. CPMformulaNUMBER
avg_cpvAvg. CPVformulaNUMBER
cost_per_convCost/Conv.formulaNUMBER
all_conversionsAll ConversionsNUMBER
clicksClicksNUMBER
conversionsConversionsNUMBER
conversions_valueConversions ValueNUMBER
costCostNUMBER
impressionsImpressionsNUMBER
video_viewsVideo ViewsNUMBER
video_quartile_p25_rateVideo Quartile P25 RateNUMBER
video_quartile_p50_rateVideo Quartile P50 RateNUMBER
video_quartile_p75_rateVideo Quartile P75 RateNUMBER
video_quartile_p100_rateVideo Quartile P100 RateNUMBER
view_through_conversionsView Through ConversionsNUMBER
engagementsEngagementsNUMBER
interactionsInteractionsNUMBER
Dimensions
Field nameLabelType
configNameAccount NameSTRING
account_idAccount IDSTRING
ad_group_idAd group IDSTRING
ad_idAd IDSTRING
campaign_idCampaign IDSTRING
adNetworkTypeNetworkSTRING
deviceDeviceSTRING
dateDateSTRING
monthYear MonthSTRING
conversionActionCategoryConversion CategorySTRING
conversionActionNameConversion ActionSTRING

Keywords

report_type: keywords · 45 metrics · 33 dimensions · showing 45 of 45 metrics and 20 of 33 dimensions retrievable via API
Metrics
Field nameLabelType
CTRCTRformulaNUMBER
avg_cpcAvg. CPCformulaNUMBER
cost_per_convCost/Conv.formulaNUMBER
clicksClicksNUMBER
conversionsConversionsNUMBER
conversions_valueConversions ValueNUMBER
costCostNUMBER
impressionsImpressionsNUMBER
historical_quality_scoreHistorical Quality ScoreNUMBER
firstPageCpcFirst Page CPCNUMBER
firstPositionCpcFirst Position CPCNUMBER
search_impression_shareSearch Impr. ShareNUMBER
view_through_conversionsView Through ConversionsNUMBER
video_viewsVideo ViewsNUMBER
cross_device_conversionsCross Device ConversionsNUMBER
engagementsEngagementsNUMBER
Dimensions
Field nameLabelType
keywordKeywordSTRING
keyword_idKeyword IDSTRING
keyword_matchTypeKeyword Match TypeSTRING
adGroupCriterionStatusKeyword StatusSTRING
approvalStatusApproval StatusSTRING
servingStatusServing StatusSTRING
labelsLabelsSTRING
ad_group_idAd group IDSTRING
campaign_idCampaign IDSTRING
dateDateSTRING
monthYear MonthSTRING

Search terms

report_type: search · 34 metrics · 31 dimensions · showing 34 of 34 metrics and 20 of 31 dimensions retrievable via API
Metrics
Field nameLabelType
CTRCTRformulaNUMBER
avg_cpcAvg. CPCformulaNUMBER
cost_per_convCost/Conv.formulaNUMBER
clicksClicksNUMBER
conversionsConversionsNUMBER
conversions_valueConversions ValueNUMBER
costCostNUMBER
impressionsImpressionsNUMBER
all_conversionsAll ConversionsNUMBER
cross_device_conversionsCross Device ConversionsNUMBER
view_through_conversionsView Through ConversionsNUMBER
video_viewsVideo ViewsNUMBER
engagementsEngagementsNUMBER
interactionsInteractionsNUMBER
Dimensions
Field nameLabelType
search_termSearch termSTRING
search_term_match_typeSearch Term Match TypeSTRING
statusSearch term statusSTRING
keywordKeywordSTRING
keyword_matchTypeKeyword Match TypeSTRING
ad_group_idAd group IDSTRING
campaign_idCampaign IDSTRING
dateDateSTRING
monthYear MonthSTRING

Placements

report_type: placements · 16 metrics · 29 dimensions · showing 16 of 16 metrics and 20 of 29 dimensions retrievable via API
Metrics
Field nameLabelType
all_conversionsAll ConversionsNUMBER
clicksClicksNUMBER
conversionsConversionsNUMBER
conversions_valueConversions ValueNUMBER
costCostNUMBER
impressionsImpressionsNUMBER
engagementsEngagementsNUMBER
interactionsInteractionsNUMBER
video_viewsVideo ViewsNUMBER
video_quartile_p25_rateVideo Quartile P25 RateNUMBER
video_quartile_p100_rateVideo Quartile P100 RateNUMBER
view_through_conversionsView Through ConversionsNUMBER
cross_device_conversionsCross Device ConversionsNUMBER
Dimensions
Field nameLabelType
target_urlPlacement URLSTRING
placement_typePlacement TypeSTRING
group_placement_target_urlGroup Placement TargetSTRING
ad_group_idAd group IDSTRING
campaign_idCampaign IDSTRING
dateDateSTRING
monthYear MonthSTRING

Geo targets — country

report_type: geotargets_country · 0 metrics · 14 dimensions
Dimensions
Field nameLabelType
countryCountrySTRING
countryCodeCountry CodeSTRING
country_idCountry IDNUMBER
configNameAccount NameSTRING
dataFreshnessData FreshnessSTRING

Geo targets — region

report_type: geotargets_region · 0 metrics · 14 dimensions
Dimensions
Field nameLabelType
regionRegionSTRING
region_idRegion IDNUMBER
countryCodeCountry CodeSTRING
configNameAccount NameSTRING
dataFreshnessData FreshnessSTRING

Geo targets — city

report_type: geotargets_city · 0 metrics · 14 dimensions
Dimensions
Field nameLabelType
cityCitySTRING
city_idCity IDNUMBER
countryCodeCountry CodeSTRING
configNameAccount NameSTRING
dataFreshnessData FreshnessSTRING

Campaigns dimensions

report_type: campaigns_dimensions · 2 metrics · 23 dimensions · showing 2 of 2 metrics and 20 of 23 dimensions retrievable via API
Metrics
Field nameLabelType
targetCPATarget CPANUMBER
targetROASTarget ROASNUMBER
Dimensions
Field nameLabelType
campaign_idCampaign IDSTRING
campaign_nameCampaign NameSTRING
campaign_statusCampaign StatusSTRING
advertisingChannelTypeCampaign typeSTRING
bidingStrategyTypeBidding Strategy TypeSTRING
budgetBudgetNUMBER
optimizationScoreOptimization ScoreNUMBER
campaignLabelsCampaign LabelsSTRING
labelsLabelsSTRING
servingStatusServing StatusSTRING

Ad groups dimensions

report_type: ad_groups_dimensions · 0 metrics · 26 dimensions · showing 0 of 0 metrics and 20 of 26 dimensions retrievable via API
Dimensions
Field nameLabelType
ad_group_idAd group IDSTRING
adgroup_nameAd group nameSTRING
adgroup_statusAd group statusSTRING
adgroup_typeAd group typeSTRING
adRotationModeAd rotationSTRING
adGroupLabelsAd group labelsSTRING
campaign_idCampaign IDSTRING
utm_campaignUTM CampaignSTRING
utm_mediumUTM MediumSTRING
utm_sourceUTM SourceSTRING
utm_contentUTM ContentSTRING
utm_termUTM TermSTRING

Ads dimensions

report_type: ads_dimensions · 0 metrics · 39 dimensions · showing 20 of 39 dimensions retrievable via API
Dimensions
Field nameLabelType
ad_idAd IDSTRING
ad_nameAd NameSTRING
ad_statusAd statusSTRING
ad_typeAd typeSTRING
adStrengthAd strengthSTRING
approvalStatusApproval StatusSTRING
headline1Headline 1STRING
headline2Headline 2STRING
description1Description 1STRING
description2Description 2STRING
displayUrlDisplay URLSTRING
finalUrlFinal URLSTRING
adLabelsAd LabelsSTRING
ad_group_idAd group IDSTRING
campaign_idCampaign IDSTRING
unified_imageImageformulaSTRING

Assets

report_type: assets · 0 metrics · 33 dimensions · showing 20 of 33 dimensions retrievable via API
Dimensions
Field nameLabelType
asset_idAsset IDSTRING
asset_nameAsset NameSTRING
asset_typeAsset TypeSTRING
headlineHeadlineSTRING
descriptionDescriptionSTRING
description1Description 1STRING
description2Description 2STRING
callout_textCallout TextSTRING
business_nameBusiness NameSTRING
headerHeaderSTRING
link_textLink TextSTRING
cta_typeCTA TypeSTRING
cta_descriptionCTA DescriptionSTRING
assetImageUrlAsset Image URLSTRING
languageLanguageSTRING
app_idApp IDSTRING
app_storeApp StoreSTRING

Ad asset dimensions

report_type: ad_asset_dimensions · 0 metrics · 19 dimensions
Dimensions
Field nameLabelType
ad_idAd IDSTRING
asset_idAsset IDSTRING
asset_typeAsset TypeSTRING
ad_group_idAd group IDSTRING
campaign_idCampaign IDSTRING
youtubeImageUrlYouTube image URLSTRING
dataFreshnessData FreshnessSTRING

Geo (performance)

report_type: geo · 26 metrics · 29 dimensions · showing 26 of 26 metrics and 20 of 29 dimensions retrievable via API
Metrics
Field nameLabelType
CTRCTRformulaNUMBER
avg_cpcAvg. CPCformulaNUMBER
cost_per_convCost/Conv.formulaNUMBER
value_per_convValue/Conv.formulaNUMBER
absolute_top_impression_percentageAbsolute Top Impression PercentageNUMBER
all_conversionsAll ConversionsNUMBER
clicksClicksNUMBER
conversionsConversionsNUMBER
conversions_valueConversions ValueNUMBER
costCostNUMBER
impressionsImpressionsNUMBER
top_impression_percentageTop Impression PercentageNUMBER
video_viewsVideo ViewsNUMBER
view_through_conversionsView Through ConversionsNUMBER
engagementsEngagementsNUMBER
Dimensions
Field nameLabelType
country_idCountry IDNUMBER
region_idRegion IDNUMBER
city_idCity IDNUMBER
typeTypeSTRING
campaign_idCampaign IDSTRING
dateDateSTRING
monthYear MonthSTRING

Geo targets — postal code

report_type: geotargets_postal_code · 0 metrics · 14 dimensions
Dimensions
Field nameLabelType
postal_codePostal CodeSTRING
postal_code_idPostal Code IDNUMBER
countryCodeCountry CodeSTRING
configNameAccount NameSTRING

Age

report_type: age · 19 metrics · 27 dimensions · showing 19 of 19 metrics and 20 of 27 dimensions retrievable via API
Metrics
Field nameLabelType
all_conversionsAll ConversionsNUMBER
clicksClicksNUMBER
conversionsConversionsNUMBER
conversions_valueConversions ValueNUMBER
costCostNUMBER
impressionsImpressionsNUMBER
video_viewsVideo ViewsNUMBER
video_quartile_p25_rateVideo Quartile P25 RateNUMBER
video_quartile_p50_rateVideo Quartile P50 RateNUMBER
video_quartile_p75_rateVideo Quartile P75 RateNUMBER
video_quartile_p100_rateVideo Quartile P100 RateNUMBER
view_through_conversionsView Through ConversionsNUMBER
engagementsEngagementsNUMBER
gmail_forwardsGmail ForwardsNUMBER
gmail_savesGmail SavesNUMBER
Dimensions
Field nameLabelType
ageAgeSTRING
ad_group_idAd group IDSTRING
campaign_idCampaign IDSTRING
dateDateSTRING
monthYear MonthSTRING

Gender

report_type: gender · 19 metrics · 27 dimensions · showing 19 of 19 metrics and 20 of 27 dimensions retrievable via API
Metrics
Field nameLabelType
all_conversionsAll ConversionsNUMBER
clicksClicksNUMBER
conversionsConversionsNUMBER
conversions_valueConversions ValueNUMBER
costCostNUMBER
impressionsImpressionsNUMBER
video_viewsVideo ViewsNUMBER
video_quartile_p100_rateVideo Quartile P100 RateNUMBER
view_through_conversionsView Through ConversionsNUMBER
engagementsEngagementsNUMBER
Dimensions
Field nameLabelType
genderGenderSTRING
ad_group_idAd group IDSTRING
campaign_idCampaign IDSTRING
dateDateSTRING
monthYear MonthSTRING

Shopping

report_type: shopping · 15 metrics · 42 dimensions · showing 15 of 15 metrics and 20 of 42 dimensions retrievable via API
Metrics
Field nameLabelType
avg_cpcAvg. CPCformulaNUMBER
cost_per_convCost/Conv.formulaNUMBER
all_conversionsAll ConversionsNUMBER
clicksClicksNUMBER
conversionsConversionsNUMBER
conversions_valueConversions ValueNUMBER
costCostNUMBER
impressionsImpressionsNUMBER
search_absolute_top_impression_shareSearch abs. top ISNUMBER
search_impression_shareSearch Impr. ShareNUMBER
search_click_shareClick ShareNUMBER
cross_device_conversionsCross Device ConversionsNUMBER
product_countryProduct CountryNUMBER
Dimensions
Field nameLabelType
product_titleProduct TitleSTRING
product_item_idProduct Item IDSTRING
product_brandProduct BrandSTRING
product_type_l1Product Type L1STRING
product_type_l2Product Type L2STRING
product_channelProduct ChannelSTRING
product_conditionProduct ConditionSTRING
product_languageProduct LanguageSTRING
product_merchant_idProduct Merchant IDSTRING
click_typeClick TypeSTRING
deviceDeviceSTRING
campaign_idCampaign IDSTRING
ad_group_idAd group IDSTRING
dateDateSTRING
monthYear MonthSTRING

Local Services leads

report_type: local_service_leads · 0 metrics · 32 dimensions · showing 20 of 32 dimensions retrievable via API
Dimensions
Field nameLabelType
lead_idLead IDSTRING
lead_typeLead TypeSTRING
lead_statusLead StatusSTRING
lead_charged_statusLead Charged StatusSTRING
consumer_nameConsumer NameSTRING
phone_numberPhone NumberSTRING
business_categoryBusiness CategorySTRING
service_typeService TypeSTRING
dateDateSTRING
monthYear MonthSTRING
account_idAccount IDSTRING

Recommendations

report_type: recommendations · 0 metrics · 17 dimensions
Dimensions
Field nameLabelType
recommendation_typeRecommendation TypeSTRING
current_budget_amountCurrent Budget AmountSTRING
recommended_budget_amountRecommended Budget AmountSTRING
campaign_idCampaign IDSTRING
account_idAccount IDSTRING
dataFreshnessData FreshnessSTRING
Native MCP

What the native MCP adds

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.

ToolData points / capability
campaign_performanceClicks, impressions, cost, conversions, ROAS, CPC, CTR — live, by campaign.
ad_group_performanceAd group-level performance metrics with date range flexibility.
keyword_performanceKeyword-level stats including quality score, match type, first-page CPC estimates.
ad_performanceAd-level metrics: impressions, clicks, conversions, ad strength.
analyze_search_termsSearch term report with match analysis — identifies negative keyword opportunities. Not available in PMA.
auction_insightsOverlap rate, outranking share, impression share vs competitors. Not available in PMA.
impression_share_dataSearch IS, Display IS, lost IS (budget vs rank) by campaign.
conversion_action_performanceBreakdown by individual conversion action type and value.
change_historyRecent account changes: bids, budgets, status, ad edits — with timestamp and editor. Not available in PMA.
recommendationsLive Google Ads recommendations with impact estimates.
performance_by_locationLocation-segmented performance data.
performance_by_deviceDesktop, mobile, tablet split.
performance_by_hourHourly segmented performance for bid scheduling decisions.
performance_by_day_of_weekDay-of-week performance patterns.
age_gender_performanceDemographic breakdown with conversion data.
asset_performanceAsset-level performance ratings (Best, Good, Low) for RSAs and PMax.
pmax_asset_group_performancePerformance Max asset group breakdown — not segmentable in PMA.
adjust_campaign_budget WRITEUpdates daily or shared budget on a live campaign.
change_keyword_bid WRITESets CPC bid on a specific keyword.
add_keywords WRITEAdds new keywords to an ad group.
add_negative_keywords WRITEAdds negative keywords at campaign or ad group level.
create_rsa_ad WRITECreates a new Responsive Search Ad with up to 15 headlines and 4 descriptions.
set_campaign_status WRITEEnables or pauses a campaign.
generate_campaign_plan / execute_campaign_planBuilds full campaign structures (campaigns, ad groups, keywords, ads) from a brief, then executes in paused state.