Smart Search - Membership Groups as at a Specific Date

Modified on Wed, 18 Nov at 9:52 AM

Use Smart Search to identify and export members belonging to specific Membership Groups as at a particular date.


For example, you can use this search to determine how many members were in each Membership Group at the beginning of a month. This is useful for reporting on membership numbers at a specific point in time.


To track changes and movements between Membership Groups over time, use the Group Movement Detailed Report.


Steps – Create and Run the Smart Search


  1. Select Smart Search from the main menu.
  2. Select Members from the Search Output options.
  3. Click Next: Build Criteria.
  4. Set the Membership criteria using the following Search Field options:
    • Field Section: Membership
    • Field Name: Group
    • Field Operation: In
    • Field Value: Select the required Membership Groups by ticking the relevant checkboxes.
    • Time Period: Exists On
    • Date: Enter the date you want to search against (e.g. the first day of the month).
  5. Click the + Criteria button to add the search criteria.
  6. Optional – Include Resigned Members: By default, the search is restricted to members with a current status. To include resigned members, click the X next to Member Status Equal to Current in the Search Criteria section to remove this filter.
  7. Click Next: Preview Results to run the search and display the members who matched the selected criteria as at the specified date.


Export the Results to CSV

  1. Tick the Select All checkbox to select all members returned by the search.
  2. Click the Bulk Action button and select Export Members. This opens the data export window.
  3. Select the data fields you want to include in the export by moving them from the left column to the right column. The selected fields will determine which columns appear in your spreadsheet.
  4. Click Export to CSV to download the file to your device.





Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article