RCS Summary

This data source provides summary-level information about RCS messages. You can select from one or more fields to include in the report, and filter by one or more parameters, such as message contents, RCS type, as well as accepted, delivery, and read dates. Fields you can include and filter by are described in the RCS Summary Data Source Fields and Filters table below. Message information can also be aggregated by Accepted, Awaiting Report, Delivered, or Failed, which are described in the RCS Summary Data Source Aggregate Fields table .

Standard reports

RCS standard reports were designed by as a set of default scheduled RCS reports useful to most businesses. These reports use the RCS Summary as the source for these reports:

  • RCS Daily Summary - Last Month
  • RCS Daily Summary - This Month
  • RCS Monthly Summary - 13 Months

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 RCS 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.

Custom reports

You can use the RCS Summary Data Source to create a custom report with a date range of 13 months. See Create a custom report for the steps.

Quick tips

Some helpful tips for when using this data source are:

  • If you want a high-level view of message delivery, use Message Status.

  • For most use cases you'll want to include Message Direction as it separates out MO traffic from MT traffic.

  • Message Originator refers to your short codes, VMNs, etc, through which you send and receive messages. It never refers to an end user's number.

When using this data source, the following fields report similar information and you might want to include only one of them:

  • Country Name shows the full name and Country Code Alpha-2 shows a two-letter abbreviation.

  • Account Name and Account ID are linked unique identifiers, so you only need to include the field that suits you. If you want to see what the possible values for either field, then:

    1. Add them as filters
    2. Use the drop-down to check the field values (and remove the filters when ready)

Note: If you are filtering the report by a dialable message originator or the end user's phone number, then you need to make sure you supply the number in international format; e.g. with the country code included. For example: 12515550100 (US number) or 447700900750 (UK number). Don't include a "+" character. This doesn't apply to short codes, which you should enter as is.

RCS Summary Data Source Fields and Filters

Parameter

Description

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, messages are grouped by one of:

  • 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

Aggregatable? No.

Filterable? Yes. This filter is always required.

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 31 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 option, as these adjust for each run of the report to show data relative to the run time.

Account ID

The unique ID of an account you have with OpenMarket. Depending on your business requirements, you may have multiple accounts to send RCS messages. You can alternatively use Account Name 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.


Aggregatable? No.

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.

Account Name

The unique name of an account you have with OpenMarket. Depending on your business requirements, you may have multiple accounts to send RCS 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.


Aggregatable? No.

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.

Campaign ID

The unique identifier for a global campaign, which is associated with an account ID and name.


Aggregatable? No.

Filterable? Yes. Enter one or more campaign IDs on which to filter. From the drop-down list, enter the campaign ID, and then select it from the list. Search and add additional campaign IDs as needed. A tally keeps track of the number of IDs added to the filter. Alternately, you can filter on Campaign Name.

Campaign Name

The name associated with the campaign ID.



Aggregatable? No.

Filterable? Yes. Enter one or more campaign names on which to filter. From the drop-down list, enter the campaign name, and then select it from the list. Search and add additional campaign names as needed. A tally keeps track of the number of names added to the filter. Alternately, you can filter on Campaign ID.

Company ID

The identifier of the company that sent and/or received the message.


Aggregatable? No.

Filterable? Yes. Enter one or more company IDs on which to filter. From the drop-down list, enter the company ID, and then select it from the list. Search and add additional company IDs as needed. A tally keeps track of the number of IDs added to the filter. Alternately, you can filter on Company Name.

Company Name

The name of the company that sent and/or received the message.


Aggregatable? No.

Filterable? Yes. Enter the full company name by which to filter. Alternately, you can filter on Company ID.

Country Code Alpha-2

The two-letter code that identifies the country or region. For example, AU (Australia) or CA (Canada). You can find a list of the codes on Wikipedia.

  • For MTs, this is the country of the destination
  • For MOs, this is the country of the originator

You can alternately use the Country Name, which lists the full name of the country or region.


Aggregatable? No.

Filterable? Yes. You can filter by one or more country alpha codes. From the drop-down list, enter or search for the country code then select it. As you select country codes, a tally keeps track of the number of country codes added to the filter.

Country Name

The name of the country in which the end user's phone number is registered.

You can alternately use the Country Code, which is the two-letter code for a country or region


Aggregatable? No.

Filterable? Yes. You can filter by one or more country names. From the drop-down list, enter or search for the country name, and then select it. As you select country names, a tally keeps track of the number of country names added to the filter.

Message Direction

Indicates whether the message was sent from your account or from an end user.


Aggregatable? No.

Filterable? Yes. You can select one or both of:

  • MT — for filtering on messages sent from your account
  • MO — for filtering on messages sent from an end user
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).

Add Phone Number to the report if you want to see the end user's number, and Message Direction to see who sent the message.


Aggregatable? No.

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.

Message Status

Provides the current or final delivery status of a message.


Aggregatable? No.

Filterable? Yes. Select one or more of the following statuses on which to filter:

  • Awaiting Report — we forwarded the message to the operator; however, we have not yet received a delivery status
  • Delivered — the message was successfully delivered
  • Read — the message was read by the end user
  • Failed — the message was not delivered.

A tally keeps track of the number of messages statuses selected.

Message Type

Indicates the type of sent RCS message.

 

Aggregatable? No.

Filterable? Yes. You can filter on one or more of the following:

  • Chat — The message content was text.
  • Media — The message content was a media file — for example, an image or video.
  • Postback — Indicates the MO direction for a suggested action or reply.
  • Premium — The message content was a Rich Card.

A tally keeps track of the number of message types selected.

Mobile Operator ID

Use this field if you want if you want to see the operators your end users are connected to, organized by mobile operator ID.


Aggregatable? No.

Filterable?: Yes. This is always a number, such as 383 for AT&T, and 348 for T-Mobile in the UK. Select one or more mobile operators to add to the filter. As you select operators, a tally keeps track of the number of operators added to the filter.

You can alternatively use Mobile Operator Id in the report.

Mobile Operator Name

Use this field if you want to see the operators your end users are connected to, organized by mobile operator name.


Aggregatable? No.

Filterable? Yes. This filter list organizes mobile operators by name, followed by their country of operation and mobile operator ID. Select one or more mobile operators to add to the filter. As you select operators, a tally keeps track of the number of operators added to the filter.

You can alternatively use Mobile Operator Name in the report.

Aggregate fields

Aggregate fields are also filterable fields. When using fields for aggregation, choose Sum to see the sum of the field aggregation requested (you can ignore the None option), and then choose one of the following:

  • Equals — this option selects a specific value. We recommend not using it as a filter.
  • Greater Than
  • Greater Than or Equal To
  • Less Than
  • Less Than or Equal To
  • Between — the left-hand value must be lower than the right-hand value

RCS Summary Data Source Aggregate Fields

Parameter

Description

Messages Accepted

The number of message requests that we accepted from your account.

If you want to see Messages Accepted data split into the messages you sent versus the messages you received, then include Message Direction in your report as a field or a filter.


Messages Awaiting Report

Number of MT messages for which messages are waiting submission to the MaaP, or the MaaP has not yet provided a final delivery status.

In the final report, the default name of the column "Sum of Messages Awaiting Report".


Messages Delivered

The number of MT messages that the MaaP confirmed as either successfully delivered or read, or the number of MOs sent to the MaaP.

If you want to see Messages Delivered data split into the messages you sent versus the messages you received, then include Message Direction in your report as a field or a filter.

Messages Failed

The number of MT messages that were not successfully delivered.

Messages Read

The number of MT messages that were read by the end user.