256
edits
Changes
How to check Outbound SMS usage with IoT Platform (Truphone) (view source)
Revision as of 15:34, 15 November 2022
, 15:34, 15 November 2022Step by step guide on calculating outbound SMS usage
==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)
[[File:Reports menu.png|thumb|none|Picture 1. '''Reports menu'''|link=Special:FilePath/Reports menu.png]]
3. In the "SIM Cards" tab select the option — "All SIM cards" (Picture 2)
[[File:SIM cards menu.png|thumb|none|Picture 2. '''SIM cards menu'''|link=Special:FilePath/SIM cards menu.png]]
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
[[File:Time scale.png|thumb|none|Picture 3. '''Time scale menu'''|link=Special:FilePath/Time scale.png]]
5. After the report has been generator export the data by clicking on the "Export Data" button (Picture 4)
[[File:Export Data.png|thumb|none|Picture 4. '''Exporting Data'''|link=Special:FilePath/Export Data.png]]
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"
[[File:Text to columns.png|thumb|none|Picture 5. '''Text to columns'''|link=Special:FilePath/Text to columns.png]]
7. Choose "Delimited" and press the "Next >" button
[[File:ttc1.png|thumb|none|Picture 6. '''Text to columns step 1'''|link=Special:FilePath/ttc1.png]]
8. Select "Comma" and press the "Next >" button
[[File:ttc2.png|thumb|none|Picture 7. '''Text to columns step 2'''|link=Special:FilePath/ttc2.png]]
9. Select "Text" and press the "Next >" button
[[File:ttc3.png|thumb|none|Picture 8. '''Text to columns step 3'''|link=Special:FilePath/ttc3.png]]
10. Select the column with "Total usage" data and in the bottom-right corner in the "Sum" window "Outbound SMS" usage will be visible
[[File:TotalOutboundSMS.png|thumb|none|Picture 9. '''Calculating total outbound SMS value'''|link=Special:FilePath/TotalOutboundSMS.png]]
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)
[[File:Reports menu.png|thumb|none|Picture 1. '''Reports menu'''|link=Special:FilePath/Reports menu.png]]
3. In the "SIM Cards" tab select the option — "All SIM cards" (Picture 2)
[[File:SIM cards menu.png|thumb|none|Picture 2. '''SIM cards menu'''|link=Special:FilePath/SIM cards menu.png]]
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
[[File:Time scale.png|thumb|none|Picture 3. '''Time scale menu'''|link=Special:FilePath/Time scale.png]]
5. After the report has been generator export the data by clicking on the "Export Data" button (Picture 4)
[[File:Export Data.png|thumb|none|Picture 4. '''Exporting Data'''|link=Special:FilePath/Export Data.png]]
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"
[[File:Text to columns.png|thumb|none|Picture 5. '''Text to columns'''|link=Special:FilePath/Text to columns.png]]
7. Choose "Delimited" and press the "Next >" button
[[File:ttc1.png|thumb|none|Picture 6. '''Text to columns step 1'''|link=Special:FilePath/ttc1.png]]
8. Select "Comma" and press the "Next >" button
[[File:ttc2.png|thumb|none|Picture 7. '''Text to columns step 2'''|link=Special:FilePath/ttc2.png]]
9. Select "Text" and press the "Next >" button
[[File:ttc3.png|thumb|none|Picture 8. '''Text to columns step 3'''|link=Special:FilePath/ttc3.png]]
10. Select the column with "Total usage" data and in the bottom-right corner in the "Sum" window "Outbound SMS" usage will be visible
[[File:TotalOutboundSMS.png|thumb|none|Picture 9. '''Calculating total outbound SMS value'''|link=Special:FilePath/TotalOutboundSMS.png]]
