Scheduled Reports

Automated report generation and delivery.

API Endpoints

Method	Endpoint	Description
GET	/api/reports	List saved reports
POST	/api/reports	Create report config
PUT	/api/reports/:id	Update report
DELETE	/api/reports/:id	Soft delete
POST	/api/reports/:id/generate	Generate now
GET	/api/reports/export	Ad-hoc export

Data Model

model CompanyReport {
  id               String
  companyId        String
  name             String
  reportType       String     // 'analytics', 'engagement', 'growth'
  dateRange        Json       // Preset or custom
  platforms        String[]
  socialAccountIds String[]
  metrics          String[]
  schedule         Json?      // Frequency, dayOfWeek, time
  recipients       String[]   // Email addresses
  isActive         Boolean
  lastGeneratedAt  DateTime?
  lastReportUrl    String?
}

Report Types

• Analytics: Engagement, reach, impressions
• Growth: Follower trends, growth rate
• Content: Post performance ranking
• Comparison: Platform vs platform

Generation Flow

1. Check if report is due (schedule)
2. Fetch analytics for date range
3. Generate PDF/CSV/XLSX
4. Upload to R2 storage
5. Email download link to recipients
6. Update lastGeneratedAt

Formats

Format	Library	Use Case
PDF	pdfkit	Visual reports
CSV	native	Data export
XLSX	exceljs	Spreadsheet

Scheduling

Uses background jobs to check due reports:

• Cron: Every hour
• Check: Is it time based on schedule?
• Generate if due