Weekly YouTube and Twitter Performance

For a content team that wants weekly learnings without the weekly data wrangling. One prompt pulls the numbers across channels, spots the top performer, and recommends which format to lean into next.

YouTubeTWTwitterGAGoogle Analytics

The grind

Performance reviews happen monthly at best

Here's what doing this by hand looks like today, and why it doesn't scale.

The numbers exist, but pulling YouTube, Twitter, and Google Analytics into one view takes a whole morning, so it only happens once a month and the learnings arrive late.
YouTube analytics sit in one tab, Twitter in another, and Google Analytics in a third.
The same what worked analysis gets redone from scratch every time.
Wins on one channel never make it across to the others.

MewCP collapses all of this into one prompt. Here's what that looks like.

The flow

5 steps · 3 servers

Your agent runs it end-to-end

Pull the week's YouTube metrics, including views, watch time, and click through rate.

Pull Twitter engagement and the top performing hooks.

Pull blog sessions and the top articles from Google Analytics.

Find the format with the highest engagement per session.

Post the digest to Notion under Content and the week of the date.

The payoff

Weekly learnings instead of monthly postmortems

The team sees what is working every Monday, and the formats that win get scaled while they are still hot.

Paste this into Claude, Codex, or any MCP-connected agent. It'll connect your apps and run the task from start to finish.

Run it yourself

Copy the prompt

prompt

Goal: Weekly YouTube and Twitter Performance

MCP servers needed (connected through MewCP): YouTube, Twitter, Google Analytics

Steps:
1. Pull the week's YouTube metrics, including views, watch time, and click through rate.
2. Pull Twitter engagement and the top performing hooks.
3. Pull blog sessions and the top articles from Google Analytics.
4. Find the format with the highest engagement per session.
5. Post the digest to Notion under Content and the week of the date.

Check with me before sending any message or changing data in a connected app.

More recipes

AHSE