A side-by-side of every platform connected in Power My Analytics against our own Hedgehog and Mechanic MCP servers — what each can pull, where they overlap, and which to reach for. Drill into any platform for its full field catalogue.
PMA is a read-only reporting warehouse with broad platform reach. Our native MCPs are live API connections — narrower, but deeper, real-time, and able to take action. The overlap is the Google stack, Meta, and organic social.
Each subpage lists every queryable PMA field grouped by report type, with a live filter, plus the native MCP data points where they exist. both systems · PMA only.
Each platform PMA syncs for us, and whether a native MCP also covers it. Full = comprehensive, Partial = some data or single-purpose, None = not available there.
| Platform | In PMA | Native MCP | Where each wins |
|---|---|---|---|
| Paid advertising | |||
| Google Adsgoogle_ads | Full | Full | Native wins. report-engine + ads-writer + mechanic MCP + campaign-builder give search terms, auction insights, quality score, change history, recommendations — plus write access to bids, budgets and campaign builds. PMA adds the historical warehouse and cross-channel blend. |
| Meta / Facebook Adsfacebook_ads | Full | Full | Tie — different strengths. hedgehog-meta-ads does management, audience research, lead retrieval, ad-library and creative fatigue/placement/demographic breakdowns. PMA has the deepest metric catalogue (589 metrics) plus pixel-event data. |
| Microsoft / Bing Adsbing | Full | None | PMA only. No native MCP for Microsoft Advertising — PMA is our sole source. |
| TikTok Adstiktok | Full | None | PMA only. Paid TikTok lives in PMA; native MCPs cover TikTok organic, not ads. |
| LinkedIn Adslinkedin_ads | Full | None | PMA only. social-insights covers the organic company page, not paid LinkedIn. |
| Web analytics & search | |||
| Google Analytics 4google_analytics4 | Full | Full | Native wins. mechanic / report-engine expose traffic, conversions, funnels, attribution comparison, landing pages and ecommerce in real time. PMA is better for blended historical trends. |
| Google Search Consolegoogle_searchconsole | Full | Full | Native wins. top queries/pages, URL inspect, coverage errors and period comparison. Semrush (third-party) adds keyword and competitor research on top. |
| Google Merchant Centergoogle_merchant | Full | None | PMA only. Product feed / shopping data has no native MCP. |
| YouTube Analyticsgoogle_youtube | Full | None | PMA only. Organic YouTube channel analytics aren't in any native MCP (mechanic's video tools cover Google Ads video, not YouTube organic). |
| Local presence | |||
| Google Business Profilegoogle_mybusiness | Partial | Full | Native wins clearly. mechanic / report-engine read performance, reviews and questions and write — create posts, reply to reviews, update business info. PMA only reads profile metrics. |
| Ecommerce | |||
| Shopifyshopify | Full | None | PMA only. Orders, revenue and product data — no native Shopify MCP (only API reference code). |
| WooCommercewoocommerce | Full | None | PMA only. Sole source for Woo store performance. |
| Email & CRM | |||
| Mailchimpmailchimp | Full | None | PMA only. Campaign and audience stats. (Our Kit MCP is a separate HH-owned platform, not these client accounts.) |
| Klaviyoklaviyo | Full | None | PMA only. Flow and campaign performance for ecommerce email. |
| ActiveCampaignactivecampaign | Full | None | PMA only. Automation and campaign metrics. |
| HubSpothubspot | Full | None | PMA only. CRM and marketing metrics — no native HubSpot MCP. |
| Organic social | |||
| Facebook Pagesfacebook_pages | Full | Full | Tie. hedgehog-social-insights gives live page and post insights; PMA holds the historical record in the blended schema. |
| Instagram Insightsfacebook_instagram | Full | Full | Tie. social-insights covers account and post insights live; PMA for trend history. |
| LinkedIn Companylinkedin_companies | Full | Full | Tie. social-insights adds follower demographics and post insights; PMA for the historical view. |
| TikTok Organictiktokorganic | Full | Full | Tie. social-insights pulls account insights and recent videos live; PMA holds the warehouse copy. |
Group the platforms and a clear pattern emerges: native is deeper on the channels we actively manage; PMA is the only door to everything else.
Both systems carry these, but the native MCPs go far deeper and add write access. Use PMA here only for blended historical trends or when you want everything in one query.
We have no native MCP for these. PMA is the single source for spend, clicks and conversions across all three paid networks.
The widest PMA-exclusive group. Store revenue, email performance and CRM data all flow through PMA and nothing else — essential for full-funnel reporting.
hedgehog-social-insights for live, current numbers; PMA for the historical record sitting alongside paid and web data in one schema.
Beyond platform reporting, our native servers do things a reporting warehouse has no concept of. None of these have a PMA equivalent.
Build and edit campaigns (Google & Meta), adjust bids and budgets, pause/enable, add keywords and negatives, update ad copy, post to GBP and reply to reviews. PMA is read-only.
hedgehog-seo-auditor runs technical audits, PageSpeed, schema, sitemaps, internal links, duplicate content and GEO readiness — a whole class of data PMA doesn't touch.
hedgehog-meta-ads estimates audience size, searches interests/behaviours/geos, retrieves actual lead-form submissions, and searches the Meta Ad Library for competitor creative.
The mechanic MCP builds Google Docs planning reports, writes to client Sheets and Drive, and assembles formatted weekly reports — output, not just input.
PMA's standard lead field only surfaces Meta's native lead actions. Custom pixel conversions — like a WhatConverts "WC Lead" event — fall through that gap, so a client can look like it has zero conversions in PMA while tracking fine. For conversion truth on managed accounts, trust the live MCP's conversion-action data over PMA's lead column.