How to Automate Your Social Media Reports with AI [Claude+Metricool]

If you’re managing social media for multiple clients at your agency, monthly reports are probably the one task you most want off your plate. That day spent copy-pasting numbers, formatting and writing summaries? Gone for good. 

Here’s what changes with Metricool’s MCP connection: you connect your Metricool account (all your brands included) with Claude, and it reads your data directly. 

Ask it anything you’d normally spend time digging through your dashboard for, and it pulls the numbers and writes the narrative for you. That means no more losing the last Friday of every month to reporting.

This guide shows you exactly how to set it up and the four prompts that build a complete client report. 

What is Metricool’s MCP and Why it Matters for Reporting 

Metricool’s MCP (Model Context Protocol) is the server that connects your Metricool account with Claude. Once it’s set up, Claude can: 

• read your analytics and prepare reports on them
• check your best times to post
• schedule posts
• pull competitor performance data

You don’t even need to open the dashboard, just ask Claude whatever you need. Thanks to this direct connection, you won’t receive generic answers the AI guessed about your performance, and you’ll no longer need to copy and paste data into an AI. Claude reads your analytics, your scheduled posts, your competitor data, and more, directly.

How to Connect Metricool to Claude 

The setup should take no longer than five minutes and you don’t need any experience with coding. These steps are for Claude.ai.

If you don’t have a Metricool account yet, create one for free. The connection works on every plan, including free*. 

1. Open Claude and click your profile icon in the bottom left corner, then go to Settings and from there to ‘Connectors’.

2. Click ‘Go to Customize’. Next to ‘Connectors’, you’ll see a magnifying glass and a ‘+’ icon – tap the ‘+’ icon and click ‘Add custom connector’.
3. A window will pop up. Add the name of your connector here (e.g. ‘Metricool’) and paste in the server URL: https://ai.metricool.com/mcp. Hit ‘Add’ when you’re ready. 
4. A Metricool login prompt will appear. Sign in and click ‘Grant access’. 

That’s it! All your Metricool brands are now accessible to Claude.

*Free plan users: the MCP connection works on all plans. The limitations that apply are those of your plan. For example, with the free account you cannot access data older than 3 months nor schedule more than 20 posts. Paid plans extend these limits.

The New Routine: 4 Prompts That Build a Complete Client Report 

Once your connection is live, run these four prompts in sequence once a month. Each one feeds into the next, so by the end you have a full narrative report ready to share or lightly edit.

Prompt 1: Pull the core numbers 

📝 “Give me the key performance metrics for [brand] across Instagram, LinkedIn, and TikTok for the last 30 days.”

What it returns: Follower growth, reach, impressions, engagement rate, and total posts published per network pulled directly from your Metricool data. Claude formats these into a clean summary table.

Adaptation tip: Replace the networks with whichever platforms your client uses. For e-commerce clients, add “and break out any link clicks or website traffic” to the prompt.

Prompt 2: Find what worked and why 

📝 “Looking at [brand]’s posts from the last 30 days, which content performed best in terms of engagement and reach? What do the top posts have in common – format, topic, posting time, or tone?”

What it returns: A ranked breakdown of your top-performing posts with engagement numbers, plus Claude’s pattern analysis across format (Reel vs. carousel vs. static), topic category, and approximate posting window. This is the section clients actually read.

Adaptation tip: For video-heavy clients, add “and compare average watch time on Reels vs. TikTok” to push Claude to surface platform-specific insights. For B2B clients on LinkedIn, add “and note which post topics drove the most profile visits.”

Prompt 3: Compare against last month and flag trends 

📝 “Compare [brand]’s engagement rate and reach from this month against last month. What are the biggest positive and negative changes, and what might explain them?”

What it returns: A month-over-month comparison with percentage deltas, plus Claude’s interpretation of the shifts — tying them to posting frequency changes, content mix, or external factors where it can infer them from the data.

Adaptation tip: If the brand runs paid campaigns alongside organic, add “separate paid and organic reach where possible” so the comparison is meaningful. For seasonal businesses, add “and note whether this aligns with expected seasonal patterns.”

Prompt 4: Write the client-facing summary 

For this one, it’s best to upload a template and ask Claude to fill it out. 

📝 “Based on the data from the previous prompts, fill in this report template and output it ready to share with a client. Use this structure:

• Executive summary (2–3 sentences on overall performance)
• Network-by-network breakdown (followers, reach, impressions, engagement rate, posts published)
• Top content this month (top 3 posts, what they had in common)
• Month-over-month comparison (key metric deltas and what explains them)
• What we learned (3–5 bullet points)
• Recommendation for next month (one specific, actionable suggestion)

Keep it clear, avoid jargon, and write it for a client who doesn’t live in dashboards.”

What it returns: A fully populated report, structured and ready to share. Claude fills in every section from the data it pulled in Prompts 1–3.

Adaptation tip: Add “write it in the voice of a strategic consultant, not a data analyst” if your client expects premium positioning. For retainer clients, add “and reference last month’s recommendation to show continuity.”

How to Schedule the Monthly Automation 

Running the four prompts once is useful. Building a repeatable system is what turns this into a real time-saver. Here’s a workflow that keeps the process under 20 minutes per client once it’s set up.

When to run it

Run the report on the first or second working day of the new month, while the previous month’s data is complete and fresh. Set a recurring calendar reminder for the same day each month; the consistency also makes month-over-month comparisons cleaner because you’re always pulling the same window.

Save your prompts as templates

Keep a simple text file (or a Notion page) with your four prompts pre-filled for each client – brand name, platforms, and any client-specific additions already in place. When report time comes, you’re copy-pasting, not rewriting. For agencies with multiple clients, give each client their own section with their customised prompt variants.

Build in a 20-minute human review

Claude’s output is a strong first draft, not a finished report. Reserve 20 minutes to:

• check any numbers that look surprising against the Metricool dashboard directly
• add one or two sentences of context Claude couldn’t know, like a campaign that launched mid-month, a product announcement that drove a spike
• adjust the recommendation if you have a strategic reason to push in a different direction

Your expertise is the layer on top; the automation handles the data gathering and first-draft writing.

Multi-client workflow

For agencies managing five or more brands, batch the report runs on the same morning. Run Prompt 1 for all clients first, then cycle through Prompts 2–4 per client. This keeps Claude’s context focused. Most agencies find this cuts reporting time from a full day to a focused two-hour block.