SMS Reporting

The SMS logs screen helps you analyze and gather information about your outbound and inbound SMS traffic. In addition to SMS Logs UI, you can also use the following to get details about your messages:

  • API: Use Plivo REST APIs or SDKs to get message information programmatically.
  • Callbacks: Use Callback URLs to get live information about the state of your message.

SMS Logs

To view the SMS Logs screen, login into Console and navigate to the Logs page.

SMS Logs

You can view all your outbound and inbound messages for the selected time filter on the Logs screen, along with the following details:

  • Date: The time at which the message was queued in Plivo.
  • From: The Source number of the text message.
  • To: The Destination number of the text message.
  • To Country: Country ISO of the Destination country.
  • Direction: Message Direction. Can be Inbound or Outbound
  • Status: The current status of the message.
    Following are the statuses for Outbound messages:
    • Queued
    • Failed
    • Send
    • Delivered
    • Undelivered

    Following are the statuses for Inbound messages:

    • Received
    • Delivered
    • Undelivered
  • Error Reason: The reason for failure in cases where message status is Undelivered or Failed
  • Total Amount ($): Total amount charged for this message. This includes the carrier pass-through fees.

Filters

By default, all messages for your account are displayed on the Logs screen. Use filters to add context to the displayed results. You can filter your results based on the following parameters:

  • From number
  • To number
  • Direction
  • Status
  • Error
  • Time range
  • Subaccount

Logs

Using a combination of these filters, you can narrow down your search to relevant messages.

Note: Data of up to three months old can be viewed on the Logs screen.

Export

To analyze data, you can download the message details or the summary as a CSV file.

Note: Large CSV files (more than 10000 records) will be sent over an email. Smaller CSV files (less than 10000 records) can be downloaded in the browser itself.

SMS Logs

Export MDRs

To export all messages matching your filter criteria,

  • Enter the time range and your search keywords, if any, and then click Search.
  • From the Export dropdown list, select All MDRs or Selected MDRs, and then click “Export”.

The downloaded CSV will have the following fields:

  • Message UUID
  • From
  • To
  • To Country ISO2
  • Direction
  • Message Time
  • Status
  • Error Code
  • Error Reason
  • Units
  • Rate Per Unit (USD)
  • Carrier Surcharge Per Unit (USD)
  • Total Charge Per Unit (USD)
  • Total Charge (USD)

Export Summary:

To perform a high-level analysis of your SMS traffic, use the Usage Summary options from the Export dropdown list. You can view the usage summary by day, or by day and hour. This allows the user to download CSV which has MDR data grouped by some key differentiating factors like:

  • Date
  • Hour
  • Sub Account Id
  • Message Direction
  • To Country
  • Message State
  • Mobile Country Code
  • Mobile Network Code
  • Error Code
  • Error Reason
  • Powerpack Id
  • Application
  • Message Intent
  • Message Units

Total Count, Total Units, and Total Spend Including Carrier Passthrough Fee for each of the grouped data points are calculated and added to the CSV.

Note: Mapping of Mobile Country Code(MCC), Mobile Network Code(MNC) to Network operator can be downloaded here

Below are some examples of how the CSV data can be used to gain valuable insights:

  1. “During some hours of the day I see a dip in the message delivery of my outbound messages. What is the hour-wise distribution of outbound delivery rates for the last 3 days”

    • In the SMS logs page, select the date range for the last three days.
    • In the search field, enter “outbound” and click “Search”. This will display only the outbound messages.
    • Next, to export the summary of the displayed data, select “By Day & By Hour” from the Export dropdown list, and then click Export.
    • Select the folder to save the CSV file in, and then click Save.
    • You can use the downloaded CSV to arrive at the required data using Microsoft Excel or Google Sheets Data Pivots. Downloaded CSV
  2. “I ran two SMS campaigns this week and want to monitor the daily DND opt-in and opt-out rates for that time period”

    • In the SMS logs page, select the date range for the last week.
    • In the search field, enter “inbound” and click “Search”. This will display only inbound messages.
    • Next, to export the summary of the displayed data, select “By Day” from the Export dropdown list, and then click Export.
    • Select the folder to save the CSV file in, and then click Save. You can use the downloaded CSV to arrive at the required data using Microsoft Excel or Google Sheets Data Pivots. Export CSV
  3. “I am in the process of budgeting my SMS campaigns for the next quarter and need to check my daily spends on SMS over the last 1 month per subaccount”

    • In the SMS Logs page, select the time period for the last month, and then click Search.
    • To export the summary of the displayed data, select By Day from the Export dropdown list, and then click Export.
    • Select the folder to save the CSV file in, and then click Save.
    • You can use the downloaded CSV to arrive at the required data using Microsoft Excel or Google Sheets Data Pivots. Save CSV