Help Center

Best practice article

Export lists in bulk

Generate custom reports of organization and personnel records, create new Salesforce records, and download organization details in a table

In this help article...

Most Cause IQ users want to get the data that's relevant to them out of the Cause IQ website. This way, they can share their findings with colleagues and load the information into their systems (e.g., CRM, marketing automation software). Cause IQ has multiple purpose-built features to help you easily download pertinent information in bulk. You can use:

  • The export tool to generate CSV file reports of organization and personnel records;
  • The export tool to create new records in Salesforce; and
  • The table tool's "Download spreadsheet" button to quickly create Excel files containing quantitative and qualitative organization details.

Here's a video highlighting how you can use Cause IQ's export tool to generate bulk reports of organization data and contacts:

Export records to a CSV file

Cause IQ's export tool allows you to generate custom CSV files containing organization and/or personnel records. If you use a CRM other than Salesforce, generating a CSV export in Cause IQ is the easiest way for you to retrieve relevant data that you want to load up into your CRM. Here are the general steps:

  • Step 1

    Choose the organizations you want to export

    Either create a new search for a desired target market, load a saved search, or open a list (from scratch or an uploaded CSV file) in the search interface. To open a list of specific organizations, you just need to add a My saved lists filter from your search filter sidebar and choose the appropriate list's name.

  • Step 2

    Access the export tool

    Select the "Export" tab from the search interface to access the export tool.

  • Step 3

    Choose your export type

    In the "What" step of the export process, choose "Organization details" if you're looking to export just organization records from Cause IQ. If you want your CSV file to have personnel records, choose "Personnel, with organization details."

    If you have the Salesforce integration enabled, you need to select the "CSV spreadsheet file" box in the "CSV or Salesforce" section. All other customers will automatically have exports generated as CSV files.

  • Step 4

    Dedupe your export (optional)

    The "Which records to include" section lets you exclude both organization and personnel records that you've previously exported from Cause IQ (you choose to remember exports for future deduping in the "Remember exported records" section). You can:

    • Include all records (so no deduping)
    • Exclude records from specific remembered exports
    • Exclude records from all remembered exports

    Choosing to dedupe previously-remembered exports helps you only to export records that are new to your CRM and is helpful when you're exporting information from multiple searches that have overlapping results.

    If you're looking to exclude records that you have in your systems that are from data sources other than Cause IQ, you can use our CSV upload tool to match the records and create a list. With the list created, you then can add a My saved lists filter with an exclude method to your target search. Doing this removes all the organizations that belong to your list from your search. Check out this article for more details on the CSV upload tool.

  • Step 5

    If you're exporting personnel, select your personnel settings

    In the "Personnel" step of the export process:

    1. Choose the appropriate position levels and functions for the personnel you want to include in your export
    2. Set the maximum number of contacts you want to export from a given organization (Cause IQ exports the highest ranking personnel first)
    3. Select the appropriate contact information criteria (if you're looking only to export personnel with email addresses, we suggest you choose the first and second options)

    Pro tip: Choose to "Preview" your matching personnel, so you can check to make sure you're exporting the right type of contacts and see how many personnel records your CSV file will contain.

  • Step 6

    Choose the details you want to include in your export

    You choose the organization information and the contact information (when doing a personnel export) in the "Columns" step of the export process. To choose the desired fields, click the "Change columns" button on the right, find the desired columns by keywords or subcategories, and select "Add column".

  • Step 7

    Check your export settings and generate your report

    In the "Confirm" step of the export process, we suggest you that you review the information your CSV file will contain. Once you've confirmed that everything looks good, select "Create spreadsheet" and Cause IQ begins processing your export.

  • Step 8

    Download your CSV file

    Once Cause IQ processes your export, you can download the CSV file directly in the website from the blue pop-up notification. Additionally, your file is available to download from your dashboard and Cause IQ emails you the file.

    Now that you have your bulk export report, you can share your findings with colleagues, load the information into your CRM or marketing automation tools, work with the data in Excel, etc.

Create new Salesforce Objects in bulk

For Cause IQ's customers using the Salesforce integration, the process of creating new records in your Salesforce instance is very similar to the steps above. In the "What" step of the process, make sure you select "Salesforce" under the "CSV or Salesforce" section to tell the system you want to export directly to your Salesforce. 

When configuring Cause IQ's Salesforce integration, you choose to map your Salesforce fields to corresponding fields in Cause IQ. Since this is done beforehand, there's no need to select the information that you want Cause IQ to export to Salesforce. To make sure duplicate records aren't added to your Salesforce, Cause IQ respects your internal Salesforce deduping rules and has built-in Salesforce deduping.

After you review your Salesforce export selections, select "Start Salesforce export." Once your export finishes processing (please note that it takes longer to process Salesforce exports than to export to a CSV file) Cause IQ provides a CSV file that summarizes your Salesforce export. The file gives you information on the new records that were created and any that were deduped. You can download the file from the blue pop-up box or from your dashboard. Here's a screenshot of the "What" step that shows you where you choose to export directly to Salesforce:

Select to Export directly to Salesforce

Download organization details from the table tool

Cause IQ's table tool lets you easily compare data points for a given search segment. The tool has a built-in download feature that allows you to quickly generate an Excel file of relevant quantitative and qualitative organization information. You can use these Excel files to share your findings with colleagues and further analyze the relevant information. After you've either created a new search, loaded a saved search, or opened a list (from scratch or an uploaded CSV) in the search interface, click on the "Table" tab to access the table tool.

You can add most organization information to the table tool as a column. To download the organization information to Excel, click "Download table" and access the file from your computer's downloads folder.

Here's a look at where you can download organization information from Cause IQ's table tool:

Download table tool to Excel

Where to contact the Cause IQ team

If you would like to get in contact with Cause IQ to ask questions, share ideas, or to schedule a one-on-one web training, the easiest way to contact the Cause IQ team is from the orange-chat widget that you'll see at the bottom-right of this help center page and within the Cause IQ website.

Reach out to the Cause IQ team here