# Reporting Ninja (MCP)

> Access to your Reporting Ninja marketing and analytics data across 20+ ad and analytics platforms (Google Ads, Meta Ads, GA4, TikTok, LinkedIn, Pinterest, Microsoft Ads, Search Console and more) for AI assistants, and the tools to turn an analysis into a real Reporting Ninja report: branded, scheduled and delivered to your client's portal.

Connector URL (MCP, Streamable HTTP): https://mcp.reportingninja.com/mcp
Auth: OAuth (browser sign-in) or an 'Authorization: Bearer <key>' header (key from the 'AI connector (MCP)' tab in Reporting Ninja).

## Tools
- list_integrations, describe_integration, list_connections, list_fields: discover integrations, connected accounts and fields.
- query_data: run a query (date-range presets or custom, filters, period-over-period compare_to, cursor pagination).
- submit_async_query, get_query_status: large or long-running queries.
- query_blend: merge several accounts/sources on a shared dimension (e.g. by date).
- get_capabilities, list_reports, get_report, list_report_templates, list_template_catalog, list_schedules, list_portal_views, list_client_users: what exists in the account and the rules a write follows.
- create_report, create_report_from_template, append_sections, create_widget: build a report out of the catalog or out of widgets you define.
- create_schedule, update_schedule, delete_schedule: have it delivered by email.
- create_client_user, create_portal_view, update_portal_view: put it in a client's portal; delete_portal_view and delete_client_user take it away again.
- delete_report, delete_section, delete_widget: remove what you created, always in two steps.

Writing is opt-in: an account owner or admin enables it in the 'AI connector (MCP)' section, and every connection of the account writes from then on. Every write takes an idempotency_key, accepts dry_run, and the irreversible ones ask for an explicit confirmation first.

## Prompts
- query_workflow_guide (start here), ppc_audit, cross_channel_roas.

## More
- Full reference: https://mcp.reportingninja.com/llms-full.txt
- Supported data sources (JSON): https://mcp.reportingninja.com/datasources
- Connection guide: https://app.reportingninja.com/userguide/1/en/topic/connecting-an-ai-assistant-mcp