Focused use cases, a strong data foundation, and some Saturday AI experimentation helped Defenders of Wildlife turn questions into action with Unite Analytics, the nonprofit constituent data platform.
I spent a Saturday building a fundraising dashboard. Not because anyone asked me to work over the weekend, but because I was having fun.
We had recently started using Unite Analytics at Defenders of Wildlife in October, and with our focus rapidly turning to year-end, I wanted a way to build momentum. ROI Solutions suggested connecting Claude to Unite to see what we could accomplish. I’m not a SQL developer, nor a report or visualization developer, and I certainly am not an Amazon QuickSight expert. But I know our fundraising programs, the questions my colleagues ask, and many of the reporting challenges we’ve been trying to solve.
So, I started experimenting. I explained our canvassing program to Claude, asked questions about the data available through Unite, and started working through dashboard ideas. Claude helped me identify relevant information, confirm assumptions, and create a prototype. When I wanted to build it in QuickSight, it walked me through the process.
A few hours later, I had visuals and KPIs that hadn’t existed that morning. I had no idea I could accomplish that much so quickly.
Seventy Ideas. Five Priorities. One Place to Start.
Our interest in Unite started well before that Saturday. We had our first Unite demo in 2025, but we reconnected with ROI this summer to try again. After our summer demonstration, colleagues across Development and Marketing began identifying ways we might use the platform. We eventually came up with over 70 potential use cases. Seventy is a pretty exciting number until you realize someone has to figure out where to start.
I asked both departments to identify their five highest priorities. We also needed to be realistic about the data we had available. Not every source was connected yet, and I didn’t want to wait until everything was perfect before building something useful.
Canvassing seemed like a manageable starting point. It involved a well-defined group of donors, and I knew the team wanted better visibility into performance. We needed to understand acquisition, revenue, cancellations, and vendor performance without constantly recreating reports or distributing spreadsheets.
One important measure is clawbacks, which occur when recurring donors cancel within a defined period after signing up. Previously, we’d typically send a weekly file identifying those cancellations. With Unite, we can explore that information much more easily. Staff can review results by vendor, week, or geography, examine the underlying records, and export information when needed.
Revolution CRM continues to manage our constituent and transaction data. Unite gives us another way to work with that information, explore trends, and make it accessible to the people who need it.
From Questions to Dashboards, Without the Technical Learning Curve
What surprised me most was how conversational the process became. I explained how we identify canvassing donors through source codes and which vendors we work with. Claude explored the data in Unite, identified additional codes, and asked me to confirm whether its assumptions were correct. I also had to explain things like our fiscal year and how we wanted to measure performance.
That part matters. Claude didn’t automatically know everything about Defenders or our fundraising programs. I had to provide context, confirm definitions, and decide what information was useful. Once we set those parameters, I could move quickly.
When I wanted to build something in QuickSight, Claude provided instructions. When I got stuck, I could explain the problem and ask for more guidance. Instead of waiting until I’d mastered an unfamiliar technical tool, I could learn while building something we actually needed.
One Dashboard Led to Another
Once I had a working canvassing dashboard, I showed it to my colleague who oversees direct marketing. Her response was essentially, “Can you do one for mid-level giving next?” That led to additional work on mid-level program reporting and identifying prospects for outreach.
We already had Wiland Giving Signals incorporated into Revolution CRM. By working with Claude and Unite, I could explore those signals alongside our constituent information and identify groups worth reviewing more closely. One analysis identified approximately 26,500 potential prospects, including about 1,500 who met multiple higher-priority criteria.
That doesn’t mean 1,500 people automatically become outreach targets. We still need to decide what action makes sense, who should receive it, and how those opportunities fit into our fundraising strategy. But having a more focused group to evaluate is a meaningful starting point.
The process also reinforced something important: we need shared definitions. For example, our teams have specific ways of defining clawbacks and at-risk donors. Those definitions affect how people interpret the results and what actions they take. I’ve started incorporating that context directly into dashboards so colleagues can understand what they’re seeing without having to track down an explanation.
Sometimes the Biggest Win Is Getting Time Back
Not everything we’ve accomplished has involved AI or dashboards I built myself. ROI also developed a dashboard for our Development team that replaces a recurring manual reporting process. Previously, staff spent approximately six to eight hours each month recreating reports, pivot tables, and graphs. Now they can open the dashboard and find the information waiting for them.
That might not sound revolutionary, but anyone who has spent hours rebuilding the same monthly report understands why it matters. And it’s not just about saving time. It’s about what people can do with that time instead, like spending more of it on the donors whose support makes our work for wildlife possible.
Thirty Days In, and Just Getting Started
We’re still early in this process. Not all our data sources are connected, the dashboards I’ve built are evolving as colleagues review them and suggest changes, and we still have plenty of ideas on that original list of 70.
I’m also learning that building a dashboard is only part of the work. We need to make sure the information is accurate, that people understand the definitions, and that we’re using the results to make decisions.
But after six years at Defenders, I know where many of our reporting challenges are. What I value most is being able to look at those challenges and see practical ways to address them. I’ve started having conversations with colleagues about information they’d like to see, and increasingly, my reaction is the same: We could do that in Unite.
I didn’t expect to accomplish so much in our first month. I certainly didn’t expect to spend a Saturday having fun building dashboards. But that’s probably the biggest thing I’ve learned so far: when you understand your organization’s data and have tools that make it easier to explore, you can start answering questions that previously seemed much harder to tackle.
And once you see what’s possible, it’s difficult to stop thinking about what you might build next.
Learn more about Defenders of Wildlife!
Are you interested in exploring Unite Analytics? Let’s Talk!
Key Takeaways
- Defenders of Wildlife utilized the nonprofit constituent data platform Unite Analytics to build a fundraising dashboard for better performance visibility.
- The team identified over 70 potential use cases, narrowing down to five priorities to tackle manageable projects first.
- The conversational interaction with Claude helped in data exploration and prototype creation, making dashboard building intuitive and fast.
- The use of dashboards significantly reduced time spent on manual reporting, allowing staff to focus more on donor engagement.
- The ongoing process highlights the importance of accurate data and shared definitions to make informed decisions and address challenges effectively.