SMS reports

you can find your sms reports in the 'reports' tab under admin there are 4 types of reports that are available in the report type dropdown sms detailed report sms summary report dlt error report ( applicable for indian accounts only) url shortening report reports are provided the facility to filter report queries on the basis of sms type and sms status sms types include all promotional transactional transactional opt in sms status’ include all sent failed failed dnd sms type and filter is not applicable for dlt error report sms detailed report format field values comments id unique alphanumeric identifier of the sms direction incoming / outbound api type transactional / promotional 'transactional' if the message matches a transactional template in your account from sms sender id lm xxxxxx for outbound sms and the sending number for inbound sms to number to which sms was sent body body of the message status sent / failed / failed dnd / submitted sent all is well failed message was not sent failed dnd this happens when a promotional sms is sent to a number in ncpr (dnd list) submitted this means that the sms you have sent has been submitted from our system to sms gateway time dd/mm/yy hh\ mm ss price in rupees 1 sms unit = 160 characters detailedstatuscode the code of the detailed sms status refer to the table below for the possible values detailedstatus the name of the detailed sms status refer to the table below for the possible values date sent sent time stamp dd/mm/yy hh\ mm ss customfield numberofunits 1 unit= 160 characters encodingtype message type of sms, can be of plain or unicode plain ( for english) or unicode (other languages) dltentityid the numeric identifier for the dlt platform in india is configured on the exotel dashboard or passed in the api request note this column would only be populated if your exotel account is domestic (india specific) if this is empty or incorrect, the dlt platform will fail your smses you can configure this via exotel dashboard settings (link) dlttemplateid the numeric identifier for dlt template in india as configured on exotel dashboard or passed in the api request a single quote (') would be added at the end to allow this to be readable in excel note this column would only be populated if your exotel account is domestic (india specific) if this is empty or incorrect, the dlt platform will fail your smses refer to this knowledge base to learn more on template scrubbing compliance list of possible detailedstatus and detailedstatuscode detailedstatuscode nature of detailed status code status detailedstatus what it means 21010 intermediate, may change in future queued pending to operator the message is being processed by exotel 21015 intermediate, may change in future sending sending to operator the message has been processed by exotel and is en route to the operator 21020 intermediate, may change in future submitted pending on operator the message has been successfully submitted to the operator and is pending delivery in india, promotional sms may be in this state if submitted outside the permitted time (10 am to 9 pm ist) 20005 final sent delivered to handset we know with confidence that the message has been delivered to the recipient's handset 20006 final sent delivered to operator the message has been delivered to the operator in some regions and routes, handset delivery status (delivered to handset) is not available and hence this is the best we can ever report about the delivery status 23005 final failed dnd failed rejected dnd the message has been rejected as the end user is a subscriber of dnd (do not disturb) services 23010 final failed failed invalid destination number the destination number is incorrect, not sms enabled, or is a pstn landline 23015 final failed failed spam detected one of the most common reasons for sms delivery failure is carrier level spam filters carriers have added systems and algorithms that detect spam content and then block these messages unfortunately, these filters are hidden, subject to carrier preferences, vary from carrier to carrier, and can be changed without notice 23020 final failed failed rejected blacklist you tried to send a message to a blacklisted phone number that is, the user has already sent a stop/dnd opt out message and no longer wishes to receive messages from you 24990 final failed failed unknown error delivering your message failed for reasons that are unknown to us and to our carriers if you notice too many of these cases, please reach out to us 23030 final failed failed unavailable route the carrier and fallback carriers were not able to deliver the sms message because no route was available 23035 final failed failed subscriber unavailable this message was not delivered because the subscriber was temporarily unavailable for example, the receiving handset was out of coverage or switched off this is a temporary failure, but a message sent to the same subscriber at a later point in time may get delivered 23040 final failed failed subscriber unknown subscriber is unknown to the operators or no longer active 23050 final failed failed expired the message was sent to the operator and may have been retried several times within the default network sms expiration duration the message request has now expired 23060 final failed failed rejected for a number of reasons, the message was rejected by exotel or the operator 24105 final failed failed handset error the message was not delivered to the subscriber due to handset failure 24110 final failed failed operator error the message failed due to an issue at the operator's end 23070 final failed failed invalid message the message was rejected by the operator as invalid while exotel will automatically split messages longer than 160 gsm 7 bit characters, or 70 unicode 16 bit characters into multipart sms, messages exceeding the allowed character limit of 2000 characters may also end in this state any request error related to the message, say unidentified character, may also fall under this bucket in india, if dlt related parameters are not set like entity id, your sms may fail with this error code 23072 final failed failed invalid sender id the message failed due to an invalid or unregistered sender id in the case of india, if your sender id (header) is not registered with the operator dlt platform, you may receive this error 24010 final failed failed system error sms failed while processing within the exotel system 24120 final failed failed subscriber error all subscriber or recipient issues that are unrelated to the handset (for eg the receiver does not have enough mobile balance to receive the sms) may fall under this bucket 23080 final failed sender blocked by dlt applicable only for smses sent to indian destination numbers via domestic lines sender id (header) is blocked or failed at dlt due to mismatch, non registration, etc 23081 final failed entity blocked by dlt applicable only for smses sent to indian destination numbers via domestic lines entity (dlt entity id) is blocked or failed at dlt due to not being set, mismatch, etc 23082 final failed template blocked by dlt applicable only for smses sent to indian destination numbers via domestic lines template (template id) is blocked or failed at dlt due to not being set, mismatch, non registration, etc 23083 final failed failed dlt scrubbing error applicable only for smses sent to indian destination numbers via domestic lines sms is blocked or failed at dlt even after the registration due to explicit blocking of the sender id due to spam, issues with consent, or any other technical issues with the dlt platform 23084 24000 final failed reserved for future these statuses will not be populated right now but are reserved for the future for any other detailed status scenario related to sms 2\ sms summary report format sms summary report provides a high level summary of the smss it captures the number of units with delivery status and the total price of those units field values comments date timestamp (yyyy mm dd) status sms delivery status it could be submitted, sent, failed and failed dnd smstype transactional (otp or service implicit content) transactional opt in (service explicit content) promotional (promotional content with numeric header) | | \| exostatus | detailed status | | \| numunits | number of sms units | 1 sms unit = 160 characters | \| price | cumulative price of those smses | price is calculated at the sms unit level | \| count | count of sms | | \| percentage | count/(total count) | | 3\ dlt error format dlt error report provides the details of dlt errors along with the templateid you can check how many smss were delivered or failed for a particular template errors will be shown only if detailed status / total sms with template id > 1% field values comments account sid account sid sms type transactional (otp or service implicit content) transactional opt in (service explicit content) promotional (promotional content with numeric header) | | \| dlt template id | content template id against the sms body registered with dlt | | \| template on exotel | template body | | \| total sms with template id \| totalcount of sms with the template id | | \| total delivered with template id | total count of sms delivered with the template id | delivered= delivered to handset or delivered to operator | \| dlt error type (detailed status) | detailed status | | \| sms count with detailedstatus | total count of undelivered sms with the template id | status = failed or failed dnd detailed status will be one of the following 'sender blocked by dlt','entity blocked by dlt','template blocked by dlt', 'failed dlt scrubbing error','failed dlt consent error','dlt template id invalid', 'dlt template not found','dlt template id inactive','dlt template id blacklisted', 'dlt template does not match','dlt length exceeded', 'dlt entity not found','failed invalid message','failed invalid sender id' | 4\ url shortening report only applicable if you have used url shortening service field values comments id unique alphanumeric identifier of the sms direction incoming / outbound api type transactional / promotional 'transactional' if the message matches a transactional template in your account from sms sender id lm xxxxxx for outbound sms and the sending number for inbound sms to number to which sms was sent body body of the message status sent / failed / failed dnd / submitted sent all is well failed message was not sent failed dnd this happens when a promotional sms is sent to a number in ncpr (dnd list) submitted this means that the sms you have sent has been submitted from our system to sms gateway time dd/mm/yy hh\ mm ss price in rupees detailedstatuscode the code of the detailed sms status detailedstatus the name of the detailed sms status datesent sent time stamp dd/mm/yy hh\ mm ss dltentityid the numeric identifier for the dlt platform in india is configured on the exotel dashboard or passed in the api request dlttemplateid the numeric identifier for dlt template in india as configured on exotel dashboard or passed in the api request a single quote (') would be added at the end to allow this to be readable in excel url shortenend yes the report is applicable only if url is shortened url clicked yes the report is applicable only if url is clicked customfield numberofunits unit of sms 1 sms unit = 160 characters encodingtype message type of sms, can be of plain or unicode plain ( for english) or unicode (other languages) url sid unique id for shortened url short url shortened url short code shortcode for url long url original url tracking true expires at shortened url expiry time created time created time of shortened url last viewed at last viewed time of the short url total clicks total number of clicks on the short url country code country code where the url is clicked city city name from where the url is clicked country name of the country ip address ip address of the device from where the url is clicked postal code postal code of the area from where url is clicked region state or province of the city accuracy radius accuracy radius in meters os version os version of the device from which the link is clicked os name name of the os device name name of the device watch a short video