MarketingContent Strategistintermediate 45 min saved

Data-Driven Content Strategy Generator

Transform raw Google Analytics data into an actionable, high-performance content calendar in seconds.

Customise & copy

Add the context you have. The prompt updates as you work.

Target Audience / Niche *

Define your current target audience or niche.

Top Pages by Pageviews *

Enter top pages by pageviews and unique users from last month.

Engagement Metrics *

Enter average time on page and bounce rates for key content categories.

Traffic Acquisition Channels *

Select your dominant traffic acquisition channel breakdown.

Live prompt

4 fields

Analyze the provided Google Analytics data for B2B SaaS Content Marketing and generate a data-backed content plan for the upcoming month.

### Inputs Provided:
- Top Pages & Metrics: /blog/seo-audit-checklist (15,400 PV, 12,100 UV), /pricing (8,200 PV, 6,500 UV)
- Engagement Metrics: Guides category: Avg time on page 4:30, 42% bounce rate. Product pages: Avg time on page 1:15, 68% bounce rate.
- Traffic Channels: Organic Search Heavy (65%+)

### Instructions:
1. Provide a concise performance summary highlighting top content drivers and drop-off points based strictly on the provided data.
2. Outline 3-5 data-backed content topics mapped to specific audience intent and traffic channels.
3. Create a structured content calendar outline including formats, primary keywords, and success metrics.

Do not invent fake traffic numbers or statistics. Avoid conversational filler, hype openers, and methodological explanations.

Proof before you use it

A real example

Tested on gemini-3.1-flash-lite on 2026-09-02

{
  "niche": "Direct-to-Consumer Sustainable Fashion",
  "top_pages_data": "/shop/organic-cotton-tees (22,500 PV), /journal/supply-chain-transparency (9,100 PV)",
  "engagement_data": "Product page: 1m 05s avg time, 55% bounce rate. Journal article: 5m 12s avg time, 31% bounce rate.",
  "traffic_channels": "Social Media Heavy (65%+)"
}

A small ritual that works

How to use it

01Export your top pages, engagement metrics, and traffic source data from Google Analytics.
02Paste the data into the corresponding input fields in the prompt.
03Define your niche to ensure the generated topics align with your audience intent.
04Review the output and implement the suggested content calendar directly into your workflow.

Why it works

The prompt successfully enforces a structured framework for analyzing provided Google Analytics inputs (pageviews, unique users, engagement metrics, and traffic channels) and translating them into a data-backed content plan, performance summary, and structured calendar without allowing conversational filler or hype.

Where it fails

INSUFFICIENT_EVIDENCE

Customisation tips

To adapt this prompt for different analytical frameworks, explicitly specify the exact metrics available in your analytics tool (e.g., event tracking, ecommerce conversions) and adjust the required output format to match your specific publishing cadence or content distribution channels.

Watch-outs

Avoid assuming specific user intent or funnel stages when the input data only provides raw pageviews, bounce rates, and time on page.
Do not permit the model to invent numerical performance targets, percentage improvements, or success thresholds that were not present in the original inputs.
Ensure the model strictly utilizes the specified traffic acquisition channel provided in the variables rather than introducing unlisted distribution channels.

Works in

ChatGPTClaudeGemini

Was this useful?

Submit your variation

If your version helps, it may be published with your name and a link back to you.

Want to make AI useful across your team? Explore Atul's training.