Zeotap CDP MCP Server

An MCP (Model Context Protocol) server that connects Claude to Zeotap's Audience and Destination APIs. Clients can ask questions in plain English — Claude handles all the API calls and ID lookups internally.

What it does

• Fetches audiences, destinations, and sync status from Zeotap
• Compresses API responses by ~85% using tiktoken so Claude can handle more data
• Joins audience + destination data (replicating your SQL join via API calls)
• Accepts org names and audience names — clients never need to know IDs

Files

Setup

1. Install dependencies

python3 -m venv .venv
source .venv/bin/activate   # Windows: .venv\Scripts\activate
pip install -r requirements.txt

2. Get your bearer token

1. Log into unity.zeotap.com
2. Open DevTools → Network tab → click any request
3. Copy the Authorization: Bearer eyJ... value (just the eyJ... part)

3. Set the token

echo 'ZEOTAP_TOKEN=your-token-here' > .env

⚠️ Tokens expire every 1 hour. Repeat step 2–3 when you get a 401 error.

4. Run with MCP Inspector (for testing)

npx @modelcontextprotocol/inspector .venv/bin/python server.py

Open the URL printed in the terminal.

Adding a new org

Each org needs two IDs. Find them from DevTools when browsing that org in the Zeotap app:

Update tools.yaml:

audience_org_id: 1918
org_uuid: "efc1d9ad-8bb2-48a2-8c84-46f2e9f2b9b4"
org_name: "Your Org Name"

Tools

Example Claude queries

Once connected to Claude Desktop, clients can ask:

Connect to Claude Desktop

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "zeotap-cdp": {
      "command": "/Users/megha/Documents/MCP1/.venv/bin/python",
      "args": ["/Users/megha/Documents/MCP1/server.py"],
      "env": {
        "ZEOTAP_TOKEN": "your-token-here"
      }
    }
  }
}

On Mac, the config file is at: ~/Library/Application Support/Claude/claude_desktop_config.json

Restart Claude Desktop after updating the config.

Audience ↔ Destination Join

The get_org_full_report tool replicates this SQL join via two API calls:

SELECT fpa.name, fpa.status, csw.status, ip.int_partner_name
FROM public_audience_destinations pad
JOIN public_first_party_audience fpa ON pad.first_party_audience_id = fpa.id
JOIN public_channel_service_workflow csw ON pad.latest_channel_service_workflow_id = csw.id
JOIN public_integration_partner ip ON pad.channel_id = ip.int_id
WHERE fpa.org_id = 1918

Token reduction