Tab: SMS Stats

Filters

  • All SMS:  Transactional High, Transactional, Transactional Opt-in, and Promotional

  • Date: Filter by Start date and End date

  • These filters apply to all graphs shown on this page


Total SMS

Total SMS are split into 3 categories.: Deliverable, Undeliverable and Pending. 

 

  • Deliverable = Delivered + Failed. These messages were either Delivered to the customer or Failed for some other reason


  • Undeliverable messages could not be delivered due to DLT, DND, or other errors, which should be addressed before trying them again


  • Pending messages are still in an intermediate state, and will convert to a final state over time


Deliverable SMS

Deliverable SMS represents the SMS that did not have any DLT, DND, or other errors, and could be delivered to the customer

  • Delivered

  • Failed



Delivery Latency

Delivery Latency represents the time period over which SMSes are delivered


  • Delivery Latency is not applicable to SMS Type = Promotional, as delivery reports are not available for promotional messages

  • Promotional messages are excluded when computing Delivery Latency for SMS Type = All SMS


Messages over time:


The “Message over Time” bar graph shows how Total SMS Volume trends over time along with the Delivery Rate.


The date filter lets the user select a date range from

  • Day-wise Deliverable,  Pending, and Undeliverable messages are shown.

  • Day wise Delivery Rate is shown


Reports can be downloaded in CSV format



Total SMS Stats:

Shows detailed information on Deliverable, Undeliverable and Pending messages including

  • Status

  • SMS Count (Volume)

  • % within each section and % of the total




Reports can be downloaded in CSV and Excel formats
Columns can be sorted in the increasing or decreasing order of the values present


Status Codes

Status

Explanation

Status code

Delivered

Status = sent

20005: DELIVERED_TO_HANDSET

20006: DELIVERED_TO_OPERATOR

Failed

Error that the customer cannot do anything about on their own

Subscriber (retry)

  • 24105: FAILED_HANDSET_ERROR

  • 23035: FAILED_SUBSCRIBER_UNAVAILABLE

  • 24120: FAILED_SUBSCRIBER_ERROR

Expired

  • 23050: FAILED_EXPIRED

Other

  • 23015: FAILED_SPAM_DETECTED

  • 23030: FAILED_UNAVAILABLE_ROUTE

  • 23060: FAILED_REJECTED

  • 24010: FAILED_SYSTEM_ERROR

  • 24110: FAILED_OPERATOR_ERROR

  • 24990: FAILED_UNKNOWN_ERROR

Undeliverable

Error that the customer can act on

DLT

  • 23080: SENDER_BLOCKED_BY_DLT

  • 23081: ENTITY_BLOCKED_BY_DLT

  • 23082: TEMPLATE_BLOCKED_BY_DLT

  • 23083: FAILED_DLT_SCRUBBING_ERROR

  • 23084: FAILED_DLT_CONSENT_ERROR

  • 23181: DLT_TEMPLATE_ID_INVALID

  • 23182: DLT_TEMPLATE_NOT_FOUND

  • 23183: DLT_TEMPLATE_ID_INACTIVE

  • 23184: DLT_TEMPLATE_ID_BLACKLISTED

  • 23185: DLT_TEMPLATE_DOES_NOT_MATCH

  • 23186: DLT_LENGTH_EXCEEDED

  • 23281: DLT_ENTITY_NOT_FOUND

Other

  • 23070: FAILED_INVALID_MESSAGE – could be DLT related in India

  • 23072: FAILED_INVALID_SENDER_ID – could be DLT related in India

DND

  • 23005: FAILED_REJECTED_DND

  • 23020: FAILED_REJECTED_BLACKLIST


Subscriber (do not retry)

  • 23010: FAILED_INVALID_DESTINATION_NUMBER

  • 23040: FAILED_SUBSCRIBER_UNKNOWN

Pending

Nature of detailed status code = intermediate

21010: PENDING_TO_OPERATOR

21015: SENDING_TO_OPERATOR

21020: PENDING_ON_OPERATOR




Tab: Detailed Stats

The Detailed Stats page shows the date-wise data under all the categories. 


Filters

  • Date: Filter by Start date and End date


Table 1: SMS Volume by Date and SMS Category

  • Date

  • Count

  • Deliverables

  • Deliverable %

  • Undeliverables

  • Undeliverable %

  • Pending

  • Pending %

  • Delivered

  • Delivered %

  • Failed

  • Failed %




Reports can be downloaded in CSV and Excel formats
The columns can be sorted in the increasing or decreasing order of the values present




Table 2: SMS Volume by Date and Detailed Status

  • SMS Category

  • Status

  • Date Wise Count and % SMS Category



Reports can be downloaded in CSV and Excel formats
The columns can be sorted in the increasing or decreasing order of the values present





Tab : Template Wise Analysis

The Template Wise Analysis tab shows the list of templates along with the types of errors with counts.


Filters

  • Date: Filter by Start date and End date

  • Template ID: Filter by the template ID


Search by Template ID:


Table 1: Top 10 Template IDs Based on Error Count

  • Template ID

  • Status

  • Count


Table 2: Template IDs by Status and SMS Category

  • Template IDs

  • SMS Category

  • Status

  • Count

  • Percentage




You can always reach our Support at hello@exotel.in or 08088-919-888, in case you have any queries on the same.