# SISTRIX Content Integration Guide

**Last Updated:** 2026-03-24  
**Purpose:** Comprehensive guide to using SISTRIX data for content optimization, including competition analysis, PAA questions, search intent, and SERP features

## Overview

This guide explains how to use SISTRIX data to make data-driven content decisions. SISTRIX provides valuable insights into keyword competition, search intent, People Also Ask (PAA) questions, SERP features, and domain opportunities that can inform content strategy and optimization.

**Blog keyword workflow (primary/secondary order, ideas API, GSC vs new posts):** See [docs/content/blog/KEYWORD_RESEARCH_WORKFLOW.md](../content/blog/KEYWORD_RESEARCH_WORKFLOW.md).

## Reader-facing prose vs internal research

Use SISTRIX exports, PAA lists, SERP feature notes, and keyword metrics **only in** planning files under `docs/content/blog/posts/.../` (e.g. `data/keywords-sistrix.json`, `SERP_ANALYSIS.md`, `CONTENT_OUTLINE.md`). **Do not** paste methodology into published copy: avoid terms like „PAA“, „SERP“, „SISTRIX“, „Suchanfragen“ (as meta-commentary on search behaviour), or outline filenames inside `content-draft.html`, live `content.html`, or reader-facing FAQ answers.

When this guide says **target PAA questions** or **use PAA in content**, it means: **cover the underlying user questions** in natural German (H2 sections or FAQs)—not **name** PAA, People Also Ask, or SEO tools in the article.

**Validation:** `php v2/scripts/blog/validate-reader-facing-copy.php` (also runs under `make validate-blog`). Full report: `python3 scripts/blog/scan-reader-facing-meta-language.py`. Editorial rules: [READER_FACING_COPY_GUARDRAILS.md](../content/blog/READER_FACING_COPY_GUARDRAILS.md).

## SISTRIX Data Types

### 1. Keyword Competition Levels

**Location:** `docs/content/blog/posts/{category}/{slug}/data/keywords-sistrix.json`

**Data Structure:**

```json
{
  "keyword": "digitale zeiterfassung",
  "competition": 45,
  "search_volume": 1200,
  "position": 12,
  "trend": "rising"
}
```

**Competition Levels:**

- **Low (< 30):** Quick optimization wins, easier to rank
- **Medium (30-60):** Content expansion needed, moderate effort
- **High (> 60):** Long-term strategy, significant effort required

**Content Optimization Use Cases:**

**Low Competition (< 30):**

- Quick optimization wins
- Focus on meta tags, internal linking
- Add comprehensive content
- Target featured snippets

**Medium Competition (30-60):**

- Content expansion needed
- Add more depth and examples
- Improve internal linking
- Target PAA questions

**High Competition (> 60):**

- Long-term content strategy
- Comprehensive, authoritative content
- Strong backlink strategy
- Focus on user experience

### 2. Search Intent Classification

**Location:** `docs/content/blog/posts/{category}/{slug}/data/search-intent.json`

**Data Structure:**

```json
{
  "keyword": "digitale zeiterfassung",
  "intent": "informational",
  "confidence": 0.85,
  "sub_intent": "how-to"
}
```

**Intent Types:**

- **Informational:** User wants to learn (guides, explanations, tutorials)
- **Transactional:** User wants to buy/use (product pages, tools, templates)
- **Navigational:** User wants to find specific brand/page
- **Commercial:** User wants to compare/consider (comparison pages)

**Content Optimization Use Cases:**

**Informational Intent:**

- Expand content depth
- Add comprehensive explanations
- Include examples and use cases
- Add FAQ section
- Target featured snippets

**Transactional Intent:**

- Clear value proposition
- Product/service benefits
- Use cases and examples
- Clear call-to-action
- Conversion-focused content

**Navigational Intent:**

- Clear branding
- Easy navigation
- Internal linking
- Brand mentions
- Authority signals

**Commercial Intent:**

- Comparison content
- Pros and cons
- Feature comparisons
- Clear recommendations

### 3. People Also Ask (PAA) Questions

**Location:** `docs/content/blog/posts/{category}/{slug}/data/serp-features.json`

**Data Structure:**

```json
{
  "paa_questions": [
    {
      "question": "Wie funktioniert digitale Zeiterfassung?",
      "position": 1,
      "answer_length": 45
    }
  ]
}
```

**Content Optimization Use Cases:**

**FAQ Generation:**

- Use PAA questions as FAQ items
- Provide comprehensive answers (40-60 words)
- Add FAQ schema markup
- Place FAQ section after main content

**Featured Snippet Optimization:**

- Target PAA questions in content
- Provide direct, concise answers
- Use structured formats (lists, tables)
- Place answers in first 100 words

**Content Expansion:**

- Add sections addressing PAA questions
- Expand existing content with PAA insights
- Create comprehensive guides covering PAA topics

### 4. SERP Features

**Location:** `docs/content/blog/posts/{category}/{slug}/data/serp-features.json`

**Data Structure:**

```json
{
  "featured_snippet": {
    "present": true,
    "type": "paragraph",
    "position": 1
  },
  "people_also_ask": {
    "present": true,
    "count": 4
  },
  "related_searches": ["digitale zeiterfassung app", "zeiterfassung gesetz"]
}
```

**Content Optimization Use Cases:**

**Featured Snippets:**

- Optimize for featured snippet queries
- Create concise, direct answers (40-60 words)
- Use structured formats (lists, tables, numbered steps)
- Place answers in first paragraph

**People Also Ask:**

- Add PAA questions as FAQs
- Provide comprehensive answers
- Add FAQ schema markup
- Update FAQs based on new PAA questions

**Related Searches:**

- Cover related topics in content
- Add internal links to related content
- Expand content to cover related searches
- Create content clusters

### 5. Domain Opportunities

**Location:** `docs/content/blog/domain-level-data/domain-opportunities.json`

**Data Structure:**

```json
{
  "keyword": "prozentrechner",
  "position": 15,
  "gain": 100,
  "search_volume": 5000,
  "competition": 25
}
```

**Content Optimization Use Cases:**

**High-Gain Opportunities:**

- Focus on keywords with high gain potential
- Optimize existing content for target keywords
- Improve internal linking
- Enhance meta tags
- Add structured data

**Position 11-20 Keywords:**

- Quick wins for moving to top 10
- Optimize content for target keywords
- Improve user experience
- Add comprehensive content
- Target featured snippets

### 6. Competitive Gaps

**Location:** `docs/content/blog/domain-level-data/competitive-gaps.json`

**Data Structure:**

```json
{
  "keyword": "schichtplanung software",
  "competitors": ["competitor1.com", "competitor2.com"],
  "gap_type": "content_depth",
  "opportunity": "high"
}
```

**Content Optimization Use Cases:**

**Content Gaps:**

- Create content covering missing topics
- Expand existing content to match competitors
- Add comprehensive guides
- Cover related topics

**Feature Gaps:**

- Add missing features/content types
- Create comparison content
- Add tools/calculators
- Create templates

## Workflow: SISTRIX → Content Optimization

### Content Writing Assistant (Master Workflow)

**Script:** `v2/scripts/content/content-writing-assistant.php`

**Usage:**

```bash
# Full workflow: Collect data + generate brief + suggestions
php v2/scripts/content/content-writing-assistant.php --post=slug --category=category --mode=full

# Brief only (assumes data exists)
php v2/scripts/content/content-writing-assistant.php --post=slug --category=category --mode=brief

# Suggestions only
php v2/scripts/content/content-writing-assistant.php --post=slug --category=category --mode=suggestions
```

**What it does:**

- Collects all SISTRIX data (keywords, search intent, SERP features, PAA questions, competitor analysis)
- Generates comprehensive content briefs
- Generates optimization suggestions
- Scores content quality against SISTRIX data

**Output:**

- Complete content brief with all insights
- Optimization suggestions with specific recommendations
- Content quality score (0-100)

### Content Brief Generator

**Script:** `v2/scripts/content/generate-content-brief-from-sistrix.php`

**Usage:**

```bash
php v2/scripts/content/generate-content-brief-from-sistrix.php --post=slug --category=category --output=content-brief.md
```

**What it does:**

- Generates comprehensive content briefs with all SISTRIX insights
- Includes PAA questions, competitor analysis, keyword clusters
- Provides specific actionable recommendations

**Output:**

- Primary and secondary keywords with metrics
- Related keywords and semantic variations
- Specific PAA questions with traffic data
- Competitor analysis (word count, headings, FAQs)
- Recommended headings from competitors
- Content depth recommendations
- Internal linking opportunities

### Automated Content Suggestions

**Script:** `v2/scripts/content/integrate-sistrix-insights.php`

**Usage:**

```bash
php v2/scripts/content/integrate-sistrix-insights.php --post=slug --category=category
```

**What it does:**

- Loads SISTRIX data for the post (keywords, search intent, SERP features, PAA questions, competitor analysis)
- Analyzes competition levels and search intent
- Generates actionable content improvement suggestions with specific recommendations
- Provides prioritized recommendations based on data

**Output:**

- Competition-based suggestions (quick wins, content expansion, long-term strategy)
- Search intent-based suggestions (informational vs transactional optimization)
- SERP features suggestions (FAQ optimization, visual content, video content)
- **Specific PAA questions** (not just detection)
- **Competitor insights** (word count targets, recommended headings, competitor FAQs)
- **Keyword cluster recommendations** (related keywords for internal linking)
- Specific actions for each suggestion

**Example Output:**

```
## Suggestion #1: quick_win
**Priority:** high
**Message:** Low competition (23) for 'sales prozess' (volume: 60). Quick optimization wins...
**Recommended Actions:**
- Optimize meta tags (title, description)
- Add 10+ internal links
- Expand content depth (target 1,500+ words)
- Target featured snippets
```

### Step 1: Review SISTRIX Data

**For Each Post:**

1. **Generate Automated Suggestions:**

   ```bash
   php v2/scripts/content/integrate-sistrix-insights.php --post=slug --category=category
   ```

2. **Check Competition Level:**

   - Low (< 30): Quick optimization wins
   - Medium (30-60): Content expansion needed
   - High (> 60): Long-term strategy

3. **Review Search Intent:**

   - Informational: Expand content depth
   - Transactional: Add CTAs and conversion elements
   - Navigational: Improve brand mentions

4. **Analyze PAA Questions:**

   - **Collect actual questions** using `collect-post-paa-questions.php`
   - Use specific questions as FAQ items
   - Target in content with comprehensive answers
   - Optimize for featured snippets (40-60 word answers)
   - Prioritize by search volume

5. **Review Competitor Analysis:**

   - Analyze competitor content structure
   - Identify recommended headings from competitors
   - Determine target word count based on competitor average
   - Review competitor FAQs to address gaps

6. **Review Related Keywords:**

   - Use semantic variations for content expansion
   - Identify internal linking opportunities
   - Map keyword clusters for topical authority

7. **Review SERP Features:**
   - Featured snippet opportunities
   - PAA optimization needs
   - Related searches coverage
   - Image/video optimization opportunities

### Step 2: Identify Optimization Opportunities

**Quick Wins (Low Competition):**

- Optimize meta tags
- Improve internal linking
- Add comprehensive content
- Target featured snippets

**Content Expansion (Medium Competition):**

- Add more depth and examples
- Improve content structure
- Add FAQ section
- Target PAA questions

**Long-Term Strategy (High Competition):**

- Comprehensive, authoritative content
- Strong backlink strategy
- Focus on user experience
- Content clusters

### Step 3: Implement Optimizations

**Meta Tags:**

- Optimize title tags (50-60 chars)
- Optimize meta descriptions (150-160 chars)
- Include primary keywords naturally
- Add AEO/GEO meta tags

**Content:**

- Expand content depth
- Add examples and use cases
- Improve content structure
- Add FAQ section

**Internal Linking:**

- Add 10+ internal links
- Link to related content
- Use descriptive anchor text
- Contextual placement

**Schema Markup:**

- Add FAQ schema (if FAQs present)
- Add Article schema
- Add HowTo schema (if applicable)
- Validate with Google Rich Results Test

### Step 4: Monitor and Measure

**Track Progress:**

- Keyword ranking improvements
- Search intent alignment
- Competition level changes
- SERP feature appearances
- Domain opportunity gains

**Monitor:**

- Google Search Console performance
- GA4 traffic
- Keyword positions
- Conversion rates

## Examples

### Example 1: Low Competition Keyword

**Keyword:** "zeiterfassung app gastronomie"
**Competition:** 25
**Search Intent:** Informational
**Position:** 15

**Optimization Strategy:**

1. Optimize meta tags (title, description)
2. Expand content depth (add examples, use cases)
3. Add FAQ section (use PAA questions)
4. Improve internal linking (10+ links)
5. Target featured snippet (concise answer in first paragraph)

**Expected Outcome:**

- Move from position 15 to top 10
- Increase organic traffic
- Improve user engagement

### Example 2: Medium Competition Keyword

**Keyword:** "digitale zeiterfassung"
**Competition:** 45
**Search Intent:** Informational
**Position:** 12

**Optimization Strategy:**

1. Expand content depth (1,500+ words)
2. Add comprehensive examples
3. Add FAQ section (8-10 FAQs)
4. Improve content structure (clear headings)
5. Target PAA questions in content

**Expected Outcome:**

- Move from position 12 to top 10
- Increase organic traffic
- Improve user engagement
- Target featured snippets

### Example 3: High Competition Keyword

**Keyword:** "schichtplanung"
**Competition:** 75
**Search Intent:** Commercial
**Position:** 8

**Optimization Strategy:**

1. Comprehensive, authoritative content (2,500+ words)
2. Strong backlink strategy
3. Focus on user experience
4. Content clusters (related topics)
5. Comparison content

**Expected Outcome:**

- Maintain or improve position 8
- Increase organic traffic
- Improve user engagement
- Build authority

## Data-Driven Content Decisions

### Using Competition Data

**Low Competition (< 30):**

- Quick optimization wins
- Focus on meta tags and internal linking
- Add comprehensive content
- Target featured snippets

**Medium Competition (30-60):**

- Content expansion needed
- Add more depth and examples
- Improve internal linking
- Target PAA questions

**High Competition (> 60):**

- Long-term content strategy
- Comprehensive, authoritative content
- Strong backlink strategy
- Focus on user experience

### Using Search Intent Data

**Informational Intent:**

- Expand content depth
- Add comprehensive explanations
- Include examples and use cases
- Add FAQ section
- Target featured snippets

**Transactional Intent:**

- Clear value proposition
- Product/service benefits
- Use cases and examples
- Clear call-to-action
- Conversion-focused content

**Navigational Intent:**

- Clear branding
- Easy navigation
- Internal linking
- Brand mentions
- Authority signals

### Using PAA Questions

**FAQ Generation:**

- Use PAA questions as FAQ items
- Provide comprehensive answers (40-60 words)
- Add FAQ schema markup
- Place FAQ section after main content

**Featured Snippet Optimization:**

- Target PAA questions in content
- Provide direct, concise answers
- Use structured formats (lists, tables)
- Place answers in first 100 words

**Content Expansion:**

- Add sections addressing PAA questions
- Expand existing content with PAA insights
- Create comprehensive guides covering PAA topics

### Using SERP Features

**Featured Snippets:**

- Optimize for featured snippet queries
- Create concise, direct answers (40-60 words)
- Use structured formats (lists, tables, numbered steps)
- Place answers in first paragraph

**People Also Ask:**

- Add PAA questions as FAQs
- Provide comprehensive answers
- Add FAQ schema markup
- Update FAQs based on new PAA questions

**Related Searches:**

- Cover related topics in content
- Add internal links to related content
- Expand content to cover related searches
- Create content clusters

### Using Domain Opportunities

**High-Gain Opportunities:**

- Focus on keywords with high gain potential
- Optimize existing content for target keywords
- Improve internal linking
- Enhance meta tags
- Add structured data

**Position 11-20 Keywords:**

- Quick wins for moving to top 10
- Optimize content for target keywords
- Improve user experience
- Add comprehensive content
- Target featured snippets

## Integration with Content Creation Workflow

### Before Creating Content

1. **Research SISTRIX Data:**

   - Check competition levels
   - Review search intent
   - Analyze PAA questions
   - Review SERP features

2. **Plan Content:**

   - Determine content depth based on competition
   - Structure content based on search intent
   - Include PAA questions as FAQs
   - Target featured snippets

3. **Create Content:**
   - Write comprehensive content
   - Include examples and use cases
   - Add FAQ section
   - Optimize for featured snippets

### After Creating Content

1. **Optimize Meta Tags:**

   - Optimize title tags (50-60 chars)
   - Optimize meta descriptions (150-160 chars)
   - Include primary keywords naturally

2. **Add Schema Markup:**

   - Add FAQ schema (if FAQs present)
   - Add Article schema
   - Validate with Google Rich Results Test

3. **Improve Internal Linking:**

   - Add 10+ internal links
   - Link to related content
   - Use descriptive anchor text

4. **Monitor Performance:**
   - Track keyword rankings
   - Monitor traffic
   - Measure engagement
   - Adjust strategy as needed

## Best Practices

### Data Collection

- **Regular Updates:** Update SISTRIX data quarterly
- **Comprehensive Coverage:** Collect data for all target keywords
- **Cross-Source Analysis:** Combine SISTRIX with GA4 and GSC data

### Data Usage

- **Prioritize Opportunities:** Focus on high-gain keywords
- **Match Intent:** Align content with search intent
- **Use PAA Questions:** Generate FAQs from PAA questions
- **Target SERP Features:** Optimize for featured snippets

### Content Optimization

- **Data-Driven Decisions:** Use SISTRIX data to inform content strategy
- **Comprehensive Content:** Create content that matches competition level
- **User-Focused:** Focus on user value, not just SEO
- **Continuous Improvement:** Monitor and adjust based on performance

## Related Documentation

- `docs/content/blog/NEXT_STEPS.md` — Blog-wide backlog after SISTRIX / data collection (legacy `NEXT_STEPS_AFTER_COLLECTION.md` removed; see Git history)
- `docs/seo-strategy-2026/SISTRIX_KEYWORDS_ACTION_PLAN.md` - SISTRIX keywords action plan
- `docs/content/CONTENT_WRITING_BEST_PRACTICES_2026.md` - Content writing best practices
- `docs/content/CONTENT_CREATION_WORKFLOW_2026.md` - Content creation workflow

## References

- SISTRIX API documentation
- Google Search Console best practices
- SEO best practices for data-driven content
- Content optimization strategies