About the Shipment Cost Breakdown dashboards

The Shipment Cost Breakdown dashboards provide a detailed breakdown of rate shop selections, including base rates and categorized surcharges. All surcharges have been standardized to ensure consistent comparisons across carriers. Key breakdowns include carriers, service methods, and surcharges.

There are two Shipment Cost Breakdown dashboards:

1. Shipment Cost Breakdown. This dashboard displays shipment costs, with breakdowns by carrier and surcharge type.
2. Shipment Cost Breakdown Data Export. This data table allows filtering by carrier, carrier service method, surcharge type, surcharge name, surcharge cost, and volume of rates selected. This dashboard features two tables: one providing aggregated data for the trailing 90 days, and the other offering detailed shipment-level information, with each charge presented as a separate row, for the previous week. You can export filtered data to a CSV file.

👍

Customer data security

With Shipium’s reporting applications, you can count on your data being secure:

• Data encryption
• Compliance
• Access controls
• Security audits

This document provides an overview of the Shipment Cost Breakdown dashboards, outlining their functionality, handling of data exceptions, and key definitions. You can refer to the Domo Overview documentation for more general information on Shipium reporting and user roles in Domo.

Access the Shipment Cost Breakdown dashboards

To access any dashboard in Domo, you’ll need to log in to the Domo application:

1. Go to the Shipium-provided URL. It will look like: www.shipium-[customer name].domo.com.
2. Log in using your credentials: email, password, and a multi-factor authentication (via phone or email).

Next, you’ll navigate to the dashboard:

1. After logging in, you’ll use the vertical menu on the left side of the screen.
2. Go to the folder labeled “Shipment Cost Breakdown Dashboards”. You’ll select any of the dashboards nested under this folder to view their particular content.

View Shipment Cost Breakdown dashboards

This section includes instructions for each of the Shipment Cost Breakdown dashboards as well as default settings, metrics, and data nuances for these reports.

Filters for each dashboard are defined in the following table.

Terms used in these dashboards are defined in the following table.

Shipment Cost Breakdown Dashboard

While the default setting is a label creation period of the last seven weeks, grouped by week, you can adjust the dates in the top-right corner and apply filters across the top of the dashboard.

For each filter, this dashboard provides the following reports:

• Selected Rates Volume Summary
• Average Cost Per Package (CPP) Summary
• Rate Shop Volume and Average Cost Per Package
• Average Cost Per Package Breakdown
• Applied Surcharge Rate CPP by Surcharge Type
• Base Rate Cost Percent
• Comparison of Average Base Rate and Average Cost Per Package Over Time
• Percentage Average Base Rate of Total Average CPP by Carrier by Week
• Average Base Rate CPP vs. Total Average CPP

You can also click on specific visuals (e.g., Comparison of Average Base Rate and Average Cost Per Package Over Time) to filter the rest of the dashboard accordingly.

Shipment Cost Breakdown Data Export

As with the Shipment Cost Breakdown Dashboard, you can adjust the reporting dates in the top-right corner and apply filters via the drop-downs across the top of the dashboard.

Then you can export the data table as a CSV or Excel file, with the following restrictions:

• Domo only supports exporting one million rows at a time.
• Data is not available at the shipment ID level.

Default settings

Each dashboard defaults to a label creation period of the last seven weeks, grouped by week. You can adjust the time period filter for any period after 1/1/2023.

Metrics

The following metrics are provided for the Shipment Cost Breakdown dashboards:

• Selected rate volume. The total number of rates selected within the given time period; defined by the creation date of the carrier selection record
• Selected rate cost. The estimated cost at the time of rate selection
• Average cost per package (CPP). Calculated by dividing the selected rate cost by the selected rate volume; this dashboard highlights two types of CPP calculations.
  • Impact on total average CPP. Measures the overall impact of a surcharge by dividing the total surcharge cost by all rate selections and provides insight into how the surcharge influences average total CPP across all selected rates
  • Applied surcharge CPP. Focuses on the surcharge cost only for rates selected where the surcharge was applied and offers a targeted view of the direct cost impact of the surcharge

Data nuances

The following data nuances apply to the Shipment Cost Breakdown dashboards:

• All dashboards are based on a selected rate volume that is determined by the creation date of the carrier selection record.
• This analysis excludes uncosted shipments, meaning those for which labels were printed without Shipium calculating the cost.
• The dataset reflects trailing 90 days but does not contain shipment-level details. A data export dashboard offers detailed shipment-level information for the previous week, with each row representing either a base rate or a surcharge.

Resources

For assistance, reach out to your Customer Success Manager. Response times are typically within 2 to 5 business days.