Pool Utilization Report

The Pool Utilization page is available in the AerPort Portal under the Analytics menu. The Pool Utilization table displays each pool in your account and provides details on the devices and usage in each one. To view the report as an interactive line chart, switch the table to chart view.

Rate Plan Pools (Pools) are defined at the time your account is set up. When you create pools, each one is assigned a rate plan. The pool is then given a name, a start and end date, and rules about how to handle overages (optional).

For example, if your company has a rate plan named Acme_FG_10MB (shorthand notation for Acme company, Fusion Global product, and 10 MB of data monthly), it can create a Rate Plan Pool named ACME_FG_10MB_POOL (shorthand notation for Acme company, Fusion Global product, 10 MB of data per device in the pool).

Your company can then place devices into the pool and configure them using the Device Details page in AerPort.

Note: Only devices that are in a Billed state contribute to the pool.

In the Acme Fusion Global example, each Billed device contributes 10 MB to the amount of data included in the pool per month. The total data included in the pool is the number of devices multipled by the rate plan data size. If there are three devices in the pool, then the pool includes 30 MB of data in total. If one device in the pool uses 20 MB of data in one month and the other two devices each use 2 MB, the total data usage is 24 MB, which is still below the 30 MB of data included in the pool.

Note: A pool does not have a maximum size. Any data use above the Total Included Data in your pool results in overage charges. Check your pool use regularly to avoid unnecessary overage fees.

The Pool Utilization Report page displays a range of information about the pools, devices, and data usage for the configured time period.

The following components comprise the Pool Utilization Report screen:

Based on the Product, Pool Name, and Time Period filters you select, the Pool Utilization Report table updates with a list of appropriate pools. See the following sections to learn more about the report table:

To view more details about a pool, select a Pool Name from the Pool Utilization Report table to open the Pool and Device table. This table displays all devices in the pool and how much data each device used during the configured time period.

To use the Pool and Device table to help regulate activity in your pool:

1. Click the Pool Name in the Pool Utilization Report table.
2. Look at each device in the Pool and Device table.
3. Identify devices that cause your pool utilization to exceed or fall short of its target size.
4. Change the pool assignment for devices as needed.

In the screenshot below, the Total data usage and Projected usage are much less than the Total included data. Only a few devices are using the data included in the pool. Using this information, the owner of the pool may decide to move some inactive devices out of this pool or suspend them.

The Pool and Device table includes the following columns by default:

• Product: Product associated with the device.
• Pool Name: Name of the pool in which the device resides.
• Rate Plan: Rate plan associated with the device. The rate plan indicates the amount of data included per device.
• ICCID: Identification number of the SIM.
• Plan Included: Amount of data the device contributes to the pool.
• Current Usage: Amount of data used during the configured time period.
• Included Usage: Amount of data consumed from the pool during the time the device was assigned to the pool rate plan. If the total data consumed for the whole pool during the time period is less than 100%, this number is the same as Current Usage.
• Overage: Amount of data consumed after the pool consumed 100% of its data.
• Proj. Usage: Amount of data the device is projected to consume by the end of the selected time period.

You can search for a particular device using the Filter by Device box. This feature searches for a particular SIM using one of several types of identifiers shown in the drop-down list.

The following screenshot displays how you can use the Pool and Device table to compare individual device data usage in your pool. The red boxes highlight the following for each device:

Each device in this pool contributes 25 MB to the pool, and there are 200 billed devices in the pool. Data is showing for the first 24 days of the month. Unless this pool typically utilizes a much higher amount of data at the end of the month, this is an underutilized pool. The first 10 devices are projected to use only about 4.3 MB each. If most of the other devices have similar projections, the pool owner may use this information to reduce the rate plan to 4-5 MB instead of 25 MB.

To view the pool utilization data as an interactive line chart, click Chart.

The chart-view displays each pool as a chart with utilization data from over the last month. The lines on the chart represent the following:

Note: Monthly est pool size and Monthly pool size show the same value when no devices are added or removed from the pool during the month and no devices are moved in or out of the billed state.

To view additional information about a pool, hover over the blue or gold lines. This reveals a color-coded window with the following information about the pool:

• Date: Date the information is from.
• Monthly pool size: Amount of data alloted to the pool for the month.
• Actual usage to date: Amount of data used up to the selected date.
• Device count: Number of devices in the pool.

In the following example, the chart on the left reflects an optimized pool, while the chart on the right represents an underutilized pool.

Note: These chart examples were viewed at the end of the month, so the trend line provides a close approximation to the final usage for the month. If it is early in the month, the final actual usage will likely flux from the projected actual usage.

An overutilized pool shows the Actual usage to date line surpassing the Monthly pool size line.

To view further details about the pool, click on the chart to access the Pool and Device table for that pool.

Click Export to download the report screen information as a .csv file.

Note: You must remain in the AerPort app in your browser until the file successfully downloads.

To view the file, open the .csv file in a spreadsheet app. To view the file by importing it through the Microsoft Excel Data menu:

1. Open Microsoft Excel and create a blank workbook.
2. Select Data > From Text or From Text/CSV.
3. Locate the .csv file in your Downloads or other designated folder.
4. Right-click the file and select Import.
5. Follow the subsequent prompts to specify a comma-delimited file.
6. If you see an option for Data Type Detection, select Do not detect data types.

Long numbers like device IDs may default to a format similar to scientific notation in Microsoft Excel. To view the full ID numbers:

1. Select the range of cells you want to view.
2. Right-click the selected range.
3. Click Format > Number format.

You can add or remove devices from a pool whenever you choose. To review devices and add or change a device pool assignment:

1. Locate the device you want to adjust in the Pool Utilization Report page.
2. Hover the mouse over the ICCID copy select Copy to copy the number to the Clipboard.
3. Select the SIMs menu.
4. In the Search for Device box, paste the ICCID number and click the magnifying glass icon.
5. Select the Settings tab.

   

6. Select the pencil icon in the Rate Plan box.
7. From the Change Rate Plan and Pool Name box, you can adjust the device's rate plan and/or pool assignment and set the effective date.