TECH **Salesforce Administrator: Scheduled Reports & Email Distribution**

Salesforce Administrator: Scheduled Reports & Email Distribution

A Hyper-Practical, Zero-Fluff Study Guide

1. What This Is & Why It Matters

Scheduled Reports & Email Distribution let you automate sending Salesforce reports to users, managers, or external stakeholders on a recurring basis—without manual exports or reminders.

Why This Matters in Production

• Broken without it: Managers forget to pull reports, sales teams miss pipeline updates, and executives don’t get critical KPIs on time. Manual exports waste hours weekly.
• Superpower it gives you: Turn Salesforce into a self-service analytics engine. Example: A sales ops team needs a weekly pipeline report sent to 50 reps every Monday at 8 AM—without lifting a finger.
• Real-world scenario: You inherit a Salesforce org where the CFO manually exports a monthly revenue report and emails it to the board. They want it automated, formatted as a PDF, and sent to 10 executives—with a 3-day preview before the board meeting.

If you don’t master this, you’ll drown in manual work, miss SLAs, and frustrate leadership.

2. Core Concepts & Components

3. Step-by-Step: Schedule a Report & Email It

Prerequisites

✅ You have System Administrator permissions.
✅ The report is saved in a shared folder (not private).
✅ External email recipients are enabled (Setup → Email Administration → Deliverability → "All Email").
✅ The report runs successfully manually (test with "Run Report").

Task: Schedule a Weekly Pipeline Report for Sales Reps

Goal: Send a PDF report of "Open Opportunities by Stage" to 50 sales reps every Monday at 8 AM, with a custom email subject.

Step 1: Create or Locate the Report

1. Go to Reports tab → New Report.
2. Select Report Type: "Opportunities" (or a custom report type if needed).
3. Set filters:
4. Opportunity Status = Open
5. Close Date = Next 90 Days (adjust as needed)
6. Group by Stage.
7. Save in a shared folder (e.g., "Sales Reports").
8. Name: "Weekly Pipeline - Open Opportunities by Stage"
9. Folder: "Sales Reports" (must be shared with "All Internal Users" or a group).

Step 2: Schedule the Report

1. Open the report → Click Subscribe (or "Schedule Future Runs" in Classic).
2. Configure:
3. Run Report: Weekly, Every Monday at 8:00 AM.
4. Email Report To:
   • Users: Select all sales reps (or use a Public Group).
   • Additional Emails: (Optional) Add a manager or external email.
5. Subject: "Weekly Pipeline Update - {TODAY()}" (dynamic date).
6. Message: "Here’s your open pipeline for the week. Focus on Stage 3 opportunities!"
7. Format: PDF (formatted, printable).
8. Attachments: Include report details (optional).
9. Click Save.

Step 3: Verify the Scheduled Job

1. Go to Setup → Environments → Jobs → Scheduled Jobs.
2. Look for your report name (e.g., "Weekly Pipeline - Open Opportunities by Stage").
3. Check:
4. Next Scheduled Run = Next Monday at 8 AM.
5. Status = "Scheduled" (not "Failed").

Step 4: Test the Email (Critical!)

1. Manually run the report → Click Run Report.
2. Click Subscribe → Send Now (to test the email).
3. Check your inbox (and spam folder) for the email.
4. Verify:
   • Subject includes the dynamic date.
   • PDF attachment opens correctly.
   • Data matches the report.

Step 5: Troubleshooting (If It Fails)

4. ? Production-Ready Best Practices

Security

• Least privilege: Only share report folders with necessary users/groups.
• External emails: Use Email Relay (Setup → Email Administration) to avoid spam filters.
• Sensitive data: Avoid sending PII (e.g., SSNs, credit cards) in reports. Use field-level security to hide sensitive fields.

Cost Optimization

• Report complexity: Complex reports (e.g., 100K+ rows) slow down performance. Optimize filters or use Dashboard Snapshots instead.
• Email volume: Sending to 100+ users daily? Consider Report Subscriptions (user-controlled) or Chatter posts instead.

Reliability & Maintainability

• Naming conventions:
• Weekly - Pipeline - Open Opps by Stage
• Monthly - Revenue - Closed Won by Region
• Folder structure:
• Sales/Reports/Weekly
• Finance/Reports/Monthly
• Documentation: Keep a spreadsheet of all scheduled reports (name, frequency, recipients, last modified).

Observability

• Monitor Scheduled Jobs: Set up a weekly reminder to check the Scheduled Jobs log for failures.
• Alerts: Use Flow or Process Builder to notify admins if a scheduled report fails.
• Audit trail: Enable Setup Audit Trail (Setup → Security → View Setup Audit Trail) to track report changes.

5. ⚠️ Common Mistakes & Traps

6. ? Exam/Certification Focus

Typical Question Patterns

1. "Which report format is best for a pivot table?"
2. ✅ Matrix (rows + columns).

3. ❌ Tabular (flat list).

4. "Where do you check if a scheduled report failed?"

5. ✅ Setup → Environments → Jobs → Scheduled Jobs.

6. ❌ Reports tab (doesn’t show failures).

7. "How do you send a report to an external email?"

8. ✅ Enable Deliverability = "All Email" and add the email in the schedule.

9. ❌ External emails are blocked by default.

10. "What’s the default report timeout?"

11. ✅ 10 minutes.
12. ⚠️ Complex reports may need a timeout increase.

Key ⚠️ Trap Distinctions

7. ? Hands-On Challenge

Challenge:

Schedule a daily "Open Cases by Priority" report to send to the Support Manager (internal) and [email protected] (external) every weekday at 9 AM in Excel format.

Solution:

1. Create a Cases report with filters:
2. Status = New, Working, Escalated
3. Priority = High, Medium, Low
4. Group by Priority.
5. Save in a shared folder (e.g., "Support Reports").
6. Schedule:
7. Run Report: Daily, Monday–Friday at 9:00 AM.
8. Email To: Support Manager + [email protected].
9. Subject: "Daily Open Cases - {TODAY()}"
10. Format: Excel.
11. Test with Send Now.

Why it works:
- Shared folder ensures the report can be scheduled.
- Excel format is best for data manipulation.
- {TODAY()} keeps the subject dynamic.

8. ? Rapid-Reference Crib Sheet

9. ? Where to Go Next

1. Salesforce Help: Schedule Reports
2. Trailhead: Reports & Dashboards
3. Salesforce Admins Blog: Report Subscriptions
4. YouTube: Scheduled Reports Deep Dive (Search for "Salesforce scheduled reports tutorial")