Introduction to Data Utilization for NPOs — Practical Steps for Small Organizations to Get Started
Many NPOs write annual reports but struggle to show impact. A four-stage guide to data utilization—from collection to analysis and practical application.
TL;DR
- Practical approaches to overcoming three barriers: lack of specialists, limited budgets, and absence of data culture
- A four-step framework (collect, organize, analyze, apply) with implementation examples using free Google tools
- Addresses structural challenges across the entire NPO sector, not just individual organizations
Introduction
Establishes the need for data-driven accountability in NPO reporting and impact demonstration
We write annual activity reports every year. However, we don't feel confident about how well these reach supporters and government agencies. Many people involved in NPOs and social activities share this sentiment.
Reporting to supporters, grant applications, collaboration with government agencies. In every situation, "accountability for results" is increasingly demanded. What fundamentally strengthens this explanatory power is data utilization.
However, looking at the actual situation, as repeatedly pointed out by the Japan NPO Center (JNPOC) "Survey on IT Utilization by Nonprofit Organizations," barriers of human resources, costs, and organizational culture are preventing NPO data utilization. While expectations for "organizations that can speak with data" in collaboration with government agencies are rising, the field cannot keep up. How can we bridge this gap? This article organizes practical steps that even small NPOs can start working on today.
Barriers Preventing NPOs from Using Data
Identifies key obstacles like resource constraints and organizational culture preventing data adoption
Shortage of Specialized Human Resources
"We don't have anyone who can do data analysis"—this is the most frequently cited challenge in NPOs. Staff can use Excel but don't understand statistics, systems have been introduced but aren't being utilized effectively. The shortage of digital talent that is becoming serious even in large corporations is even more pronounced in the NPO sector.
However, it's better to abandon the misconception that "we can't start without hiring a data scientist." Even data utilization at the level where field staff can aggregate data in Google Sheets can be a meaningful first step.
Cost and Priority Issues
With personnel costs, rent, and program expenses under pressure, it's difficult to allocate budget to "building data utilization systems." For organizations that are already stretched thin running current programs, establishing data infrastructure tends to be postponed as "something to do someday."
However, the combination of Google Forms, Sheets, and Looker Studio is free within the basic functionality range. A complete flow from data collection to visualization can be built without initial investment.
Absence of "Data Culture"
Activities should be driven by intuition and passion—in such organizational cultures, collecting numbers itself may be perceived as "managerial and bureaucratic." This barrier tends to be particularly high in organizations with strong founding passion.
Reposition data not as a "tool for management" but as a "language for articulating mission." Being able to show with numbers "how many people were changed by this support" can also strengthen pride in the activities.
Steps for Data Utilization
Provides actionable framework for implementing data practices in small organizations
Collection — Deciding What to Collect
The first question is "What should we measure to communicate the value of our activities?" Here, it's necessary to be conscious of outcome indicators. "Number of participants" is an output, while "behavioral change of participants" is an outcome.
Candidates for measurement include items such as the following:
- Changes in beneficiary status (pre- and post-surveys)
- Service usage continuation and dropout rates
- Stakeholder satisfaction levels
- Cost per outcome achieved
The key is not to try to measure everything at once. Start by deciding on 1-2 "core indicators" and building a system for continuous collection.
Organization — Processing into Usable Form
Collected data cannot be used as-is. Work is needed to unify input rules, remove duplicates, and organize into an analysis-friendly structure.
Responses collected through Google Forms are automatically linked to spreadsheets. Unify column names, align date formats, and clearly separate free text from multiple choice. This meticulous organizational work affects subsequent analysis accuracy.
A common failure is "several years of data accumulating in various formats, making retrospective aggregation impossible." Deciding on an organization-friendly format at the collection design stage makes a big difference in long-term efficiency.
Analysis — Reading Patterns
Analysis doesn't require advanced statistics. What's practical for NPOs includes basic interpretations such as:
- Time series comparison (Did participants increase compared to the same month last year?)
- Analysis by attributes (What differences exist by age, region, participation route?)
- Observing correlations (Do people with more participation have higher continuation rates?)
Using Looker Studio, spreadsheet data can be automatically visualized as graphs. Creating dashboards and making it a habit to review them in monthly regular meetings prevents data from "sleeping unused."
Application — Using for Decision-Making and Communication
This is the stage of connecting analysis results to actual decisions and communication.
Internal application includes using data as the basis for decisions about program continuation, improvement, or termination. Data showing "participant satisfaction has declined for three consecutive months" makes it easier to lead to constructive improvement than intuitive discussions.
External application includes grant reports, supporter newsletters, and website content. The statement "This term we reached XX people with support, of whom XX% felt improvement in their situation" cannot be written without numbers.
Low-Cost Implementation Example: Starting with Google Tools
Demonstrates practical, budget-friendly approach using accessible technology tools
Here's a specific implementation example. Implementation cost is zero; all that's needed is a Google account.
Beneficiary Survey Design (Google Forms)
Include questions about "before and after service status" in the form. "Rate your current level of difficulty on a 5-point scale (before support)" and "same question after support" provides the simplest outcome measurement through before-and-after comparison. Responses are automatically output to spreadsheets.
Monthly Dashboard Construction (Looker Studio)
Connect spreadsheets as a data source for Looker Studio. Create graphs for "monthly participant trends," "composition by attributes," and "satisfaction score time series," and simply share the URL to create an environment where stakeholders can check in real-time.
CANPAN Utilization
CANPAN, the NPO information disclosure platform provided by The Nippon Foundation, is a free tool for accumulating and publishing financial information and activity reports. It can be used both for ensuring external transparency and organizing information for certified NPO status acquisition.
Common Points in Success Stories
Analyzes shared characteristics and strategies of NPOs that successfully implemented data utilization
What's common among advanced examples of NPO data utilization in Japan is the attitude of "start small and continue."
According to Fundrex's "White Paper on Donations" analysis, the top tier of certified NPO corporations that collect more than 10 million yen in annual donations (22.6% of the total) accounts for 92.4% of total donations. One factor creating this concentration structure is communication design based on data. Organizations that visualize results and maintain a cycle of delivering them to supporters find it easier to build long-term donation relationships.
Even small organizations can change supporter engagement levels just by carefully analyzing data from a single survey and communicating "before and after support" through newsletters. Perfect systems matter less than accumulating small pieces of evidence. That's the starting point.
Structural Issues — Systems and Environment Hindering Data Utilization
Examines broader systemic challenges that limit NPO data capacity and adoption
Attributing NPOs' lack of progress in data utilization to individual organizations' lack of effort captures only half the problem. Behind this are structural issues affecting the entire sector.
First is the fragmentation of information disclosure infrastructure. The Cabinet Office NPO portal, public data from various jurisdictions, and voluntary disclosure information on CANPAN—these are not integrated, and there's no system for NPOs themselves to comprehensively manage and utilize their own organizational data. According to the Cabinet Office "Survey on the Actual Conditions of NPO Corporations and Usage of the Certified NPO System" (2023), among approximately 50,000 NPO corporations, the percentage electronically publishing business reports remains limited, and ensuring data standardization and machine readability is identified as a future challenge.
Second is insufficient function of intermediary support organizations. Intermediary support organizations capable of supporting data utilization are limited, particularly pronounced in rural areas. The structure where technical support resources are concentrated in major metropolitan areas creates gaps in the NPO sector similar to the digital divide.
Third is the mismatch between grant design and data utilization. Many grants are tied to single-year business plans, making it difficult to allocate funds to medium- to long-term investments like "data infrastructure development" and "evaluation system construction." The structure that prevents investment in the very mechanisms for measuring results ironically reproduces situations where accountability for results cannot be fulfilled.
These structural issues are not the type that can be solved by individual NPOs working hard with free tools. Regarding the background of why the ability to speak with data is required in collaboration with government agencies—namely the EBPM trend—this is explained in detail in Introduction to EBPM. While the starting point for data utilization lies in individual organizational practice, developing an ecosystem to support such practice is the challenge for the entire sector.
For NPO practitioners, data utilization is not a technology problem. It starts with design questions that begin with articulating the mission: "What do we define as results?" and "Who do we want to communicate what to?" Start by selecting "just one indicator to measure" from your organization's activities. One Google Form, one spreadsheet. That's all you need to start moving today.
For related practical methods, also refer to How to Create Logic Models, How to Draw Stakeholder Maps, and Collective Impact Design.
References
Survey on the Actual Conditions of NPO Corporations and Usage of the Certified NPO System — Cabinet Office. Cabinet Office NPO Portal
Survey on IT Utilization by Nonprofit Organizations — Japan NPO Center (JNPOC). Japan NPO Center
Giving Japan 2024 — Japan Fundraising Association. Japan Fundraising Association
Survey on Promotion of Statistical Data Utilization — Statistics Bureau, Ministry of Internal Affairs and Communications. Statistics Bureau
