Data to AI™ / Copilot/Google Ads

How to connect Google Ads to Copilot

Give account managers a Copilot agent in Teams that answers Google Ads questions on device performance, shopping products and impression share from synced report data.

Better answers, fewer tokens.

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

Which search campaigns lost the most impression share to budget last month?

Copilot Answer · Google Ads

Competitor terms lost 44% of its eligible search impressions to budget and Generic - Running shoes lost 31%. Brand - Exact lost only 2%.

Campaign - NameCost Micros (Spend)Search Impression ShareSearch Budget Lost Impression Share
Competitor terms Campaign Report 5,41038%44%
Generic - Running shoes Campaign Report 12,88054%31%
Brand - Exact Campaign Report 3,24091%2%

Cost Micros (Spend) was divided by 1,000,000 to match the amounts in the Google Ads interface.

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

Questions Copilot can answer from your Google Ads data

Google Ads data comes as Reports with Metrics, Reports without Metrics and Keyword Planner Historical Metrics. You pick a report type such as campaign, keyword, search term or shopping, then the attributes, segments and metrics to extract.

Device split in the client channel

Ask Copilot

@Search Ads Desk Compare Conversions Value per cost by device for each campaign last week, with costs converted from micros.

An agency publishes the agent to its account team channel in Teams. Account managers discuss device bid adjustments in the same thread as the answer.

Shopping products without conversions

Ask Copilot

@Search Ads Desk Which Shopping Performance View products by Title had the most Clicks but no Conversions this month?

In Microsoft 365 Copilot, the merchandising team gets the list grouped by Brand and Product Type Level 1 and pastes it into the next product plan.

Report loaders in VS Code

Ask Copilot

Use the dataddo tools to describe the Campaign Report entity and add a micros-to-currency conversion for Cost Micros (Spend) in our report loader.

A developer uses GitHub Copilot in Agent mode so the internal dashboard converts micros before values reach anyone, using field names taken straight from Dataddo.

Google Ads 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 Ads 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 Ads to Dataddo Sign in with your Google Ads account in Dataddo and choose the datasets to sync, such as Campaign Report and Campaign Budget Report.
  3. 3
    Choose what Copilot can see Select the Google Ads 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 Ads in Copilot, with and without Dataddo

Without Dataddo With Dataddo Outcome for you
Many client accounts Account managers export the same report from each Google Ads account and stitch the files together before every client review. Multi-account extraction, enabled by the Dataddo Solutions team, pulls the same report from several accounts into one flow the agent can split by account. Every account in one agent
Answers where the team works Questions about impression share or devices wait for whoever has Google Ads access and time to pull a report. Anyone in the Teams channel mentions the Copilot Studio agent with @ and gets the answer from synced Google Ads data. No waiting on an analyst
Freshness A spreadsheet shared in Teams on Monday is still being quoted on Thursday, with no date attached. Reports with Metrics refresh on your schedule over a relative date range, and the agent can call data_status to say how current they are. Answers with a date
Token consumption Copilot spends tokens exploring raw Google Ads 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 Ads datasets and the questions they answer in Copilot

The Google Ads 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
Campaign Report
  • Search Impression Share
  • Campaign - Name
  • Cost Micros (Spend)
  • Conversions
  • Conversions Value
  • + others
How did Search Impression Share change week over week for our brand campaigns?
Campaign Budget Report
  • Cost Micros (Spend)
  • Campaign Budget - Amount Micros
  • Campaign Budget - Recommended Budget Amount Micros
  • + others
How did Cost Micros (Spend) compare with budget across the last three months?
Keyword View Reports
  • Clicks
  • Ad Group Criterion - Keyword - Text
  • Ad Group Criterion - Keyword - Match Type
  • CTR
  • Cost Per Conversion
  • + others
Which keywords lost the most Clicks compared with last month?
Search Term View Report
  • Conversions
  • Search Term View - Search Term
  • Search Term Match Type
  • Cost Micros (Spend)
  • + others
Which search terms with Conversions this week did not appear last month?
Shopping Performance View
  • Product Type Level 1
  • Conversions Value
  • Item ID
  • Title
  • Brand
  • + others
Which Product Type Level 1 categories saw falling Conversions Value month over month?
Ad Group Ad Reports
  • Ad Group Ad - Ad Strength
  • Ad Group Ad - Ad - Responsive Search Ad - Headlines
  • + others
How many of our ads improved their Ad Group Ad - Ad Strength rating since last month?
Keyword Planner Historical Metrics
  • Keyword
  • Avg Monthly Searches
  • Competition
  • Low Top Of Page Bid Micros
  • High Top Of Page Bid Micros
  • + others
Which Keyword ideas are cheapest to bid on for a top of page position?
See all Google Ads 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 Ads and Copilot: FAQ

How do I connect Google Ads to Copilot?

Attach Google Ads sources from Dataddo, such as the Campaign Report and Shopping Performance View, to a Copilot destination or AI Model. In Copilot Studio, add a Model Context Protocol tool with https://headless.dataddo.com/mcp-data and OAuth 2.0 with Dynamic discovery, sign in, and publish the agent to Teams and Microsoft Copilot.

Can Microsoft 365 Copilot answer questions about Google Ads?

Yes, through a Copilot Studio agent with Dataddo Data Access as a Model Context Protocol tool. Publish it to Microsoft 365 Copilot and Teams, then mention it with @.

Why are Google Ads costs from the agent a million times too high?

The Google Ads API returns costs in micros. Ask the agent to divide micros fields such as Cost Micros (Spend) by 1,000,000 so answers show currency.

How do I keep the agent from calling Dataddo for unrelated questions?

Write a precise server description in Copilot Studio, such as Google Ads campaign, keyword and shopping results. The agent uses it to decide when to call Dataddo.

Can GitHub Copilot use the same Google Ads data?

Yes. Add the server to .vscode/mcp.json with type http and the URL, start it, sign in and use Agent mode. Copilot Business and Enterprise need the MCP servers in Copilot policy enabled.

Can one agent cover several Google Ads accounts?

Yes. Multi-account extraction pulls the same report from several accounts into one flow, and the agent can split answers by account.

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.