Ever wonder just how profoundly a nonprofit can permeate and lift up its community? Look to Brooklyn Community Services (BCS). Since 1866, founded on the principle of neighbors helping neighbors, BCS has worked in neighborhoods impacted by systemic poverty. Today, the agency continues to strengthen communities by fostering the educational success of children, the leadership development of youth, the employment and housing stability of adults, the advancement of individuals living with disabilities, and the empowerment of seniors and families.
BCS roots its work in the struggle for social justice and, through action and advocacy, commits to shining a light on barriers that perpetuate inequitable systems as a part of the collective effort to ignite change.
Due to its diverse funding streams, program locations distributed over a wide geographic area across the Borough of Brooklyn, and recent mergers with other local nonprofits, BCS has grappled with maintaining streamlined internal communications, data aggregation, and cross-departmental workflows. Because programs are geographically siloed, BCS lacked a singular database platform that would allow ease of data sharing, including a way to easily manage internal referrals between programs, making it difficult to connect participants to additional beneficial services within BCS. There was a need to bring all of the various sites and departments together through mutual referrals and technical and administrative support. Moreover, the requirements to track program data in third-party funders’ proprietary databases presented a need for a data management system with broad reporting and integration capabilities, attributes that were insufficient in BCS’ legacy database.
Many BCS programs that serve individuals with developmental disabilities are reimbursed for services through Medicaid and Medicare. One such program is Day Habilitation, which helps adults with developmental disabilities to maximize independence in daily living, personal health, and socialization. Prior to implementing Apricot, preparation for biweekly billing reports regularly took the Program Director and other staff two to three days to complete, having to sift through multiple excel sheets and paper service logs to pull together and manually cross-reference data from all participants and caseworkers.
Site directors lead programs across BCS’ portfolio of services, and multiple staff members are responsible for providing and documenting direct services to participants. Because government funding agencies require regular submissions of quantitative and qualitative data documenting participants’ progress, it’s crucial that BCS administrators have the ability to build custom forms and reports in their data management system and that program leaders can track their participants’ progress toward goals and milestones. Without an easily customizable database with dynamic search and reporting capabilities, leaders of BCS programs like Youth Stand United, an education and skills development program serving youth and young adults in South Brooklyn, would often have to track data in spreadsheets, on paper forms, or in word processing documents.
Over the course of more than a year of staggered implementation, BCS has rolled out Apricot as their primary program and administrative database system agency-wide. It is the hub of all things data-related, from program participant demographics, enrollments, and services to incident reports, internal referrals, and maintenance requests. In addition, program staff may consult an internal Program and Employee Directory to identify additional services that may benefit their clients and then reach out to their colleagues to initiate internal referrals.
The site-based permissions settings in Apricot ensure that participant information is kept secure and only accessible to relevant program staff members and administrators. The import interface allows administrators to quickly update entire programs’ rosters at once with data pulled from funders’ proprietary sites.
BCS development staff is able to quickly pull program- or division-specific reports of participant demographic information required for grant applications. Looking ahead, BCS is working with their Apricot account managers and support specialists to identify opportunities to integrate their system with external databases to further simplify data collection and reporting processes.
Thanks to the Apricot software system, the billing process for BCS’ programming for the developmentally disabled has been tremendously refined and expedited. Now, their software immediately converts data of services delivered into billable units in an exportable document formatted for submission to a third-party billing agency. All that is required now is to enter a date range, and Apricot does everything else. “A process that would previously take two to three days now takes literally 20 minutes; it’s one of the best features that I really, really like about Apricot,” says La’Kisha Alvarado, the supervisor who oversees BCS’s Day Habilitation, Community Prevocational, and Lifelong Enrichment programs, all of which utilize this tool.
Apricot offers a simplified dashboard view, allowing program directors to see essential information all at one glance, including names of program participants and staff activities. One can see, for example, how many progress notes each staff member has completed in a given time period, any existing gaps, and possible opportunities to improve and augment services.
Symphoni Samuels, the director of Youth Stand United, now has a report that allows her to track service activities by multiple criteria, either by participants or by staff members, to ensure that her staff members are entering data in a timely manner. She highlights the flexible filtering and reporting capabilities as key features of Apricot. Without the ability to run time-bound reports of services by staff members, service type, or program participants, submitting data to funders at regular intervals would be far more time-consuming. In addition, monitoring participant engagement and progress in real-time would be nearly impossible. Says Samuels, “We use it every day, for everything.”
For organizations as large as BCS, change management and implementation can present challenges. But La’Kisha Alvarado, whose programs were some of the first in the agency to utilize Apricot, is proud to share the accomplishment of working together with her team to successfully implement the system: “When staff is accustomed to doing something one way and then you show a new system, there can be resistance; they may not want to put the effort into learning it.”
For a social services agency as big, diverse, and responsive to its community as BCS, implementing any database system is a challenging and continual process. New programs start, and legacy programs end while others scale up or wind-down based on the current needs of Brooklynites. By creating solid deadlines, ensuring staff is meeting them and providing support in retraining when needed, BCS has set up an efficient system that has become simple and repeatable: Program Directors meet with the internal Apricot system administrator to identify the data that must be tracked to satisfy funders requirements, then a process of iterative development and review takes place over several weeks to build out new forms, train and gather feedback from end-users, make revisions, retrain end-users, and provide support through and beyond system launch.
When BCS purchased Apricot to replace its legacy database, they intended to use it primarily to track program enrollments, services, and participant demographic and contact information. But since their initial buildout, they have found that the system can be used to simplify many common administrative workflows involving information management. For example, administrative forms now hosted in Apricot include:
Prior to implementation in Apricot, maintenance requests were submitted through a ticketing system that did not allow the facilities team to search by services requested or location, and there was no way to prevent duplicate ticket entries; merchandise requests were handled through electronic survey forms that couldn’t be customized to fit the marketing teams’ exact needs, which caused confusion for program staff completing them; volunteer assignments, contracts and grants, and incident reports were all tracked in electronic spreadsheets that lacked consistent formatting or reliable search capabilities; and other surveys were primarily completed by hand and later coded into spreadsheets.
A lot has changed in a short time. Facilities managers now receive automated emails alerting them when new maintenance requests are submitted. They can assign tasks to individual maintenance workers, send updates to the staff who submitted the requests, and submit purchase orders all from their Apricot dashboards. In addition, merchandise request forms are now streamlined and easy to submit and review, eliminating the need for additional back-and-forth communication between administrative and program teams around simple tasks.
Volunteer applications are now submitted directly to Apricot, triggering automated alerts to volunteer coordinators to review and reach out to applicants. Volunteers are also given access to update their personal and contact information and log their service hours through Apricot’s Connect feature. Additionally, the grants, finance, and executive team members have a user-friendly, universally-accessible platform to share documents and collaborate on proposals and contract management.
Today, agency-wide incident reports are better organized, consistent, and readily available for review by its committee each quarter.
Recently, BCS utilized Apricot’s Intake Form feature to disseminate and capture responses to its first agency-wide Diversity, Equity, and Inclusion (DEI) staff survey and its first agency-wide client satisfaction survey. This tool allowed staff and clients to submit survey responses on computers or smartphones while administrators collected the responses that individuals chose to submit in hard copy.
BCS creatively used Apricot’s Intake Form to implement its first universal client satisfaction survey across all its programs. Flyers with QR codes were printed to be scanned by smartphones, leading to the survey about their client’s program experience. Across the agency, they received over 700 responses. Next, survey results will be parsed by division and program, analyzed in-depth, and shared across the organization. Alba Rodriguez, Chief Strategy and Data Officer, says, “I think many people wouldn’t initially think a database could be used to do something like this. Our client survey distribution was a great first effort, and I’m really happy that we can now start looking at responses and sharing them with departments, program directors and executive staff.
The many ways in which Apricot benefits large organizations with diverse programming like Brooklyn Community Services include staff management, program and participant tracking, communication among staff, internal referrals, increased efficiencies, a more cohesive structure as a whole, and the list goes on and keeps growing. “Across all of BCS’s 40-plus programs, we probably use every feature available in Apricot – we use every part of it. And if there’s a feature that we don’t use, I might get excited and figure out a way to use it,” says Stephen Crano, Data Management Analyst at BCS.
|_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|