At Social Solutions, we get to see our customers make strides and take leaps when it comes to nonprofit data management and reporting. The Arab-American Family Support Center, based in New York, is one such customer. This nonprofit that empowers immigrants and strengthens families is in the process of overhauling its approach to data capture and reporting. We spoke with Stefanie Tocco Pilkington, AAFSC’s Senior Director of Special Projects and Strategic Initiatives, to learn more about how the organization is tackling this revamp and to uncover insights that can help other nonprofits that are taking similar steps to modernize their approach to data management.
Stefanie Tocco Pilkington: It started with the end in mind. When we looked at the data we capture, it’s essentially information about our clients, programs and impact. My question then became, “So what?” So what if we have information if we’re not deriving meaning from it or using it to drive decision-making? So what if we are gathering data if we’re not consistently using it to improve services? So what if we gather certain data points if we cannot understand how our efforts are fully impacting a family or community that we serve?
Essentially, this simple so what question is guiding our entire strategic data management initiative because it forces us to begin with the end in mind. By questioning our current state, we can start the process of raising our standards, capturing more actionable information and then doing something with it.
STP: Like many organizations, we’re starting from a place where much of our data is inconsistent and our data management tools are siloed.
As an example, we have eight program areas, and each have their own intake form and required fields. When staff input data, it is not consistent. As part of our plan to get more accurate and consistent data, we developed one single intake form across all programs to capture basic demographic data and then add supplemental intake forms that are program-specific, depending on the program requirements.
Another area that illustrates our current state is impact and outcomes reporting. In terms of evaluation tools, up to this point, we have not had one approach to evaluate programs, and through this initiative, we are starting with the end in mind to develop more specific program evaluation surveys to ensure we capture relevant outcomes and impact of our services. Our vision for impact reporting and communication is to have a more proactive approach, supported by a data dashboard where any staff can access the impact data they require for their specific program, which supports program quality improvement, funding opportunities and stakeholder engagement.
STP: One of our biggest challenges is overcoming existing perspectives of the burden of data entry. For instance, our Preventive Services program is highly regulated, since much of this work is focused on child welfare. As a result, our Case Planners are required to enter data into government databases and provide documentation and case notes. To avoid asking our staff to take on more data entry, we are redefining current client intake forms and processes to streamline the process.
Another challenge is consistency in data entry. We’re planning to overcome this with staff training, quality control checks and accountability. We will need to hold ourselves and each other accountable to ensure the entry and management of this initiative is successful.
STP: It all hinges on the understanding the “why” of the data we’re collecting, so we’re focusing on building a data culture. One critical piece for getting to our target state is putting a team in place to own client intake and evaluations. We’re carving out new space on our team so that we can centralize intake and evaluations through a dedicated staff of intake coordinators and an evaluation coordinator who will oversee the entire project. I have set the vision, and from there I am looking to the team to draft the process. It’s important that the people who will be running the work feel a sense of ownership.
Apricot 360 is another key piece of our plan. This data management system is a good fit for us right now because we can customize it to our vision and build straightforward, streamlined forms with required fields so that we can ensure data is captured consistently with no misalignment.
STP: My best advice is to be realistic about where you are today, where you want to go, and the steps you need to take to get there. Overhauling data management can feel like such a big project, but we aren’t biting off more than we can chew.
We are going to get to our target state, but we are being realistic that it will take lots of moving parts and steps along the way. We’re starting with aligning the team, getting the right technology and streamlining our forms. Once we’ve done these things, we can add more. Keep your “So what?” line of questioning alive, and focus on the realistic steps to get to your answers.
AAFSC provides culturally and linguistically competent, trauma-informed, multigenerational social services to the marginalized and under-resourced. While their doors are open to anyone, they have gained expertise serving Arab, Middle Eastern, Muslim and South Asian immigrant communities.
|_biz_flagsA||1 year||A Cloudflare cookie set to record users’ settings as well as for authentication and analytics.|
|_biz_pendingA||1 year||A Cloudflare cookie set to record users’ settings as well as for authentication and analytics.|
|_biz_sid||30 minutes||This cookie is set by Bizible, to store the user's session id.|
|ARRAffinity||session||ARRAffinity cookie is set by Azure app service, and allows the service to choose the right instance established by a user to deliver subsequent requests made by that user.|
|ARRAffinitySameSite||session||This cookie is set by Windows Azure cloud, and is used for load balancing to make sure the visitor page requests are routed to the same server in any browsing session.|
|BIGipServerab09web-nginx-app_https||session||This cookie is associated with a computer network load balancer by the website host to ensure requests are routed to the correct endpoint and required sessions are managed.|
|cookielawinfo-checbox-analytics||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".|
|cookielawinfo-checbox-functional||11 months||The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".|
|cookielawinfo-checbox-others||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.|
|cookielawinfo-checkbox-advertisement||1 year||Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Advertisement" category .|
|cookielawinfo-checkbox-necessary||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".|
|cookielawinfo-checkbox-performance||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".|
|CookieLawInfoConsent||1 year||Records the default button state of the corresponding category & the status of CCPA. It works only in coordination with the primary cookie.|
|__atuvc||1 year 1 month||AddThis sets this cookie to ensure that the updated count is seen when one shares a page and returns to it, before the share count cache is updated.|
|__atuvs||30 minutes||AddThis sets this cookie to ensure that the updated count is seen when one shares a page and returns to it, before the share count cache is updated.|
|__cf_bm||30 minutes||This cookie, set by Cloudflare, is used to support Cloudflare Bot Management.|
|_biz_nA||1 year||This cookie, set by Bizible, is a sequence number that Bizible includes for all requests, for internal diagnostics purposes.|
|_biz_uid||1 year||This cookie is set by Bizible, to store user id on the current domain.|
|bcookie||1 year||LinkedIn sets this cookie from LinkedIn share buttons and ad tags to recognize browser ID.|
|lang||session||LinkedIn sets this cookie to remember a user's language setting.|
|lidc||1 day||LinkedIn sets the lidc cookie to facilitate data center selection.|
|UserMatchHistory||1 month||LinkedIn sets this cookie for LinkedIn Ads ID syncing.|
|_gaexp||2 months 10 days 10 hours||Google Analytics installs this cookie to determine a user's inclusion in an experiment and the expiry of experiments a user has been included in.|
|_uetsid||1 day||Bing Ads sets this cookie to engage with a user that has previously visited the website.|
|_uetvid||1 year 24 days||Bing Ads sets this cookie to engage with a user that has previously visited the website.|
|SRM_B||1 year 24 days||Used by Microsoft Advertising as a unique ID for visitors.|
|_BUID||1 year||This cookie, set by Bizible, is a universal user id to identify the same user across multiple clients’ domains.|
|_ga||2 years||The _ga cookie, installed by Google Analytics, calculates visitor, session and campaign data and also keeps track of site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognize unique visitors.|
|_ga_33YSH1JFFW||2 years||This cookie is installed by Google Analytics.|
|_gcl_au||3 months||Provided by Google Tag Manager to experiment advertisement efficiency of websites using their services.|
|_gd_session||4 hours||This cookie is used for collecting information on users visit to the website. It collects data such as total number of visits, average time spent on the website and the pages loaded.|
|_gd_visitor||2 years||This cookie is used for collecting information on the users visit such as number of visits, average time spent on the website and the pages loaded for displaying targeted ads.|
|_gid||1 day||Installed by Google Analytics, _gid cookie stores information on how visitors use a website, while also creating an analytics report of the website's performance. Some of the data that are collected include the number of visitors, their source, and the pages they visit anonymously.|
|_hjAbsoluteSessionInProgress||30 minutes||Hotjar sets this cookie to detect the first pageview session of a user. This is a True/False flag set by the cookie.|
|_hjFirstSeen||30 minutes||Hotjar sets this cookie to identify a new user’s first session. It stores a true/false value, indicating whether it was the first time Hotjar saw this user.|
|_hjIncludedInPageviewSample||2 minutes||Hotjar sets this cookie to know whether a user is included in the data sampling defined by the site's pageview limit.|
|_hjIncludedInSessionSample||2 minutes||Hotjar sets this cookie to know whether a user is included in the data sampling defined by the site's daily session limit.|
|_hjTLDTest||session||To determine the most generic cookie path that has to be used instead of the page hostname, Hotjar sets the _hjTLDTest cookie to store different URL substring alternatives until it fails.|
|at-rand||never||AddThis sets this cookie to track page visits, sources of traffic and share counts.|
|CONSENT||2 years||YouTube sets this cookie via embedded youtube-videos and registers anonymous statistical data.|
|undefined||never||Wistia sets this cookie to collect data on visitor interaction with the website's video-content, to make the website's video-content more relevant for the visitor.|
|uvc||1 year 1 month||Set by addthis.com to determine the usage of addthis.com service.|
|_fbp||3 months||This cookie is set by Facebook to display advertisements when either on Facebook or on a digital platform powered by Facebook advertising, after visiting the website.|
|_mkto_trk||2 years||This cookie, provided by Marketo, has information (such as a unique user ID) that is used to track the user's site usage. The cookies set by Marketo are readable only by Marketo.|
|ANONCHK||10 minutes||The ANONCHK cookie, set by Bing, is used to store a user's session ID and also verify the clicks from ads on the Bing search engine. The cookie helps in reporting and personalization as well.|
|fr||3 months||Facebook sets this cookie to show relevant advertisements to users by tracking user behaviour across the web, on sites that have Facebook pixel or Facebook social plugin.|
|loc||1 year 1 month||AddThis sets this geolocation cookie to help understand the location of users who share the information.|
|MUID||1 year 24 days||Bing sets this cookie to recognize unique web browsers visiting Microsoft sites. This cookie is used for advertising, site analytics, and other operations.|
|test_cookie||15 minutes||The test_cookie is set by doubleclick.net and is used to determine if the user's browser supports cookies.|
|VISITOR_INFO1_LIVE||5 months 27 days||A cookie set by YouTube to measure bandwidth that determines whether the user gets the new or old player interface.|
|YSC||session||YSC cookie is set by Youtube and is used to track the views of embedded videos on Youtube pages.|
|yt-remote-connected-devices||never||YouTube sets this cookie to store the video preferences of the user using embedded YouTube video.|
|yt-remote-device-id||never||YouTube sets this cookie to store the video preferences of the user using embedded YouTube video.|
|_an_uid||7 days||No description available.|
|_clck||1 year||No description|
|_clsk||1 day||No description|
|_dc_gtm_UA-718299-1||1 minute||No description|
|_hjSession_2602456||30 minutes||No description|
|_hjSessionUser_2602456||1 year||No description|
|6suuid||2 years||No description available.|
|AnalyticsSyncHistory||1 month||No description|
|CLID||1 year||No description|
|d-a8e6||1 year||No description available.|
|dpi_test||1 day||No description|
|dpi_utmOrigVals||5 months 27 days||No description|
|intercom-id-rbb6qelf||8 months 26 days 1 hour||No description|
|intercom-session-rbb6qelf||7 days||No description|
|li_gc||5 months 27 days||No description|
|loglevel||never||No description available.|
|referrer||session||No description available.|
|s-9da4||15 minutes||No description available.|
|SM||session||No description available.|
|xtc||1 year 1 month||No description|