Report Generation

{
  totalClicks: 1234,
  totalImpressions: 45678,
  averagePosition: 12.3,
  averageCTR: 2.7,
  topKeywords: [
    {
      keyword: "best seo tools",
      clicks: 234,
      impressions: 5432,
      position: 3.2,
      ctr: 4.3
    }
    // ... top 10 keywords
  ],
  topPages: [
    {
      page: "https://example.com/blog/seo-guide",
      clicks: 543,
      impressions: 12345,
      position: 5.6,
      ctr: 4.4
    }
    // ... top 10 pages
  ],
  dailyData: [
    {
      date: "2025-01-15",
      clicks: 42,
      impressions: 987,
      position: 12.1,
      ctr: 4.3
    }
    // ... daily time series
  ]
}

{
  organicSessions: 2345,
  sessionsDelta: 15.3, // % change from previous period
  bounceRate: 42.5,
  averageSessionDuration: 145.2, // seconds
  topLandingPages: [
    {
      page: "/blog/seo-guide",
      sessions: 432,
      users: 387,
      bounceRate: 38.2,
      averageSessionDuration: 187.4
    }
    // ... top 10 landing pages
  ],
  trafficTrend: [
    {
      date: "2025-01-15",
      sessions: 78,
      users: 65
    }
    // ... daily traffic data
  ]
}

{
  url: "https://example.com",
  mobileScore: 78,
  desktopScore: 92,
  coreWebVitals: {
    lcp: 2400,  // Largest Contentful Paint (ms)
    fid: 85,    // First Input Delay (ms)
    cls: 0.08   // Cumulative Layout Shift (score)
  },
  opportunities: [
    {
      title: "Properly size images",
      description: "Serve images that are appropriately-sized...",
      savings: 1200, // milliseconds
      impact: "high"
    }
    // ... top 10 optimization opportunities
  ]
}

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 keywords, pages, metrics)
2. ACTIONABLE with clear next steps  
3. PRIORITIZED based on potential impact

DATA TO ANALYZE:
- Domain: ${domain}
- Total Clicks: ${clicks} (${clicksChange}% change)
- Average Position: ${position}
- Top Keywords: ${topKeywords.join(', ')}
- Mobile Score: ${mobileScore}/100

Return JSON with exactly 5 recommendations:
{
  "insights": [
    {
      "title": "Action-oriented title",
      "description": "2-3 sentences with specific data references",
      "priority": "high|medium|low",
      "category": "keyword|technical|content|performance",
      "expectedImpact": "Quantified expected outcome",
      "actionItems": ["Step 1", "Step 2", "Step 3"]
    }
  ]
}
`;

const getLogoUrl = () => {
  const defaultReportrLogo = 'data:image/svg+xml;base64,...';
  
  // Use agency logo if white-label enabled
  if (data.branding.whiteLabelEnabled && data.branding.logo) {
    return data.branding.logo;
  }
  
  // Otherwise use Reportr logo
  return defaultReportrLogo;
};

const brandedStyles = createBrandedStyles(data.branding.primaryColor);

{
  id: "clx123...",
  title: "SEO Report - January 2025",
  status: "COMPLETED",
  pdfUrl: "https://blob.vercel-storage.com/...",
  pdfSize: 245678, // bytes
  processingStartedAt: "2025-01-15T10:30:00Z",
  processingCompletedAt: "2025-01-15T10:32:45Z",
  generationTimeMs: 165000, // 2.75 minutes
  
  // AI Insights metadata
  aiInsights: [...], // Array of insight objects
  aiInsightsSource: "ai", // or "fallback"
  aiTokensUsed: 2847,
  aiCostUsd: 0.0085,
  
  // Report data snapshot
  data: {
    clientName: "Acme Corp",
    startDate: "2025-01-01",
    endDate: "2025-01-31",
    agencyName: "Your Agency",
    gscData: {...},
    ga4Data: {...},
    pageSpeedData: {...}
  }
}

const limitCheck = await canGenerateReport(user.id);

if (!limitCheck.allowed) {
  return res.status(403).json({
    error: limitCheck.reason,
    currentCount: limitCheck.currentCount,
    limit: limitCheck.limit,
    upgradeRequired: true,
    billingCycle: {
      start: cycleStart,
      end: cycleEnd,
      daysRemaining: daysLeft
    }
  });
}