How to Connect Ad Platforms to Copilot Studio
Build a Copilot Studio agent that gives your team AI-powered ad insights — right inside Microsoft Teams.
Microsoft Copilot Studio lets you build custom AI agents and publish them to Microsoft Teams, SharePoint, and other Microsoft channels. By connecting Ad Superpowers as an MCP data source, your Copilot agent gets real-time access to Meta Ads, Google Ads, GA4, LinkedIn Ads, TikTok Ads, and Google Search Console.
This means anyone on your team can ask questions about ad performance in Teams — without logging into a single ad platform. "How did our Meta campaigns perform yesterday?" "What is our Google Ads spend this week?" "Compare LinkedIn vs Meta CPL this month." All answered instantly by your Copilot agent.
This is especially powerful for enterprise marketing teams where ad platform access is limited to a few specialists, but performance visibility is needed across the organization. Deploy once, and everyone from the CMO to the junior marketer can query live ad data.
This guide walks you through creating a Copilot Studio agent with Ad Superpowers in about 10 minutes. You need a Microsoft 365 account with Copilot Studio access and an Ad Superpowers account.
The Old Way
Media buyer pulls data from 4 platforms. Formats a report. Posts it in Teams. By the time leadership reads it, the data is a day old. Someone asks a follow-up question — repeat the whole process.
The New Way
Anyone in Teams asks the Copilot agent a question. Gets a live answer with real data from all connected platforms. Follow-up questions answered instantly in the same conversation.
What You Need
- Microsoft 365 account with Copilot Studio access
- An Ad Superpowers account (Free or Pro depending on platforms)
- Admin access to publish agents in your Microsoft Teams environment
- 10 minutes to configure
Step-by-Step Setup
Create your Ad Superpowers account
Go to app.adsuperpowers.ai and sign up. Connect all the ad platforms your team uses. The Free plan includes Meta Ads, Google Ads, GA4, and Google Search Console. The Pro plan adds LinkedIn, TikTok, Shopify, and Klaviyo.
Get your API key
Navigate to Settings in the Ad Superpowers dashboard. Under "API Keys", generate a new key. Copy both the API key and the MCP server URL: https://mcp.adsuperpowers.ai/v1.
Open Copilot Studio and create a new agent
Go to copilotstudio.microsoft.com and sign in with your Microsoft 365 account. Click "Create" to start a new agent. Give it a name like "Ad Insights" and a description like "Query advertising data across Meta, Google, LinkedIn, and TikTok."
Add Ad Superpowers as a connector
In your agent's settings, go to "Actions" or "Connectors" and add a custom connector. Set the Server URL to https://mcp.adsuperpowers.ai/v1. For authentication, add a custom header: Header name "Authorization", Header value "Bearer YOUR_API_KEY" (replace with your actual key).
Publish to Microsoft Teams
Click "Publish" in Copilot Studio and select Microsoft Teams as the deployment channel. Choose which Teams channels or users should have access. Once published, team members can start chatting with the agent directly in Teams.
Try These Prompts
Once connected, try these prompts to explore your data. Click to copy.
Why Copilot Studio for ad data?
Most marketing teams face the same problem: ad data is locked inside platforms that only specialists can navigate. The CMO wants a performance update, but first someone needs to log into Meta Ads Manager, then Google Ads, then LinkedIn Campaign Manager, then compile the numbers into a format that makes sense.
Copilot Studio solves this by putting an AI agent directly in the tool your team already uses — Microsoft Teams. No new logins, no new software, no training on ad platform UIs.
Key advantages for enterprise teams:
Instant access for everyone: From the marketing director to the sales team to the CFO — anyone with Teams access can ask the Copilot agent about ad performance. No need to wait for a specialist to pull a report.
Microsoft governance: IT controls who can access the agent, where it appears, and what data it can query. This fits into existing Microsoft 365 security and compliance policies.
No platform sprawl: Instead of giving everyone access to Meta Ads Manager and Google Ads (with all the training and security implications), you give them access to one agent that answers their questions.
Real-time data: The agent queries live data through Ad Superpowers every time someone asks a question. No stale reports, no cached numbers — always current.
Enterprise use cases
Marketing leadership briefings: The CMO asks "How are we pacing against our quarterly spend targets across all channels?" and gets a cross-platform answer in Teams within seconds.
Sales and marketing alignment: The sales team asks "Which LinkedIn campaigns drove the most leads this week?" directly in their Teams channel. No waiting for the weekly marketing update.
Budget monitoring: Finance asks "What is our total advertising spend month-to-date?" and gets a real-time answer combining Meta, Google, LinkedIn, and TikTok spend — without needing access to any ad platform.
Client reporting (agencies): Account managers ask the agent for client performance summaries before client calls. No need to bother the media buying team for numbers.
Anomaly detection: Team members notice something off and ask "Did our Meta spend spike yesterday?" — getting immediate confirmation and context without logging into Ads Manager.
Troubleshooting
If your Copilot Studio agent cannot access ad data:
1. Verify the connector URL is exactly https://mcp.adsuperpowers.ai/v1 in your Copilot Studio agent settings. 2. Check the Authorization header: it should be "Bearer YOUR_API_KEY" with a space between Bearer and the key. 3. Make sure your Ad Superpowers account has at least one ad platform connected in the dashboard. 4. Test the API key by regenerating it in the Ad Superpowers dashboard if the current one is not working. 5. Check Copilot Studio's connector logs for error messages — these often indicate authentication or URL issues. 6. Ensure your Microsoft 365 tenant allows custom connectors. Some enterprise policies restrict external API connections.
If the agent works in Copilot Studio's test panel but not in Teams, the issue is usually with the Teams publishing step. Make sure the agent is published and the Teams channel has been granted access.
For more help, visit our troubleshooting docs or contact support through the Ad Superpowers dashboard.
Frequently Asked Questions
Related Guides
Learn More About All Platforms
See all tools, features, and technical details for the All Platforms integration.
Ready to Connect?
Create your free account and set up All Platforms with Copilot Studio in under 10 minutes.