Getting Total Visibility With 7 Supply Chain Analytics Reports: CoyoteGO Premium User Guide
CoyoteGO® Premium isn’t just focused on your short-term shipping needs. It’s designed to help monitor and improve the long-term health of your entire supply chain.
How does our free, cloud-based TMS give you the visibility you need to take total control? Through seven unique supply chain analytics reports that you can access on demand at any time right in the platform.
This is the last chapter of this guide and your final step in familiarizing yourself with all the features of our powerful shipping platform that can help you save time, eliminate errors and ship with the confidence of a true logistics pro.
In this chapter, you’ll learn about the following reports:
- Acceptance Report
- Load Detail Report
- Load Rate Detail (Accessorial) Report
- Carrier Scorecard
- Carrier Network Scorecard
- Load Service Report
- Load Tracking Report
- Custom Reports
*To view any image in this post at a higher resolution, right click it and select "Open image in new tab."
How to Access Supply Chain Analytics Reports in CoyoteGO Premium
Your data reports are accessible from any page in CoyoteGO Premium via the red menu bar at the top of the screen.
Simply click the “Reporting” link to visit the platform’s analytics hub. From this page, you can export specific load data, generate the seven out-of-the-box reports we’ll cover in this chapter, and view any custom reports our team has put together for you.
When you select an analytics report, you can either view and manipulate it in the CoyoteGO Premium platform or export and download it as a Microsoft Excel, PowerPoint or .pdf file. All reports update automatically every day at 5:00 a.m. Central Time.
If you’re confused about any term or category you see in these reports, each one includes a definitions tab that explains them and describes how we calculate values for certain quantitative data fields.
But if you have any questions at all about the information you see in your supply chain analytics reports or how to best make this data actionable, please reach out to your CoyoteGO Premium support team.
Acceptance Report
What is it?
This report shows you tender acceptance performance for any carrier or group of carriers in your network. You can see how often they accept your tendered freight, reject it or let your tender expire.
When should you use it?
The acceptance report is most useful for evaluating your contracted carriers’ tender acceptance rate. However, it can also be used to focus on your spot freight, to give you a window into which carriers are participating most frequently and to help you determine if you want to pursue a contract rate with them in the future.
Pro Tip
If tender acceptance rate is one of your most important logistics KPIs, you’ll want to have a clear idea of the benchmark standard you expect the carriers in your network to hit.
This report is most valuable when used to see who is honoring their commitments to haul at a high level and who is not.
Load Detail Report
What is it?
The load detail report contains every piece of information about every shipment you move through the platform. These include:
- Load date
- Carrier
- Whether it’s spot or contract
- Number of stops
- Total miles
- Load progress (dispatched, delivered, etc.)
- Mode
- Equipment type
- Freight volume
- Freight weight
- Origin and destination
- Shipper and consignee names
- Financial data
When should you use it?
This report can help you assess your actual shipping needs at a granular level. You can filter each data category to determine how many truckloads you move vs. LTL shipments, which of your lanes are getting the most traffic, and so on.
Pro Tip
The load detail report is most effective when pulled and analyzed with a regular cadence. Whether this means monthly, quarterly or something else for you, you’ll find the best results when you use it to assess changes over time that may prompt network rebalancing or optimization in the future.
Load Rate Detail (Accessorial) Report
What is it?
The load rate detail report is where you can really dig into your freight financials with precision. It contains an itemized cost report for each shipment you move that covers:
- Linehaul
- Fuel
- Accessorials and additional charges
Note that this report displays costs in U.S. dollars only. Keep this in mind when using it to evaluate any cross-border shipments.
When should you use it?
The load rate detail report is your go-to tool when preparing transportation financial data for your company’s leadership. It can help you pinpoint the source of fluctuations in your spend, whether they’re due to macro rate cycles in the truckload market, fuel cost increases or some other factor.
Pro Tip
This report becomes even more powerful once you export it to Excel. By adding a lane column, you can determine costs on a lane-by-lane basis over any period of time. You can also filter it to help you calculate cost per pound, percentage of your total spend that’s going toward fuel, or any other slice of this thorough data set. Feel free to contact your onboarding team with any questions.
Carrier Scorecard
What is it?
A carrier scorecard provides your team a snapshot of a single carrier’s performance as it pertains to tender acceptance rates, on-time metrics and bounce data (when a carrier accepts your tender but is unable to complete a shipment due to mechanical failure, weather or another reason).
Each carrier scorecard includes both an executive summary with high-level performance rates highlighted and detailed breakdowns of whether performance benchmarks were hit for each load you’ve moved with them over any period of time.
When should you use it?
These reports can be used to monitor carriers’ performance in real time or as a tool for periodically checking in on their performance history (such as for a quarterly business review).
If you start to suspect from anecdotal data that a carrier is falling behind your targets for on-time performance or tender acceptance, you can quickly pull a carrier scorecard to see if that is indeed the case.
Pro Tip
The executive summary tab of each carrier scorecard contains a holistic score out of 100 that describes your carrier’s overall performance. This score is a weighted average of each of your transportation KPIs, and you can adjust their weights manually to place more importance on ones that your business prioritizes.
Carrier Network Scorecard
What is it?
This is basically a carrier scorecard expanded to the scale of your network. It contains the same capabilities for assigning a weighted performance score out of 100 to your network as the individual carrier scorecards and the same option to dig into metric-by-metric data in more detail.
When should you use it?
This report is most useful for a quick top-level view of your entire network. It can help you assess whether performance has dipped in a significant way that may prompt a more targeted investigation using one of the other reports at your disposal.
Pro Tip
This report can also be used to assess a subset of your network rather than its entirety. You can filter carriers operating in a specific region, servicing a specific facility, in a specific mode or any other grouping that provides you the insights you seek.
Load Service Report
What is it?
The load service report focuses on on-time performance metrics for your network. These include not only on-time pick-up and delivery data, but dwell time as well (the amount of time your carrier’s truck waited at a pick-up appointment before embarking on its route).
When should you use it?
You’re most likely to use this report if on-time performance is a high-priority KPI for your business. It is your quickest and most detailed look at which carriers are meeting your targets and which are not.
Pro Tip
This report is just as useful for evaluating your own performance as it is for that of the carriers in your network, and it’s particularly powerful when used in tandem with the load rate detail report.
If you see in the load rate detail report that you’re spending an unusually high amount on detention, the load service report can help you identify which of your facilities are most at fault and help you pinpoint necessary improvements to your own operational efficiency.
Load Tracking Report
What is it?
The load tracking report compiles tracking data for all your currently active shipments. It is a one-stop shop for viewing shipment locations (it pulls last known location data via EDI) and any tracking notes that have been left.
When should you use it?
Consult this report whenever you want to know the real-time scheduling demands of your network. You can see how many loads you have picking up at a facility in a given week, appointment times across your network, and anything else pertaining to scheduling and location.
Pro Tip
You don’t actually need to export this report to Excel to get the most out of it. You can simply navigate your report using the clickable arrows in the CoyoteGO Premium interface to see all the relevant tracking data at a glance.
Have Unique Supply Chain Data Needs? Ask Us About Custom Reports
If you have a request for a specific data set that you don’t see represented in any of the reports here, our supply chain engineering team is happy to help you create a custom report.
Read more about our reporting and analysis services and schedule an appointment with one of our logistics data experts to discuss scope and pricing options.
See Supply Chain Data in Action in a CoyoteGO Premium Demo
The best way to visualize all the data available into CoyoteGO Premium is to ask our platform specialists to show it to you in action.
You can schedule a CoyoteGO Premium demo either by reaching out to your shipper representative or by filling out the form at the link below. We can’t wait to show you everything you can do in a completely free TMS platform.
Read the Full CoyoteGO Premium User Guide
Chapter 1: Demo & Implementation
Chapter 2: Using the Dashboard & Tendering Freight
Chapter 4: Managing Shipments & Financials
Chapter 5: Analytics Reports