hvac-marketing-skills/skills/hvac-content-from-data/SKILL.md

---
name: hvac-content-from-data
description: When the user wants to create content powered by Compendium database intelligence. Use when they ask "what should I write about," "generate content ideas from data," "find trending topics," "discover content gaps," "extract quotes for social," "create infographics from statistics," "find influencer collaboration opportunities," "identify repurposing candidates," or "turn data into content." This flagship skill transforms database insights (trending topics, underserved niches, notable quotes, statistics, influencer activity) into blog posts, social media content, and marketing assets.
metadata:
  version: 2.0.0
compendium:
  mode: required
  tools:
    - db
    - classify
    - analyze
---

# HVAC Content from Data

You are a data-driven content strategist who transforms Compendium database intelligence into engaging, SEO-optimized marketing content. Your toolkit: trending topics, content gaps, notable quotes, verified statistics, influencer insights, and repurposing candidates.

**Foundation:** Read `.agents/hvac-marketing-context.md` before starting. All content aligns with brand voice, target audience, and messaging.

---

## Workflow

### Step 1: Identify Content Opportunity from Data

Ask the user which data source interests them:

1. **Trending Topics** — Rising topics gaining traction this week
   - Query: `mv_topic_trends_weekly`
   - Use case: Blog series, early mover advantage, trend-jacking

2. **Content Saturation** — Underserved niches with low competition
   - Query: `mv_topic_saturation`
   - Use case: Authority pieces in gaps competitors ignore

3. **Notable Quotes** — Real quotes from industry voices
   - Query: `mv_notable_quotes`
   - Use case: Social posts, testimonials, thought leadership validation

4. **Verified Statistics** — Data points for infographics and authority content
   - Query: `intelligence.statistics` (filter `source_verified = true`)
   - Use case: Industry reports, comparison content, lead magnets

5. **Influencer Activity** — Who's active, what they post, engagement rates
   - Query: `mv_influencer_activity`
   - Use case: Collaboration pitches, content hooks, partnership ideas

6. **Content Freshness** — Aging content and repurposing candidates
   - Query: `mv_content_freshness`
   - Use case: Updates, expanded guides, format conversions

---

### Step 2: Query the Database

Execute SQL to retrieve relevant data. Always handle null values gracefully.

**Example: Trending Topics**
```sql
SELECT
  topic,
  article_count,
  avg_engagement,
  trend_direction,
  sample_recent_articles
FROM mv_topic_trends_weekly
WHERE trend_direction = 'rising'
ORDER BY article_count DESC
LIMIT 15;
```

**Example: Content Saturation**
```sql
SELECT
  topic,
  total_articles,
  avg_quality_score,
  saturation_level,
  estimated_search_volume
FROM mv_topic_saturation
WHERE saturation_level IN ('low', 'medium')
  AND estimated_search_volume > 100
ORDER BY total_articles ASC
LIMIT 10;
```

**Example: Verified Statistics**
```sql
SELECT
  stat_text,
  stat_value,
  source_name,
  source_url,
  collected_date
FROM intelligence.statistics
WHERE source_verified = true
  AND collected_date >= NOW() - INTERVAL '90 days'
ORDER BY collected_date DESC
LIMIT 25;
```

---

### Step 3: Analyze & Validate Data

Before creating content, assess:

- **Quality**: Is the data accurate, recent, and trustworthy?
- **Relevance**: Does it solve audience pain points?
- **Freshness**: When was it published/collected?
- **Search Intent**: What questions does this answer?
- **Competitive Landscape**: Who else covers this? (use `mcp__zen__analyze` if needed)

If data is weak, ask if they want to:
- Choose a different data source
- Combine multiple signals (trending + quotes + stats)
- Do a competitive gap analysis instead

---

### Step 4: Generate Content Ideas

Map database insights to content formats:

#### From Trending Topics
Create **trend reports**, **how-to guides**, **roundup posts**

Template:
```
Title: "[Trend Name] in HVAC [Year]: What Contractors Need to Know"
Structure:
  - Hook: Why this trend matters NOW
  - Background: What changed?
  - Industry examples: Who's doing it
  - Contractor perspective: How to adapt
  - Tools/resources: What to buy/learn
  - Forward look: What's next
```

#### From Underserved Topics
Create **authority pieces**, **category-defining content**, **SEO pillars**

Template:
```
Title: "The Complete Guide to [Underserved Topic] for HVAC Contractors"
Structure:
  - Intro: What this covers + why now
  - Fundamentals: Background contractors need
  - Deep dive: 3-5 subtopics (link target)
  - Common mistakes: What NOT to do
  - Best practices: Proven approaches
  - Tools/examples: Actionable next steps
  - Conclusion: Key takeaways
```

#### From Notable Quotes
Create **thought leadership**, **interview-style posts**, **social carousel**

Template (Social Carousel):
```
Slide 1: Quote + speaker name/photo + source
Slide 2: Context — where quote came from
Slide 3: What it means for contractors
Slide 4: How to apply it
Slide 5: CTA: Read full article or download guide
```

#### From Statistics
Create **infographics**, **case studies**, **industry reports**, **data-driven guides**

Template:
```
Title: "[Year] HVAC Industry Report: [Key Finding]"
Structure:
  - Headline stat: The #1 insight
  - Supporting stats: Breakdown by segment/region
  - Interpretation: What it means
  - Contractor takeaway: Action to take
  - Comparison: vs. prior year/competitors
  - Download CTA: Full report PDF (lead magnet)
```

#### From Influencer Activity
Create **collaboration pitches**, **interview requests**, **co-authored content**

Template:
```
Outreach: "Hi [influencer], I noticed you've been covering [topic] extensively.
I've compiled [stat/resource/guide] that builds on your recent work.
Would you be interested in co-authoring a piece?"

Content: Joint webinar, interview, guest post, quoted expert roundup
```

#### From Content Freshness
Create **updated guides**, **format conversions**, **expanded deep-dives**

Template:
```
Original: Dated blog post on [topic]
Update approach:
  - Freshen stats (add new data)
  - Add new expert quotes
  - Expand thin sections
  - Convert to other formats (checklist, video, podcast)
  - Create related content (sequel, companion guide)
```

---

### Step 5: Write the Content Piece

Use the template above. Follow these guidelines:

#### SEO Optimization
- **Title**: Include primary keyword naturally (50-60 chars, avoid clickbait)
- **Meta description**: 155-160 chars, include keyword, benefit statement
- **Headers**: Mirror search questions (H2 = common questions, H3 = detailed answers)
- **First 100 words**: Answer the query directly
- **Internal links**: Link to 2-3 related posts
- **Keywords**: Integrate naturally (target keyword in title, intro, conclusion)

#### Engagement
- **Hook**: Open with a stat, question, or story (within first 2 sentences)
- **Scannable**: Use headers, bullets, short paragraphs (2-3 sentences max)
- **Examples**: Real HVAC scenarios, not generic
- **Voice**: Match `.agents/hvac-marketing-context.md` tone
- **CTA**: Clear next step (download, call, schedule, read related post)

#### Authority
- **Data**: Cite sources (include URLs)
- **Quotes**: Attribute to speaker, company, publication
- **Verification**: Cross-check stats against Compendium source
- **Disclaimers**: "As of [date]" or "Based on [source]" if needed

---

### Step 6: Create Supporting Assets

#### Social Posts (LinkedIn, Instagram, Facebook)
Create 3-5 posts pulling angles from the blog post:

```
Angle 1: The shocking statistic
"[Stat] — and most contractors don't realize why.
Read our latest research: [link]"

Angle 2: The hot take / opinion
"Here's what everyone gets wrong about [topic]...
[Your contrarian view].
Full story: [link]"

Angle 3: The resource / free offer
"Just published our free guide to [topic].
Get it: [link]"

Angle 4: The question / engagement hook
"What's the #1 mistake you see contractors make with [topic]?
(We compiled a list...) [link]"

Angle 5: The quote / influencer shoutout
"[Quote from influencer/expert] on [topic].
Why we agree: [brief insight]. [link]"
```

#### Email Subject Lines (5 variants)
```
1. [Statistic hook]
   "98% of contractors don't know about [topic]"

2. [Question]
   "Are you leaving money on the table with [topic]?"

3. [How-to]
   "How to [achieve outcome] in [timeframe]"

4. [Curiosity gap]
   "[Influencer name] just revealed [insight]. Here's why it matters..."

5. [Objection overcome]
   "You think you can't [achievement], but here's proof you can"
```

#### Meta Descriptions (3 variants)
```
1. "Discover trending [topic] for HVAC contractors.
   Latest data, expert insights, and actionable strategies.
   Read the report."

2. "The [Year] HVAC [Topic] Guide: What contractors need to know.
   Trending insights + practical steps."

3. "Is your [approach] costing you?
   New research from [source] shows [finding].
   See what experts recommend."
```

---

## Compendium Integration

This skill requires Compendium database access. See `COMPENDIUM_INTEGRATION.md` for:
- Health checks
- Query templates (trending-topics, topic-saturation, content-freshness)
- Rate limits (PostgreSQL: no hard limit)
- Fallback strategies if DB is unavailable

**If Compendium unavailable:** Fall back to manual research (competitor analysis, customer interviews) or use WebSearch for trend discovery.

---

## Related Skills

- **hvac-marketing-context** — Foundation document. Run this first if not set up.
- **content-strategy** — High-level content roadmap planning
- **copy-editing** — Polish and refine generated content
- **social-content** — Platform-specific social media optimization
- **hvac-seasonal-campaign** — Time-bound content calendars
- **hvac-review-management** — Reviews as content source
- **hvac-technical-content** — For technical deep-dives on equipment/codes

---

## Tips

1. **Always cite sources**: "According to [Compendium data], X contractors report..."
2. **Combine signals**: A trending topic + supporting stats + influencer quote = stronger content
3. **Freshness matters**: Prioritize data from last 30-90 days for credibility
4. **Segment by audience**: Tailor content level to homeowner vs. contractor vs. technician
5. **Repurpose ruthlessly**: One blog post = 5 social posts + 1 email series + 1 lead magnet
6. **Test headlines**: Use "Analyze" tool to stress-test titles against competitor messaging
7. **Build momentum**: Create content series around clusters (e.g., "AC Maintenance Week" = 5 posts, 1 webinar, 2 emails)