Online & Peer-to-Peer Fundraising: Fundraiser Pages, Giving Days, Matching Gifts, Appeal Emails & Cost per Donor
Run online appeals that add up: fundraiser pages, giving-day pacing, matching gifts, appeal emails and the net cost of every new donor, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you run the numbers of one fictional charity's online fundraising in eight interactive spreadsheet labs. You turn walk registrations into a fundraiser funnel, sort pages into amount bands with COUNTIFS and SUMIFS and measure the share of the top fundraisers with LARGE. You read a gift log by page and weekday, pace a giving day by the hour with HOUR, TIME and SUMIFS, and apply a capped matching gift with MIN. You compare appeal email segments per 1,000 sends, gross up cover-the-fee gifts, and finish with cost per new donor and a chart. Every rule is simplified and fictional, and every cell is checked instantly.
Lessons
- The Fundraiser Funnel: Registrants, Active Pages & Average Raised per Page Pro
- Fundraiser Tiers: Amount Bands, Top Fundraisers & the Top 10 % Share Pro
- Gifts on the Pages: Donors per Page, Average Gift & Giving by Weekday Pro
- Giving Day Pacing: Hourly Blocks, Cumulative Targets & Ahead/Behind Flags Pro
- Matching Gifts: Match Ratios, Caps per Gift & the Unused Match Pool Pro
- Appeal Emails: Opens, Clicks, Gifts & Raised per 1,000 Sends Pro
- Processing Fees & Cover-the-Fee: Gross-Up, Net per Gift & Fees Absorbed Pro
- Cost per New Donor & the Online Fundraising Dashboard Pro