Usage Reports

These 10 views are available:

• Overview Usage

  • SIM Details - Overview Usage (on demand)

• Overview Service Usage

• Usage Details

• SIM Details - SIM Usage

• SIM’s with usage per customer

• SIM’s with usage per VPMN

• SIM’s with usage per country

• SIM’s with usage per RAT

• SIM’s with usage details

These views are aggregated daily. The day considered here is based on UTC timezone.

1. Usage report dimensions and metrics

Dimensions are descriptive characteristics or attribute of your data. Example: dimensions show you when, where, what, why, with whom and how you view data in the report. The metrics are always expressed by numbers (number values, %).

Dimensions:

• REVENUE_DATE REVENUE_TIMESTAMP - Date and Timestamp of a given record

  • aggregation is done every 15 minutes

  • Timezone is of the User’s

• ACCOUNT_ID - Account to which the Usage record refers to

• SERVICE_TYPE_ID - Service Type to which the Usage record refers to: DATA, SMS-MO or NB-IOT

• SUB_SERVICE_TYPE - Sub-Service Type to which the Usage record refers to (only applicable to SMS-MO Service): A2P, P2A, P2P ON-NET or P2P OFF-NET

• IMSI, ICCID, MSISDN - SIM details to which the Usage record refers to

• ENDPOINT_ID - ID of the Endpoint to which the Usage record refers to (only available to Enterprise Users)

• IMEI - IMEI value to which the Usage record refers to

• REVENUE_PLAN_ID - Base Plan to which the record refers in case Usage was charged from the Base Plan

• REVENUE_BENEFIT_ID - Benefit to which the record refers in case Usage was performed under a Benefit

• REVENUE_ADDON_PLAN_ID - Addon Plan to which the record refers in case Usage was performed under an Addon Plan

• REVENUE_TARIFF_ID - Tariff applied to calculate the charges of the Usage performed. In case of Usage under a Benefit, Default Addon Tariff is provided

• REVENUE_RATE_ZONE_ID - Ratezone under which the Usage was performed.

• REVENUE_DYNAMIC_BENEFIT_ID - Dynamic Benefit to which the record refers in case Usage was performed under a Dynamic Benefit

• VISITED_OPERATOR_ID - Visited Operator Network in which Usage was performed. Visited Country is also taken from this information.

• ROAMING_RELATION_TYPE - Roaming Agreement under which Usage was performed: IR, OC or Direct

• SPONSOR_OPERATOR_ID - Sponsor Operator through which the Usage was performed. In case of Usage via OC or DIRECT, Sponsor Operator is NULL

• APN - APN in which DATA or NB-IOT Usage was performed

• RAT_TYPE - RAT Type in which Usage was performed: 2G, 3G, 4G, NB-IOT, 5G

Metrics: