Data to AI™ / Copilot/Google Analytics 4

Google Analytics 4 in Microsoft Copilot

Let content, regional and product teams ask a Copilot agent in Teams about website traffic, page views and new users instead of waiting for the analytics team.

Better answers, fewer tokens.

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

Which channel brought the most key events for its traffic last month?

Copilot Answer · Google Analytics 4

Organic Search brought the most Key Events, 1,446. Email converted best, with 7 key events per 100 sessions against 5 for Paid Search and 3 for Organic Search.

ChannelSessionsKey EventsEngagement Rate
Organic Search google / organic 48,2001,44661%
Paid Search google / cpc 21,5001,07558%
Email newsletter / email 6,40044872%

Sessions are taken by channel without a Page Path breakdown, so no session is counted twice.

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

Questions Copilot can answer from your Google Analytics 4 data

Google Analytics 4 measures how people reach and use your website and apps. Dataddo extracts one flexible GA4 dataset: pick from 184 standard metrics and 374 dimensions, plus custom ones defined in your property.

Content planning in the channel

Ask Copilot

@Web Traffic Which ten Page Path values gained the most Screen Page Views this week, and which of them were not in last week's top ten?

An editorial team mentions the agent in its Teams channel, so the planning meeting starts from GA4 figures rather than a screenshot someone took on Friday.

Market growth for country managers

Ask Copilot

@Web Traffic Show New Users and Sessions for my Country by week this month, and tell me how they compare with last month.

Country managers ask the agent in Microsoft 365 Copilot while writing their monthly update and paste the answer into the document they already have open.

Event check after a deploy

Ask Copilot

Use the dataddo tools to compare Event Count by Event Name before and after today's deploy, and list any event that stopped firing.

A developer runs GitHub Copilot in VS Code in Agent mode and catches a renamed or missing event before marketing finds a hole in its reports.

Google Analytics 4 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 Analytics 4 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 Analytics 4 to Dataddo Sign in with your Google Analytics 4 account in Dataddo and choose the datasets to sync, such as Users and engagement and Acquisition.
  3. 3
    Choose what Copilot can see Select the Google Analytics 4 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 Analytics 4 in Copilot, with and without Dataddo

Without Dataddo With Dataddo Outcome for you
Where people ask Editors and country managers email the analytics team for page views or new users and wait days for a report to come back. A Copilot Studio agent in Teams and Microsoft 365 Copilot answers from the GA4 flow whenever someone mentions it with @. Answers inside Teams
Breakdowns that look short A country or gender split in an export adds up to less than all users, and someone patches the gap by hand. The agent reads rows as GA4 returns them, where users Google cannot classify are left out of the breakdown, so the gap can be explained. Gaps explained, not patched
Several websites or apps Each GA4 property is exported on its own, and merged rows lose track of which site they belong to. Multi-account extraction, enabled by the Dataddo Solutions team, pulls the same fields from every property, and Include property ID labels each row. Every row tied to a property
Developers checking tracking After a release, developers ask someone with GA4 access to confirm that events still fire, often a day later. GitHub Copilot in VS Code queries Event Count by Event Name through the server in .vscode/mcp.json, in Agent mode. Tracking checked from the editor
Token consumption Copilot spends tokens exploring raw Google Analytics 4 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 Analytics 4 datasets and the questions they answer in Copilot

The Google Analytics 4 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
Users and engagement
  • Average Session Duration
  • Active Users
  • New Users
  • Sessions
  • Engagement Rate
  • + others
Is Average Session Duration longer this month than last month?
Acquisition
  • First User Source
  • Session Default Channel Grouping
  • Session Source Medium
  • Session Campaign Name
  • + others
Which First User Source values first brought users to our site in Google Analytics?
Pages and events
  • Landing Page
  • Screen Page Views
  • Page Path
  • Event Name
  • Event Count
  • + others
Which Landing Page saw the biggest drop in Screen Page Views versus last month?
Ecommerce
  • Purchase Revenue
  • Ecommerce Purchases
  • Add To Carts
  • Item Name
  • Item Category
  • + others
How did weekly Purchase Revenue compare with the same weeks last year?
Key events and ads
  • Session Key Event Rate
  • Key Events
  • Ads cost
  • Return on ad spend
  • + others
Is Session Key Event Rate higher this quarter than in the same quarter last year?
Audience
  • User Age Bracket
  • Country
  • Device Category
  • New vs Returning
  • + others
Has the share of the youngest User Age Bracket grown since last year?
See all Google Analytics 4 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 Analytics 4 and Copilot: FAQ

How do I connect Google Analytics 4 to Copilot?

Set up a Google Analytics 4 source in Dataddo with fields such as Page Path, Screen Page Views and New Users, attach it to a Copilot destination or AI Model, then add https://headless.dataddo.com/mcp-data as a Model Context Protocol tool in a Copilot Studio agent with OAuth and publish it to Microsoft 365 Copilot and Teams.

How does a Copilot agent know when to query GA4?

The server description you enter in Copilot Studio tells the agent when to call Dataddo. Describe it as the source for website traffic and conversions.

Can the GA4 agent answer in Microsoft Teams?

Yes. After publishing, open Channels > Teams and Microsoft Copilot and add the channel. People in Teams then mention the agent and get answers from the same GA4 data.

Can developers use GA4 data in GitHub Copilot?

Yes. Add the Dataddo server to .vscode/mcp.json, start it, sign in and use Copilot Chat in Agent mode. On Business and Enterprise an org admin must enable the MCP servers in Copilot policy.

Why does Copilot report fewer GA4 users by gender than in total?

Google leaves out users it cannot classify by gender or country, without adding an unknown row. Breakdown totals can therefore be lower than the overall figure Copilot shows.

Can one Copilot agent cover several GA4 properties?

Yes, through multi-account extraction set up with the Dataddo Solutions team. Turn on Include property ID so the agent can tell which property each row belongs to.

Why is today's GA4 data missing in Copilot?

Google takes 24 to 72 hours to process GA4 data. Data appears after the flow runs, and the most recent three days may still change once Google finishes processing.

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.