How to Connect Facebook Lead Ads to Microsoft Copilot (No Code)

If you run Facebook Lead Ads, you already know the reporting is slower than it should be. Ads Manager buries lead counts under menus and date pickers, and every time you want a fresh view you are rebuilding the same breakdown by hand.

The data is also siloed. Your lead records live inside Meta, your spend lives somewhere else, and your CRM has yet another version of the truth. So the moment a colleague asks a simple question, you are exporting CSVs, stitching them together in a spreadsheet, and hoping the numbers still match by the time the meeting starts.

What you actually want is to type a question in plain language and get the answer back, with no dashboards to configure and no exports to clean. The fix is connecting Facebook Lead Ads to Microsoft Copilot with Windsor.ai.

Ready to try it? Start for free with Windsor.ai. The free forever plan needs no credit card, so you can connect Facebook Lead Ads and start asking Copilot about your leads today.

Before you start

You need three things in place. This takes a few minutes and none of it involves code.

• A Facebook Lead Ads account with real data, meaning at least one lead form that has already collected leads you can report on.
• A Windsor.ai account. It is free forever with no credit card, so you can set this up before deciding on a paid plan.
• Access to Microsoft Copilot Studio, where you will add Windsor as a tool for your Copilot agent.

Connect Facebook Lead Ads to Copilot with Windsor.ai

Windsor.ai reads your Facebook Lead Ads data and makes it available to Copilot for reporting and analysis. Copilot only reads and analyzes this data, so nothing is ever changed, pushed, or synced back to Facebook. Follow these four steps.

1. Connect the data source in Windsor.ai. Go to onboard.windsor.ai/app/facebook_leads, sign in, and authorize Facebook Lead Ads. Pick the account or accounts you want to report on, then click Next.
2. Add Windsor MCP as a tool in Copilot Studio. In Microsoft Copilot Studio, create a new agent. Click + Add tool, then + New tool, then Model Context Protocol. Fill in the details:
   • Server Name: Windsor MCP
   • Server URL: https://mcp.windsor.ai
   • Authentication: API Key
   • Header name: Authorization

   Click Create, then Add and configure.

3. Create a new connection. Under “Not connected”, choose Create new connection, then enter your Windsor API key with the Bearer prefix in front of it, for example: Bearer YOUR_WINDSOR_API_KEY. Use your own key from your Windsor.ai account in place of the placeholder.
4. Start querying. Open a new chat. Copilot will ask you to connect to Windsor MCP through the Connections manager. Click Connect, then Submit. Return to the chat, click Retry, and then ask about your Facebook Lead Ads data.

The Facebook Lead Ads metrics that matter

The Facebook Lead Ads connector returns your lead records with the dimensions below. The core measure is the number of leads, which you count and slice across campaigns, ad sets, ads, and time. Here is what each field tells you.

Metric	What it tells you
Campaign Name	Total leads grouped by campaign, so you can see which campaign delivers the most volume.
Campaign ID	The stable identifier for a campaign, so you can track the same campaign consistently even if its name changes.
Ad Set Name	Leads by ad set, so you can compare which audiences and targeting are producing leads.
Ad Set ID	The stable identifier for an ad set, so ad sets with similar names stay separate in your reports.
Ad Name	Leads by individual ad, so you can see which creative is driving the most leads.
Account Name	Which Facebook ad account the leads came from, handy when you manage more than one.
Date	Lead volume over time, so you can spot trends and compare week over week.

What to ask Copilot: prompt ideas

Once the connection is live, you can drop these prompts straight into Copilot. Copy, paste, and adjust the dates to fit your reporting window.

How many leads did each Facebook lead ad campaign and ad generate in the last 30 days, and which campaign is trending up week over week?

Which ad set generated the most leads last month, and how does lead volume by ad set compare across my Facebook lead ad campaigns?

Show me daily lead volume by ad for the past 8 weeks and tell me which ad name is driving the most leads right now.

Bonus: analyze Facebook Lead Ads alongside your full stack

Facebook Lead Ads is more useful when you read it next to the rest of your marketing data. Because Windsor.ai brings every source into one place, Copilot can report across them together. This is all read-only, blended reporting, so nothing is ever written back to any platform.

• Cost per lead by campaign. Blend Facebook Lead Ads with the Meta Ads spend connector so Copilot can divide spend by lead count and show you cost per lead for each campaign, all in one cross-channel view.
• Leads to pipeline. Blend Facebook Lead Ads with your CRM, such as HubSpot or Salesforce, to see which campaigns and ads produced the leads that turned into real deals, giving you a single source of truth from ad to pipeline.
• Channel comparison. Blend Facebook Lead Ads with Google Ads and GA4 so Copilot can compare lead volume and ROAS across your paid channels in one blended report, without a single export.

Conclusion

Connecting Facebook Lead Ads to Microsoft Copilot with Windsor.ai turns slow, siloed lead reporting into a plain-language conversation. Set the connection up once, then ask about lead volume by campaign, ad set, and ad, watch trends over time, and get answers in seconds instead of exports. It is no-code, it stays read-only, and you can be up and running in minutes.

Start for free with Windsor.ai today. Free forever plan, no credit card, and your Facebook Lead Ads data is ready for Microsoft Copilot in minutes.