Data to AI™ / Copilot/X Ads

X Ads to Microsoft Copilot integration

Give the social media team an agent in Teams that answers X Ads spend, follower growth and campaign end date questions, so nobody logs in to Ads Manager for a quick number.

Better answers, fewer tokens.

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

Which X Ads campaigns got the cheapest link clicks last week?

Copilot Answer · X Ads

Spring Webinar Promo had the cheapest link clicks at $0.41 each, on less than a quarter of the spend. Brand Awareness Q2 took the most budget but cost $1.12 per URL click.

Campaign NameSpendURL ClicksImpressions
Spring Webinar Promo Campaign Analytics $1,2303,000184,500
Product Launch Retarget Campaign Analytics $2,0503,420142,800
Brand Awareness Q2 Campaign Analytics $4,4804,000611,200

Spend is Billed Charge Local Micro divided by 1,000,000, in the ad account's currency, for placements on X itself.

source
X Ads · as of Mon 06:40 UTC
covers
Last 7 days
Example answer · fictional account and figures
X Ads in Copilot

Questions Copilot can answer from your X Ads data

X Ads (formerly Twitter Ads) extracts paid and organic performance from an X ads account: campaign spend and engagement, promoted post results with web conversions and video completion, post text, and campaign budgets and status.

Yesterday's X spend in the channel

Ask Copilot

@Social Ads What did each Campaign Name spend yesterday in Campaign Analytics, and how many URL Clicks and Follows did it bring?

The social team asks the agent in its Teams channel each morning and discusses outliers in the thread, instead of one person checking X Ads Manager and posting a screenshot.

Account growth for the monthly slide

Ask Copilot

@Social Ads Give me a table of Impressions, Engagements, Follows and Replies from Account Analytics for each day we have this month.

In Microsoft 365 Copilot, the agent returns a table while you write the monthly social report in PowerPoint, using the same numbers the team saw in Teams.

Campaign calendar as code

Ask Copilot

Use the dataddo tools to describe Campaigns and generate a JSON calendar of Name, Start Time, End Time and Entity Status for our internal planning tool.

A marketing engineer uses GitHub Copilot in Agent mode in VS Code, so the planning tool shows real X Ads campaign dates without a manual export.

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

X Ads in Copilot, with and without Dataddo

Without Dataddo With Dataddo Outcome for you
Quick numbers in Teams One person has access to X Ads Manager, so every spend question in the channel waits until they log in and paste a number. The Copilot Studio agent answers spend and engagement questions in Teams from the scheduled X Ads flow. No waiting for one login
When the agent calls Dataddo A general assistant cannot tell which questions need X ad data, so people type figures into prompts by hand. The server description you enter in Copilot Studio tells the agent to call Dataddo for X Ads spend, follower and campaign questions. Ad questions routed to ad data
Campaigns ending soon Campaign end dates are checked one by one in the X Ads interface, and a campaign that ends before a launch is noticed late. Campaigns carries Start Time, End Time and Entity Status, so the agent lists campaigns ending in the next weeks on request. Renewals decided on time
Several ad accounts Each ads account is exported separately and merged in a spreadsheet before anyone can answer a cross-account question. Each X Ads source reads one Ads Account; attach the flows for every account to the AI destination and the agent can query all of them. One agent across accounts
Token consumption Copilot spends tokens exploring raw X 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

X Ads datasets and the questions they answer in Copilot

The X 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 Analytics
  • Spend
  • Follows
  • Campaign Name
  • Date Start
  • Impressions
  • + others
Which campaigns brought the most Follows for the Spend yesterday?
Promoted Tweets
  • Video Views 100
  • Tweet Id
  • Spend
  • Billed Engagements
  • Conversion Purchases Sale Amount
  • + others
Which promoted video posts keep viewers to the end, based on Video Views 100?
Promoted Tweets Metadata
  • Created at
  • Tweet ID
  • Full text
  • Tweet language
  • Tweet type
  • + others
Which promoted posts were Created at more than 60 days ago and are still in use?
Campaigns
  • End Time
  • Name
  • Daily Budget Amount Local Micro
  • Entity Status
  • Effective Status
  • + others
Which campaigns have an End Time in the next 14 days?
Organic Tweets
  • Video Total Views
  • Tweet Id
  • Full Text
  • Impressions
  • Engagements
  • + others
Which organic posts with video had the highest Video Total Views?
Account Analytics
  • Replies
  • Retweets
  • Account ID
  • Date Start
  • Impressions
  • + others
How many Replies and Retweets did the account collect in total yesterday?
See all X 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

X Ads and Copilot: FAQ

How do I connect X Ads to Copilot?

Set up an X Ads source in Dataddo with Campaign Analytics and Account Analytics and attach it to a Copilot destination or AI Model. In Copilot Studio, add https://headless.dataddo.com/mcp-data under Tools as a Model Context Protocol tool with OAuth 2.0 Dynamic discovery, then publish the agent to Teams and Microsoft 365 Copilot.

Do I need Copilot Studio to use X Ads data in Microsoft 365 Copilot?

Yes. Dataddo connects as a Model Context Protocol tool on a Copilot Studio agent. Once the agent is published to Microsoft 365 Copilot and Teams, people reach the data by typing @ and selecting it.

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

Write a clear server description in Copilot Studio. Say it holds X Ads (formerly Twitter Ads) campaign, spend and engagement data, so only those questions trigger a lookup.

Can the agent cover more than one X ads account?

Yes. Each source selects one Ads Account. Create a source per account and attach their flows to the Copilot destination; the Ads Accounts dataset lists the accounts with names and status.

Can GitHub Copilot query Twitter Ads data in VS Code?

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 admin first enables MCP servers in the Copilot policy.

Why can the agent not answer questions about last year's X campaigns?

The X API allows extraction only up to 7 days back, so older periods cannot be loaded into a new source. The agent can answer for the periods your flow has extracted since you set it up.

Can the Copilot agent pause campaigns on X?

No. The agent reads X Ads data that Dataddo extracted and answers questions about it. Status and budget changes still happen in X Ads Manager.

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.