Content Strategy

For the website shopify.com/blog, analyze:

1. Their top 50 pages by organic traffic - what topics drive visitors?
2. Keyword opportunities in position 4-15 (quick win content refreshes)
3. Related keywords they should be targeting but aren't ranking for
4. Competitor content from bigcommerce.com that outranks them

Create a Google Doc "Shopify Blog - 6 Month Content Strategy" with:
- Content audit summary (what's working)
- Quick wins: 10 articles to refresh with target keyword improvements
- New content: 12 article ideas with target keywords, volume, and difficulty
- Monthly editorial calendar table (Month, Article Title, Target Keyword, Priority)
- Format professionally with proper headings and bullet points

I'm writing a comprehensive guide about "project management software comparison".

1. Analyze the top 10 SERP results for this keyword
2. Get DR and traffic for each ranking page
3. Check SERP overlap with related terms: "best project management tools",
   "project management software for small business", "free project management software"
4. Identify SERP features present (featured snippets, videos, etc.)

Create a Google Doc "SERP Analysis: Project Management Software" with:
- Current SERP landscape summary
- Competitor content analysis (what makes top pages rank?)
- Content requirements for our guide (length, topics to cover, questions to answer)
- On-page optimization recommendations
- Internal linking opportunities

We have a successful English blog on cooking.nytimes.com.
Research expansion opportunities for German market:

1. Get worldwide search volume for our top 20 English keywords
2. Compare US vs Germany volume for these keywords
3. Find the German equivalents and their search volumes
4. Analyze top German cooking sites (chefkoch.de, essen-und-trinken.de) - 
   what keywords do they rank for that we could target?

Create a Google Sheet "NYT Cooking - Germany Expansion" with:
- Keyword translation and volume comparison matrix
- Top 30 German keyword opportunities
- Competitor keyword overlap analysis
- Priority ranking for localization
- Chart showing volume opportunity by category

Find "quick win" keyword opportunities for hubspot.com.
Look for keywords where they rank in positions 4-10 with:
- Search volume > 1000
- Keyword difficulty < 50

These are pages that could reach top 3 with optimization.
Give me the top 20 opportunities in a Google Sheet.

Show me the top 30 blog posts on backlinko.com by organic traffic.
For each post:
- What's the main keyword it ranks for?
- How much traffic does it get?
- What's the content format? (guide, list, how-to, case study)

Create a Google Doc summarizing:
- Content patterns that work
- Topics that drive the most traffic
- Content formats to prioritize

I have a blog at ahrefs.com/blog.
Find articles that:
- Used to rank well but have declined (positions 11-30)
- Still have good keyword volume (>500)
- Have keyword difficulty < 60

These are prime candidates for content refreshes.
Export to Google Sheets with priority ranking.

Analyze the content strategy of nerdwallet.com:
- What are their top 20 topics by traffic?
- What content formats do they use most?
- What keywords bring them the most organic visitors?
- What categories have they invested in most?

Create a Google Doc with:
- Content strategy summary
- Lessons we can apply to our own site
- Content gaps we could fill

Find keywords where healthline.com ranks in positions 2-10 
and the SERP has a featured snippet.

These are opportunities to optimize content for featured snippet capture.
Give me the top 20 opportunities with:
- Keyword
- Current position
- Search volume

Export to Google Sheets.

Create a 3-month content calendar for a B2B SaaS blog about "customer success".

1. Research the top 30 keywords related to "customer success"
2. Analyze what competitors (gainsight.com, totango.com) are writing about
3. Group keywords into themes/clusters

Create a Google Sheet with:
- Monthly content calendar (12 articles)
- Each row: Month, Week, Article Title, Target Keyword, Search Volume, Priority
- Color-code by content type (guide, how-to, list, case study)