Help Center

Best practice article

Analyze quantitative characteristics of like organizations

See how organizations match up against each other and view how their quantitative data points have changed over time

In this help article...

Understanding how like organizations match up against each other gives you the insights you need for proposal development and helps you answer client questions on industry trends. Cause IQ has tools and features to help you easily see how an organization's quantitative information compares to its peers, and learn how selected fields have changed over the years. Cause IQ customers use our purpose-built "Benchmark" tool to generate custom reports that compare and summarize quantitative details for up to 250 organizations at once. Additionally, Cause IQ's multi-year export feature is used to download specific quantitative information (e.g., financial data points) from the past five years for a desired search segment or list of organizations. Please note that the multi-year export feature can be used for more than 250 organizations.

Compare organization details with Cause IQ's "Benchmark" tool

If you're creating a proposal to present to a prospective customer, you can use the "Benchmark" tool to run pricing analyses to compare their fee-for-service fields (e.g., Accounting fees) to the fees of similar organizations. Additionally, if a client is looking for insights on how their quantitative characteristics compare to like organizations, you can use the "Benchmark" tool to quickly compare any of the organization's quantitative data to their peers. Here are the general steps:

  • Step 1

    Choose the organizations you want to benchmark

    If you're looking to benchmark organizations meeting specific criteria (e.g., "Total revenues," "Metro area"), simply add the appropriate filters from Cause IQ's search filter sidebar to narrow down on a desired search segment.

    If you're looking to benchmark specific organizations, you can do so by manually creating a peer list or using Cause IQ's "CSV upload" tool.

    Please note that your search segment or list must contain 250 or fewer organizations in order for you to use the "Benchmark" tool.

  • Step 2

    Access Cause IQ's "Benchmark" tool

    Select the "Benchmark" tab from the search interface to access Cause IQ's "Benchmark" tool.

    If you're benchmarking a list of specific organizations, go to the "Lists" section on the left of your dashboard, select the name of the list that contains the organizations you want to benchamrk, and choose the "Open" button on the right. This opens the search interface with the list as the only filter; click on the "Benchmark" tab to access the "Benchmark" tool.

  • Step 3

    Choose your benchmark type

    Since you're looking to compare the quantitative data of organizations, choose "Organization details" as your benchmark type.

  • Step 4

    Select your reference organization (optional)

    In the "Benchmark type" step, you have the option to include a baseline reference organization in your custom report.

    You can pick a reference organization from the list of organizations you're benchmarking by choosing "Select among organizations being benchmarked." If you're looking to add a reference organization that isn't in your benchmark group, choose "Search for reference organization." You have the option to search for a reference organization by Name, EIN, Metro area, State, and Revenue range.

    If you're using the "Benchmark" tool for proposal support, you want to select the organization that you're creating the proposal for.

    If you're using the "Benchmark" tool for client services, you want to select your client as the reference organization.

  • Step 5

    Select the quantitative fields you want to benchmark

    The "Fields and analysis" step is where you choose the details that you want to compare the organizations by. Select "Change columns" on the right and search for the field names by "Keywords" or find them by "Categories."

    The most common fields benchmarked by Cause IQ customers are "Accounting fees," "Program services revenue," and "Total expenses."

  • Step 6

    Generate your custom report

    Select "Next: Generate report," and Cause IQ will start creating your custom benchmark report.

  • Step 7

    Download your benchmarked information

    If you're looking to share your benchmark report with others for further analysis, select "Download to Excel" on the right of the screen and Cause IQ packages the benchmarked information in one file.

Export multiple years of quantitative information in bulk

Cause IQ's multi-year organization exports allow you to download quantitative data for organizations from the past five years, so you can analyze how specific data points have changed over time. First, add appropriate filters from the search filter sidebar to narrow down on a segment of organizations, or create a list of specific organizations in Cause IQ. Next, select the "Export" tab from the search interface to start the export process. If you're looking to export data from a list you created, go to the "Lists" section on the left of your dashboard, select the name of the list that contains the organizations you want to export, and choose the "Open" button on the right. This opens the search interface with the list as the only filter; click on the "Export" tab to start the export process.

The multi-year export feature is only available for exporting organizational information. In the "What" step of the export process, you want to make sure "Organization details" is selected in the "What to export" section. The "Single or Multi-year Export" section is where you choose "Multiple years of information, for last five years."

The "Columns" step of the export process is where you choose the quantitative information you want to include in your multi-year export. Choose "Change columns" on the right of the screen and search for the fields by "Keywords" or find them by "Categories." Once you're ready to run your multi-year export, select "Create spreadsheet" in the "Confirm" step. You can access your file from the in-site blue pop-up box, the Dashboard, or from your email that's associated with your Cause IQ account. Your file contains a most recent overview worksheet and one worksheet per year that shows the exported organizations' selected quantitative data point from the corresponding year. Here's a summary video that takes you through the multi-year export process, staring from the search interface: