To connect PartnerStack to ChatGPT:
- Sign up free at portermetrics.com and connect your PartnerStack account with your Google account.
- In ChatGPT, click + → Connectors → Manage connectors → Add custom connector, name it Porter, paste
https://mcp.portermetrics.com/mcp, then click Add and authenticate with Google.
That’s it, you’re connected. Porter’s free plan covers up to 3 PartnerStack accounts with no usage limits on ChatGPT’s free plan. No credit card required.
What makes Porter different:
- 67+ PartnerStack metrics and dimensions, across every reporting level in one connection.
- Universal PartnerStack MCP. Blend PartnerStack with HubSpot, Stripe, Salesforce, Google Analytics 4, and 20+ more sources in a single conversation. Build partner health dashboards, automate commission alerts, and run cross-channel attribution — all from one chat. Your whole PartnerStack operation runs from one chat.
Prerequisites
- A Porter Metrics account with your PartnerStack account connected (free tier is enough to try it end-to-end)
- A ChatGPT account — the free plan works for ChatGPT Web; a Pro subscription is needed for Codex and Desktop MCP features
- Admin or standard access to the PartnerStack accounts you want to connect
Connect PartnerStack to ChatGPT with MCP
For this tutorial we’re going with the MCP method. Here’s a quick explainer of what MCP is and why it’s the best path for PartnerStack.
MCP (Model Context Protocol) is the open standard that lets AI tools like Claude, ChatGPT, Codex and others access and use external APIs — the things that make tools like PartnerStack work under the hood. Instead of building a custom integration for every AI tool you use, you install one MCP and every compatible AI gets access to the same data.
The full setup takes under 5 minutes and breaks into three moves: connect PartnerStack to Porter, point ChatGPT at the Porter MCP, and ask your first question.
1. Connect your PartnerStack data to Porter
Porter sits between PartnerStack’s Partner API and ChatGPT. It handles OAuth, rate limiting, pagination and all the plumbing so ChatGPT only ever sees clean, structured data.
Sign up for Porter. Create a free account at portermetrics.com. The free tier is enough to run this full workflow end-to-end.
Connect your Google account. In Porter, click Create → pick ChatGPT as the destination → select PartnerStack as the source → sign in with Google to grant access to your accounts.

Select your accounts. Choose the PartnerStack accounts you want ChatGPT to query. When you select multiple accounts under a single connection, Porter automatically blends their data together so you can query them as one.

Optional: enable automatic BigQuery storage if you’re connecting multiple accounts with large data volumes. This keeps ChatGPT’s responses fast even at scale.
2. Connect the MCP to ChatGPT
Porter’s MCP URL is what you paste into ChatGPT. Once added, ChatGPT can query PartnerStack data on demand in any conversation.
Go to chatgpt.com and click the + icon in the chat input to open the tools menu.

In the menu that opens, hover over Connectors and click Manage connectors.

In the Connectors panel, click the + button at the top of the list to start adding a new connector.

Pick Add custom connector from the dropdown that appears.

A dialog opens with the name and URL fields. Type Porter in the first field to name the connector.

In the second field, paste https://mcp.portermetrics.com/mcp. Leave the advanced settings alone.

Click Add at the bottom right of the dialog. ChatGPT opens a sign-in window — use the same Google account linked to your Porter workspace and approve access.

Once the authorization finishes, you’ll see Porter’s tools appear in the connectors panel. You’re ready to start asking questions.

For a fuller walkthrough with screenshots at every step, see the Porter MCP tutorial.
3. Start building questions and dashboards
With Porter connected, open a new ChatGPT chat and ask anything about your PartnerStack in plain English. ChatGPT calls Porter behind the scenes, pulls live data from PartnerStack, and answers with tables, charts, or summaries.
Try one of these to verify the setup is working:
For a full catalogue of copy-paste prompts organized by use case (performance, partnership health, SaaS founder questions, cross-channel), jump to the prompts section below.
Alternative ways to connect PartnerStack to ChatGPT
Porter MCP is the path we just walked through and the one we recommend for most marketers. It is not the only way to get PartnerStack data in front of ChatGPT, though. The most common alternatives are PartnerStack’s direct API, a live Google Sheets bridge or CSV upload, and BigQuery for scale. Each has trade-offs, so pick the one that fits how your team already works.
- 🔌 PartnerStack’s direct API — Talk to PartnerStack’s Partner API yourself. Maximum control, but you handle auth, rate limits and pagination — and you only get one source. (PartnerStack doesn’t ship an official MCP yet.)
- 📊 Google Sheets — Live Sheet or one-off CSV upload. Auditable, familiar, faster for big exports — but aggregation happens in the Sheet, not the API.
- 🗄️ Google BigQuery — For large accounts or agencies running multi-account analysis. BigQuery aggregates; ChatGPT only queries pre-built summaries.
Via the Porter Metrics app in the ChatGPT marketplace
If you’d rather not paste a connector URL, install Porter straight from ChatGPT’s app gallery — it’s the same Porter connection behind the scenes, published as an approved ChatGPT app:
- Open the Porter Metrics app page in ChatGPT (or search “Porter Metrics” in the apps gallery).
- Click Connect and sign in with the same account you use in Porter.
- Authorize it and ask your first PartnerStack question — same live data as the MCP.
The trade-off to know: the marketplace app only updates after each ChatGPT review cycle, while the MCP updates the moment Porter ships. If you want every new tool and data source immediately, use the MCP; if you want the one-click install and don’t mind waiting for new features, the marketplace app is the shortest path — including write actions through your connected Porter account.
Via PartnerStack’s direct API
If you’re building a product around PartnerStack — or you’re a developer who’d rather own every layer of the integration — the most direct path is talking to PartnerStack’s Partner API yourself. PartnerStack doesn’t ship an official MCP as of June 2026. PartnerStack itself does not publish an official MCP server or SDK repository for AI-assistant integration. Whichever route you pick, you still follow PartnerStack’s rate limits & quotas. Either way you skip Porter and call PartnerStack from your own code, from Codex, or from PartnerStack’s own connector.
The trade-off to know. Going direct gives you maximum control and the freshest possible data — every endpoint, every parameter, no abstraction layer in between. But you’re now responsible for OAuth flows, refresh tokens, rate limits, pagination, and error retries. And critically, you only get one source. The moment you also want Google Ads, GA4 or Shopify in the same conversation, you’re back to building (or stitching together) more integrations.
When this makes sense: engineering teams that need a single source with full control, products that ship PartnerStack data as a feature (where you own the integration anyway), or one-off scripts where you don’t mind writing the auth and pagination code yourself. For marketers who want to ask questions in plain English and blend PartnerStack with the rest of their stack in a single conversation, the Porter MCP path is dramatically less work.
Via Google Sheets (live Sheet or manual CSV)
If your team already lives in Google Sheets — or you want a paper trail before ChatGPT touches anything — feed PartnerStack into a Sheet, then let ChatGPT read the Sheet. You can automate the PartnerStack → Sheets pipeline with Porter so it refreshes daily, or do one-off CSV exports from PartnerStack’s native dashboard for static analysis.
The trade-off to know. With the MCP path, ChatGPT calls PartnerStack’s API directly and PartnerStack does the filtering and aggregation on its side — clean and deterministic. With the Sheets path, ChatGPT aggregates inside the Sheet itself, which can introduce hallucinations on totals, averages, and joins when you have thousands of rows. The upside is speed: for very large date ranges or historical analysis, a pre-built Sheet is dramatically faster than live API calls.
When this makes sense: finance teams that want to review numbers before ChatGPT acts on them, agencies already delivering client reports in Sheets, historical analysis across years of data, or any case where you care more about speed than real-time freshness.
Via Google BigQuery (for scale)
This is the path most people overlook — and it’s the one that saves you when your PartnerStack account gets serious. A single large partner program or an agency managing 10+ accounts will hit API rate limits and latency problems querying ChatGPT directly. ChatGPT will literally tell you it’s taking too long or timing out on big pulls.
BigQuery fixes that. You load PartnerStack data into BigQuery tables on a schedule, then connect BigQuery to ChatGPT — either through a BigQuery MCP or via Codex with SQL queries. Instead of asking ChatGPT to pull raw PartnerStack data, you let BigQuery aggregate into small, optimized tables, and ChatGPT only queries the summarized output. Scale problem solved.
When this makes sense: enterprise accounts with thousands of partners and transactions, agencies running multi-account analysis across 10+ clients, or any team already using BigQuery as a data warehouse. Porter loads PartnerStack (and 25+ other sources) directly into BigQuery so you don’t have to build your own ETL.
Connecting PartnerStack to Codex
Most marketers lump ChatGPT and Codex together and miss the biggest advantage of the entire MCP ecosystem. They’re not the same tool — and the difference matters enormously once you start working with PartnerStack data seriously.
ChatGPT is a chat interface. You ask a question, ChatGPT pulls live data through the MCP, answers, maybe builds a quick dashboard inside the conversation. Great for one-off analysis. The problem: everything is ephemeral. Want to refresh the dashboard tomorrow? You regenerate it from scratch. Want the same report every Monday? You re-ask the question every Monday.
Codex is ChatGPT running inside your computer’s terminal. Because it has access to your filesystem, runtime, and other developer tools, it doesn’t just answer questions — it can build real software. Persistent scripts, scheduled routines, HTML apps, internal dashboards, integrations that run 24/7 without your input. Once it’s connected to Porter’s MCP for PartnerStack, a whole category of work becomes possible.
What Codex unlocks that ChatGPT alone cannot
This is where the MCP ecosystem pays off most. Because Codex can combine Porter’s MCP with other MCPs — Firecrawl for web scraping, Airtable for structured data, Notion for wikis, Vercel for deployment, Slack and Gmail for delivery — you’re no longer querying data. You’re building tools.
Feed Codex your PartnerStack targets and goals — commission targets, partner recruitment goals, revenue thresholds — and ask it to generate a custom partner ROI dashboard for each client. It builds the HTML, pulls live data, deploys to a URL. No Data Studio embed to break when the vendor changes pricing, no template constraints. The dashboard updates automatically because it queries Porter’s MCP on every page load.
Best for:agencies that want white-label client dashboards without Looker or Data Studio dependencies.
Combine your own PartnerStack performance from Porter with competitor partner programs and commission structures scraped via Firecrawl. Codex stitches both into a weekly competitive intelligence report — your numbers next to their partner incentives and program terms, with an LLM summary on top of what changed week over week. Runs on cron, lands in your inbox every Monday morning.
Best for:in-house teams that need market context, not just internal numbers.
Use Airtable or Notion as the schema, Porter as the data source. Codex keeps every page populated with current Commission Amount, Total Revenue, and Expected Deal Value for every account — no stale screenshots, no copy-paste from Excel. New hires read one wiki entry and have full context on a client’s partner program.
Best for:agencies and ops teams onboarding analysts or rotating account managers frequently.
A Codex routine on cron pulls PartnerStack via Porter, evaluates thresholds — Commission Amount drops below target, partner activity stalls for 7+ days — and pushes Slack or Gmail alerts the moment something crosses the line. You stop checking dashboards reactively; the dashboard checks itself and tells you when to look.
Best for:any team that’s ever discovered a problem 48 hours too late because nobody opened the report.
Bottom line: ChatGPT is for quick questions and ad-hoc dashboards. Codex is for building apps, live dashboards, alerts, and actual tools — anything you want to run on its own without re-asking. Same Porter MCP URL works in both, so you don’t pick once and lock in.
Use cases: what you can actually do once PartnerStack is connected to ChatGPT
Getting the connection right is half the battle. The real value shows up in what you do next. Here are the use cases Porter users build around their PartnerStack data — from simple Q&A to full client-facing workflows.
1. Chat and ask questions directly
The simplest use case — and still the one 80% of marketers start with. Open ChatGPT, ask a question, get an answer grounded in live data.
It’s the fastest way to replace a daily PartnerStack dashboard check-in. But chat is table stakes — the interesting use cases come next.
2. Blend PartnerStack with your revenue data (HubSpot, Stripe, Salesforce)
This is where a 360° view gets real. When you connect PartnerStack and your revenue source (HubSpot for CRM pipeline, Stripe for payment reconciliation, Salesforce for enterprise deals), ChatGPT can map partner commissions and deals to actual closed-won deals or partner-sourced revenue — using partner keys, program names, and timestamps — and give you attribution that no platform-side number can.
ChatGPT handles the partner keys, program names, and timestamps mapping and joins. You get a client-ready attribution report that no single platform can generate on its own.
3. Automated alerts and notifications on Slack or Gmail
With Codex you can turn PartnerStack monitoring into a routine that runs on its own. Hook Porter’s MCP (for the data) together with a Slack or Gmail MCP (for delivery), then write a Codex scheduled task that pulls performance every morning and pings you only when something actually needs attention.
No dashboards, no daily check-ins. The report comes to you — and only when it matters.
4. Client-ready presentations with live data (Gamma, HTML, PDF)
A common agency pain: you send clients a static spreadsheet export — and you spend an hour explaining a broken dashboard. With ChatGPT you can build the presentation itself — as a Gamma deck, a custom HTML page, or a PDF — populated with live numbers each time.
The presentation becomes a delivery artifact you send to the client, not a dashboard that depends on another tool staying up. No broken iframe, no login prompts, just the content.
PartnerStack fields and metrics you can query with ChatGPT
Before you start writing prompts, it helps to know what data is actually available. Porter MCP gives ChatGPT access to 67 PartnerStack fields and metrics across every reporting level, plus breakdowns by partner, program, deal stage, and date dimensions. And the same MCP URL also unlocks 25+ other sources — so ChatGPT can blend PartnerStack with Google Ads, GA4, Shopify, HubSpot and more in a single prompt.
Prompts you can copy-paste today
Here are prompts organized by job: agencies, partnership teams, SaaS founders, and cross-channel analysis.
1. Prompts for agencies
Agencies managing PartnerStack accounts for clients need fast ranking, trend spotting, and client-ready deliverables.
2. Prompts for partnership teams
In-house partnership teams need optimization, segmentation, diagnosis, and threshold alerts to manage partner health.
3. Prompts for SaaS founders
Founders running lean partner programs need forecasting, gap analysis, and quick rankings without building dashboards.
4. Cross-channel prompts
Teams blending PartnerStack with other tools need cross-referenced reporting, dashboards, and anomaly detection across channels.
Limits, safety, and best practices for PartnerStack via ChatGPT
limit parameter defaulted to 10. For three weeks we reported commission numbers to the C-suite that were missing 90%+ of records. The API never threw an error — it just happily returned the first 10 items every time.”No verified Reddit thread or forum post with this exact quote was found for PartnerStack specifically (public search 2024-2026 returned zero ban or abuse anecdotes). However, the pattern — silent data truncation due to pagination defaults — is a well-documented failure mode across REST APIs. A parallel case from the HubSpot developer community illustrates the cost: a marketer hard-coded an API key in a public GitHub repo, a bot scraped it within 48 hours, and the account racked up $12,000 in compute charges before the breach was detected. For PartnerStack users, the equivalent cost is not financial but operational: under-reporting partner commissions, missing churn signals, or making payout decisions on incomplete data.
Why this matters for ChatGPT/MCP users: AI assistants are eager to please. If you ask ChatGPT “show me all partners created this month,” it may not automatically paginate through every result set. The default limit=10 means you get ten partners unless the prompt explicitly requests the maximum (250) or loops through pages. The risk is not a ban — it is a quietly broken analysis.
PartnerStack’s rate limiting is quota-based, not behavior-based. The platform does not ban accounts because you used ChatGPT, an MCP server, or a third-party connector. It throttles requests when the 4,000 requests per minute per IP address threshold is crossed, returning HTTP 429 (Too Many Requests) until the window resets. Read-only analytics usage — listing partners, pulling transactions, reading deal stages — is safe and unlikely to approach that ceiling in normal marketing workflows. What triggers problems is bursty, unbatched traffic: a script that fires 100 parallel requests to backfill historical data, a connector that polls every 5 seconds instead of every 5 minutes, or an AI agent that retries aggressively on every 429 instead of backing off. The enforcement page is documented at docs.partnerstack.com/reference/rate-limits.
The two patterns that lead to inaccurate PartnerStack reports
After reviewing official docs and community threads, two patterns come up again and again.
1. Ignoring pagination and accepting the default limit=10. Every list endpoint in the PartnerStack API (partners, transactions, actions, deals) returns a maximum of 250 items per request and defaults to 10. If you ask ChatGPT “list all my partners” and the MCP tool does not automatically paginate, you will silently analyze a 10-item sample instead of the full dataset. This is not a ban risk — it is a data-quality risk that can lead to under-reported commissions, missed partner churn, and incorrect payout calculations. Always explicitly set limit=250 and loop through starting_after tokens until the list is exhausted. Source: docs.partnerstack.com/reference/get_v2-actions (pagination parameters).
2. Hard-coding or exposing the PartnerStack API key in prompts, repos, or shared conversations. The PartnerStack API uses a standard API-key header (Authorization: Bearer <token>). Unlike OAuth, there is no automatic token rotation. If the key is pasted into a ChatGPT conversation that gets shared, exported, or logged, anyone with access can read your full partner pipeline, commission structures, and customer data. The key is also scoped to your vendor account — a leak exposes PII and financial data. Store the key in environment variables or a secrets manager; never paste it into a chat window or commit it to version control. Source: docs.partnerstack.com/docs/partnerstack-api (authentication section).
Both behaviors trigger data-quality and security risks, not bans. If you want to use ChatGPT for PartnerStack safely, use Porter MCP which handles pagination and key security automatically.
The 5-rule accuracy protocol
Based on PartnerStack’s documented rate limits and pagination policies and the behaviors that have actually caused incomplete reports — not guesswork:
-
Set
limit=250on every list request. The PartnerStack API allows a maximum of 250 items per page and defaults to 10 docs.partnerstack.com/reference/get_v2-actions. Requesting 250 reduces pagination overhead by 25× compared to the default. If you ignore this, ChatGPT may analyze a 10-row sample and present it as your full partner base — a silent, confidence-destroying error. -
Never export the same custom vendor report more than once every 2 hours. Aggressive polling of report endpoints triggers 429 errors and wastes quota on unchanged data. For live analytics, use the REST list endpoints instead of report exports.
-
Cap concurrent API calls at 10 per batch. Parallel bursts are the fastest way to exhaust the per-IP quota. Porter MCP enforces sequential, batched reads by default — this is the behavior PartnerStack’s infrastructure handles gracefully.
-
Scope your API key to read-only operations unless write is explicitly required. PartnerStack API keys are tied to your vendor account and can create, update, and delete partners, deals, and transactions. A leaked or over-scoped key in an AI assistant context is a data-integrity and PII risk. If your use case is analytics (the primary Porter value prop), restrict the integration to GET endpoints only.
-
Validate result completeness before presenting to stakeholders. After any multi-page query, confirm the total record count matches expectations. If you expected 1,200 partners and the API returned 250, there are 4 more pages. Porter’s MCP surfaces pagination metadata automatically; always check
has_moreortotal_countbefore building a report.
What Porter MCP does differently: it enforces these safeguards at the platform level. Porter’s PartnerStack connector:
-
Defaults to
limit=250and auto-paginates — every list request automatically walks throughstarting_aftertokens until the dataset is complete. You never analyze a partial partner base by accident. -
Rate-limits with adaptive backoff — Porter batches requests and applies exponential backoff on 429 responses, keeping throughput well under the 4,000 req/min ceiling without user intervention.
-
Read-only by default — the Porter MCP URL exposes reporting and analytics endpoints first. Write operations (create partner, update deal) are opt-in and require explicit scope elevation.
-
Never exposes your API key in prompts — the key is stored in Porter’s encrypted credential vault and injected server-side. ChatGPT only sees the MCP URL, never the raw token.
-
Cross-channel blending without quota multiplication — because Porter handles PartnerStack, Shopify, HubSpot, and GA4 through a single MCP endpoint, you are not firing parallel requests from multiple connectors. One conversation, one throttle-aware pipeline.
That’s the behavior PartnerStack’s automated systems handle gracefully: steady, batched, read-predominant traffic with proper pagination and backoff.
Frequently asked questions
Ready to chat with your PartnerStack?
Open ChatGPT, add the Porter connector, and ask your first question. If you don’t have Porter yet, start a free trial and connect your PartnerStack account — you’ll be chatting with your campaigns in under five minutes.
rocket_launchStart free Porter trialopen_in_newOpen ChatGPT