How to check Outbound SMS usage with IoT Platform (Truphone)

Introduction

In the internal Truphone network, SMS are free, but sometimes it is necessary to send SMS from Truphone to the external network. To do so an Outbound SMS service should be used.

Please follow this tutorial to check the amount of Outbound SMS used

Checking used outbound SMS is a simple procedure with a few steps. Spreadsheet editing software (like Microsoft Excel) is needed:

1.    Open the IoT Platform at https://account.truphone.com/login and log in.

2.    Navigate to the "Reports" menu and select "Outbound SMS Usage" as the Report type (Picture 1)

Picture 1. Reports menu

3.    In the "SIM Cards" tab select the option — "All SIM cards" (Picture 2)

Picture 2. SIM cards menu

4.    In the "Time scale" tab select the following options (Please refer to picture nr. 3):

• Granularity — Monthly.
• Custom range from data of SMS bundle purchased to the current date.
• Press the "Finish" button to generate the report

Picture 3. Time scale menu

5.    After the report has been generator export the data by clicking on the "Export Data" button (Picture 4)

Picture 4. Exporting Data

6.    Open the spreadsheet that has been exported and do the following steps:

• Select column "A".
• Open the "Data" tab
• Select the function "Text to columns"

Picture 5. Text to columns

7.    Choose "Delimited" and press the "Next >" button

Picture 6. Text to columns step 1

8.    Select "Comma" and press the "Next >" button

Picture 7. Text to columns step 2

9.    Select "Text" and press the "Next >" button

Picture 8. Text to columns step 3

10.    Select the column with "Total usage" data and in the bottom-right corner in the "Sum" window "Outbound SMS" usage will be visible

Picture 9. Calculating total outbound SMS value