Reports
MMS Summary
This data source provides summary-level information about both MT and MO MMS messages. You can compare the messages you send against the messages delivered or failed, and the data source can calculate this as success and failure rates.
The data source contains data for two years prior to the current date. The maximum date range supported by this data source is 31 days. All dates and times are UTC.
Standard reports
Standard reports were designed by OpenMarket as a set of default scheduled reports useful to most businesses. The MMS Summary is the source for these standard reports:
- MMS Daily Summary - This Month
- MMS Daily Summary - Last Month
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 MMS Summary 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.
- For the steps to generate a standard report, see Standard Reports.
- For the steps to generate a custom report, see Create a Custom Report.
Fields and Filters
The following table describes the MMS Summary Data Source fields and filters. 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.
MMS Summary Data Source Fields and Filters
Accepted Date |
The time and date (in UTC) when we accepted a valid message request from your account or from a mobile operator. If included, you can select to group messages by:
Filterable? Yes. This filter is required cannot be removed. 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. |
Account ID |
The unique ID of an account you have with OpenMarket. Depending on your business requirements, you may have multiple accounts to send MMS messages. Include if your business is using multiple accounts, particularly if your business units use different accounts that you will need to report on. Filterable? Yes. Enter one or more account IDs on which to filter. From the drop-down list, enter the account ID, and then select it from the list. Search and add additional account IDs as needed. A tally keeps track of the number of IDs added to the filter. Alternately, you can filter on Account Name. Aggregatable? No. |
Account Name |
The unique name of an account you have with OpenMarket. Depending on your business requirements, you may have multiple accounts to send and receive SMS messages. You can alternatively use Account ID in the report. Include if your business is using multiple accounts, particularly if your business units use different accounts that you will need to report on. Filterable? Yes. Enter one or more account names on which to filter. From the drop-down list, enter the account name, and then select it from the list. Search and add additional account names as needed. A tally keeps track of the number of account names added to the filter. Alternately, you can filter on Account ID. Aggregatable?: No. |
Failure Reason |
Text description that identifies the reason the message failed to be delivered. Use this field to see the reason that the message failed to be delivered to the end user. Filterable?: Yes. This is a text-only field that supports the following failure reasons:
To add multiple values to the filter, enter a value from above, and then press Enter. Add another value. Continue to add as many values as you want to filter on. Aggregatable?: No. |
Message Originator |
The source number used to send an MT message or receive an MO message. Types of originators include short codes, text-enabled landlines, toll-free numbers, alphanumeric strings, and virtual mobile numbers (long codes). Filterable? Yes. Multiple values are supported. This is a free-text field, so you will need to know your originators before using this filter. To add multiple originators, include a line space between each number—that is, press the Enter key after adding each number so that each number is on its own line. Use this to split the message traffic by your message originators. You can use this in conjunction with the Message Direction field to see the messages coming from and to that originator. Aggregatable?: No. |
Mobile Operator ID |
Use this field if you want to see the operators your end users are connected to, organized by mobile operator ID. Use this field if you want to see the operators your end users are connected to. Note, however, that this does not always indicate the operator that we directly sent the messages to; some messages are sent off-net —for example, using a related operator in the same region— or in more remote locations by a high-quality route. This can be useful for troubleshooting high message failures with a specific operator. You can use this field instead of Mobile Operator Name. Filterable?: Yes. This is a text-only field that will always be a number — for example, enter 383 for AT&T, and 348 for T-Mobile in the UK. Multiple values are permitted, but each value must be on its own line. Enter a mobile operator ID, and then press Enter. Add the next operator ID, and again press Enter. Add as many mobile operator IDs as you want to filter on. Aggregatable?: No. |
Mobile Operator Name |
Name of the mobile operator associated with the end user's phone number. Use this field if you want to see the operators your end users are connected to, organized by mobile operator ID. Use this field if you want to see the operators your end users are connected to. Note, however, that this does not always indicate the operator that we directly sent the messages to; some messages are sent off-net —for example, using a related operator in the same region— or in more remote locations by a high-quality route. This can be useful for troubleshooting high message failures with a specific operator. You can use this field instead of Mobile Operator ID. Filterable?: Yes. This is a text-only field that will always be a number — for example, enter AT&T or Vodafone.. Multiple values are permitted, but each value must be on its own line. Enter a mobile operator name, and then press Enter. Add the next operator ID, and again press Enter. Add as many mobile operator IDs as you want to filter on. Aggregatable?: No. |
MO Accepted |
The number of MOs accepted by OpenMarket. Use this field to both aggregate and filter by the number of MOs accepted. Filterable?: Yes. Enter a value by which to filter. Aggregatable?: Yes. Choose one of the following categories on which to aggregate data:
|
MT Failed |
The number of requests sent that were failed by either OpenMarket or by the mobile operator before any attempt was made to deliver the message. Filterable?: Yes. Enter a value by which to filter. Aggregatable?: Yes. Choose one of the following categories on which to aggregate data:
|
MT Submitted |
The number of MTs that were submitted to OpenMarket. Aggregatable?: Yes. Choose one of the following categories on which to aggregate data:
|
Reports Expired |
The number of expired delivery reports. This indicates that the mobile operator could not reach the end user. Filterable?: Yes. This is a text-only field. Enter a value by which to filter. Aggregatable?: Yes. Choose one of the following categories on which to aggregate data:
|
Reports Other |
The number of delivery reports that fall into other categories. Filterable?: Yes. This is a text-only field. Enter a value by which to filter. Aggregatable?: Yes. Choose one of the following categories on which to aggregate data:
|
Reports Rejected |
The number of rejected delivery reports. Use this field to both aggregate and filter by the number of rejected delivery reports. These are returned if:
Filterable?: Yes. This is a text-only field. Enter a value by which to filter. Aggregatable?: Yes. Choose one of the following categories on which to aggregate data:
|
Reports Retrieved |
The number of retrieved delivery reports. This indicates that the end user received the MMS message.
Note that not all mobile operators will send a delivery report even if the end user retrieves the MMS content. Filterable?: Yes. This is a text-only field. Enter a value by which to filter. Aggregatable?: Yes. Choose one of the following categories on which to aggregate data:
|