Asset Utilization reports

Asset Utilization reports help fleet managers understand how assets are being used.

These reports answer questions like: "Which assets are used a lot?" and "Which ones are underused?" This helps fleets to make smarter decisions about right-sizing, asset reallocation, and asset retirement.

Which asset utilization report should I use?

The default Asset Utilization report is an excellent starting place. With the default report, you can:

  • Download the results displayed on the Asset Utilization page, with all of the same filters applied.

  • Add a histogram to your Dashboard, to show the distribution of vehicles by days, hours, or distance driven.

  • Set up recurring emails to deliver asset utilization reports to your colleagues.

Use the advanced Asset Utilization report when you need:

  • An emailed report broken up into subperiods. For example, utilization for each day in the past month, or utilization for each month in the past year.

  • An emailed report that combines utilization data (days, hours, distance) with events (stops in a particular zone type, preventable idling).

Accessing the Asset Utilization report

You can access the Asset Utilization in the following ways:

Downloading the Asset Utilization report

Learn how to download the Asset Utilization report from the Asset Utilization page.

Note: The following workflow applies to the default Asset Utilization report.
  1. Navigate to Productivity > Asset Utilization in the main menu.
  2. Under Filters:
    1. Select the groups you want to include in the report.
    2. Select the asset types you want to include in the report.
    3. Select the powertrain or fuel types you want to include in the report.
    4. Select the assets you want to include in the report.
    5. Select a date range for your data.
    6. Click Apply.
  3. Download the report in the format of your choice:
    1. Click Reports > Standard to download the report as an Excel file.
    2. Click Reports > More Actions menu > Prepare PDF to download a PDF copy of the report.

Depending on the size of your report, it will take some time to generate. Navigate to Reports > My Reports to view its status.

Adding the Asset Utilization chart to your dashboard

Learn how to add the Asset Utilization report to your Dashboard

Note: The following workflow applies to the default Asset Utilization report.

You can add the Asset Utilization report to your Dashboard using the Adding Dashboard charts and Editing Dashboard charts workflows.

The first chart found in the Excel file will be added to the dashboard. For the Asset Utilization report, this is a Days Used histogram. If you want to use a different chart:

  1. Download the report template.
  2. Use Excel to edit the report template so that it contains only the chart you want to use.
  3. Save the template with a unique filename.
  4. In MyGeotab, navigate to Reports > All Available Reports in the main menu.
  5. Click + Report in the top toolbar.
  6. Select your new template.
  7. Locate the report on the All Available Reports page and select Edit report in the more actions menu.
  8. On the Dashboard tab, select + Create new chart.
  9. Configure the settings for your chart.
  10. Click Save.
Your new chart will be displayed on the Dashboard at the bottom of the page. Click and drag the chart to rearrange its position.

Additional Asset Utilization report options

The advanced Asset Utilization report offers additional options that are not available when using the default report.

You can access additional reporting options when you choose to use the advanced Asset Utilization report. The following options are available for the advanced report:

  • Sub-periods for emailed reports: You can choose sub-periods for your data for your emailed reports. If your date range is "last 12 months", you can expect the following behavior:

    • No subperiod: The Excel reports will contain one row per asset, showing the total usage over the past 12 months.

    • Daily subperiods: The Excel report will contain 365 rows per asset, showing how much the asset was used on each day in the reporting period.

    • Monthly subperiods: The Excel report will contain 12 rows per asset, showing how much the asset was used on each month in the reporting period.

  • Rules: You can choose the rules associated with the event data you would like included in the Excel report. You can select up to 12 rules.
    Note: Event data appears on the Data tab of the Excel report, which is hidden by default. You'll need to unhide the Data tab to view your event data.

These report options for the advanced Asset Utilization report can be found by opening the report on the All Available Reports page and locating the Additional report options section of the Email report tab.