CF Insights FAQs

CF Insights was created in 2006 by the community foundation field as a partnership between FSG and the Council on Foundations. CF Insights continues the legacy of the Columbus Foundation who led the effort to track the field’s growth and evolution from 1988 to 2007. In 2015, CF Insights moved to Foundation Center (now Candid), who expanded the work and reach of CF Insights for eight years. As of September 1, 2023, CF Insights is a service of the Council on Foundations.

We’re excited to bring CF Insights back home to the Council and better serve our community foundation members and the field with benchmarking data, annual survey, and other resources.

Transition

As philanthropy-serving organizations, both Candid and the Council continually seek ways to center the needs of the sector in what we do. When our two organizations began discussing a potential move, we both saw a clear alignment with our respective strategic directions and a clear benefit for the field. 

Candid recognized the move as an opportunity for CF Insights to have an even greater impact than it does today by building synergies with the Council’s broad spectrum of offerings for community foundations. Candid also saw it as a way to fulfill one of its core strategic objectives: to put resources into the hands of as many organizations that could benefit from them as possible. Given the Council’s large and growing membership of community foundations, our organizations agreed that the Council is in a unique position to expand the reach of CF Insights and thus leverage it to better serve community foundations both now and in the future. We’re excited to add CF Insights to our roster of offerings for community foundations, who are vital forces for change in their communities.  

Yes! All previously collected data moved from Candid to the Council and continues to be securely maintained.

Reach us anytime at cfinsights@cof.org.

Membership Details

For most current CF Insights members, no.

Moving forward, member-level access to CF Insights will only be available through the Council’s Plus Membership add-on, which costs less than what foundations previously paid Candid but is in addition to Council membership.

Fees for Council membership and the Plus Membership add-on are on a sliding scale, based on the operating budget of your community foundation.

Learn more about Council Membership

Existing Council members can opt into Plus Membership anytime! We will prorate the cost of Plus to align with your current Council membership expiration date. Council members can also wait until their next annual renewal to add CF Insights access to your membership.

Programs and Services

Yes! The Council is committed to deepening our collective understanding of the state of the community foundation field and will continue to conduct the survey. The next survey, collecting data for fiscal year 2022 will open in the fall of 2023.

View the latest results

CF Insights is the financial and operational benchmarking platform designed specifically for community foundations. With CF Insights, you can:

  • Compare your community foundation to your peers. Use CF Insights to:
    • Find an ideal peer group using over 100 different criteria
    • Create and download comprehensive peer datasets
    • Track your community foundation’s comparative growth and performance over time
  • Access customized peer benchmarking dashboards, prepared by Council staff to share with your board. 
  • Get expert help to fully leverage toolkits to assess your operating model’s sustainability, including:
    • Activity-Based Costing, which helps you assess the true cost and performance of your community foundation’s products and services
    • Economic Scenario Planning, which helps you create forecasts to assess organizational sustainability as impacted by fluctuating market conditions
    • The Interactive Strategy Model, which helps you determine the impact of strategic operational changes on your community foundation’s economics

We’re always grateful for member input. Consider applying for our Community Foundations Advisory Group.

Using CF Insights Data Platform

Accessing CF Insights requires a free Council on Foundations account. To set up a new Council account, visit cof.org and click “Login” in the upper right-hand corner of the page:

Click Login in the upper right hand corner of cof.org

On the next screen, click “Don’t have an account?”:

Click Don't have an account?

Fill in all the required fields on the next screen: 

Fill in all the required fields on the next screen.

Once your account has been created, you can return to the CF Insights data platform and login with your Council login credentials. On the next screen, enter the name of your community foundation and your title (Optional) to request access to CF Insights, which will usually be granted within 1 business day. 

CF Insights collects financial and related operational data on community foundations based in the United States. A full listing of the data points can be found below:

Basic foundation data

  • Foundation data
    • Foundation name
    • CF Insights member
    • EIN
    • Region
    • Address
    • Year foundation created
    • Fiscal year end
    • Are you a conversion foundation?
  • Geographic
    • Does your community foundation serve an urban area, rural area, or both?
    • Scope of area served
    • Service area
    • National standards
  • National standards compliant status

Operations

  • Total population of area served
  • Organizational structure
  • Is your foundation an affiliate of another community foundation?
  • Is your foundation part of an administrative alliance?
  • Operating endowments and reserves
    • Does your foundation have an operating endowment?
    • Does your foundation have an operating reserve?

Staffing

  • Staffing by function, FTEs for the year, including all vacant positions, at year-end

Community Leadership

  • Please indicate in which of the following community leadership activities your community foundation engages:
    • Community foundation field building
      • Convening and facilitating
      • Educating legislators / advocating policy
      • Non-profit capacity development
      • Philanthropic advising / research on nonprofits
      • Research on community needs
      • Engages residents to actively listen to their concerns
      • Works across sectors
    • Which statement most closely describes your foundation's stance on community leadership?

UN Sustainable Development Goals

  • How familiar are you with the UN Sustainable Development Goals?
  • Does your community foundation leverage the SDGs to inform its work?
  • In what ways is your community foundation using the SDGs?
  • SDG connection to equity work
  • Which of the SDGs are advanced by the work of your community foundation?

The foundation and related entities

  • Core foundation only
    • Total – Assets at year end, Gifts received, Grants approved
    • Endowed assets and funds – Assets at year end
    • Quasi-endowed assets and funds – Assets at year end
    • Non-endowed assets and funds – Assets at year end
  • Supporting organizations – Assets at year end, Gifts received, Grants approved
  • Other related entities – Assets at year end, Gifts received, Grants approved
  • Audited or unaudited
    • Total foundation gross assets
    • Total foundation gifts
    • Total foundation grants

Product composition of core foundation (assets, gifts, and grants)

  • Agency/nonprofit endowment
  • Designated
  • Donor advised
  • Field of interest
  • Geographic affiliates
  • Deferred gifts
  • Scholarships
  • Unrestricted

Other products (assets, gifts, grants)

  • Products
  • Community leadership
  • Fiscal sponsorship / fundraising
  • Revenues earned on other services
  • Nonprofit resource center
  • Services to private foundations
  • Special initiatives

Operating expenses and revenues

  • Operating expenses
    • Core personnel expenses
    • Supporting org personnel expenses
    • Special initiative personnel expenses
    • Non-personnel expenses
    • Total operating expenses

Operating revenues

  • Fees
    • Administrative fees from fund assets
    • Administrative fees – one time gift fees
    • Fees for service for consultation
    • Transaction fees
    • PRI/impact investing fees
    • Planned gift fees
  • Fundraising to support operations
    • Gifts for operating capacity
    • Grants for operating capacity
    • Gifts/grants for special initiatives
  • Other revenues
    • Distributions from funds or endowments for operations
    • Distributions from operating reserve
    • Real estate revenue
  • Total revenues

Donor-advised fund details

  • DAF inactivity policy
    • Does your community foundation have a policy in place regarding inactive/dormant donor-advised funds?
    • Which of the following steps, if any, are taken by the community foundation to address dormant DAFs?
      • Notify the fund advisor to encourage them to activate the fund.
      • Distribute the fund to grant recipients that align with donor intent.
      • Transfer the fund to the community foundation's unrestricted fund.
      • Other steps taken
    • DAF fund types at the end of the fiscal year
      • Family/individual funds
      • Corporate
    • DAFs by endowment status
      • Endowed DAFs
      • Quasi-endowed DAFs
      • Non-endowed DAFs
    • DAF holder succession planning
      • What % of donors have designated the ultimate future purpose of funds over the life of the fund
        • Unlimited successors/spend down
        • Unrestricted or field of Interest
        • Other CF Fund
        • Unknown
    • DAF grantmaking over the last year
      • Proportion of DAF grantmaking to organizations in the CF's service area
      • Proportion of DAF grantmaking to non-US organizations
      • Proportion of DAF grantmaking that aligns with the community foundation's own focus issue areas
      • DAF revenues over the last year
      • Revenue retained from DAF administrative fees

Once you click "Submit" on any of the survey pages, any changes or updates you have made are automatically placed in the queue to be approved. 

Click submit.

When your changes are saved you will see a green checkmark on the top right of the page.  

Green checkmark

After submitting your survey, you will receive an email confirmation once that survey has been approved. 
 

After logging into the CF Insights data platform, click on the My surveys button on the home page or at the top of the page.

Click the My surveys button on the pageOr click the My surveys link at the top of the page

Once on the My surveys page, choose the option “Add new survey.” A new annual survey will be created automatically the day after your fiscal year ends.

Select the survey year

To complete a survey for a fiscal year not previously submitted, click the “Add new survey” tile, and select the desired fiscal year from the dropdown menu:

Add new survey
Select year

 

Begin by visiting cof.org and clicking “Login” in the upper right-hand corner of the page:

Click Login in the upper right hand corner of cof.org

On the next screen, click “Forgot Your Password?”

Click Forgot your password?

On the next page, enter your email address and click “Reset Your Password.”

Enter your email address and click Reset Your Password

You will receive instructions to your email address to reset your password and regain access to your Council on Foundations account, which you will need to log in to CF Insights.

To save benchmarking charts to your computer, right-click the chart and select “Save image as….”

Right click and select Save Image As

To export and download your benchmarking charts to your computer, select “Export to .xlsx” on the right-hand of the chart.

Select Export to xlsx

Logging into CF Insights requires (free) registration on cof.org. Once you’ve registered, return to CF Insights and click the “Login” button in the upper right corner of the page. 

Click Login

You will log in to the platform using your Council on Foundations credentials: 

Enter your login credentials

Once logged into your account, you will see the full navigation bar at the top of the page. You will also see an option to “Logout” in the top right of the page.

Logout

If you select the option to “Logout,” you will be returned to the Council on Foundations home page. 

To find the CF Insights annual survey, log in to the site using your Council on Foundations credentials, then select “My surveys.”

Click My surveysMy surveys

You will be directed to the page with your current and previous fiscal year surveys. Select the survey for the year you would like to complete.

Select the year you would like to complete

New surveys will state “NEW!” on the bottom right of the tile for that year. 

Annual surveys previously saved as a draft that you or others in your foundation have worked on will indicate how much of the survey has been completed.

If the survey for that year is complete and submitted, it will state “Progress 100%.”

Once the survey is approved by an administrator, it will state “Approved.”

To make changes to data that has already been submitted and approved, simply revisit the page you would like to make changes to and click the "Edit" button at the top right of the page.

Click Edit

After the data is edited, click “Save as draft” to save and continue later or “Submit” if the edits are complete.

Select Save as draft or Submit

 

Creating a peer group 

To create a peer group, click “Benchmarking” in the navigation bar after logging in.

Click Benchmarking

Once on the Benchmarking page, you will be able to create, edit, and save peer groups. Select “+ New peer group” to create your peer group.

Select + New peer group

Clicking “+ New peer group” will give you the option to name your peer group in the text box for “Peer group name.” 

Name your peer group

After naming the peer group, you must select at least one peer characteristic to save the peer group. 

Select a peer characteristic

After selecting a peer characteristic select “Save” in the upper right-hand corner of the Benchmarking page.

Save your peer group

When your changes are saved or submitted you will see a green checkmark on the top right of the page. Changes do not autosave – it’s best practice to save your changes often.

Peer group saved successfully

For each peer group page, you will see options to “Duplicate”, “Cancel”, and “Save”:

  • Duplicate – creates a copy of the current peer group. You will need to then click Save to keep that copy. 
  • Cancel – cancels all changes and reverts to the last saved state. 
  • Save – saves all changes 

When you are ready to save or duplicate your peer group, click the appropriate option.

Save or duplicate your peer group.

Previously saved peer groups will be available in the “Peer group” dropdown menu. You can make copies of and delete existing peer groups. 

Previously created peer groups will be available in the peer group dropdown menu

Editing and adding characteristics to your peer group

To edit your peer group, add peer characteristics (which essentially act as search criteria) to the characteristics section with “+ Add characteristic.” 

Select + Add characteristic

Select a characteristic and the appropriate operator from the drop-down menu. 

Select a characteristic and an operator

Input a number value or select a value from the drop-down menu.

Input a number value or select a value.

If required fields of the characteristics are not filled, the unfilled fields will be highlighted in red text when you attempt to show the results. You will also receive an error stating “Required Field” and be taken to the first empty required field.

Required fields must be filled

To add another characteristic, select “+ Add characteristic” and select AND or OR in the drop-down menu.

Select And or Or

To show the most recent results from surveys from each foundation, select the “Show most recent” button at the bottom of the characteristics before selecting the “Show results” button.

Show only the most recent

To delete a characteristic, select the “Delete” button to the right of the value box.

Select Delete to delete a characteristic

For each peer group page, you will see options to “Clear all” and “Show results”:

  • Clear all – clear all the characteristics selected and start over 
  • Show results – show the results for the peer group 

 

Clear all or Show results

When you are ready to clear all of your characteristics or show the results of your peer group, click the appropriate option. 

Adding comparative metrics to an existing peer group 

To add metrics to your peer group without using characteristics to filter your results further, click the “Metrics…” button after clicking “Show results.” 

Filter results by clicking Metrics...

Select a metric from the drop-down menu and select apply. To add another metric select “Add new metric,” select a metric from the new drop-down menu and select apply. You can also add multiple metrics at once before clicking Apply to create robust datasets in just a few clicks.

Add multiple metrics before clicking Apply

To delete a metric, select the trash can button to the right of the value box.

Select the trash can to delete

Again, select apply to apply the metrics to the results of the peer group.

Deleting an existing peer group 

To delete a peer group, select the peer group. To the right of the name, select the delete button to delete the group. 

Select Delete to delete a peer group

A pop-up will appear confirming if you would like to delete the peer group. Select “Ok” to confirm you would like to delete the group.

Confirm by clicking Ok to delete

 

To export and download peer data, create a peer group, then select “Show results” in the characteristics section.

Click Show results

In the results section, select “Export to .xlsx” to export and download your benchmarking report.

Click Export to xlsx

To complete your Basic foundation data, click “My foundation” in the navigation bar.

Click My foundation

Once on the My foundation page, you will be able to edit, save it as a draft, and submit your Basic foundation data. Click the Edit button in the upper right corner of the page to make any required changes.

You can hover over the Question mark symbol for clarification on any terms.

Hover over the question mark for more information

When you are ready to save or submit your data, click the appropriate option: 

  • Cancel reverts any changes without saving 
  • Save as draft saves made changes without submitting them for admin approval 
  • Submit sends changes to Council staff for approval 

When your changes are saved or submitted you will see a green checkmark on the top right of the page. Changes do not autosave – it’s best practice to save your changes often. 

After selecting the My surveys tab at the top of the navigation bar and after selecting the appropriate fiscal year, you will be taken to the annual survey for that fiscal year. 

Start the survey

On each annual survey page, you will see options to “Cancel”, “Save as draft”, and “Submit”. When you are ready to save or submit your data, click the appropriate option. These options will be at the top and bottom of every page in the survey.

Options to Cancel, Save as draft, or Submit

When your changes are saved or submitted you will see a green checkmark on the top right of the page. Changes do not autosave – it’s best practice to save your changes often. 

Changes successfully saved.

You will also see a progress bar that will inform you how much of your foundation’s survey is complete.  This progress bar will be at the top and bottom of every page in the survey.

Progress bar

When a progress bar circle is blue, you have completed that section in the survey. You will also see a yellow checkmark to the left of the title of the section in the survey.

Hover over the question mark for more information

If you have questions about any terms used in the survey, hover over the question mark to the left of the question or term.

Completed section

New or unanswered sections of the annual survey will have a blue dot to the left of the section. 

Unanswered sections will have a blue dot.

To expand a section or a question, click on the plus sign to the right of the section.

Click the plus sign to expand a section or a question.

To collapse a section or a question, click on the minus sign to the right of the section. 

Click the minus sign to collapse a section or a question.

If required questions of the annual survey are not answered, the unanswered questions will be highlighted in red text when you attempt to submit. You will also receive an error stating “Required Field” and be taken to the first empty required field.

Required questions must be answered.

You can click on the progress bar on the top or bottom of the page to move to different sections within the annual survey. 

Navigate using the progress bar.

You can also right-click any of the bubbles in the progress bar to copy the link to any individual survey section. 

Questions?

Connect with Council Staff

David Rosado

Senior Advisor, Community Philanthropy