The CEDP L2/L3 Dashboard provides visibility into Level 2 and Level 3 data penetration and savings across your payment portfolio. It surfaces how much of your transaction volume qualifies for L2/L3 interchange rates, what the resulting savings look like versus potential, and allows you to drill into the underlying data through configurable pivot tables.
Submitting L2 and L3 enrichment data on eligible transactions can unlock lower interchange rates. This dashboard helps identify where that opportunity exists and tracks whether it is being captured.
Equivalent of the L2/L3 Optimization dashboard.
This dashboard displays sales transactions from Mastercard and Visa that are eligible for L2/L3 enhanced data processing. Adjust the Eligible L2/L3 filter to view non-eligible transactions.
Summary Pivot Table
The top pivot table provides a high-level breakdown of L2/L3 metrics across configurable dimensions.
Controls
|
Control |
Default |
Description |
|---|---|---|
|
Measure |
Transactions, Net Sales, L2 Penetration, Actual L2 Savings, Potential L2 Savings, L3 Penetration, Actual L3 Savings, Potential L3 Savings, Actual Savings, Potential Savings |
Multi-select — see available measures below |
|
Groups |
2 |
Number of active group levels |
|
Group 1 |
MID : Acquirer |
Primary row dimension |
|
Group 2 |
Card : MOP Name |
Secondary row dimension |
Available Measures
|
Measure |
Description |
|---|---|
|
Net Sales |
The net revenue from sales after accounting for refunds. |
|
Transactions |
The total count of all transactions, including both completed sales and refunds. |
|
Interchange Fees |
The total interchange fees assessed on transactions. |
|
Actual Savings |
The total cost savings realized from transactions successfully optimized through L2/L3 enrichment, tokenization, and DCAP. |
|
Potential Savings |
The estimated savings available from transactions eligible for interchange optimization, tokenization, and DCAP that have not yet been fully optimized. |
|
L2 Penetration |
The percentage of L2-eligible commercial card sales that were successfully submitted with Level 2 enhanced data and captured the lower L2 interchange rate. |
|
Actual L2 Savings |
The realized cost savings from transactions successfully processed at the L2 interchange level. |
|
Potential L2 Savings |
The estimated savings available from eligible transactions that could qualify for L2 interchange rates. |
|
L3 Penetration |
The percentage of L3-eligible commercial card sales that were successfully submitted with Level 3 enhanced data and captured the lower L3 interchange rate. |
|
Actual L3 Savings |
The realized cost savings from transactions successfully processed at the L3/Product 3 interchange level. |
|
Potential L3 Savings |
The estimated savings available from eligible transactions that could qualify for L3/Product 3 interchange rates. |
Use the group dropdowns to focus on specific acquirers or MIDs where L2/L3 submission rates may be low.
L2 & L3 Penetration (Combo Chart)
This chart shows L2 and L3 sales volume alongside penetration rates over time, using a dual-axis layout.
-
Left Y-Axis: Sales volume ($) — covers Actual L2 Sales and Actual L3 Sales as area/bars
-
Right Y-Axis: Penetration rate (%) — covers L2 Penetration and L3 Penetration as lines
-
X-Axis: Date (configurable via Date Granularity: Y / Q / M / W / D — defaults to Monthly)
-
Legend: Actual L2 Sales, Actual L3 Sales, L2 Penetration, L3 Penetration
Controls
|
Control |
Default |
Options |
Description |
|---|---|---|---|
|
Type |
All |
All, L2, L3 |
Filter to show All, L2-only, or L3-only series |
|
Date Granularity |
Month |
Y / Q / M / W / D |
Date bucketing for the X-axis |
Use this chart to understand what share of your total sales volume is being submitted with L2 or L3 data, and how that rate is trending over time. A low or declining penetration rate signals missed interchange savings opportunity.
L2 & L3 Savings (Stacked Bar Chart)
This chart compares actual savings realized against potential savings still available from L2/L3 data submission.
-
Y-Axis: Dollar savings ($)
-
X-Axis: Date (configurable via Date Granularity: Y / Q / M / W / D — defaults to Monthly)
-
Legend: Dynamically shows "Actual L2 Savings / Potential L2 Savings" or "Actual L3 Savings / Potential L3 Savings" based on the Type selection
Controls
|
Control |
Default |
Options |
Description |
|---|---|---|---|
|
Type |
L2 |
L2, L3 |
Toggle between L2-only and L3-only savings views |
|
Date Granularity |
Month |
Y / Q / M / W / D |
Date bucketing for the X-axis |
Use the L2/L3 toggle to isolate L2-only and L3-only savings views.
Detail Pivot Table
The bottom pivot table provides a more granular breakdown with up to 8 configurable group dimensions and monthly column headers for trend analysis.
Controls
|
Control |
Default |
Description |
|---|---|---|
|
Measure |
Net Sales, Transactions, Actual Savings, Potential Savings |
Multi-select — the four measures listed are the default selection, not a limit. This pivot draws on the same measure library as the Summary Pivot Table, so add any of those measures when you need them alongside the granular grouping. |
|
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 |
|
Group 3-8 |
— |
Optional additional row dimensions for deeper hierarchical slicing |
|
Date Granularity |
Month |
Y / Q / M / W / D |
Table Structure
|
Column |
Description |
|---|---|
|
Group columns |
Up to 8 configurable dimensions as row groupings (e.g., Acquirer → MID → Card Brand). |
|
Monthly columns |
Selected Measure values for each month in the date range, displayed side by side for trend comparison. |
Expand to additional group levels when you need to pinpoint exactly which acquirer, MID, and card brand combinations have the lowest L2/L3 penetration.
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, MID, or card brand across all components at once without manually adjusting each control.
Filtering Tips
Use the Filters button at the top right to narrow the dashboard:
-
Date Period: Defaults to the last 13 months including the current month — adjust to focus on a specific period
-
Eligible L2/L3: Defaults to eligible transactions only — switch to include non-eligible transactions
-
Funding Method: Switch between Settled (default) and Conveyed data
-
Date Granularity: Switch from Monthly to Quarterly or Yearly for a higher-level view
Use Case Example:
"We want to find out which of our MIDs have the lowest L2/L3 penetration and estimate how much we could save by improving submission rates."
Check the L2 & L3 Penetration chart — identify months where penetration rates are low or declining
Review the L2 & L3 Savings chart to quantify the gap between Actual and Potential savings over the same period
In the Detail Pivot Table, add a third group (e.g., MID : DBA Name) under the default Acquirer → MOP grouping — sort by L2 Penetration or L3 Penetration to surface the lowest-performing accounts
Right-click any low-performing MID row and select Use as Filter to instantly scope all charts to that account
Click Revert Use as Filter when done to return to the full portfolio view
Use these MIDs as the target list for L2/L3 enrichment enablement with your acquirer or processor