Member Counts As Of Specified Date Report

Introduction

This report shows a breakdown of member profiles that were added and a breakdown of member profiles that were dropped within a date range that you specify.

Back to Table of Contents

Running the Report

  1. Click on the Reports menu and Run a Report.
  2. Click to expand the Member Reports.

  1. Click on Member Counts as of Specified Date.

This will open a window where you define parameters for the report.

After you click OK to run the report, you can refresh the report page at any time to go back to the parameters window, and make changes.

At the top of the report, be sure to look at the paging controls (see screenshot below). If the button on the right (next page) is available then there is more data.

Back to Table of Contents

Parameters

After you define these parameters, scroll to the bottom, and click OK to go into the report.

Enter Beginning of Date Range and Enter End of Date Range: This date range determines what period of time should be reflected in the report. Added or dropped profiles will appear if the Activity Date falls within this date range. 

Enter SortOption: This determines the sort order.

  • Date: If this is selected, the list of profiles will be sorted by the "ActivityDate" column.
  • Activity Type: If this is selected, the list of profiles will be sorted by the "ActivityType" column.

Back to Table of Contents

Breakdown of Report

Member Activity

This report is based on your Member Activity Codes.

When you create a Member Activity Code, you indicate if it is an Add Code, Drop Code, or Change Code.

So you might create an Activity Code called Joined which would be an Add Code, another Add Code called Rejoined, and a Drop Code called Dropped.

Back to Table of Contents

Sections

This report has two sections:

  • Adds: Member activity that is under an Add Code will appear in this section.
  • Drops: Member activity that is under a Drop Code will appear in this section.

On the left side, you can click Adds to jump to the beginning of the Adds section, or Drops to jump to the beginning of the Drops section. This is particularly useful if, for example, your Adds section spans several pages, and you are trying to find the Drops section.

Columns

In each section of the report, you can see the Activity Type, the Profile ID, the Report Name (name of the profile), and the Activity Date.

Back to Table of Contents

Totals

At the top of the report is the total number of members as of the beginning date specified.

At the top of the Adds section, you can see the number of adds.

This does not mean the total number of profiles. For example, ABC Company joined on 1/16/2023, but later dropped, and then rejoined on 11/13/2023. ABC Company would appear in the Adds section of the report twice, so the total is the number of add records.

Similar to Adds, at the top of the Drops section, you can see the number of drops.

Back to Table of Contents

Exporting

In the top left corner is a button to print which allows you to export this report to PDF.

Once exported to PDF, you can view and print the PDF.

Also in the top left corner is a button to export to other formats.

The other available formats include:

  • Crystal Reports (RPT)
  • PDF
  • Microsoft Excel
  • Microsoft Word
  • Rich Text Format
  • Character Separated Values (CSV)
  • XML

Back to Table of Contents

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request