SMS Tabular only MT Report
The SMS tabular MT report shows all the relevant details of the messages sent by the organization to customers. If you are requesting the tabular report before the implementation of MO and MT reports, then you can find the details of your report in the file SMS Tabular only MT Report.
| Column | Description | Example |
|---|---|---|
| COUNTRY_NAME | The country name(region) to which the recipient's mobile number is associated. | India |
| NETWORK_NAME | The name of the mobile network used to deliver the message to the mobile number. | Vodafone Essar Ltd. |
| SENDER | This is the sender ID. A Sender ID is a unique name or standard mobile number that shows in the “from” field of your text messages on your phone. It could be a phone number, an alpha-numeric, an alphabetic, or a numeric alias. | Kalyra |
| MOBILE | The mobile number to which the SMS is sent. | 9198333xxxx |
| SOURCE | The source of the request to send the SMS. For example, API or campaign. | API |
| STATUS | The delivery status of the SMS. | Delivered |
| STATUS_TRACE | This is the sub-status of the SMS that further helps understand more about the delivery status. | Delivrd |
| REFUNDED | Indicates if the SMS service amount is refunded or not. The value ‘1’ in the field means that either some part or the whole amount is refunded. The value ‘0’ in the field means that no refund is done. | 0 |
| CREATED | The date and the time at which the request to send a message has been received. | 2023-03-01T19:07:20:000Z |
| SMS_LENGTH | The length of the SMS in characters. | 54 |
| BILLING_UNIT | The billing unit applied to the SMS service. The value '1' means that the whole text has been sent as one single SMS and a value more than '1' means that the whole text has been sent in several concatenated SMS. | 1 |
| SMS_ROUTE | The SMS route type, for example, OTP, Transactional, and Promotional. | OTP |
| MESSAGE_TYPE | Indicates whether the message is sent as Unicode(U) or Non Unicode(N) characters. | N |
| SALE_PRICE | The amount charged for the SMS delivery. | 0.002 |
| AMOUNT_REFUNDED | Amount of money refunded. | 0 |
| CAMPAIGN_NAME | The name of the campaign through which the SMS is sent. Note: If the SMS is sent outside of any campaign, this field is empty. | BBD_SALE |
| CAMPAIGN_KID | This is a unique identifier value for the request. | 81b8b035-2cb5-4ca0-8656-b55589cc3359 |
| DELIV_TIME | The date and time at which the SMS has been delivered to the end customer. | 2023-03-01T19:07:22:000Z |
| REF | The REF parameter is optional. You can pass the required information for this parameter displayed in the report. | |
| REF1 | The REF1 parameter is optional. You can pass the required information for this parameter displayed in the report. | |
| REF2 | The REF2 parameter is optional. You can pass the required information for this parameter displayed in the report. |
Updated 5 months ago