Keyword Research

Analyze these 15 keywords for our office furniture client in Germany:
- Bürostuhl ergonomisch
- Schreibtisch höhenverstellbar  
- Büromöbel kaufen
- ergonomischer Arbeitsplatz
- Stehschreibtisch
- Gaming Stuhl Büro
- Home Office Möbel
- Büroeinrichtung modern
- Chefsessel Leder
- Büroschrank abschließbar
- Rollcontainer Metall
- Aktenschrank günstig
- Bürodrehstuhl Test
- Schreibtischlampe LED
- Monitorhalterung verstellbar

I need: search volume, keyword difficulty, CPC, traffic potential, and intent for each.
Then identify the top 5 quick wins (high volume + low difficulty).
Export results to a new Google Sheet named "Keyword Audit - Office Furniture DE"
with proper formatting: bold headers, alternating row colors, and conditional formatting 
(green for KD<30, yellow for 30-50, red for >50).

Analyze seasonal trends for "Weihnachtsgeschenke für Männer" and related gift keywords in Germany.
Get 12-month volume history, identify peak months, and find the top 20 related long-tail keywords.
Create a Google Doc titled "Christmas Gift Keywords - Seasonal Strategy" with:
- Executive summary of seasonality patterns
- Table showing month-by-month volume trends
- Recommended content calendar (when to publish, what keywords to target)
- List of long-tail opportunities organized by search intent

I'm working with evergreen.media - an SEO agency in Austria.
Compare our organic keyword profile against these competitors:
- searchonespots.at
- 121watt.de
- sistrix.de

Find keywords where competitors rank but we don't (keyword gap).
Prioritize by: traffic potential > 500, KD < 40.
Export findings to Google Sheets with:
- Tab 1: Full keyword gap data
- Tab 2: Quick wins (top 50 opportunities)
- Tab 3: Competitor comparison summary chart

I want to build a topic cluster around "Content Marketing" for the German market.
1. Find the top 100 related keywords and search suggestions
2. Analyze SERP overlap to identify which keywords can be grouped together
3. Identify parent topics and subtopic opportunities
4. Get volume and difficulty for all keywords

Create a Google Doc with:
- Pillar page recommendation (main topic + target keyword)
- Cluster structure diagram (use a table showing pillar → cluster relationships)
- Supporting article ideas (at least 15 articles with target keywords)
- Internal linking strategy recommendations

Get me the search volume, difficulty, and CPC for these keywords in the US:
- email marketing software
- best email marketing tools
- email automation platform

Find long-tail keywords and search suggestions for "project management software" in the US market.
Give me at least 30 variations with their search volumes.
Focus on keywords with buyer intent.

Show me the worldwide search volume distribution for "sustainable fashion".
Which countries have the highest demand?
Compare US, UK, Germany, and France volumes specifically.

Analyze the search intent for these 10 keywords:
- buy running shoes online
- how to choose running shoes
- best running shoes 2024
- running shoes vs walking shoes
- Nike running shoes review
- running shoes near me
- cheap running shoes
- running shoes for beginners
- marathon running shoes
- trail running shoes waterproof

Categorize each as: informational, commercial, transactional, or navigational.
Export to a Google Sheet with intent labels and recommended content types for each.