Looking for
downloadable content?
Download our functional scenario kits, scenario guides, and day in the life guides to accelerate your Copilot implementation.
View downloadsNonprofit scenario: Manage the donor pipeline
Download scenario guideAvailable with: Microsoft 365 Copilot Scenario level:
KPIs impacted
Fundraising efficiency
Value benefit
Cost savings
Employee experience
Using Copilot to manage the donor pipeline
1. Identify trends and patterns
Leverage Copilot in Excel to analyze data. Import data from various sources to identify trends and patterns in donor behavior, helping to pinpoint potential prospects.

Copilot in Excel
Example prompt: Create a summary table showing total donations by donor for the past year.
2. Segment and score prospects
Categorize prospects based on specific criteria and assign scores to prioritize them.

Copilot in Excel
Example prompt: Assign a score to each prospect based on their donation frequency and average donation amount.
3. Personalize messaging
Based on the insights gained from data analysis, draft personalized messages for each donor segment.

Copilot in Outlook
Example prompt: Write an email message using a warm tone thanking the donor for making more than $1,000 in donations last year.
4. Manage pipeline
Track interactions with potential donors and partners, providing insights into the best times to reach out and the most effective communication strategies.
Copilot2
Example prompt: Summarize recent interactions with [donor name] and suggest follow-up actions.
5. Optimize campaigns
Query donor-related information using natural language chat by creating an agent for your SharePoint site.
Example prompt: Which of our donors live in Spain and like dogs.
1Access Copilot at copilot.microsoft.com or the Microsoft Copilot mobile app and set toggle to “Web”.
2Access Copilot at copilot.microsoft.com, the Microsoft Copilot mobile app, or the Copilot app in Teams, and set toggle to “Work”.
The content in this example scenario is for demonstration purposes only. You should evaluate how Copilot aligns with your organization’s business processes, regulatory requirements, and responsible AI principles.