Reports
MEP Deactivated Users
This data source provides information on MSISDNs that have been deactivated from US mobile operators and the MEP Subscription lists with which those numbers were associated.
Your ability to access these reports depends on whether your OpenMarket account manager has provisioned them for your company, and whether your organization's administrator has either shared the reports with you or given you access to the MEP Deactivated Users data source. If you have access to the data source then you can add the standard reports to your folders. If the reports are shared with you then you have either Can View or Can Edit access. A custom report allows you to select the fields you want in the report, as well as set how you want to aggregate and/or filter the report data. For either of these types of reports, data is available four months previous to the current date.
Dashboards and Reporting provides two types of reports, standard and custom. With standard or custom reports you can set a schedule to generate the report or set a specific delivery destinations.
- For generating a standard report, or for setting a schedule or delivery destination, see Standard Reports.
- For generating a custom report, or for setting a schedule or delivery destination, see Create a Custom Report.
You can choose to either view a report online or download a CSV, XML, or JSON ZIP file.
Note: Any report returning more than 500 rows can only be downloaded as a ZIP file and cannot be viewed online.
Standard reports
Standard reports were designed by OpenMarket as a set of default scheduled reports useful to most businesses. The MEP Deactivated Users data source is the source for these standard reports. There are no standard widgets for these reports.
-
Daily Detailed MEP Deactivated Users Report: This report returns details about the total number of deactivated users for the past 24 hours from the current date. It is set to run at 10:00 AM UTC. Fields returned are Collection, Subscription Name, Subscription ID, User ID, MSISDN, Network, Day of Disconnect Date.
- Daily Deactivated Users Count Report: This report returns the number of deactivated users for the last 24 hours from the current date. It returns the Count of User IDs per Collection, Subscription ID, and Subscription Name.
Custom reports
The custom report allows you to select the fields you want to include in the report and also uses the MEP Deactivated Users data source as the source for the report.
Data is returned based on the IDS contract Account ID corresponding to the MEP client you are associated with. The maximum date range supported by this data source is 4 months from the current date. All dates and times are UTC. There are no standard widgets available for this report.
Fields and Filters
The following describe the fields found in both the standard and custom reports. You can assign any alias you want to a report field so that the alias displays for the column name in the report instead of the field name. Click any field you want to add to the report, and in the Alias field enter a new name for the column. If you do not assign an alias to the field, the default column name is used.
Important: If you select None as an aggregate or filter type, you will not be able to change it to another type. You must first remove that aggregate and/or filter, re-add it, and then select the aggregate or filter type you want.
MEP Deactivated Data Source Fields and Filters
Parameter |
Description |
---|---|
Deactivate Date |
The date on which the user's phone number was deactivated. While not a required field, you'll need to include this field if you want to see a date range for deactivated users. If included, you can select to group data by any of the following:
Fillterable?: Yes. Used as a filter, this is a mandatory field. You cannot remove it. You can filter the report by the following:
When creating a scheduled report, use either the Predefined or the Rolling options as these adjust for each run of the report to show data relative to the run time. Aggregatable?: No. |
Client ID |
The MEP client identifier. Filterable?: No. Aggregatable?: No |
Collection Aggregatable?: No |
The subscription collection name. Filterable?: Yes. Aggregatable?: No. |
Contract Account |
The IDS contract account identifier. Filterable?: No Aggregatable?: No. |
Internal MEP List ID |
The MEP subscription identifier. Filterable?: No Aggregatable?: No. |
MSISDN |
The end user's mobile phone number, including country code. Filterable?: Yes. This is a text-only field. Enter a value by which to filter. Aggregatable?: Yes. This is a text-only field. Enter a value by which to aggregate data. You can return information by either of the following:
|
Network |
Identifies the mobile operator associated with the deactivated user's mobile number. This will always be a number; for example, use 383 for AT&T. Filterable?: Yes. This is a text-only field. Enter a value by which to filter. Aggregatable?: Yes. This is a text-only field. Enter a value by which to aggregate data. You can return information by either of the following:
|
Subscription ID |
The encoded MEP Subscription ID. Filterable?: Yes. This is a text-only field. Enter a value by which to filter. Aggregatable?: Yes. This is a text-only field. Enter a value by which to aggregate data. You can return information by either of the following:
|
Subscription Name |
The MEP Subscription Name. Filterable?: Yes. This is a text-only field. Enter a value by which to filter. Aggregatable?: Yes. This is a text-only field. Enter a value by which to aggregate data. You can return information by either of the following:
|
User ID |
The MEP user identifier. Filterable?: Yes. This is a text-only field. Enter a value by which to filter. Aggregatable?: Yes. This is a text-only field. Enter a value by which to aggregate data. You can return information by either of the following:
|
Collection |
Identifier of the subscription collection to which the deactivated number belongs and which is associated with your IDS contract account ID. This field uses Equals to return all Collections. It is used as a filterable field only. Filterable?: Yes. Aggregatable?: No. |