Automated Report Scheduling

Why Schedule Reports?

Automated report delivery saves time and ensures stakeholders receive critical data without manual intervention.

Benefits

• Consistency: Reports delivered same time every week (predictable)
• Time Savings: No manual running/emailing (automation handles it)
• Timeliness: Executives get Monday morning report at 7 AM (before they arrive)
• Reduced Errors: No forgotten reports or wrong recipients
• Scalability: One schedule sends to 100 recipients (no extra effort)

Common Scheduling Patterns

Daily Reports

• Use Case: Sales activity summary (calls, meetings, opps created)
• Schedule: Every weekday at 6 AM
• Recipients: Sales managers (review before team standup)
• Format: Excel attachment (sortable data)

Weekly Reports

• Use Case: Pipeline review (opportunities by stage, close dates)
• Schedule: Every Monday at 7 AM
• Recipients: Sales VPs, Directors
• Format: PDF with charts (executive summary)

Monthly Reports

• Use Case: Revenue summary (actuals vs budget vs forecast)
• Schedule: 1st of month at 8 AM
• Recipients: CFO, CEO, Board
• Format: PowerPoint (ready for board meeting)

Quarterly Reports

• Use Case: Customer satisfaction trends (CSAT, NPS, churn rate)
• Schedule: 1st day of Q2, Q3, Q4, Q1 (Apr 1, Jul 1, Oct 1, Jan 1)
• Recipients: Executive team, Customer Success
• Format: PDF report (20 pages, detailed analysis)

Setting Up a Scheduled Report

Step 1: Create/Select Report

• Navigate to Reports → My Reports
• Select existing report: "Weekly Pipeline Summary"
• Or create new custom report (follow previous lessons)

Step 2: Configure Schedule

1. Click Schedule button
2. Frequency: Select "Weekly"
3. Day: Monday
4. Time: 7:00 AM (server timezone: EST)
5. Start Date: Next Monday (Nov 11, 2025)
6. End Date: None (runs indefinitely) OR specific date (Dec 31, 2025)

Step 3: Set Parameters

• Date Range: "Last 7 Days" (dynamic, always shows previous week)
• Territory: "All" (or specific territory if needed)
• Owner: "Current User's Team" (report shows each manager's team)

Step 4: Choose Output Format

• PDF: Best for executives (formatted, charts)
• Excel: Best for analysts (sortable, pivot tables)
• CSV: Best for imports (raw data, no formatting)
• HTML: Best for email body (no attachment, inline viewing)

Step 5: Configure Delivery

• Email Recipients: sales-vp@company.com, director1@company.com, director2@company.com
• Subject: "Weekly Pipeline Report - [Date]" (auto-populates date)
• Body: "Attached is this week's pipeline summary. Total pipeline: $12.5M, Top 10 deals listed."
• Attachment: "Pipeline_Report_2025-11-11.pdf"

Step 6: Save & Activate

• Click Save Schedule
• Schedule appears in "My Scheduled Reports" list
• Status: Active (green indicator)

Advanced Scheduling Options

Conditional Delivery

• Only if data exists: Don't send empty report (if no new SRs today, skip email)
• Only if threshold met: Alert if pipeline < $10M (send email with warning)
• Only on business days: Skip holidays (US holiday calendar)

Bursting

One schedule generates personalized reports for multiple recipients.

Cascading Parameters

• Dynamic Date: "Last Week" always shows previous 7 days (not static dates)
• Rolling Quarter: "Current Quarter" automatically updates (Q4 2024 → Q1 2025 on Jan 1)
• Relative Owner: "My Team" shows current user's team (different for each recipient)

Managing Scheduled Reports

Monitor Execution

• Navigate to Administration → Scheduled Reports → History
• View execution log:
  • Nov 4, 7:00 AM - Success (delivered to 5 recipients)
  • Oct 28, 7:00 AM - Success (delivered to 5 recipients)
  • Oct 21, 7:00 AM - Failed (SMTP server unavailable - retried at 7:15 AM, success)
• Click execution → View generated PDF (audit what was sent)

Pause/Resume Schedule

• Scenario: VP on vacation for 2 weeks (don't want daily reports)
• Action: Select schedule → Click "Pause" → Status: Paused (yellow)
• Resume: VP returns → Click "Resume" → Status: Active (green)

Edit Schedule

• Change frequency: Weekly → Daily (more frequent updates)
• Add recipient: New manager joins, add to distribution list
• Update filters: Report now shows only "High Priority" opportunities

Delete Schedule

• Scenario: Report no longer needed (project completed)
• Action: Select schedule → Click "Delete" → Confirm
• Result: No future executions, history preserved (audit trail)

Error Handling

Common Errors

• Email Delivery Failed: Recipient mailbox full (retry 3 times, then notify admin)
• Report Timeout: Query too slow (> 5 min) → Optimize query or schedule during off-hours
• No Data: Filters too restrictive (0 records) → Send "No data found" email or skip
• Server Down: Database maintenance window (schedule around it, or auto-retry)

Notifications

• Admin Alert: If 3 consecutive failures → Email to report admin
• Success Confirmation: Optional "Report sent successfully" email to creator
• Recipient Confirmation: Track email opens (know if executives are reading reports)

Best Practices

• Off-Peak Execution: Schedule heavy reports at night/weekends (avoid peak hours, reduce database load)
• Limit Frequency: Don't over-email (daily reports should be 1 page, not 50 pages)
• Clear Subject Lines: "Weekly Pipeline - [Date]" (recipients know what it is)
• Test First: Run manually before scheduling (verify output, recipients)
• Document Schedules: Maintain list of all scheduled reports (owner, purpose, recipients)
• Regular Review: Quarterly audit - delete unused schedules (reduce clutter, server load)
• Versioning: If report definition changes, notify recipients (new columns, filters)
• Unsubscribe Option: Let recipients opt-out (if no longer relevant to them)

Example: End-of-Month Revenue Report