Sorting and Filtering Donation Records

Sorting and Filtering Donation Records

Within your 360MatchPro account portal, you have the ability to sort and filter donation records to narrow down the exact data that you are looking for. 

Filtering Donation Records

You have the ability to filter donation records based on the following:
  1. Date Range
  2. Statuses
  3. Eligibility

Date Range

You can filter donation records based on a date range. The default date range will be 30 days, but you can change the date range based on what donation records you would like to see. 

Statuses

The statuses that you can filter are the following:
  1. Waiting for Donor
  2. Match Initiated
  3. Pending Payment
  4. Match Complete
  5. Unknown Employer
  6. Ineligible Eligibility

To filter out donation records based on their status, uncheck the status that you don't want to include so the donation records of the checked statuses only appear. 


The statuses you have selected will be visible below the search bar. You can remove a status by clicking on the ‘X’ next to the status. 

Eligibility

To filter donation records based on eligibility, check the eligibility type you'd like to include. The eligibility types are as follows: 
  1. Match Eligible 
  2. Volunteer Grant Eligible 
  3. Forms Available
  4. Donor Submitted


These eligibility types correspond to the insights in the company and status columns. For more information about Insights, view this article. 

The eligibility types you have selected will be visible below the search bar. You can remove an eligibility type by clicking on the ‘X’ next to the type. 

Sorting Donation Records

You have the ability to sort donation records based on the following:
  1. Date
  2. First and Last Name
  3. Amount 
  4. Email
  5. Campaign
  6. Phone Number
  7. Identifier
To sort these columns, you can click on the up or down arrow next to the column title:

There are two available search mechanisms in the 360MatchPro Donations tab:
  1. Simple Search: Enter in your search query, and Simple Search will scan for that string of characters across all searchable columns in the Donations table.
  2. Advanced Search: Select which searchable column you would like to scan for your search query and then enter your search query, and Advanced Search will scan for that string of characters in just the column you indicated. You can combine Advanced Searches to create a more narrow query.
Tip! Most 360MatchPro clients use Simple Search for a vast majority of their search queries. Advanced Search tends to be used by organizations with a large volume of donation records or with highly specific search queries.
To access the Advanced Search, select 'Switch to Advanced Search.'





With the Advanced Search, you can access the following searchable columns:
  1. Name
  2. Email
  3. Company
  4. Campaign
  5. Vendor
  6. Identifier


To create a more narrow query, you can combine Advanced Searches. If you use more than one of the search fields, 360MatchPro adds an "and" statement between the search fields. In the example below, donation records will appear where the campaign name is Cat Rescue Club AND the company name is Home Depot. 

Navigating through Donation Records

Within your donations tab, you can sort donation records so you see 25, 100, or 250 donation records at a time. You can do this by scrolling to the bottom of the donation records page and looking to the left-hand corner. Select the number of entries you’d like to see. 


You have the ability to sort through donation records by moving from different pages. You can do this by scrolling to the bottom of the donation records page and looking to the right-hand corner. Select the page you’d like to move to in order to view different donation records. 



Training Video: Sort and Filter Records







Training Video: Organize Donation Records











    • Related Articles

    • Getting Started: Donations Overview

      Donations Overview The donations tab shows all donation records that can be found within your 360MatchPro account. This includes specific information for each donation record that flows into 360MatchPro. This may include: Date of donation First and ...

    • Using CSV Download

      Exporting Donation Records Exporting Records Using Filters Log into 360MatchPro account ---> Donations To export donation data from your 360MatchPro account, you can set filters for the records you need including date, status, and particular ...

    • Understanding Individual records

      Each donation record includes the following information:  Donation date First and last name of the donor Donation amount Donor’s email address Phone number (if applicable) Company name (if applicable) Donor Status Campaign name Donation identifier ...

    • Blocklist: How Records are Added

      Adding Donation Records to Blocklist Donation records can be added to the blocklist in the following ways: If you have direct CRM integration with 360MatchPro and have donation records tagged "Do not email" those donation records will be added to the ...

    • Understanding Insights

      Email Insights Under the Company column of your Donations data, you’ll be able to see the eligibility of the donation record based on the company information that the donor has self-reported. They’ve self-reported in one of three ways: 1) If you have ...