Report Types, Account-Level and Device-Level

User-defined custom reports fall into two main categories:

Within each report category, you have a variety of options for selecting the data set to report on, over a particular period of time, and how often to generate the report.

Account-Level Reports

Account-level reports provide general data for all SIMs/devices in the account, or for a specified group of SIMs or devices. There are three account-level reports.

Report Type Description

Traffic Cost Summary

Summarizes usage and overage charges based on Pool Name or Report Group over a specified time period.

Devices Detail

Provides a listing of all devices and device attributes within the selected filters.

Devices Summary

Provides a device count with sub-totals based on a selected filter.

Device-Level Reports

Device-level reports allow you to obtain detailed data for a specific SIM/device or group of SIMs/devices. There are four device-level reports.

Report Type Description

Daily Traffic Usage

Provides the total SMS, Data, and Voice usage for the indicated device(s) for each day during a specified time period.

Traffic Summary

Provides the total SMS, Data, and Voice usage for the indicated device(s) during a specified time period.

Traffic Detail

Provides details for selected traffic types (billable and non-billable) for the indicated device(s) over a specified time period. All traffic events are timestamped.

Status Activity

Lists all status changes, rate plan changes, and pool changes for the indicated device(s) over a specified time period in chronological order. This report does not contain any traffic information.

Contract Term Report Lists devices with defined contract terms scheduled to complete in a specified number of days or less.

Report Types and Criteria

The Report type and sepcific report that you build will determine the remaining report criteria that must be defined. The following table describes the report criteria available to you from the Build tab.

Report Type Required Fields Limitations
Account, Traffic Cost Summary
  • Date: The report can contain data for Month-To-Date, User-Defined Range, or Last Month.
  • Group By: Pool Name or Report Group.

If you decide to save the report as a Scheduled Report, then you must also select the frequency.

  • Frequency: The available options vary based on the selected Date.
    • A "Month-To-Date" report can be delivered daily, on a specific day of the week, or on the 15th of each month.
    • A "Last Month" report will be delivered on the 1st of each month.
  • For a User-Defined Range, the From date MUST fall on the first day of the current month. The To date can be any date before the current date.
  • Because the data for this report is generated by an End-of-Day billing job, the report will reflect data correctly up to the last End-of-Day job, which is the previous day at midnight GMT.
Account, Devices Detail
  • Status: ALL, Bill, Provision, Suspended, or Cancel. The "ALL" status option is selected by default.
  • Service Name: The "ALL" Service Name option is selected by default. All Service Names associated with your account are also available in the drop-down menu.
  • Rate Plan: The "ALL" Rate Plan option is selected by default. All Rate Plans associated with your account are also available in the drop-down menu.
  • Pool Name: The "ALL" Pool Name option is selected be default. All Pool Names associated with your account are also available in the drop-down menu.
  • Date: The report can contain data for All days, Month-To-Date, User-Defined Range, Last 3 Days, or Last 7 Days.
  • Report Group: To filter out one or more Report Groups, enter the Report Group values in the provided text box separated by a comma.

If you decide to save the report as a Scheduled Report, then you can modify the data dates and select the frequency.

  • Date: The report can contain data for All days, Last 1 Day, Last 7 Days, Last Month, or Month-To-Date.
  • Frequency: The available options vary based on the selected Date:
    • An "All" report can be delivered daily, on a specific day of the week, or on the 1st or 15th of each month.
    • A "Last 1 Day" report will be delivered daily.
    • A "Last 7 Days" report will be delivered once each week. A specific day of the week can be selected.
    • A "Last Month" report will be delivered on the 1st of each month.
    • A "Month-To-Date" report is delivered on the 15th of each month.
  • It may take up to 60 minutes before new devices or recent changes to a device are reflected in the report.
  • The downloaded report will only contain the first 50,000 report entries.
  • There is no limit to the amount of entries delivered in the scheduled Account Devices Detail report.
Account, Devices Summary
  • Group By: Devices can be grouped by Pool Name, Report Group, Rate Plan, Status, Pool Name + Status, Report Group + Status or Rate Plan + Status.

If you decide to save the report as a Scheduled Report, then you can modify the data dates and select the frequency.

  • Frequency: The report can be delivered Daily, a Specific Day of the Week, or on the 1st or 15th of each month.
  • It may take up to 60 minutes before new devices or recent changes to a device are reflected in the report.
Device, Daily Traffic Usage
  • Date: Select to include usage over the Month-To-Date, User-Defined Range, Last 1 Day, Last 3 Days, Last 7 Days, or Last Month.
  • Device Attribute: Select the method you will use to specify the devices to include in the report: ICCID, EID, IMSI, or MSISDN.
  • Device List: Device IDs must be separated by a comma or listed one per line. A maximum of 10 devices can be entered.

If you decide to save the report as a Scheduled Report, then you can modify your selections.

  • Date: The report can contain data for Month-To-Date, Last 1 Day, Last 7 Days, or Last Month.
  • If you date selection is "Last 1 Day," you can select the toggle for All Devices to report on all devices your account.
  • Frequency: The available options will vary depending on the selected Date:
    • A "Month-To-Date" report will be delivered on the 15th of each month.
    • A "Last 1 Day" report will be delivered daily.
    • A "Last 7 Days" report will be delivered once each week. A specific day of the week can be selected.
    • A "Last Month" report will be delivered on the 1st of each month.
  • The "Data Usage" column in this report corresponds to the sum of data "From" and "To" the device in its "stopped" events. Started, stopped, and continued events are listed in the Device Traffic Detail report.
  • The data provided in this report is a rounded summary of the device's traffic transactions. This value may be slightly higher than the actual sum of all the data traffic records in the traffic detail report.
Device, Traffic Summary
  • Date: Select to include data for the Month-To-Date, User-Defined Range, Last 1 Day, Last 3 Days, Last 7 Days, or Last Month.
  • Device Attribute: Select the method you will use to specify the devices to include in the report: ICCID, EID, IMSI, or MSISDN.
  • Device List: Device IDs must be separated by a comma or listed one per line. A maximum of 10 devices can be entered.

If you decide to save the report as a Scheduled Report, then you can modify your selections.

  • Date: The report can contain data for Month-To-Date, Last 1 Day, Last 7 Days, or Last Month.
  • If you date selection is "Last 1 Day," you can select the toggle for All Devices to report on all devices your account.
  • Frequency: The available options will vary depending on the selected Date:
    • A "Month-To-Date" report will be delivered on the 15th of each month.
    • A "Last 1 Day" report will be delivered daily.
    • A "Last 7 Days" report will be delivered once each week. A specific day of the week can be selected.
    • A "Last Month" report will be delivered on the 1st of each month.
  • For a User-Defined Range, the From date MUST fall on the first day of the current month. The To date can be any date before the current date.
  • The data provided in this report is a rounded summary of the device's traffic transactions. This value may be slightly higher than the actual sum of all the data traffic records in the traffic detail report.
Device, Traffic Detail
  • Date: Select to include traffic from the Month-To-Date, User-Defined Range, Last 1 Day, Last 3 Days, Last 7 Days, Last 30 Days, or Last Month. 
  • Device Attribute: Select the method you will use to specify the devices to include in the report: ICCID, EID, IMSI, or MSISDN.
  • Device List: Device IDs must be separated by a comma or listed one per line. A maximum of 10 devices can be entered.
  • Traffic Types: The "All" Traffic Types option is selected by default. Selecting another radio button will display only that traffic type in the generated report:
    • Control Plane: Cellular registration events for the device(s) while operating in the cellular network can be a Registration, De-registration, or Clear Registration event. Please note that Control Plane information is not available for Dual-Mode A-LH devices.
    • Packet: Start, Stop, and Continue events for Packet data sessions
    • SMS: MO and MT SMS
    • Voice: MO and MT Voice

If you decide to save the report as a Scheduled Report, then you can modify your selections.

  • Date: The report can contain data for Month-To-Date, Last 1 Day, Last 7 Days, or Last Month.
  • The "All Devices" check box can also be used to include all devices your account.  This option can only be used for the "Last 1 Day" Duration.
  • Frequency: available options will vary depending on the selected Status Duration:
    • A "Month-To-Date" report will be delivered on the 15th of each month.
    • A "Last 1 Day" report will be delivered daily.
    • A "Last 7 Days" report will be delivered once each week. A specific day of the week can be selected.
    • A "Last Month" report will be delivered on the 1st of each month.
  • This report contains values for started, stopped, and continued event types. Note that the sum of data "From" and "To" the device in its "stopped" transactions corresponds to the value in the "Data Usage" column in the Device Daily Traffic Usage report.
  • For a User-Defined Range, the From date can be no earlier than 60 days prior to the current date.
  • It may take up to 15 minutes after a traffic event before it is reflected in the report.
  • The downloaded report will only contain the first 50,000 report entries.
  • There is no limit to the number of entries delivered in the scheduled Account Devices Detail report.
  • Control plane information is not available for Dual-Mode A-LH devices.
Device, Status Activity
  • Date: Select to include activity within the Month-To-Date, User-Defined Range, Last 1 Day, Last 3 Days, Last 7 Days, Last Month, or Provision-To-Date.
  • Device Attribute: Select the method you will use to specify the devices to include in the report: ICCID, EID, IMSI, or MSISDN.
  • Device List: Device IDs must be separated by a comma or listed one per line. A maximum of 10 devices can be entered.  

If you decide to save the report as a Scheduled Report, then you can modify your selections.

  • Date: The report can contain data for Month-To-Date, Last 1 Day, Last 7 Days, or Last Month.
  • Frequency: available options will vary depending on the selected Status Duration:
    • A "Month-To-Date" report will be delivered on the 15th of each month.
    • A "Last 1 Day" report will be delivered daily.
    • A "Last 7 Days" report will be delivered once each week. A specific day of the week can be selected.
    • A "Last Month" report will be delivered on the 1st of each month.
  • Provision-To-Date includes all activity since the date the device was provisioned.
  • It may take up to 60 minutes before new devices or recent changes are reflected in the report.
Contract Term Report
  • Duration: Enter the number of days that the Contract Term Report will report data on. For example, if you enter 5 as the Duration, the report returns all devices with a Contract Term scheduled to complete in 5 days or less.

If you decide to save the report as a Scheduled Report, then you can modify your selections.

  • Frequency: The report can be delivered Daily, a Specific Day of the Week, or on the 1st or 15th of each month.
 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.