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: Second — this is the default value. Minute 15 Minutes 30 Minutes Hour Day — as per the UTC Week — this is Sundays to Saturdays 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 Filterable? Yes. This filter is required cannot be removed. 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.
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: NULL RECIPIENT_BLOCKED RECIPIENT_NOT_FOUND INDETERMINATE_CARRIER_ERROR INDETERMINATE_SYSTEM_ERROR ERROR_FORWARDING_TO_CUSTOMER RECIPIENT_DEACTIVATED RECIPIENT_SUSPENDED RECIPIENT_NOT_AVAILABLE_FOR_MMS ERROR_FORWARDING_TO_CARRIER UNABLE_TO_PARSE_RESPONSE SHORT_CODE_NOT_FOUND_OR_ALLOWED GENERIC_GET_CONTENTS_ERROR UNABLE_TO_ROUTE_MESSAGE CONTENT_BLOCKED_OR_REFUSED CARRIER_CAMPAIGN_NOT_FOUND DEREGISTERED NOT_FOLLOWING_REDIRECTS CARRIER_CAMPAIGN_BLOCKED DEFERRED GET_CONTENT_TOO_LARGE 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: None — Displays the field's actual value. Count — Number of records represented by this line. Sum — Returns the sum of the number of records for this line. Average — Returns the average of the field's values. Standard Deviation — Returns the standard deviation of the field's values. Min — Returns the minimum of the field's values. Max — Returns the maximum of the field's values.
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: None — Displays the field's actual value. Count — Number of records represented by this line. Sum — Returns the sum of the number of records for this line. Average — Returns the average of the field's values. Standard Deviation — Returns the standard deviation of the field's values. Min — Returns the minimum of the field's values. Max — Returns the maximum of the field's values.
MT Submitted	The number of MTs that were submitted to OpenMarket. Filterable?: Yes. Enter a value by which to filter. Aggregatable?: Yes. Choose one of the following categories on which to aggregate data: None — Displays the field's actual value. Count — Number of records represented by this line. Sum — Returns the sum of the number of records for this line. Average — Returns the average of the field's values. Standard Deviation — Returns the standard deviation of the field's values. Min — Returns the minimum of the field's values. Max — Returns the maximum of the field's values.
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: None — Displays the field's actual value. Count — Number of records represented by this line. Sum — Returns the sum of the number of records for this line. Average — Returns the average of the field's values. Standard Deviation — Returns the standard deviation of the field's values. Min — Returns the minimum of the field's values. Max — Returns the maximum of the field's values.
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: None — Displays the field's actual value. Count — Number of records represented by this line. Sum — Returns the sum of the number of records for this line. Average — Returns the average of the field's values. Standard Deviation — Returns the standard deviation of the field's values. Min — Returns the minimum of the field's values. Max — Returns the maximum of the field's values.
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: The mobile operator initially accepts the request, but then rejects it after processing. The end user's handset rejects the request. 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: None — Displays the field's actual value. Count — Number of records represented by this line. Sum — Returns the sum of the number of records for this line. Average — Returns the average of the field's values. Standard Deviation — Returns the standard deviation of the field's values. Min — Returns the minimum of the field's values. Max — Returns the maximum of the field's values.
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: None — Displays the field's actual value. Count — Number of records represented by this line. Sum — Returns the sum of the number of records for this line. Average — Returns the average of the field's values. Standard Deviation — Returns the standard deviation of the field's values. Min — Returns the minimum of the field's values. Max — Returns the maximum of the field's values.