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 AnalyticsThe 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.
TWPull blog sessions and the top articles from Google Analytics.
GAFind 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
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.
