Adops MCP Server

AdOps MCP

CSV-first analytics & optimization for Google Ads + Meta Ads — inside Claude, Cursor, and any MCP client.

Export a CSV from Google Ads or Meta Ads Manager → import into AdOps → ask your AI assistant anything about your campaigns.

No OAuth. No developer tokens. No API approval queues. Your data stays on your machine.

---

Why CSV-first?

Google Ads API and Meta Marketing API are powerful but gated: developer token approval takes days, Meta app review takes weeks, OAuth flows are fragile. For most advertisers those barriers never clear.

AdOps takes a different path. Every ad platform's dashboard already has a Download / Export button that produces a CSV of exactly what you care about: campaign performance, day-segmented metrics, spend, conversions, ROAS. AdOps reads that CSV and runs the same analysis you'd get from a $200/mo optimization suite — anomaly detection, budget allocation, A/B significance, forecasting, industry benchmarks — directly inside your AI assistant.

You stay in control of your data. You don't hand credentials to a third party. You don't wait 3 weeks for a review.

---

Features

• 17 MCP tools covering the full ad analytics lifecycle
• 4 MCP resources for at-a-glance dashboards
• CSV import from Google Ads Editor, Google Ads web UI, and Meta Ads Manager — with automatic format detection (US vs European number formatting, CRLF vs LF, BOM handling)
• Unified cross-platform schema — Google and Meta campaigns normalized into a single UnifiedCampaign / UnifiedMetrics model
• AI-powered recommendations — budget reallocation, scaling high-ROAS campaigns, pausing zero-conversion ones
• Bulk-edit CSV export — turn recommendations into Google Ads Editor / Meta Ads Manager CSVs you can paste straight into the dashboard for one-click bulk updates
• Statistical anomaly detection — CPC spikes, CTR drops, spend surges, sensitivity-configurable
• A/B test analysis with confidence scoring
• 9-vertical industry benchmarks built-in (eCommerce, SaaS, B2B, etc.)
• Spend & conversion forecasting (7/14/30 days)
• Demo mode — seed a realistic portfolio to try the tools before importing your own data
• 91 automated tests — TypeScript strict mode, Zod validation throughout

---

Quick Start

npm i adops-mcp-server

Add to your MCP client (Claude Desktop claude_desktop_config.json, Cursor, VS Code, Windsurf):

{
  "mcpServers": {
    "adops": {
      "command": "node",
      "args": ["path/to/node_modules/adops-mcp-server/dist/index.js"]
    }
  }
}

Restart your client. Then, inside Claude:

> Seed demo data so I can explore AdOps

(calls ad_demo_seed)

Or import your real data:

> Import ~/Downloads/google-ads-report.csv as a Google Ads CSV

(calls ad_csv_import with platform=google, csv_path=...)

---

Exporting CSV from Your Ad Dashboard

Google Ads

1. Open ads.google.com → Campaigns view
2. (Optional) Click Segment → Day in the toolbar for daily metrics
3. Click Download (⬇) icon → choose .csv format
4. Save to disk, give the absolute path to ad_csv_import

Meta Ads Manager

1. Open business.facebook.com → Ads Manager
2. Switch to Campaigns tab (not Ad Sets or Ads — campaign-level rollups)
3. (Optional) Breakdown → Time → Day for daily metrics
4. Click Reports → Export → Campaign performance (.csv)
5. Save to disk, give the absolute path to ad_csv_import

Both exports work out-of-the-box with or without day segmentation. Without a Day column, you get one aggregated metric row per campaign. With Day segmentation, you get daily time-series data — which powers forecasting and anomaly detection properly.

---

Tools

---

Resources

---

Unified Metrics Schema

AdOps normalizes metrics across platforms:

CSV column mapping:

European locale numbers (125,50 = 125.50) and semicolon-delimited CSVs are auto-detected.

---

Configuration

AdOps is stateless from the network's point of view — no API keys, no OAuth. The only configuration is where it persists imported data:

All other behavior is controlled via tool arguments.

---

Pricing

Available via GitHub (self-hosted, free) or the MCPize marketplace (managed).

---

Development

git clone https://github.com/enzoemir1/adops-mcp.git
cd adops-mcp
npm ci
npm run build
npm test           # 91 tests across 10 suites
npm run inspect    # Open MCP Inspector

Tests

91 tests covering:

• CSV parser (11 tests): RFC 4180 quoting, BOM, European/US number formats, delimiter detection
• Google Ads CSV import (7 tests): campaigns report, day segmentation, objective mapping, European locale
• Meta Ads CSV import (5 tests): Meta-specific columns, currency detection from header, objective mapping, reach/frequency capture
• Export recommendations (8 tests): Google Ads Editor CSV format, Meta Ads Manager CSV format, JSON wrapper, Markdown rendering, min_delta_pct filter, limit, by_type summary
• Storage: Connection CRUD, campaign search, metrics aggregation, batch inserts
• Analytics: Metric calculations, performance reports, forecasting, benchmarks
• Optimizer: Budget analysis, reallocation, scaling/pausing recommendations
• Anomaly: CPC spike detection, conversion drops, sensitivity, severity sorting
• E2E Workflow: 14 real user scenarios

---

Roadmap

• v1.3 — Add Google Ads Editor .csv.gz and Excel .xlsx support
• v1.4 — Live Google Ads / Meta Ads API integration as an optional enterprise feature (BYOK — bring your own developer token + app review)
• v2.0 — Multi-user server mode with JWT auth for team deployments

---

License

MIT License. See LICENSE for details.

Built by Automatia BCN.