Where Your Members Shop

Screen ID: 

Screen Title: 

Panel Number:

Data Source:

Snap Shot:

 

images\kb_closed_shg.gif

IPUANL-01

Where Your Members Shop

5006

ETRmmyy1, ETRmmyy2, ETRmmyy3

þ As of Month End

¨ Right Now


Click here to magnify

Access this screen by selecting Tool #979: Where Your Members Shop.

Helpful Resources

Visit Show Me the Steps for easy instructions on how to use CU*BASE to view where your members shop and complete other reporting functions and CEO-related tasks.

Dashboard Tips – Questions to Ask When Comparing a Dashboard with Another Dashboard or Report

Learn about downloading data to Excel or a comma-delimited file

Knowing Your Members CU*BASE Relationship Management Tools

Want merchant partners? Use our Building the Factory series to create a marketing campaign from start to finish!

 

Introduction to Where Your Members Shop

(See below for directions on using this screen.)

By definition, financial institutions are the middlemen of all middlemen. Settlement is about connecting our members with the retailers who are key to their daily lives. It’s not so much that someone wants a debit card, it’s that they need a convenient way to pay for groceries. And that’s where we come in. To do a better job in serving our members and being an advocate in our communities, we must understand who is important in our members’ daily lives.

With a little work, we can understand which vendors might consider our membership key to their business plans. What if you had a large number of members doing business with a vendor right around the corner? How would you like an email list or a phone log for all of your members who regularly shop at the grocery store next door or the home center down the street? Better yet, can you make a case for a new branch by understanding that your members constantly frequent a shopping location near some available space?

The Where Your Members Shop tool analyzes transaction descriptions and sorts activity by retailer name, letting you analyze where your members spend their money and even allowing you to market to these members via Member Connect.

Data on this screen is pulled from transaction descriptions, so the analysis will depend on what data was included in the transaction record from the merchant. Currently, transaction data for this screen is available for ACH debits, ATM, debit card, and online credit card purchases, using the previous month’s transaction files (ETRmmyy1, ETRmmyy2, and ETRmmyy3).

The real power of this dashboard is that you can trend the data to view membership and account details on members using a single merchant. Select a merchant and use Open-Closed Dashboard.

Overview

Find out where your members are shopping. This can be a great set of tools for marketing to members who have a loan elsewhere and/or paying someone else, but can also be helpful to find where your members are spending their money. Is there a local merchant that you could partner with to drive home the community spirit of the credit union industry?

Getting the Data

Credit card

To show credit card transactions. Applies only to CU*BASE online credit card activity (origin code 22).

Debit Card

To show debit card transactions (origin code 16).

ATM

To show ATM transactions (origin code 13).

ACH

To show ACH transactions (origin code 11).

Filtering and Sorting

Columns

You can also click on the column header to sort data by that column.

Column

Description

City/Extended Desc.

Choose this to sort alphabetically by the merchant’s city name. Keep in mind that this field sometimes contains other data such as a contact phone number or transaction descriptor

Merchant

Choose   this to sort alphabetically by retailer name, to help locate a particular local merchant or group together multiple locations of the same retailer.

State

Choose this to sort the list in descending order by total transaction amount (largest total purchases will be at the top of the list), to see where the majority of member funds are being spent in your community.

Transactions

Choose this to sort the list alphabetically by the merchant’s state. (This data is not always included in all transaction records.)

Total Amount

Choose  this to sort the list in descending order by the number of transaction records for each merchant (largest volumes will be at the top of the list), to see where the majority of member activity is occurring.

 

Analytics Booth: Power Line and Web Version

Launching the Web Version (F22) dashboard will provide additional tools to subscribers to analyze data that can only be found in Analytics Booth, including more screen real estate to view more data at one time, different filters and graphics, and new ways to understand the data. Non-subscribers will be presented with a splash page.

Use the Power Line (F23) button to launch an immediate trend line graph in Analytics Booth to help you better understand your data.

Not a subscriber? Learn more in the CU*Answers Store.

 

Buttons Available for Under 100 Merchants

If you filter the listing to under 100 merchants you have special buttons that can be used to group the data from these merchants together.

Buttons for under 100 merchants

Description

Export

Export the data in for these merchants for use with Report Builder (Query).  You can even append data to an existing file using this dashboard.  

Common Bonds

Use this option to view analysis of the members of these 100 or less merchants by the Common Bond analysis tools.

See These Members

Select this to view the members who use these 100 or less merchants.

Member Connect

After creating a database file using the Export feature, use Member Connect (F10) to contact those members.

Summary (F12)

Use this to view an analysis of data for the current month.

Show Exclusions

Show merchants excluded from the listing.  (Does not show if there are no exclusions.)

Clear Filters

Clears filters and returns listing to all merchants of selected data selection (credit card, debit card, ATM, and ACH)

Buttons Available for Merchant Listing of Over 100 Merchants

Button

Description

Export Full List

Export the data for all the merchants for use with Report Builder (Query).  You can even append data to an existing file using this dashboard.  

Summary (F12)

Use this to view an analysis of data for the current month.

Show Exclusions

Show merchants excluded from the listing.  (Does not show if there are no exclusions.)

 

 

 

 

Link to ID: https://help.cubase.org/cubase/cubase.htm#IPUANL-01.htm