What Can You Do in 30 Days? Defenders of Wildlife’s Early Wins with Unite

ROI Solutions | Defenders of Wildlife Unite Analytics

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.

Dana Hickman, Defenders’ Director of Marketing Operations, wasn’t planning to spend his Saturday building canvassing dashboards. He was having fun experimenting with Claude.

Defenders of Wildlife had recently begun using Unite Analytics, ROI Solutions’ nonprofit constituent data platform. During onboarding, ROI encouraged Dana and his colleagues to connect Claude to Unite’s Snowflake-powered data environment and explore what they could accomplish.

Dana isn’t an experienced SQL developer or Amazon QuickSight user. But he understood the organization’s fundraising programs and knew the questions his colleagues needed answered.

So he started experimenting.

He described what he wanted to know about the organization’s canvassing program. Claude helped him explore the data in Unite, validate assumptions, and prototype a dashboard, then walked him through building it in QuickSight.

By the end of the day, he’d built something that hadn’t existed that morning.

“I spent a Saturday morning doing this because it was interesting. I was having a great time, and the technology responds so quickly. By the end of the day, I’d built an entire set of dashboards that didn’t exist the day before.”

That Saturday was part of Defenders’ first 30 days with Unite. It illustrates what happens when business expertise, constituent data, and accessible AI tools come together.

Seventy Ideas. Five Priorities. One Place to Start.

Defenders didn’t begin with a shortage of ideas.

“After our first Unite demo, we started a list of possible Unite use cases and came up with about 70 between Development and Marketing,” Dana said. “After, I asked each department to identify their top five priorities. That’s where we decided to start.”

Rather than tackling everything, he looked for opportunities that were valuable, achievable, and supported by the data already available.

“We don’t have all of our data sources synced yet, so I focused on what we could build with the data we have available and what I knew people were looking for.”

Canvassing was an ideal starting point.

“The canvassing data represented a known group of donors, so I knew it wouldn’t be a heavy lift.”

It’s a principle we’ve emphasized in our writing about constituent data platforms: start with the business question, identify a manageable proof of concept, and demonstrate value before expanding.

Seventy ideas didn’t require 70 dashboards. They required a strong starting point.

From Static Reports to Operational Intelligence

Defenders’ canvassing program presented a longstanding reporting challenge.

Staff needed better visibility into donor acquisition, revenue, cancellations, and vendor performance. One key cancellation metric is the clawback, which occurs when a recurring donor cancels within a defined period after signing up. While Revolution CRM manages the underlying constituent and transaction data, Unite makes it easier to explore that information, identify trends, and share insights across teams.

“For clawbacks, we would typically send a weekly file identifying donors who had canceled. Now, with Unite, we can make that information available much more easily. People can explore the data themselves rather than waiting for someone to prepare a report,” Dana said.

Staff can now explore acquisition and cancellation trends, compare vendors, filter by time period or geography, and drill into underlying constituent records.

“Our vendors wanted better access to this information, particularly when there were discrepancies in the numbers,” he said. “Now, the staff managing canvassing can select a particular week, see exactly how many donors were acquired, review the underlying records, and export the information if they need to. It’s all right there.”

Instead of producing another static report, Defenders is making information available for people to explore and act upon.

It’s a similar evolution to what we’ve seen at Common Cause, where Unite Analytics is helping create an operational intelligence hub.

And it reinforces another idea we’ve explored: having the dashboard isn’t the destination. The value comes from asking better questions and using the answers to make decisions.

AI Changed What Dana Could Build

Defenders initially wanted to explore whether Claude could help staff navigate database structures and write SQL queries. ROI encouraged the team to connect Claude to Unite’s Snowflake-powered environment. That recommendation dramatically accelerated Dana’s experimentation.

“There was some initial nervousness about what we could accomplish. But once ROI suggested connecting Claude, things started moving incredibly quickly. You describe what you’re looking for, have a conversation, and suddenly you’re looking at a dashboard prototype.”

Dana described the canvassing program, walked Claude through source codes and vendor relationships, and clarified Defenders’ fiscal year and reporting requirements. Claude explored the data available through Unite and asked him to confirm its assumptions.

“It asked me to confirm things, like whether it had identified the correct vendor codes. I explained our fiscal year and some of the basic parameters we needed. Once it understood what we were looking for, it could move forward.”

Once he liked the prototype, Claude helped him build the dashboard in QuickSight.

“I told Claude I wanted to build it in QuickSight, and it gave me instructions. When I struggled with a step, it explained what I should be seeing and walked me through it.”

For someone without extensive technical experience, the difference was remarkable.

“We’re not a particularly technical organization. We don’t even have a dedicated SQL expert on staff. I’d watched some QuickSight tutorials, but I certainly wasn’t at the point where I could build a dashboard in six hours.”

AI didn’t supply the organizational expertise. Dana did.

Unite provided the data foundation. Claude helped translate his knowledge and questions into a working solution.

It’s a practical illustration of why AI requires a strong data foundation: the usefulness of AI depends on the quality, structure, and context of the information it can access.

One Use Case Leads to Another

When Dana showed the canvassing dashboard to the colleague overseeing direct marketing, her reaction was immediate: could he build something similar for mid-level giving?

That led to two additional dashboards: one tracking mid-level program performance and another identifying prospects for outreach.

Defenders had already incorporated Wiland Giving Signals into Revolution CRM. Unite helped Dana turn that information into more actionable prospect groups.

The initial analysis identified approximately 26,500 potential prospects, including roughly 1,500 meeting higher-priority criteria.

“Using the Wiland giving signals and the information we have available, Claude and Unite identified about 1,500 high-priority prospects who met multiple criteria,” he said. “These are people who may be stronger prospects for outreach than others in the larger group.”

Staff can explore opportunities for upgrades, retention, and reactivation, with links back to constituent records in Revolution CRM and appropriate restrictions on sensitive information.

One focused proof of concept had created momentum for the next.

Shared Data Still Requires Shared Definitions

AI can accelerate exploration, but it doesn’t eliminate the need to understand what data means.

Dana included a definition of clawbacks directly in the canvassing dashboard so everyone reviewing the results would understand what was being measured.

The same principle applies to Defenders’ mid-level giving program.

“We have a specific definition for an ‘at-risk donor,’” he said.

That definition shapes how staff interpret retention, identify potential lapses, and prioritize outreach.

It’s a theme we’ve explored in our WHYY client feature: a shared data foundation becomes more valuable when people also share an understanding of the information.

AI makes it easier to ask questions of your data. Shared definitions help ensure the answers mean what you think they mean.

Early Wins, With More to Come

Not every early success required building a new dashboard from scratch.

ROI Solutions developed an initial dashboard for Defenders’ development team that eliminated the need to manually recreate one of its recurring reports.

“The development team is excited about the dashboard ROI built for them. They no longer have to manually create the same pivot tables and graphs every month. For them, that’s a big deal.”

Dana estimated that staff had spent six to eight hours each month recreating that report.

Now, as he put it, “You just open the dashboard, and it’s there.”

The dashboards are still evolving. Dana is gathering feedback, refining what he’s built, and identifying additional information to incorporate as Unite expands.

After six years at Defenders, he knows many of the organization’s reporting frustrations firsthand.

“It’s been amazing, and it’s been fun to explore,” he said. “After six years here, I know where the pinch points are. Now I can look at those challenges and realize we can actually fix them, and in many cases, fix them pretty easily.”

Defenders hasn’t addressed all 70 use cases in its first month. It hasn’t connected every data source or completed every dashboard.

But it has demonstrated value, reduced manual work, and created momentum for what comes next. Perhaps most importantly, Dana now sees familiar challenges differently.

“I keep seeing things or hearing things and thinking, ‘We could do that in Unite.’”

Thirty days won’t deliver all 70 use cases. It can, however, deliver a first win and the momentum to pursue the next one.

What could your organization accomplish with better access to its constituent data? Explore Unite Analytics and learn how ROI Solutions helps nonprofits turn questions into actionable insights. Let’s Talk!

Key Takeaways

  • Defenders of Wildlife turned questions into actionable insights by using AI and Unite Analytics to build dashboards quickly.
  • Dana Hickman created a fundraising dashboard in just one day by leveraging Claude and his knowledge of the organization.
  • The team prioritized specific use cases from a list of 70 ideas, focusing on what they could build with available data.
  • AI improved access to insights, making it easier for staff to explore donor trends and reduce manual reporting efforts.
  • Shared definitions of data concepts are crucial for accurate interpretation and decision-making across teams.
Get the latest ROI Solutions 
News & Insights