Data to AI™ / Copilot/TikTok

Connect TikTok to Microsoft Copilot

Let the social team ask a Copilot agent in Teams about TikTok video reach, watch time and follower growth, instead of downloading analytics every Monday.

Better answers, fewer tokens.

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

How did our TikTok followers change week by week in September, and when did we lose most?

Copilot Answer · TikTok Organic

The account gained 6,210 net followers over four weeks. Losses peaked in the week of 8 Sep at 1,150, and 22-28 Sep was the strongest week with 2,500 net.

WeekDaily New FollowersDaily Lost FollowersDaily Total Followers
1-7 Sep Profile Daily Insights 1,8404201,420
8-14 Sep Profile Daily Insights 2,3101,1501,160
15-21 Sep Profile Daily Insights 1,5203901,130
22-28 Sep Profile Daily Insights 2,9604602,500

Daily Total Followers is the daily net change in followers, not the follower count, so it is summed per week.

source
TikTok Organic · as of Mon 06:40 UTC
covers
1-28 Sep 2026
Example answer · fictional account and figures
TikTok in Copilot

Questions Copilot can answer from your TikTok data

TikTok Organic extracts non-paid insights from a TikTok business account: daily profile activity, follower audience breakdowns, and per-video reach, watch time, retention, traffic sources and comments.

Monday TikTok standup in Teams

Ask Copilot

@TikTok pulse Which videos brought the most New Followers and Profile Views last week, and what Caption did each one use?

The agent sits in the social team's channel, so anyone can check last week's winners before the standup, read straight from Video Lifetime Insights instead of collected screenshots.

Where top videos get discovered

Ask Copilot

@TikTok pulse For our five videos with the most Reach, what Percentage of views came from each Impression Source?

In Microsoft 365 Copilot, the content lead sees which Impression Source values bring views to the strongest videos, using Video Lifetime Traffic Sources, and adjusts the posting plan.

Checking dashboard retention logic

Ask Copilot

Use the dataddo tools to query Video Lifetime View Retention and check our drop-off calculation in src/metrics/retention.ts.

A marketing engineer uses GitHub Copilot in Agent mode in VS Code to compare real retention by Second with the dashboard code, without copying a CSV into the repository.

TikTok 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 TikTok 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 TikTok to Dataddo Sign in with your TikTok account in Dataddo and choose the datasets to sync, such as Profile Daily Insights and Video Lifetime Insights.
  3. 3
    Choose what Copilot can see Select the TikTok data Copilot may query. Access is read-only, and data you don't select stays out of reach.
Copilot setup guide →
With vs. without

TikTok in Copilot, with and without Dataddo

Without Dataddo With Dataddo Outcome for you
Getting the numbers into Copilot Someone downloads TikTok analytics every Monday and posts screenshots of follower and video numbers into the team channel. The Copilot Studio agent reads Profile Daily Insights and Video Lifetime Insights from Dataddo whenever a colleague mentions it. No Monday export
Several brand profiles Each TikTok business account is exported on its own, then merged in a spreadsheet before anyone can compare brands. Multi-account extraction collects the same dataset from every profile you can access, so one agent answers for all of them. All profiles in one agent
When the agent calls Dataddo A general Copilot answer about TikTok draws on public knowledge, not on how your own account performed. The server description in Copilot Studio tells the agent to call Dataddo for TikTok videos and followers, so answers come from your data. Answers from your account
Token consumption Copilot spends tokens exploring raw TikTok 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

TikTok datasets and the questions they answer in Copilot

The TikTok 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
Profile Daily Insights
  • Profile Views
  • Bio Link Clicks
  • Date
  • Video Views
  • Daily New Followers
  • + others
Do Bio Link Clicks rise on days with more Profile Views on our TikTok profile?
Video Lifetime Insights
  • Reach
  • Average Time Watched
  • Caption
  • Video Views
  • Full Video Watched Rate
  • + others
Which videos had wide Reach but a low Average Time Watched?
Video Lifetime View Retention Which Video ID keeps the highest Percentage of viewers until the final second?
Video Lifetime Traffic Sources Which Impression Source sends the most views across all our TikTok videos, by average Percentage?
Video Lifetime Audience by Type Which Video ID has the highest share of returning viewers?
Profile Lifetime Audience by Country Which Country values each hold under five percent of our TikTok audience?
Video Comments Lifetime Insights Which Video ID drew the most comments with Replies from other viewers?
See all TikTok 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

TikTok and Copilot: FAQ

How do I connect TikTok to Copilot?

Create a TikTok Organic source in Dataddo with datasets such as Video Lifetime Insights and Profile Daily Insights, and attach it to a Copilot destination or AI Model. In Copilot Studio, add https://headless.dataddo.com/mcp-data as a Model Context Protocol tool with OAuth 2.0, then publish the agent to Teams.

Can I connect TikTok to Microsoft 365 Copilot without writing code?

Yes. Dataddo extracts TikTok data on a schedule, and a Copilot Studio agent reads it through the Dataddo Data Access MCP tool. You only add the tool, sign in and publish.

Can the agent explain who watches a video?

Yes. Video Lifetime Audience by Type, Country, City and Gender give a Percentage per value for each Video ID, so the agent can describe the viewers behind a specific video.

Why does the agent find no TikTok audience breakdown for a new profile?

Profile Lifetime Audience datasets by age, gender, city and country are only available for TikTok accounts with at least 100 followers.

Can Copilot show how a TikTok video's numbers changed over time?

Video datasets are lifetime snapshots. Append them with the dataddo_extraction_timestamp column and the agent can compare one day's snapshot with another.

Does GitHub Copilot work with TikTok data too?

Yes. Put the Dataddo URL in .vscode/mcp.json, start the server, sign in and use Copilot Chat in Agent mode. On Business and Enterprise, an admin enables the MCP servers in Copilot policy first.

How does the agent know when to look up TikTok data?

The server description you write in Copilot Studio tells the agent when to call Dataddo. Mention TikTok videos and followers there, so those questions trigger a lookup.

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.