FAQ content

Reports & Organization Profiles: Create a report of organization profiles

In this article

Reports allow you to generate custom lists of organization profiles. When generating a report, you can filter profiles using any combination of their system fields or type-specific fields.

If you created a report that you need to run regularly, you can save it as a report template. A report template saves the filter settings you have in place, allowing you to easily apply them to future reports.

When viewing a report, you can customize which profile columns to show or hide, giving you a customized view. You can then export that customized report to an Excel (.xls) file if needed.

You can also view and, if you have the necessary permissions, edit the listed profiles directly within your report.

Create a new report

  1. Click on Profiles in the navigation bar and select Organizations.
  2. On the Organizations page, click on the New Report button.
    • You can also generate a report from the Reports > Report Files page.
The New Report button on the Organizations page
  1. In the Configuration dialog box, click the Start New / From Template dropdown and:
    • Select Start blank if you want to create a report without any preset filters.
    • Select Start from a template if you want to create a report using a saved template. Your new report will be preset with that template's filters, but you can further customize it as needed.
    • If you are starting from a template, select the one you want to use from the Template dropdown.
  2. Click the Confirm button.
The configuration dialog box

Customize report filters

After creating your report, you can now select the filters that you want to apply. Each filter allows you to retrieve profiles that meet certain criteria, such as profiles of a specific type or with specific memberships.

Primary filters

At the top of the report page, you'll find the Organizations Filters. You can use these to filter by organization profile fields like Name, Owner, Type(s), etc. This is in addition to any custom fields you've added to your Person/Organization Types.

  1. Initially, you'll be presented with a few common fields to filter by.
    • Depending upon a field's type, you can select an option from the filter's dropdown menu and/or enter a value.
    • For example, the Owner field is a dropdown list of all profile owners you can select from, while the # Interactions filter works by selecting a comparison type (less than, greater than, or equal to) and entering a number (resulting in a filter such as > 5 to find profiles with more than 5 interactions).
Default organization filter options
  1. To add or remove filters, click on the Add/Delete Filters option.
    • This will display the Add/Delete Filters dialog box, where you can select and deselect the fields you want to filter by.
    • To include custom fields added to your Person/Organization Types, select the Custom Fields checkbox.
    • When finished, click the OK button.
The Add/Delete Filters dialog box
  1. If you selected the Custom Fields checkbox above, the Custom Fields category will display on the report page.
    • From the Type dropdown, select a profile type, then select the custom field to filter by from the Field Name dropdown.
    • This will display the Value field, where you can provide the criteria for your filter.
    • To add more custom fields to the list, click the Add Custom Field option.
    • When more than one filter is selected, the Must Match All Custom Fields toggle will appear. This can be enabled to require interactions to match all custom field filters, or disabled to require interactions to match at least one of them.
    • To remove a custom filter, click on its delete_forever icon.
  2. To clear all applied filters, click on the Clear Search option.
Custom fields options

Additional filters

In the Additional Filters panel, you have the option of adding filters related to a profile's associated activity. This includes filtering by associated interactions, projects, and tasks.

So, whereas your report's primary filters allow you to filter based on data about a profile, the additional filters allow you to limit the report based on the data you've associated with it. For example, if you wanted to generate a report of organizations that were involved in a specific project, this would allow you to add a filter for that project's title.

  1. To add a filter, click on Add/Delete Filters option in the Additional Filters panel. This will display the Add/Delete Filters dialog box.
The Add/Delete Filters option in the Additional Filters panel
  1. Select the checkbox next to each filter you would like to include in the report. To remove an enabled filter, deselect its checkbox.
  2. When finished, click the OK button.
The Add/Delete Filters dialog box
  1. The fields you selected will appear in the Additional Filters panel.
    • Depending upon a field's type, you can select an option from the filter's dropdown menu and/or enter a value.
    • For example, the Project Title filter is a text field, whereas the Project Owner field is a dropdown allowing you to select one or more project owners from a list.
Filters added to the Additional Filters panel

Generate & export a report

After you've selected your filters, click the Generate Report button.

Generate Report button

Once the report has finished loading, a data table containing the matching records will appear at the bottom of the page.

  1. In the first column, you'll find the Name of the profile. Click on any link in this column to view the corresponding profile.
  2. The subsequent columns include details about each record. Click on any column heading to sort the table by that column's data.
    • If you are using the Type(s) filter, fields from the selected type(s) will be included as columns.
  3. You can show or hide fields from the data table by clicking on Options and selecting Set Report Data Fields. In the dialog box that appears, use the checkbox next to each field to show (check) or hide (uncheck) it.
  4. The last column is the Actions column, where you'll find a shortcut to editing the profile. If you have the necessary permission for that profile, click on its edit icon (the icon will be grayed out if you don't have permission).
  5. Use the pagination controls below the table to change the number of items displayed per page and navigate between pages.
  6. To export a report, click on the Export XLS option above the data table (you can also click on the Export XLS button at the top of the page). You will be prompted to give the exported file a name, then it will download in Excel (.xls) format.
    • The file will include the entire set of matching profiles (not just those visible on screen).
    • However, please note that it will contain only those columns currently visible in the data table.
    • Exported files are archived so you can re-download them again in the future. To manage your report files, go to Reports > Report Files.
A report's data table

Save a report as a template

If you'd like to create a report using the same filter settings in the future, click the Save as Template button. When prompted, give your template a name and click the Confirm button. Once saved, you can apply your template the next time you create a report.

To edit or delete a report template, go to Reports > Report Templates.

Save as template button and dialog box