Losing the Love - Products/Services Per Member
Screen ID: | ICLOMBR-60 | |
Screen Title: | Patterns in Products Per Member - Closed | |
Panel ID: | 6017 | |
Tool Number: | 132 | |
Click here to magnify |
Access this screen by selecting "Find Patterns in Products Per Member" or "Find Patterns in Services Per Member" on the entry screen.
About this Screen
NOTE: On the first day of the month this screen may be blank. The analysis is run during EOD on the first day of the month.
Create full-color PDFs of the data on the screen – PDF Exports
Learn about downloading data to Excel or a comma delimited file
Dashboard Tips – Questions to Ask When Comparing a Dashboard with Another Dashboard or Report
This dashboard analyzes changes in the number of products per member or services per member, depending on the selection on the entry screen and the filters made on this screen. You may find that some months do not have data, and this may mean that the account was closed during that month. Scroll down the screen to view data in all columns.
Using this Screen
The default shows the products or services per closed account each month. To view the accounts that changed, use the "Changes Only" button.
Use the Select Data to View button to sort the data on this screen by a different data selection. Use the buttons at the bottom of the screen to filter the data to include and exclude memberships. Sort the columns ascending and descending by clicking on the header row. Scroll down the screen to view data in all columns. Select an date to view the accounts associated with that line and close date.
Analysis at Top of Screen
The top of the screens shows a changing analysis based on the accounts analyzed.
Filter |
Description |
Show data through the end of |
Shows month selected on entry screen. |
Member count |
Shows number of accounts being analyzed |
Deceased |
Shows number and percentage of deceased members being analyzed |
Warning signs |
Shows number and percentage of accounts being analyzed that meet the warning signs. (See explanation of warning signs above.) |
Dormant |
Shows number and percentage of accounts being analyzed that are dormant. |
Filters
Filter |
Description |
This button reveals a screen that allows you to select the way the data on the screen is sorted and controls what data is listed in the left hand column. |
Buttons
Button |
Description |
Exclude Deceased/Show Deceased (F4) |
Toggles between excluding members who are deceased and including them. At the entry of the screen the accounts are included. |
Changes Only/All |
Toggles between members for which there was a change or all dates. |
View the products and services configuration. |
|
Export (F9) |
Reveals a screen allowing you to elect to export either the account numbers only (for use with Member Connect) or the entire contents of the file for use with Report Builder. |
Member Connect (F10) |
After creating a database file using the Export feature, use Member Connect (F10) to contact those members. |
Open Mbrs/Closed Members (F11) |
Toggles between showing open memberships and closed memberships. At entry of the screen defaults to show closed members. This allows you to compare your open membership across the same parameters as your closed analysis on this screen. |
Data Sources (F16) |
Reveals a screen listing the fields and files used to calculate the data on the screen |
View Filters (F17) |
Reveals a screen showing the filters used with the dashboard. |
Exclude Dormant/Include Dormant (F18) |
Toggles between excluding dormant accounts and including them. At entry of the screen defaults to include them. |