Running a fundraising campaign without tracking progress is like coaching a game without a scoreboard. You might be winning. You might be losing. But you do not know, so you cannot adjust. The programs that consistently raise the most money are not the ones with the best ideas — they are the ones that know their numbers and act on them.
Tracking does not need to be complicated. For most youth sports programs, a simple system that answers three questions is enough: How much have we raised? Who has participated? Where are we relative to our goal? This guide covers what to track, how to track it, and how to use the data to raise more money.
What to track
Not every number matters equally. Focus on the metrics that actually drive decisions and motivation.
Total amount raised
This is the headline number. It is the first thing your board, your coach, and your community want to know. Track it in real time if possible, and compare it to your goal.
But total raised alone does not tell you enough. A campaign that has raised $3,000 with two weeks left might be in great shape or in trouble, depending on the goal and the trajectory. You need the supporting metrics below to know which it is.
Per-athlete fundraising
For campaigns where athletes have individual fundraising pages, tracking how much each athlete has raised is essential. This metric reveals:
- Participation gaps. If 30 athletes are on the roster but only 12 have any donations, you have a participation problem, not a generosity problem.
- Outlier performance. A few athletes raising significantly more than others might indicate different levels of effort in sharing their pages, or differences in family network size. Both are useful to understand.
- Where to focus coaching. Athletes who have not shared their pages at all need encouragement. Athletes who have shared but received nothing may need help crafting their message.
Per-athlete tracking also supports individual fundraising requirements if your program has them, and allows you to recognize top fundraisers — which motivates everyone.
Collection rate
Collection rate is the percentage of pledged or expected funds that have actually been received. This matters most for pledge-based events like walkathons, read-a-thons, or pledge-per-unit campaigns.
If your athletes collected $5,000 in pledges but only $3,500 has actually been paid, your collection rate is 70%. That 30% gap represents real money that you need a plan to recover.
Track collection rate separately from total raised. The two numbers together give you the full picture.
Number of donors
Total donors matters because it tells you how broad your support base is. A campaign that raises $5,000 from 100 donors is healthier than one that raises $5,000 from 5 donors. Broad support means the campaign is sustainable and not dependent on a few large gifts.
Track unique donors, not just donation count. One person who gives three times should count as one donor for this metric.
Average donation size
Average donation size helps you calibrate your messaging. If your average is $25, suggesting donation amounts of $25, $50, and $100 makes sense. If your average is $75, you might adjust upward. It also helps you set realistic goals: if you need $5,000 and your average donation is $40, you need about 125 donations.
Campaign velocity
How fast are donations coming in? Track the daily or weekly donation pace and compare it to where you need to be to hit your goal by the deadline. If you need $5,000 in 30 days, you need to average about $167 per day. If you are five days in and have raised $400, you are behind pace and need to adjust.
Velocity is the most actionable metric because it tells you when to intervene. A campaign that starts slow and never gets a push will finish short.
Spreadsheet methods
Spreadsheets are the most common tracking tool for youth sports programs, and they work fine for smaller campaigns.
Basic spreadsheet setup
Create a Google Sheet or Excel file with these tabs:
Campaign overview tab:
- Campaign name and goal
- Start and end dates
- Running total raised
- Number of donors
- Daily or weekly donation log
Per-athlete tab:
- Athlete name
- Amount raised
- Number of donors
- Whether the athlete has shared their page (yes/no)
- Notes
Donor log tab:
- Date of donation
- Donor name
- Amount
- Which athlete or campaign the donation was for
- Receipt sent (yes/no)
Formulas that help
A few basic formulas automate the math:
- Total raised: =SUM of the amount column in your donor log
- Per-athlete total: =SUMIF matching the athlete name column to the amounts
- Average donation: =AVERAGE of the amount column
- Progress percentage: =total raised / goal
- Remaining needed: =goal - total raised
- Daily pace needed: =remaining / days left
Limitations of spreadsheets
Spreadsheets work but have real drawbacks:
- Manual data entry. Someone has to enter every donation by hand, which takes time and introduces errors.
- Version control. If multiple people edit the spreadsheet, things get overwritten or conflicted.
- No real-time updates. The spreadsheet is only as current as the last time someone updated it.
- No athlete or donor self-service. Athletes cannot check their own progress, and donors cannot see campaign status without someone manually sharing.
For campaigns under $5,000 with fewer than 50 donors, spreadsheets are usually fine. Beyond that, the manual overhead starts to hurt.
Platform dashboards
Online fundraising platforms solve most of the problems that spreadsheets create. When donations are collected through a platform, tracking happens automatically.
What a good platform dashboard shows
- Real-time campaign total. Updated the moment a donation is processed.
- Per-athlete breakdowns. Each athlete's individual total, donor count, and page activity.
- Donor list with details. Who gave, how much, when, and to which athlete.
- Visual progress indicators. Progress bars and charts that show how close you are to the goal.
- Downloadable reports. The ability to export data for board presentations, tax reporting, or archival.
Benefits of platform tracking
- Zero manual entry. Donations are recorded automatically when they are made.
- Real-time visibility. Anyone with access can see current numbers at any time.
- Athlete self-service. Athletes can log in and see their own progress, which is motivating.
- Automated receipts. Donors receive confirmation automatically, reducing volunteer work.
The tradeoff is cost — most platforms charge a percentage of donations or a monthly fee. But the time savings and accuracy improvements almost always justify the cost for programs raising more than a few thousand dollars.
Reporting to stakeholders
Tracking data is only useful if it reaches the people who need it. Different audiences need different levels of detail.
Board or athletic director reports
Your board and athletic director want the big picture:
- Total raised vs. goal
- How this compares to the same period last year
- Any issues or risks (low participation, slow velocity)
- Planned next steps
A one-page summary with three to five key numbers is ideal. Do not dump the full spreadsheet on them. Deliver this monthly during active campaigns, or weekly during peak periods.
Coach reports
Coaches want to know which athletes are participating and which are not. Give coaches a simple list:
- Athletes who have raised money (and how much)
- Athletes who have not yet started
- Any athletes who need encouragement or help sharing their pages
Coaches can often motivate athletes more effectively than parents or committee members. But they need the data to do it.
Parent and community updates
Parents and community supporters want to feel connected to the campaign's progress. Share updates through your normal communication channels:
- Current total and how close you are to the goal
- Number of donors
- A thank-you to recent donors (with permission)
- A reminder of what the money will fund
- A link to the donation page for anyone who has not yet given
These updates serve double duty: they inform people who have already donated and they remind people who have not.
Real-time vs. weekly updates
How frequently you track and report depends on the campaign type and duration.
Real-time tracking makes sense when:
- You are using an online platform that updates automatically
- The campaign is short (one to two weeks)
- You are running a live event with real-time giving (banquet, pledge event)
- You want to create urgency by showing the progress bar moving
Weekly tracking is sufficient when:
- You are using spreadsheets with manual entry
- The campaign runs for a month or longer
- The audience is small and updates would feel excessive
- You do not have a volunteer who can update daily
For most campaigns, updating the data in real time (if your platform allows it) and reporting to stakeholders weekly is the right balance.
Using data to motivate athletes
Athletes respond to numbers. Showing them where they stand relative to the goal — and relative to each other — drives participation in ways that pep talks alone do not.
Leaderboards
A leaderboard showing the top fundraisers by athlete creates healthy competition. Display it in the locker room, share it at practice, or post it in a team group chat. Make sure to recognize effort (number of shares, number of donors) as well as total dollars, so athletes with smaller networks are not at a disadvantage.
Progress milestones
Set intermediate milestones and celebrate when the team hits them. "We hit $2,000 — halfway there" is a moment to recognize. Milestones create a sense of momentum and make the final goal feel achievable.
Personal challenges
Challenge athletes individually: "Can you get five people to donate this week?" A small, specific challenge is more motivating than "raise as much as you can." When athletes hit the challenge, recognize them.
Connecting money to outcomes
Show athletes what the money buys. "We have raised enough to cover tournament entry fees. We need $1,500 more for hotel rooms." When athletes understand that their fundraising directly enables their experiences, they take it more seriously.
Common tracking mistakes
Not tracking at all
Some programs just collect money and count it at the end. This means you cannot course-correct during the campaign, you cannot recognize top performers, and you cannot learn from what worked.
Tracking too many metrics
If you are drowning in data, you are tracking the wrong things. Focus on the five or six metrics that drive decisions. Everything else is noise.
Not sharing the data
Data that lives in one person's spreadsheet is not useful to the team. Share progress broadly and regularly. Transparency drives accountability and motivation.
Waiting too long to act on trends
If the data shows that participation is low after the first week, do not wait until week three to address it. Use the data to intervene early — send reminders, enlist coaches, adjust messaging.
Getting started
If you want fundraising tracking that happens automatically — real-time dashboards, per-athlete progress, and downloadable reports — HometownLift handles all of it. Every donation is tracked the moment it comes in, athletes can see their own progress, and you can pull reports for your board with a few clicks.
Request access to HometownLift and stop managing fundraising data in spreadsheets.