How to use the SIM reports

These 4 views are available:

Overview SIM Status
- SIM Status Details
Overview SIM Event
- SIM Event Details

1. SIM status (overview and details)

Main KPIs SIM status report

Total No. of SIMs as per the last available/selected date and %-difference with previous period
Total No. of Active SIMs as per the last available/selected date and %-difference with previous period
Total No. of SIMs with Usage as per the last available/selected date and %-difference with previous period
Charts in the middle and right-hand side,
No. of SIMs in each Status as per the last available/selected date of the multiple direct-Customers. The dimension of this chart can be per Subscriber Type (PostPaid or PrePaid), Account Type (Trial or Commercial) or Tier Type (Reseller or Enterprise)
Total No. of SIMs, No. of Active SIMs and No. of SIMs with over the available/selected dates.

There are multiple filters available

Date (Year, Month, Day)
Monthly (default) or daily granularity
Customer Name
Subscriber Type (PostPaid or PrePaid)
Account Type (Trial or Commercial)
Tier Type (Reseller or Enterprise)

2. SIM events (overview and details)

Main KPIs SIM Event report

SIM Events (No. of New SIM Activations by Subscription or First Usage, No. of SIM Delink or Link)

There are multiple filters available

Date (Year, Month, Day)
Monthly (default) or daily granularity
Customer Name
Subscriber Type (PostPaid or PrePaid)
Account Type (Trial or Commercial)
Tier Type (Reseller or Enterprise)

3. SIM 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:

DATE - day or month of a given statistic record
ACCOUNT_ID - Account to which the statistic record refers to

Metrics:

Metric	How is the metric calculated?
COUNT_OF_READY_TO_ACTIVATE_SIMS	This is the peak No. of Ready to Activate SIMs throughout the period. It is taken from the Inventory of SIMs (which provides the exact SIM status details at the time the reporting script is running) plus the distinct SIMs that moved from the Ready to Activate state (there’s a CDR generated for this event).
COUNT_OF_PRE_ACTIVE_SIMS	This is the peak No. of Pre-Active SIMs throughout the period. It is taken from the Inventory of SIMs (which provides the exact SIM status details at the time the reporting script is running) plus the distinct SIMs that moved from the Pre-Active state (there’s a CDR generated for this event).
COUNT_OF_ACTIVE_TEST_SIMS	This is the peak No. of Active-Test SIMs throughout the period. It is taken from the Inventory of SIMs (which provides the exact SIM status details at the time the reporting script is running) plus the distinct SIMs that moved from the Active-Test state (there’s a CDR generated for this event).
COUNT_OF_ACTIVE_INVENTORY_SIMS	This is the peak No. of Active-Inventory SIMs throughout the period. It is taken from the Inventory of SIMs (which provides the exact SIM status details at the time the reporting script is running) plus the distinct SIMs that moved from the Active-Inventory state (there’s a CDR generated for this event).
COUNT_OF_ACTIVE_SIMS	This is the peak No. of Active SIMs throughout the period. It is taken from the Inventory of SIMs (which provides the exact SIM status details at the time the reporting script is running) plus the distinct SIMs that moved from the Active state (there’s a CDR generated for this event).
COUNT_OF_SUSPEND_SIMS	This is the peak No. of Suspend SIMs throughout the period. It is taken from the Inventory of SIMs (which provides the exact SIM status details at the time the reporting script is running) plus the distinct SIMs that moved from the Suspend state (there’s a CDR generated for this event).
COUNT_OF_DEACTIVE_SIMS	This is the No. of Deactive SIMs throughout the period. It is taken from the Inventory of SIMs (which provides the exact SIM status details at the time the reporting script is running)
COUNT_OF_SIM_WITH_USAGE	This is the count of SIMs that generated Usage CDRs (SMS, Data or NB-IoT). It is taken by counting the no. of distinct IMSIs from the Usage CDRs generated during the period
COUNT_OF_TOTAL_SIMS	This is the total count of SIMs. It is taken from the Inventory of SIMs (which provides the exact SIM status details at the time the reporting script is running)
COUNT_OF_NEW_SIM_ACTIVATION_BY_SUBSCRIPTION	This is the No. of New SIM Activations by Subscription. It is taken from the State Change or Provisioning CDRs that relate to new SIMs and have Post-Event Subscriber State = Active
COUNT_OF_NEW_SIM_ACTIVATION_BY_FIRST_USAGE	This is the No. of New SIM Activations by First Usage. It is taken from the SFT-SIM Management CDRs (On-Usage Charge has to be configured in the Base Plan) that relate to new SIMs and have Post-Event Subscriber State = Active
COUNT_OF_SIM_STATE_CHANGE_TO_PRE_ACTIVE	This is the No. of SIM State Change to Pre-Active. It is taken from the State Change or Provisioning CDRs that have Post-Event Subscriber State = Pre-Active
COUNT_OF_SIM_STATE_CHANGE_TO_ACTIVE_TEST	This is the No. of SIM State Change to Active-Test. It is taken from the State Change or Provisioning CDRs that have Post-Event Subscriber State = Active-Test
COUNT_OF_SIM_STATE_CHANGE_TO_ACTIVE_INVENTORY	This is the No. of SIM State Change to Active-Inventory. It is taken from the State Change CDRs that have Post-Event Subscriber State = Active-Inventory
COUNT_OF_SIM_STATE_CHANGE_TO_ACTIVE	This is the No. of SIM State Change to Active. It is taken from the State Change or Provisioning CDRs that have Post-Event Subscriber State = Active
COUNT_OF_SIM_STATE_CHANGE_TO_SUSPEND	This is the No. of SIM State Change to Suspend. It is taken from the State Change CDRs that have Post-Event Subscriber State = Suspend
COUNT_OF_SIM_STATE_CHANGE_TO_DEACTIVE	This is the No. of SIM State Change to Deactive. It is taken from the State Change CDRs that have Post-Event Subscriber State = Deactive
COUNT_OF_SIM_LINK	This is the No. of SIM link. It is taken from the SIM Delink CDRs
COUNT_OF_SIM_DELINK	This is the No. of SIM Delink. It is taken from the SIM Link CDRs