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:

  • Day — The deactivation date per the UTC. This is the default value.
  • Week — this is Sunday to Saturday
  • Month — each calendar month
  • Quarter— The quarters are: January-March, April-June, July-September, October-December
  • Year— year by 1st of January until 31st of December

Fillterable?: Yes. Used as a filter, this is a mandatory field. You cannot remove it.

You can filter the report by the following:

  • Predefined — select a predefined choice. This can be either Today, Yesterday, This Week, Last Week, This Month, or Last Month; however remember that the maximum date range is restricted to 2 days for this report (as set in the Accepted Date filter)
  • Rolling — select the type of time period (e.g. Hours) and how many units of that time you want included in the report. For example, "5 Hours" will create a report that, when run, includes the last 5 hours data.
  • Equals — select a specific date by clicking the calendar icon, or by entering the date using a yyyy/mm/dd format.
  • Custom Range — select a date range; however, remember that the maximum data range is 2 days for this report.

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:

  • None — Displays the field's actual value.
  • Count — Number of records represented by this line.

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:

  • None — Displays the field's actual value.
  • Count — Number of records represented by this line.

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:

  • None — Displays the field's actual value.
  • Count — Number of records represented by this line.

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:

  • None — Displays the field's actual value.
  • Count — Number of records represented by this line.

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:

  • None — Displays the field's actual value.
  • Count — Number of records represented by this line.

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.