VS Code MCP for marketing data
VS Code MCP servers work with GitHub Copilot's agent mode. Add Lemonado and Copilot reads Google Ads, Meta Ads and GA4 while it works in your workspace.
No card needed. About 2 minutes to set up.
Lemonado
Lemonado for VS Code (GitHub Copilot)
Copilot reads your marketing data in agent mode and works the numbers into your code, docs and notebooks in the workspace you have open.
Set up in minutes.
- 1
Connect Google Ads
Sign in to Google Ads in Lemonado.
- 2
Copy the server URL
Turn on external access and copy one URL.
- 3
Ask in VS Code (GitHub Copilot)
Add the URL to VS Code (GitHub Copilot) and ask away.
Ask it anything.
Copilot's agent mode can call MCP tools inside your workspace, so it can read live numbers while it edits code and docs.
VS Code (GitHub Copilot)How much are we paying for clicks on our own brand name, and what share of Google spend is it?
Brand search cost $3,210 last month at $0.42 a click, 22% of Google spend. We already win 96% of brand impressions, so a pause test is low risk.
Source: your marketing stack
Did the Advantage+ audience beat our interest stack on cost per purchase?
Yes. $31 vs $44 over 21 days, with 2.3x the purchases. The gap is widest on 35 to 54-year-olds.
Source: your marketing stack
How much traffic do we get from ChatGPT, Perplexity and other AI assistants, and does it convert?
1,240 sessions last month, up 3x since July. They convert at 3.1%, above every paid channel.
Source: your marketing stack
Find pages with over 5,000 impressions and CTR under 1%, then open their title tags in the code and suggest new ones.
6 pages qualify. /guides/tent-sizes has 18,400 impressions at 0.7% CTR, and its title cuts off at 70 characters. New titles are in the diff.
Source: Google Search Console + your code
Compare the campaign names in our launch config with the naming rules sheet. Which names break the rules?
5 of 22 break them. Three are missing the market code, two use "FB" instead of "META".
Source: Google Sheets + your code
Check that every LinkedIn campaign's landing URL in our config carries utm_source=linkedin. List the ones that don't.
3 of 12 are missing it. Their leads show up as direct traffic in the CRM.
Source: LinkedIn Ads + your code
Connect your tools to VS Code (GitHub Copilot).
- Google Ads in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor about your Google Ads campaigns, search terms and spend.
Meta Ads in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor about your Facebook and Instagram ads, creatives and results.
Google Analytics in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor about GA4 traffic, conversions and funnels, next to your ad spend.
Google Search Console in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor about your search queries, rankings and lost clicks.
Google Sheets in VS Code (GitHub Copilot)Use your media plans, targets and offline sales sheets in Claude, next to live ad data.
LinkedIn Ads in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor about LinkedIn campaigns, lead forms and who converts.
TikTok Ads in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor which TikTok videos hold attention and which ones sell.
Stripe in VS Code (GitHub Copilot)Put Stripe revenue next to your ad spend in Claude, ChatGPT or Cursor.
Instagram organic in VS Code (GitHub Copilot)Ask Claude or ChatGPT which posts and reels grow your account, and which ones to turn into ads.
Pinterest Ads in VS Code (GitHub Copilot)Ask Claude or ChatGPT which pins get saved, clicked and bought.
Snapchat Ads in VS Code (GitHub Copilot)Ask Claude or ChatGPT which Snapchat ads get swipes and which ones sell.
YouTube Ads in VS Code (GitHub Copilot)Ask Claude or ChatGPT which YouTube ads get watched and which ones convert.
How to add Lemonado to VS Code (GitHub Copilot)
- 1
Connect your marketing tools in Lemonado
In Lemonado, open Connectors and sign in to the tools you want to use: Google Ads, Meta Ads, GA4 and so on. New to Lemonado? The free trial gives you $150 in credits, no card needed.
- 2
Turn on external access and copy the server URL
Open the company's settings, choose External tools, turn the connection on and pick which clients and sources it can reach. Copy the server URL.
texthttps://mcp.lemonado.io/mcp - 3
Add the server
With AI features on and a project open, run MCP: Add Server from the command palette. Choose HTTP, paste the server URL and name it lemonado.
texthttps://mcp.lemonado.io/mcp - 4
Choose where it lives
For your personal Copilot setup, choose Global → Copilot Global. That writes to ~/.copilot/mcp-config.json unless COPILOT_HOME says otherwise.
- 5
Trust and sign in
Accept the trust prompt and sign in to Lemonado. Turn the tools on under Chat: Open Customizations → Tools.
- The older .vscode/mcp.json format still works for the local harness, but VS Code now marks that destination as deprecated. It uses a servers key with type http and the same URL.
Use Lemonado with other AI apps.
Reading this as an AI agent?
Everything an agent needs to set this up, in plain text. Paste this page's link into VS Code and ask it to connect you, or copy the block.
# Lemonado MCP server in VS Code (GitHub Copilot) Lemonado is a hosted MCP server that gives AI apps the user's live marketing data from Google Ads, Meta Ads, GA4 and 3,000+ other tools. - Server URL: https://mcp.lemonado.io/mcp - Transport: Streamable HTTP - Auth: OAuth; the user signs in to Lemonado in the browser. No API keys. - Tools on https://mcp.lemonado.io/mcp (custom connectors, coding agents, n8n): list_objects, get_object_details, execute_sql, get_google_ads_resource_metadata, list_companies, get_company_details, list_actions, get_action_details, execute_action - Lemonado's Claude directory app and ChatGPT plugin (read-only): list_projects, list_project_sources, answer_data_question, explain_metric_change ## Setup 1. The user connects their tools in Lemonado (Connectors) and signs in. 2. In the company's settings → External tools, they turn the connection on and copy the server URL. 3. Add the server: With AI features on and a project open, run MCP: Add Server from the command palette. Choose HTTP, paste the server URL and name it lemonado. ```text https://mcp.lemonado.io/mcp ``` 4. Choose where it lives: For your personal Copilot setup, choose Global → Copilot Global. That writes to ~/.copilot/mcp-config.json unless COPILOT_HOME says otherwise. 5. Trust and sign in: Accept the trust prompt and sign in to Lemonado. Turn the tools on under Chat: Open Customizations → Tools. Docs: https://docs.lemonado.io/mcp-reference Full index for agents: https://lemonado.io/llms.txt
Frequently Asked Questions
Platforms like Google and Meta publish their own MCP servers, each covering one tool. Lemonado is one connection that brings Google Ads, Meta Ads, GA4, Search Console, LinkedIn, TikTok, Stripe and 3,000+ other tools into VS Code (GitHub Copilot), so you can ask questions that cross platforms.
Yes. MCP tools show up in Copilot Chat's agent mode. Turn Lemonado's tools on in the tools picker, then ask about your data in the chat.
Yes. It can read your data and make changes, like pausing an ad or moving budget, once you approve them.
MCP is included in Lemonado's paid plans and in the free trial, so you can try it before you pay.
Still have a question?
Shoot us an email at hello@lemonado.io.
Try for freeStop fighting with data. Start feeding your AI.
Connect your data to AI and free your team from reporting and busywork.
Try Lemonado free