Draft a content brief from this month's top-performing posts
Pull top blog posts from Google Analytics and create a follow-up content brief in Google Docs
Overview
Planning next months content calendar means digging through analytics to find whats working, then translating that into a brief. This template pulls your performance data and drafts the brief for you, so you can hand it to a writer the same day.
How it works
- Searches Google Analytics for the top five blog posts by page views from the last 30 days
- Notes the topic, word count, and traffic source for each
- Identifies the highest-performing topic for a follow-up post
- Drafts a content brief with suggested angle, target keyword, and recommended length
- Saves the brief to your specified Google Docs folder
Who this is for
Content and marketing managers who want to double down on whats already working without spending hours in analytics and docs.
Suggested prompt
Search Google Analytics for the top five blog posts by page views from the last 30 days. For each one, note the topic, word count, and traffic source. Then draft a content brief in Google Docs saved to [1. Folder name] for a follow-up post on the highest-performing topic, including suggested angle, target keyword, and recommended length.
Frequently asked questions
Can I change the time range?
Yes, adjust last 30 days in the prompt to any period you want to analyze.
Can I pull more than five posts?
Yes, change the number in the prompt to include as many top performers as you need.
What if I want the brief in Notion instead?
Swap Google Docs for Notion in the prompt and connect Notion to your MCP server.
Can I customize what goes in the brief?
Yes, modify the prompt to include additional sections like competitor examples or internal links to include.