AI-Powered Insights

const prompt = `
Generate exactly 5 strategic recommendations based on this SEO data.

Each recommendation MUST be:
1. SPECIFIC to this client's actual data (reference specific keywords, pages, or metrics)
2. ACTIONABLE with clear next steps  
3. PRIORITIZED based on potential impact

For each recommendation provide:
- title: Action-oriented headline (5-8 words)
- description: 2-3 sentences explaining the opportunity and approach. Reference specific data points.
- priority: "high", "medium", or "low" based on potential ROI
- category: "keyword", "technical", "content", or "performance"  
- expectedImpact: Quantified expected outcome (e.g., "Potential 20% increase in organic traffic")
- actionItems: Array of 2-3 specific action steps

Example of GOOD recommendation:
{
  "title": "Target Page 2 Keywords for Quick Wins",
  "description": "You have 12 keywords ranking positions 11-20 that are close to page 1. Keywords like 'digital marketing services' at position 14 with 450 monthly impressions represent immediate opportunities. Optimizing these pages could move them to page 1 within 30-60 days.",
  "priority": "high", 
  "category": "keyword",
  "expectedImpact": "Moving 5 keywords to page 1 could generate 200+ additional monthly clicks",
  "actionItems": [
    "Identify top 5 keywords in positions 11-15", 
    "Add target keyword to H1 and first paragraph", 
    "Build 2-3 internal links to each target page"
  ]
}

DATA TO ANALYZE:
- Domain: ${domain}
- Total Clicks: ${clicks} (${clicksChange}% change)
- Total Impressions: ${impressions}  
- Average Position: ${position}
- Organic Sessions: ${organicSessions} (${sessionsChange}% change)
- Mobile Score: ${mobileScore}/100
- Desktop Score: ${desktopScore}/100
- Top Keywords: ${topKeywords.slice(0, 10).join(', ') || 'No data'}
- Top Pages: ${topPages.slice(0, 5).join(', ') || 'No data'}

Return ONLY valid JSON array with exactly 5 recommendations in this format:
{
  "insights": [
    {
      "title": "Action-oriented title",
      "description": "Detailed explanation referencing specific data",
      "priority": "high|medium|low",
      "category": "keyword|technical|content|performance",
      "expectedImpact": "Quantified expected result",
      "actionItems": ["Step 1", "Step 2", "Step 3"],
      "dataSource": ["Google Search Console", "PageSpeed Insights", "etc."]
    }
  ]
}

Make insights specific, actionable, and data-driven. Reference actual metrics from the data provided.`;

private getFallbackInsights(data?: Partial<ReportData>): AIInsight[] {
  const insights: AIInsight[] = [];
  
  // 1. Mobile Performance Check
  const mobileScore = data?.summary?.mobileScore || 50;
  if (mobileScore < 75) {
    insights.push({
      id: `fallback-mobile-${timestamp}`,
      title: 'Improve Mobile Page Speed',
      description: `Your mobile page speed score is ${mobileScore}/100, which is below optimal performance. Mobile speed directly impacts both user experience and Google rankings, especially since mobile-first indexing.`,
      priority: mobileScore < 50 ? 'high' : 'medium',
      category: 'technical',
      expectedImpact: 'Improving to 85+ could increase mobile traffic by 15-25%',
      actionItems: [
        'Compress and optimize all images to WebP format',
        'Minimize JavaScript and CSS file sizes',
        'Implement lazy loading for non-critical content'
      ],
      dataSource: ['PageSpeed Insights']
    });
  }
  
  // 2. Keyword Position Opportunities
  const avgPosition = data?.summary?.averagePosition || 15;
  if (avgPosition > 8) {
    insights.push({
      title: 'Target Page 2 Keywords for Quick Wins',
      description: `Your average keyword position is ${avgPosition.toFixed(1)}, indicating many keywords are on page 2-3. Focusing on keywords ranking positions 8-20 represents the highest ROI opportunities for quick ranking improvements.`,
      priority: 'high',
      category: 'keyword',
      expectedImpact: 'Moving 10 keywords from page 2 to page 1 could double organic traffic',
      actionItems: [
        'Identify keywords ranking positions 8-20 with high search volume',
        'Optimize title tags and H1s for target keywords',
        'Build strategic internal links to boost page authority'
      ],
      dataSource: ['Google Search Console']
    });
  }
  
  // ... 3 more fallback insights
  
  return insights.slice(0, 5);
}

model Report {
  id              String @id @default(cuid())
  // ... other fields
  
  // AI Insights metadata
  aiInsights            Json?     // Array of insight objects
  aiInsightsSource      String?   // "ai" | "rule-based" | "fallback"
  aiInsightsGeneratedAt DateTime? // When insights were generated
  aiTokensUsed          Int?      // Token count for cost tracking
  aiCostUsd             Float?    // Cost in USD for this generation
  aiError               String?   // Error message if AI failed
}

// After Claude API call
const response = await anthropic.messages.create(...);

const tokensUsed = response.usage.input_tokens + response.usage.output_tokens;
const costUsd = (tokensUsed / 1000) * 0.003; // Claude pricing

await prisma.report.update({
  where: { id: reportId },
  data: {
    aiTokensUsed: tokensUsed,
    aiCostUsd: costUsd,
    aiInsightsSource: 'ai'
  }
});

{
  "title": "Optimize High-Impression, Low-Click Keywords",
  "description": "...",
  "dataSource": [
    "Google Search Console",
    "Google Analytics"
  ]
}