Data to AI™ / Copilot/Google Search Console

Connect Google Search Console to Copilot

Give marketing a Copilot agent in Teams that answers questions on organic clicks, rankings and CTR, and let developers query the same data in VS Code.

Better answers, fewer tokens.

  • Lower AI costs for the same work
  • More accurate, reliable answers
  • Read-only
  • Uses the Google Search Console data you already sync
  • SOC 2 Type II certified
Microsoft 365 Copilot
Connected to Dataddo

Which blog pages lost the most clicks in September compared with August?

Copilot Answer · Google Search Console

The CRM guide lost 1,240 clicks, down 37%, the largest drop, and now averages Position 7.8. The other two pages fell 21% and 12%.

URLClicks (Sep)Clicks (Aug)Position (Sep)
/blog/crm-guide Daily Metrics by Page 2,1403,3807.8
/blog/pricing-models Daily Metrics by Page 1,6202,0505.2
/blog/api-basics Daily Metrics by Page 9801,1106.4

Page rows are sampled by Google, so pages are compared with each other and not added up into a site total.

source
Google Search Console · as of Mon 06:40 UTC
covers
1 Aug-30 Sep 2026
Example answer · fictional account and figures
Google Search Console in Copilot

Questions Copilot can answer from your Google Search Console data

Google Search Console shows how a site performs in Google search: Clicks, Impressions, CTR and average Position by date, query, page, country and device, for the properties your account can access.

SEO answers in the marketing channel

Ask Copilot

@Search desk How did our new pricing landing page rank last month, and how many Clicks did it get from Daily Metrics by Page?

Campaign and content managers ask the agent in Teams instead of requesting a report from the SEO specialist, who gets time back for actual optimization work.

Docs pages that rank but get no clicks

Ask Copilot

Use the dataddo tools to query Daily Metrics by Page for URLs under /docs with Impressions but zero Clicks in the last 30 days.

A developer maintaining the documentation site uses GitHub Copilot in Agent mode, then fixes titles and meta descriptions for those pages in the same pull request.

Market visibility before local campaigns

Ask Copilot

@Search desk Show Impressions and Position by Country for our top product queries last quarter from Daily Metrics by Country and Query.

In Microsoft 365 Copilot, the regional marketing lead checks where the brand is already visible in search before planning budgets for local campaigns.

Google Search Console datasets and the questions they answer in Copilot →
Pricing

Priced per seat.

Data to AI™ is priced per seat, like the AI assistants your team already uses, with ~25% off on annual billing. Need tailored contracts or volume pricing? Talk to us about Enterprise.

Data to AITM

Serve governed business data to Claude, ChatGPT and other AI tools over MCP.

$10.49/month

per seat

3 seats minimum

Enterprise

Flexibly deploy Dataddo in any cloud or hybrid environment.

Custom

We have a payment model that works for you

See all plans and features →
Setup

Connect Google Search Console to Copilot step by step

  1. 1
    Connect Copilot to Dataddo Add Dataddo as an MCP tool to a Copilot Studio agent and sign in, or add it to mcp.json for GitHub Copilot in VS Code.
  2. 2
    Connect Google Search Console to Dataddo Sign in with your Google Search Console account in Dataddo and choose the datasets to sync, such as Daily Metrics and Daily Metrics by Query.
  3. 3
    Choose what Copilot can see Select the Google Search Console data Copilot may query. Access is read-only, and data you don't select stays out of reach.
Copilot setup guide →
With vs. without

Google Search Console in Copilot, with and without Dataddo

Without Dataddo With Dataddo Outcome for you
SEO numbers for non-specialists Marketing colleagues ask the SEO specialist for a Search Console report and wait days for a spreadsheet. The Copilot Studio agent in Teams answers questions on Clicks, Impressions and Position directly from the Dataddo flow. Self-service SEO answers
Data in the developer workflow Developers download a CSV of page performance and commit it next to the code to check titles. GitHub Copilot in VS Code queries Daily Metrics by Page through the Dataddo server in Agent mode, so no file lands in the repository. No CSV in the repo
When the agent calls Dataddo A general Copilot answer about rankings draws on web knowledge, not on your own Search Console properties. The server description in Copilot Studio names organic clicks, queries and rankings, so those questions trigger a Dataddo lookup. Answers from your properties
Recent days A report pulled too early shows partly processed days, and the channel reacts to a drop that is not real. The source uses a date range of 4 days ago or older, so the agent only reports days Google has finished processing. No false alarms
Token consumption Copilot spends tokens exploring raw Google Search Console columns, sampling rows and retrying until it understands the data. Field definitions and relations are supplied up front, so the model skips the exploration and goes straight to the answer. Fewer tokens per answer
Answer quality Prone to wrong joins, invented fields and numbers that are hard to check. Answers built on agreed definitions. In the Dataddo benchmark, Opus 5.5 reached 95.2% good outcomes, against 81% over raw SQL. Better answers
Datasets

Google Search Console datasets and the questions they answer in Copilot

The Google Search Console datasets marketing teams use most, with their real field names. Copilot queries them by name through the Dataddo semantic layer.

Dataset Metrics and attributes Ask Copilot
Daily Metrics Is our site CTR this month higher or lower than the same month last year?
Daily Metrics by Query Which queries rank just below page one by average Position and could move up?
Daily Metrics by Page Which pages have the best average Position in Google search results?
Daily Metrics by Page and Query Which queries send Clicks to more than one URL on our site?
Daily Metrics by Country and Device Which Country brings the most organic Clicks from Google search?
Sites Metadata Do we have full owner Permission Level on every Site URL we manage?
See all Google Search Console datasets, metrics and attributes on the connector page →
Benchmark

Fewer confident mistakes. No leaked personal data.

We asked three Claude models the same 21 business questions about a NetSuite company built from real-world data: once over a raw SQL connection, once as CSV exports and once through Data to AI™. Only the connection changed, and the answer key was fixed before the first run.

95.2%

good outcomes with Opus 5.5 on Data to AI™, against 81% on a raw SQL connection

58%

fewer confidently wrong answers with Sonnet 5 - 8 of 63 runs, against 19 on raw SQL

24x

cheaper per question: Haiku 5.5 on Data to AI™ (87.3%) beat Opus 5.5 on raw SQL (81%)

0 of 9

attempts disclosed a sales rep's email address, against 9 of 9 on raw SQL

Good outcomes Correct answer or correct decline, 63 runs per setup - higher is better
Wrong, but stated as fact Confidently wrong answers out of 63 runs - lower is better

21 questions, 3 runs each. 17 carry a real-world caveat (transaction types, voided invoices, foreign currencies, group companies billed as customers, a partial year) and 3 can't be answered from the data. Ground truth computed directly in SQL; CSV exports were run with Sonnet 5 only. Run date: 26 October 2026.

Read the benchmark →
FAQ

Google Search Console and Copilot: FAQ

How do I connect Google Search Console to Copilot?

Create a Google Search Console source in Dataddo with Daily Metrics by Page and Daily Metrics by Query, and attach it to a Copilot destination or AI Model. In Copilot Studio, add https://headless.dataddo.com/mcp-data as an MCP tool with OAuth 2.0 and publish to Teams, or use .vscode/mcp.json for GitHub Copilot.

Can a Copilot agent answer Search Console questions in Teams?

Yes. Publish your Copilot Studio agent with the Dataddo MCP tool and add it under Channels > Teams and Microsoft Copilot. Colleagues mention it and ask about clicks, queries and pages.

Why do the agent's totals not match the Search Console UI?

Query and page data is sampled, so sums over queries or pages differ from the UI while trends stay the same. For totals, point the agent to Daily Metrics or the country and device datasets.

Why does Copilot not show the last few days of search data?

Google needs 24 to 72 hours to process the data. Dataddo recommends a date range of 4 days ago or older for Search Console, so recent days appear a little later.

Does GitHub Copilot need an admin to enable Dataddo?

On Copilot Business and Enterprise, yes: an organization admin must enable the MCP servers in Copilot policy. Then add the server to .vscode/mcp.json and use Agent mode.

How do I make the agent use Search Console only for SEO questions?

Say so in the server description in Copilot Studio, for example organic clicks, queries and rankings. The agent uses that description to decide when to call Dataddo.

What Search Console access does Dataddo need?

The authorizing Google account must be a Site Owner or Site Full User. Sites Metadata then lists each Site URL with its Permission Level.

New from Dataddo · Data to AI™

Ask Claude or ChatGPT about your ads, analytics and CRM

“What did a new lead cost us last week, by paid channel?”

Connect 400+ sources once and get the answer right in your AI chat, without building a report. Better answers: your metrics are defined once, so the AI doesn't have to guess.