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

From Wiki Knowledge Base | Teltonika GPS
Revision as of 15:34, 15 November 2022 by AndrejKondratjev (talk | contribs) (Step by step guide on calculating outbound SMS usage)

(diff) ← Older revision | Approved revision (diff) | Latest revision (diff) | Newer revision → (diff)

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
Retrieved from "https://wiki.teltonika-gps.com/index.php?title=How_to_check_Outbound_SMS_usage_with_IoT_Platform_(Truphone)&oldid=77927"