The Qualification Summary dashboard gives you a high-level view of interchange qualification across your portfolio. Use it to understand how your transaction volume is distributed across qualification groups, track downgrade rate trends over time, and pinpoint the merchants or card segments that need attention to reduce interchange costs.
Equivalent of the Interchange Qualification dashboard.
Default view displays settled data only. Use the Funding Method filter to access conveyed data.
Summary Pivot Table
Controls
|
Control |
Default |
Description |
|---|---|---|
|
Measure |
Net Sales, % of Total Net Sales, Downgrade Sales, Downgrade Rate, Transactions, Average Sale, Effective IC Rate, Potential Savings |
Multi-select — the eight measures listed are the default selection, not the full set. See the measure library below. |
|
Groups |
2 |
Number of active group levels (supports up to 8) |
|
Group 1 |
MID : Acquirer |
Primary row dimension |
|
Group 2 |
Card : MOP Name |
Secondary row dimension |
|
Date Granularity |
Month |
Y / Q / M / W / D |
Default Measures
Both pivot tables on this dashboard draw from the same measure library — only their default selections differ. The eight measures below are what the Summary pivot shows when you open the dashboard; use the Measure control to swap in anything else from the library when the default view does not answer your question.
|
Measure |
Description |
|---|---|
|
Net Sales |
The net revenue from sales after accounting for refunds. |
|
% of Total Net Sales |
The share of net sales out of grand total net sales. |
|
Downgrade Sales |
The sales volume processed at a downgraded interchange rate. |
|
Downgrade Rate |
The percentage of sales that incurred additional downgrade fees. |
|
Transactions |
The total count of all transactions, including both completed sales and refunds. |
|
Average Sale |
Average transaction value — net sales ÷ transactions. |
|
Effective IC Rate |
Interchange cost as a percentage of net sales. Net sales denominator excludes conveyed transactions. |
|
Potential Savings |
The estimated savings available from transactions eligible for interchange optimization, tokenization, and DCAP that have not yet been fully optimized. |
Downgrade Rate by MOP Name (Multi-Line Chart)
A multi-line chart showing the downgrade rate trend over time, with one line per MOP.
-
Y-Axis: Downgrade Rate (%)
-
X-Axis: Date (configurable via Date Granularity: Y / Q / M / W / D — defaults to Daily)
-
Lines: selected Group dimension
This chart opens on Daily while the pivot tables open on Month. That is easy to miss: a daily downgrade rate is far noisier than a monthly one, so a line that looks alarmingly volatile here may be perfectly stable at the granularity the tables are using. Switch the chart to M before comparing it against either pivot.
Controls
|
Control |
Default |
Description |
|---|---|---|
|
Group |
Card : MOP Name |
Dimension used to draw each line |
|
Top N |
10 |
Limits to the top N groups |
|
Date Granularity |
Day |
Y / Q / M / W / D |
Use this chart to compare downgrade rate trends across MOPs.
Transactions/Net Sales by MOP Name (Stacked Bar Chart)
A stacked bar chart showing net sales broken down by MOP over time.
-
Y-Axis: Transactions, Net Sales, % of Total Transactions, % of Total Net Sales
-
X-Axis: Date
-
Segments: MOP
Controls
|
Control |
Default |
Options |
Description |
|---|---|---|---|
|
Measure |
Amount |
Count, Amount, % of Total Count, % of Total Amount |
Switches the Y-axis metric |
|
Group |
Card : MOP Name |
— |
Dimension used to segment the bars |
|
Top N |
10 |
— |
Limits to the top N groups by volume |
|
Date Granularity |
Month |
Y / Q / M / W / D |
Date bucketing for the X-axis |
Use this chart to see the distribution of downgraded and optimal sales volume and how that mix shifts month over month. A growing share in downgrade categories signals increasing interchange costs.
Detail Pivot Table
The bottom pivot table provides a granular line-item breakdown by acquirer, merchant account, and card type, showing full monthly columns across the selected date range.
Controls
|
Control |
Default |
Description |
|---|---|---|
|
Measure |
Net Sales, Transactions, % of Total Net Sales, Effective IC Rate, Downgrade Savings, Potential Savings |
Multi-select — the six measures listed are the default selection, not the full set. See the measure library below. |
|
Groups |
3 |
Number of active group levels |
|
Group 1 |
Qualification |
Primary row dimension |
|
Group 2 |
IC : Description |
Secondary row dimension |
|
Group 3 |
Card : MOP Name |
Tertiary row dimension |
|
Date Granularity |
Month |
Y / Q / M / W / D |
Measure Library
The Detail pivot draws from the same measure library as the Summary pivot — the six columns named in its Measure control are simply its default selection. The full library is listed below, and any measure in it can be selected in either pivot, so use this table to work out what to add when the defaults do not tell the whole story.
|
Column |
Description |
|---|---|
|
Net Sales |
The net revenue from sales after accounting for refunds. |
|
% of Total Net Sales |
The share of net sales out of grand total net sales. |
|
Downgrade Sales |
The sales volume processed at a downgraded interchange rate. |
|
Downgrade Rate |
The percentage of sales that incurred additional downgrade fees. |
|
Transactions |
The total count of all transactions, including both completed sales and refunds. |
|
Average Sale |
Average transaction value — net sales ÷ transactions. |
|
Effective IC Rate |
Interchange cost as a percentage of net sales. Net sales denominator excludes conveyed transactions. |
|
Downgrade Savings |
The estimated savings available from downgraded transactions that could be corrected and requalified at a better interchange rate. |
|
Potential Savings |
The estimated savings available from transactions eligible for interchange optimization, tokenization, and DCAP that have not yet been fully optimized. |
Use as Filter
Any cell value in the pivot tables or any element in the charts can be used as a cross-dashboard filter. To apply:
-
Right-click on any cell value or chart segment
-
Select Use as Filter from the context menu
-
The entire dashboard — both charts and tables — will update to reflect that selection
To remove the filter and return to the full view, click the Revert Use as Filter button in the top right corner of the dashboard.
This is useful for quickly drilling into a specific acquirer, qualification group, or card type across all components at once without manually adjusting each control.
Filtering Tips
Use the Filters button at the top right to refine your view:
-
Date Range for Charts and Data: Defaults to the last 13 months including the current month
-
Funding Method: Switch between Settled (default) and Conveyed data
-
Date Granularity: Switch between Yearly, Quarterly, Monthly, Weekly, and Daily. Each element carries its own control and they do not all start in the same place — the Downgrade Rate chart opens on Daily while everything else opens on Month
Use Case Example:
"We want to find out which acquirers are driving the most downgrade costs and whether it's getting worse."
Check the Downgrade Rate by MOP Name chart to see which lines are trending upward — these are your highest-risk MOPs. Switch it to Monthly first, since it opens on Daily and day-level downgrade rates are noisy
Right-click a line or bar segment and select Use as Filter to scope the entire dashboard to that selection instantly
Review the Summary Pivot Table — red-highlighted cells in Effective IC Rate and Downgrade Rate pinpoint the costliest acquirer / MOP combinations
Switch to the Detail Pivot Table to drill into specific qualification groups and IC descriptions to identify what's driving downgrade volume
Click Revert Use as Filter when done to return to the full portfolio view