Channel Activity by Member Age Group

Screen ID: 

Screen Title: 

Panel Number:

Data Source:

Snap Shot:




Channel Activity Summary



þ As of Month End

¨ Right Now


Click here to magnify

Access this screen by selecting Tool #200: Channel Activity by Member Age Group.

If I use the Channel Activity by Member Age Group dashboard (Tool #200) and choose the ATM/Debit (PIN) Processing and Debit (Signature) Processing channels, how is the data gathered?

Export and Common Bonds Using Selectable Data Points

Any data point that is selectable (differentiated by a button-like highlight, also note that when hovering over a clickable data point the cursor adjusts to allow selection) will allow you to select to either Export the data to a file, or to use Common Bonds to view additional data sets.

Additional Dashboard Links

Tips for CEOs

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

See also: Knowing Your Members CU*BASE Relationship Management Tools

Go to Example

This tool will allow you to see what types of transactions (based on transaction origin) are being performed by specific age groups. For example, if you wanted to know how many ACH transactions your 55-65 members were responsible for, this tool could provide that answer.

IMPORTANT: Because data comes from transaction history, activity such as cashing checks which don’t cause a transaction record will not be included in these figures. Any member totals may not include all members since all members may not have transactions in any given month. Use Member Counts (F11) to view a listing of total number of members in the MASTER file.

This tool lets you segment members by age group, and then analyze up to five key areas where these members are interacting with the credit union called “delivery channels.” You can define up to 7 different age groups and then break down their activity by delivery channel. The first two columns which are shown by default show you the total number of members that are active in each age group and its associated percent.

When the screen first appears, select the channels (origin codes) that you want to evaluate. The screen then calculates activity for each channel according to the default age groups. (Use Change Ages (F5) to adjust these groups if you wish.) All data is taken from static figures gathered at month-end from transaction history files (stored in a file called MACKASUM; data is available going back to May 2004).

Use the Activity Date field at the top of the screen to specify which month you wish to analyze. Both individual and organizational accounts are included in this analysis (“age” is calculated from the Charter Date for organizations).

If you select to display percent by delivery channel, under the “Members” column, you will see the number of members in each age group, with a percentage of the total members. (The % should add to 100 going down the column). The remaining groups—representing the Channels you selected in the fields above—show the number of transactions performed by each age group for each of the transaction origins.



Field Descriptions

Field Name


Activity Date

The month who’s month end data is used to calculate the results.

Display Percent

By delivery channel (default): Shows percentage activity by transaction type

By age group (second image in this help topic): Shows percentage by age


Select an option here to show activity of just one branch. If no selection is made, then all branches’ activity will be shown.

Master Type

All (default): Both individual and organizational membership transactions are shown

Individual: Only transactions made by accounts held by an individual are show

Organizational: Only transactions made by organizational accounts are shown.


Select up to five delivery channels in these fields.

The descriptions for the Origin codes come from the MAORIGSEQ file.




Change Ages (F5)

Select this to change the age ranges used to calculate the percentages

Members/ Transactions (F6)

Select this to toggle between member counts and transaction counts.

Export Full List (F8)

Select this to export dashboard information to a file in your credit union's QUERYxx library.

Member Connect (F10)

Select this to create a file to be used with the Member Connect options.

Member Counts (F11)

Select this command key to view a listing of all of your members listed in the MEMBER file or all you non-members listed in the MSNONMBR file. These numbers contain all members in these files, not just members who have had transactions during the selected month.

Data Sources (F14)

Select this to view the tables and columns that are used to generate the data in this dashboard.



Link to ID: