Overview of Data Displayed

  1. Data Date Range and Completeness

    • The Date Range tool allows you to view the range of data available. If your data appears to be missing recent months, this is common and indicates a potential delay in data submission.
    • Check for any gaps in trend lines or unusual data spikes in your charts, as these may point to missing data or inconsistencies.
    • To see a breakdown of your data, hover over the trend lines to view the count of loads in a given period. Additional load count trend lines will soon be available.
  2. Verifying Data Accuracy

    • Confirm with your team that all data sources are contributing, especially if the displayed amount (e.g., $47 million in transactions or 31,000 loads) seems lower than expected.
    • Missing Data Sources: Ensure all locations and business units contribute data to avoid gaps, which can prevent a comprehensive analysis. 
  3. Categorizing Data by Load Type

    • If you do not see contract load data, verify with your team if these loads are being marked correctly.
    • Benchmark distinguishes spot rates from contract rates, so correctly labeling these will enhance the precision of your analysis.
  4. Handling Missing or Incomplete Data

    • ZIP Codes: Some data may lack ZIP codes even though they are required. Adding ZIP codes will improve geographic analysis accuracy.
    • Carrier Names and SCAC Codes: These details, often absent, are essential for identifying carriers in your dataset. Contact our team if you need assistance adding these.
    • Office Numbers and Load Planner Names: If you manage loads by specific offices or load planners, including these fields in your data will allow for more segmented analysis.
  5. Origin and Destination Locations

    • Benchmark allows flexible use of origin and destination fields for analyzing data by various dimensions, such as customer names or office regions. Work with your team to map relevant categories to these fields for better segmentation.

Data Validation

  • Review the Load Count to check for potential data inconsistencies. High rates of flagged loads may indicate areas that need attention, such as missing fields or errors in the data.
  • Our Data Validation Tool flags outliers and displays the percentage of loads with issues.