The short answer
Both tools keep a stored copy of your marketing data and let Claude or ChatGPT read it over MCP. Power My Analytics starts from reports and BI tools, reads 85+ platforms and bills by accounts per source. DuckDive starts from the agent, reads six Google and local sources, and bills by website.
- One brand on many ad platforms fits Power My Analytics better
- Many websites on Google, Local Services Ads and local listings fit DuckDive better
- Count your own billable units both ways before you decide
Two stored-data products with different starting points
Power My Analytics began as a connector hub. It pulls ad, analytics, social and ecommerce data into its own warehouse, then feeds Data Studio, Sheets, Power BI and BigQuery. Its pricing page promises "85+ connectors, every plan" (checked November 2026). A remote MCP server now lets an assistant read that same warehouse.
DuckDive began at the other end, with the agent. You connect Claude, ChatGPT, Cursor or another MCP client, and DuckDive hands it the site's analytics and search data from Google, its Google Ads and Local Services Ads results, plus Yext listings and Local Falcon rank grids, each filed under the website it belongs to. It imports a source's history the moment you link it and keeps that copy, so a question about a whole portfolio reads rows already on hand. There is no BI export. The agent is the front door.
Where the two agree
- Stored data, not live calls. The Power My Analytics MCP page says the assistant "reads backfilled history stored by Power My Analytics." DuckDive reads its own copy too.
- OAuth, no API keys. Both work with Claude, ChatGPT and other clients that accept a remote MCP server.
Where they part
- How data is filed. Power My Analytics describes sources and the accounts inside them. DuckDive files everything under a website.
- What you pay for. A plan, then sources, then accounts per source, against a flat count of websites.
- How wide it reads. 85+ platforms against six.
- Who sets it up. You, inside the hub, against your agent, from one prompt.
None of this makes one tool better in general. Each suits a certain shape of business, and the rest of this page helps you find yours.
How each one counts what you pay for
Price tags are easy to compare; units are not. Find out what each vendor counts first, because that count is what grows when you add a site.
| Plan | Sources | Accounts included | Other allowances |
|---|---|---|---|
| Sample Data | Unlimited, sample data only | None listed | 1 admin, MCP and API access |
| Business | 5 | 5 in total; extra accounts sold (up to +5) | 2 admins, 5 GBP locations, 50 AI Insights credits |
| Grow | Unlimited | 7 per source; extra accounts sold per source | 3 admins, 10 GBP locations, Sheets and Excel |
| Pro | Unlimited | 20 per source, volume pricing beyond | Unlimited admins, 100 GBP locations |
| Custom | Unlimited | Unlimited | Hourly refreshes, dedicated warehouse options |
Source: Power My Analytics pricing page, checked November 2026.
As published there in November 2026, Business starts from $41.63 a month, Grow from $83.29 and Pro from $166.63, each billed annually. Extra Pro accounts slide from $9.95 a month each for the first 1 to 10 down to $4.95 at 61 or more ("Rate set by total quantity"). Business and Grow also carry a "Need more?" add-on control, but the page prints no per-account rate for either. Exports and hourly refreshes are paid add-ons below Custom, and paid plans carry a 14-day trial with no card.
- Source (Power My Analytics)
- One platform connector, such as GA4 or Google Ads. Capped at five on Business only.
- Account (Power My Analytics)
- The unit its plans count, not defined on the pricing page. For Google data the natural reading is one GA4 property, Search Console property or Ads account. This page assumes that; confirm it with their team.
- GBP location (Power My Analytics)
- A separate allowance for Google Business Profile locations, sized by plan.
- Website (DuckDive)
- DuckDive's only unit. A website holds at most one of each Google connection (an Analytics property, a Search Console site, an Ads account, a Local Services Ads account), and Yext or Local Falcon join only where that site has them.
Google's vocabulary shows why "account" needs checking. In its GA4 account structure article, an account is "a collection of properties," and a property "represents data for one user base." Search Console's property help page calls each site you add a property. One Google login can reach dozens of either, so a vendor's account is rarely your login.
DuckDive's side fits in one line. You pay per website, whatever mix of the six sources it links, and your opening site costs nothing and needs no card. The current figure is in the pricing section below.
One site, three counts
A per-source cap fills on every source at once. Add one site and you add a GA4 property, a Search Console property and maybe an Ads account, so one new site can push three counts past their limit together.
Worked example: counting billable units for a 20-site local portfolio
Calderbrook Services Group is made up for this page: a home-services group running local brands, each on its own domain, with a different mix of ads and listings per site. The operator wants one answer first. How many units would each vendor bill?
Start with what is really linked. Counting from memory is how teams overpay: a site that stopped advertising can still hold an account in someone's plan.
How many websites does my account hold, and how many of them have each of the six sources linked?
list_websitesevery website on the account, with the sources linked to eachget_setup_statusthe import status of each source on each site
The account holds 20 websites under one client. GA4 and Search Console are on every site; the local sources are patchier.
| Source | Sites linked | Still importing |
|---|---|---|
| Google Analytics 4 | 20 | 0 |
| Search Console | 20 | 0 |
| Google Ads | 14 | 0 |
| Local Services Ads | 9 | 2 |
| Yext | 8 | 0 |
| Local Falcon | 12 | 0 |
That is 83 source links. The two imports still running are Local Services Ads at Calderbrook Kesterby and Calderbrook Wychmoor, linked this morning. Everything else reports ready.
Now turn those links into billable units, using the account assumption above for the Power My Analytics column.
| What Calderbrook has | Power My Analytics | DuckDive |
|---|---|---|
| GA4 properties | 20 accounts | No extra unit |
| Search Console properties | 20 accounts | No extra unit |
| Google Ads accounts | 14 accounts | No extra unit |
| LSA, Yext and Local Falcon links | No connector listed | No extra unit |
| Google Business Profile locations | 20 GBP locations | Not a source |
| Billable units | 54 accounts, plus 20 GBP locations | 20 websites |
Next, fit those accounts and profile locations into each published plan.
| Plan | Accounts included | Over the cap |
|---|---|---|
| Business | 5 in total | 49 accounts; add-ons stop at +5 |
| Grow | 7 per source | GA4 +13, Search Console +13, Ads +7, all buyable as per-source add-ons |
| Pro | 20 per source | None |
| Custom | Unlimited | None |
Grow could also hold Calderbrook with per-source add-ons, so price Grow plus 33 add-on accounts against Pro before you treat Pro as the floor; the pricing page does not print the Grow add-on rate, so that quote has to come from their team. Business cannot stretch that far, since its add-ons stop five accounts above the five included. Pro holds Calderbrook with nothing extra, GA4 and Search Console sitting right on the 20-per-source line. Now grow the group, keeping its ad mix roughly the same.
| Sites | Sites running Google Ads | Pro add-ons |
|---|---|---|
| 21 | 15 | 2 |
| 25 | 18 | 10 |
| 30 | 21 | 21 |
Read the pattern, not the figures. Under a per-source cap, each new site adds a unit on every Google source it uses once you pass the line. Under per-site pricing, the count moves by one per site. The sliding add-on rate softens that curve as quantity rises, so do the dollar maths with the vendor's current volume table.
Two caveats keep this fair. First, Calderbrook's Local Services Ads, Yext and Local Falcon links have no home in Power My Analytics at all, so the bigger question for a local group may be coverage, not cost. Second, flip the shape and the result flips: one brand with one site on many platforms uses one account per platform, and unlimited sources on Grow absorb that well. DuckDive would read only the Google and local slice of that brand.
Ask your agentWhich GA4 properties and Search Console sites can my Google login see that are not attached to any of my websites yet?
Tools it calls list_available_sources list_websites
That prompt finishes an honest count. It surfaces what your login reaches but nobody linked, often a forgotten site or an old property to retire before you pay for it anywhere.
Run the source count on your own portfolio
Link your first site free, then ask your agent which sources each site has and which are still importing.
Free for 2 sites · No credit card
Setup: reports first or agent first
Both setups are short. What differs is who sits at the keyboard.
Power My Analytics, as its MCP page lists it
-
Connect accounts inside the hub
You sign in to Google Ads, Meta and your other platforms from the Power My Analytics hub. The page says "Your history backfills automatically."
-
Turn on MCP access
It is "one toggle in your Power My Analytics settings," included on every plan.
-
Add the connector to your assistant
Add a custom connector with
https://mcp.powermyanalytics.com/mcp, sign in with your Power My Analytics account, and ask.
That order suits a team whose reports already run from the hub: MCP is one more switch on top.
DuckDive, with you or with your agent doing it
-
Choose Continue with Google
A single Google consent screen opens your DuckDive account and lets it see the Analytics, Search Console and Ads properties your login can already reach. No form.
-
Create a website per Calderbrook brand
Pick each Calderbrook domain's GA4 property and Search Console site; for the brands that advertise, attach their Ads and Local Services Ads accounts too. Importing starts the moment a source is attached and is normally done in a few minutes. Yext and Local Falcon are hooked up on their own, and only for the brands that use them.
-
Connect your agent
In Claude, Cursor or any other MCP client, paste
https://api.duckdive.ai/mcpin as a new custom connector; in ChatGPT that takes a Business or Enterprise plan. The menu may be called Connectors, Apps or MCP, and chat apps rename it often. -
Or let the agent run steps one to three
Paste the prompt below. The agent reads
get_setup_status, creates the site withadd_websiteand links whatever is ready. You still click Continue with Google once, signed in as an admin who left Also allow actions ticked.
Give your agent the setup guideSet up DuckDive for my website. Follow https://analytics.duckdive.ai/
agents.md
The agent path pays off from the second site on. Adding the next Calderbrook brand is one sentence.
Ask your agentAdd calderbrook-linnetford.example as a new website under Calderbrook and link whichever Google sources are ready for it. Ask me before moving anything already linked to another site.
Tools it calls add_website list_available_sources connect_website_sources
Changes run only for an admin role, Agency Admin or Client Admin, on a connection where "Also allow actions" was left ticked; other team members get read access. The full agent flow is on the agent self-setup page. For a long list, see onboarding dozens of websites with an agent.
Source breadth and BI destinations
Breadth is where Power My Analytics leads by a distance. What matters is whether your platforms sit in its list or DuckDive's short one.
| Question | DuckDive | Power My Analytics |
|---|---|---|
| Platforms read | Six, Google and local sources only | 85+, including Meta, LinkedIn, Shopify and HubSpot |
| Local Services Ads | Yes, lead counts, charged leads and spend per site | No, not in its connector directory |
| Yext and Local Falcon | Yes, listings, ratings, map rank grids | No, neither is listed |
| Google Business Profile | No, not a source | Yes, with location allowances per plan |
| Google Ads detail | Partly, account totals only | Yes, its MCP page says the assistant can break changes down by campaign, country or device |
| BI and warehouse destinations | No, agent, dashboard and email reports | Yes, Data Studio, Power BI, BigQuery, Snowflake and more |
| Oldest period an agent can ask for | Partly, the last 12 months | Yes, warehoused history; depth not stated |
| Data filed by website | Yes, every source sits under its site | Not described on its MCP page |
| Agent can create the account and add sites | Yes, from one prompt plus one Continue with Google click (admin account, actions allowed) | Not described; accounts connect in the hub |
Sources: Power My Analytics connectors, MCP server page, Claude page and pricing page, checked November 2026. DuckDive rows: DuckDive's AI connector guide.
One detail on the count itself. The pricing and MCP pages say 85+, while the vendor's Claude page and its StackAdapt partner listing say "80+" (all checked November 2026). Either way, the gap to six is real. That listing also says warehoused data "is instantly accessible to Claude, ChatGPT, and any MCP-compatible AI."
On freshness, the Claude page says "Data updates daily," and hourly refreshes are a paid add-on below Custom. DuckDive publishes no schedule. Have the agent call get_sync_status and it reports each source's age per site, and admins can queue a fresh pull of anything up to the last 30 days, no more than once per site in any 15 minutes.
History is the row to read slowly. DuckDive keeps up to two years of each linked source, yet the longest window its agent tools accept is the last 12 months. Power My Analytics says its warehouse lets you "ask about periods the platform APIs no longer return," without naming a depth. If you need multi-year trends, test that on your own data. The wider trade-offs are in stored history versus live MCP servers.
What six local-heavy sources buy you
Narrow coverage pays off when the narrow sources are the ones you run. A home-services group lives on Google Ads and Local Services Ads together, and only one of these tools reads both.
For the 20 sites in my portfolio, which ones have both Google Ads and Local Services Ads linked? Compare their cost per result over the last 90 days.
list_websitesthe 20 sites and which sources each one has linkedget_websiteeach candidate site, to confirm both ad accounts are attachedget_google_ads_summaryspend and cost per conversion for the 90-day window, site by siteget_lsa_summaryhow many LSA leads came in, how many Google charged for, and what they cost over that window
Seven sites run both. Kesterby and Wychmoor run Local Services Ads alone, so they are left out.
Ads per result is cost per conversion in Google Ads. LSA per lead is spend divided by charged leads.
| Site | Ads per result | LSA per lead |
|---|---|---|
| Ostermere | $45.00 | $55.00 |
| Brackwater | $60.00 | $40.00 |
| Linnetford | $45.00 | $45.00 |
| Sallowmead | $70.00 | $42.50 |
| Pennywick | $44.00 | $60.00 |
| Dunmarsh | $55.00 | $50.00 |
| Elverton | $40.00 | $60.00 |
Local Services Ads is cheaper at Brackwater, Sallowmead and Dunmarsh; search ads win at Ostermere, Pennywick and Elverton; Linnetford is level. Sallowmead's gap is widest, at $27.50 per result.
Read that table with care: an Ads conversion is whatever the account was told to count, while a charged lead is one Google billed you for. Check conversion actions before moving budget. The Local Services Ads source page explains the lead fields DuckDive reads.
Ask your agentOver the past 90 days, which Calderbrook brands earned more organic search clicks than paid Google Ads clicks, and which depend on paid?
Tools it calls list_websites get_search_console_summary get_google_ads_summary
Run that comparison for Meta or LinkedIn and you need Power My Analytics. If you are also weighing another paid-media connector, read the Supermetrics comparison; for every hosted, official and community option in one table, open the marketing data MCP server roundup.
Choose Power My Analytics if
Power My Analytics is the better fit when
- Most spend runs outside Google. Meta, LinkedIn, Microsoft Advertising, Shopify and HubSpot are in its list; DuckDive reads none.
- Reports live in a BI tool. Data Studio, Power BI, BigQuery and Snowflake are destinations there. DuckDive exports to none.
- You need campaign, country or device splits. DuckDive's Ads tool stops at account totals, and its GA4 tools have no device or geography.
- Google Business Profile matters. It has a GBP connector; DuckDive reads no profile data.
- Your agent work spans several years. DuckDive's tools reach 12 months back; Power My Analytics markets deeper history.
- Procurement wants a certification. Its MCP page states SOC 2 Type II and ISO 27001 certification. DuckDive's public docs list none.
- You run few sites on many platforms. Unlimited sources on Grow and Pro suit that shape.
- You want hourly data. Hourly refreshes are sold as an add-on there, while DuckDive makes no freshness promise.
- Review text or pushed alerts are must-haves. DuckDive offers neither: Yext reviews reach the agent as counts and star ratings, and it never raises an alert, since scheduled email reports are all it sends. Power My Analytics' connector and Google Business Profile pages do not list either one, so get it in writing before you pick it for that reason.
Where a Calderbrook-shaped portfolio tips toward DuckDive
The reverse case is narrower. Picture many websites that live on Google search, Google Ads and Local Services Ads, several with Yext or Local Falcon on top, and an agent expected to answer across all of them before anyone builds a report. That is the shape DuckDive was made for, and the per-site unit from the worked example keeps the count moving one brand at a time. The guide for website portfolio operators and the portfolios overview go further.
Running both without double counting
Both connectors read Google Ads, so an agent with each one attached can add the same spend twice when it totals a portfolio. Pick one as the Google Ads record, usually whichever your reports already use, and write that into the agent's instructions. After that, coverage decides the split: Meta, LinkedIn and Google Business Profile questions go to Power My Analytics, and Local Services Ads, Yext and Local Falcon questions go to DuckDive.
Ask your agentBefore I compare tools on cost, list every site where a linked source is failing or has not refreshed in the last three days.
Tools it calls list_websites get_sync_status
Billing, sources and setup questions
Does Power My Analytics have an MCP server?
Yes. Its MCP page lists a remote server at https://mcp.powermyanalytics.com/mcp that signs in with OAuth through your Power My Analytics account. It names Claude, ChatGPT and Gemini, includes MCP on every plan, and reads backfilled history from its warehouse (checked November 2026).
How does Power My Analytics count accounts for pricing?
Its pricing page includes 5 accounts in total on Business, with up to 5 more sold as add-ons; 7 per source on Grow, with more sold per source; 20 per source on Pro, with volume pricing beyond; and unlimited on Custom. Only the Pro add-on rate is printed. The page never defines an account. For Google data it most likely means one property or Ads account, so confirm with their team before you budget.
Does DuckDive charge more when a site links more sources?
DuckDive prices by website, and its published tiers list all six sources. Each website is one billing unit, however many sources it links. Your opening site costs nothing and needs no card. The live per-site figure sits in the pricing section below.
Can I move to DuckDive without losing history?
DuckDive does not import from Power My Analytics. It pulls each source's history from the platform itself when you link the source, and keeps it. Your agent can query the last 12 months through DuckDive's tools. Data from platforms DuckDive does not read, such as Meta or Shopify, stays where it is, so keep that account if you need it.
Does DuckDive send data to Looker Studio, BigQuery or Power BI?
No. DuckDive has no BI or warehouse destinations. You reach the data through an MCP agent, the DuckDive dashboard, or scheduled email reports sent to your own account address. If your team reads numbers in a BI tool, Power My Analytics fits that habit better.
Which free option lets me test with my own data?
Power My Analytics offers a free Sample Data plan, which runs on sample data, and a 14-day trial with no card on paid plans (checked November 2026). On DuckDive the opening site costs nothing, asks for no card and runs on your real Google data, so the source audit on this page works against a live site.
Sources
- Power My Analytics Pricing, Power My Analytics, checked November 16, 2026, for plans and prices.
- Marketing Data MCP Server for Claude & ChatGPT, Power My Analytics, checked November 16, 2026, for MCP setup.
- [GA4] Google Analytics account structure, Google Analytics Help, checked November 16, 2026, for GA4 terms.
- Add a website or platform property to Search Console, Search Console Help, checked November 16, 2026, for Search Console terms.
- Data Source Connectors, Power My Analytics, checked November 16, 2026, for connector coverage.
- Connect Your Marketing Data to Claude, Power My Analytics, checked November 16, 2026, for refresh and history.
- DuckDive for Claude, ChatGPT and other AI apps, DuckDive, checked November 16, 2026, for connector steps.
- Power My Analytics | Partner Directory, StackAdapt, checked November 16, 2026, for the 80+ count.
- Set up DuckDive with your AI assistant, DuckDive, checked November 16, 2026, for agent setup.
Last reviewed . Calderbrook Services Group and every figure tagged EXAMPLE DATA are invented.
