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.

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.