audit-content

Audit Content Library

Analyze WordPress XML, CMS JSON, or CSV exports to reveal publishing trends, author contributions, topic distribution, and content opportunities.

Step 1: Detect and Parse Export File

Read export file ($1):

• Auto-detect format (XML/JSON/CSV) unless --format specified
• Validate file structure
• Count total items (posts, pages, etc.)

Report to user:

## 📁 Content Export Detected

**File:** $1
**Format:** [WordPress XML / JSON / CSV]
**Items found:** [number] posts/pages
**Date range:** [earliest] to [latest]
**File size:** [size]

Would you like to proceed with analysis?

Wait for user confirmation.

---

Step 2: Parse Content Data

Use data-parser agent to extract:

For all formats:

• Post titles
• Publication dates
• Authors
• Categories/tags
• Post length (word count)
• Status (published/draft)
• URLs/slugs

Format-specific:

WordPress XML:

<item>
    <title>Post Title</title>
    <pubDate>Date</pubDate>
    <dc:creator>Author</dc:creator>
    <category>Category</category>
    <content:encoded>Body content</content:encoded>
</item>

JSON:

{
  "title": "Post Title",
  "date": "2024-01-15",
  "author": "Name",
  "categories": ["cat1", "cat2"],
  "content": "Body..."
}

CSV:

title,date,author,category,word_count
"Post Title","2024-01-15","Author","Category",1500

Progress report:

🔄 Parsing content...
- ✅ Posts extracted: [number]
- ✅ Authors identified: [number]
- ✅ Date range: [range]
- ✅ Categories: [number]

---

Step 3: Analyze Publishing Trends

Use publishing-analyzer agent to calculate:

Publishing Cadence:

• Posts per month (last 6, 12, 24 months)
• Publishing frequency trends (increasing/decreasing)
• Seasonal patterns
• Content velocity

Present to user:

## 📊 Publishing Trends

### Overall Stats
- Total posts: [number]
- Active period: [months/years]
- Average: [X] posts/month
- Trend: [Increasing 15% / Stable / Decreasing 10%]

### Recent Performance (Last 6 months)
- [Month]: [count] posts
- [Month]: [count] posts
[etc...]

### Publishing Patterns
- Peak month: [month] ([count] posts)
- Lowest month: [month] ([count] posts)
- Most active day: [day of week]

Would you like to continue with author and topic analysis?