Over the last few months I’ve been speaking to a lot of customers (of Twilio), who need to be able to break down the spend of minutes spread over the countries that they call.
An example here would be:
|ISO Country Code||Minutes Used||Total Price||Number Of Calls|
Thinking about how to solve this issue, I thought the best way to do it was to put the power into a script that you can download and run yourself.
You can find the script at: https://github.com/dotmat/TwilioCountryMonthlyReport
You will need to install Twilio helper library by running:
pip install Twilio
Once you have the helper library installed you need to edit the ‘CountryReportGenerator.py’ file to include your AccountSID and AuthKey as well as the dates you want to examine.
- Keep in mind that the larger date range you select the longer the script will take to run.
From your terminal you can now run:
The script will generate three reports for you.
- A CSV file showing containing the log of calls made in the date period. The CSV headers are: CallSID, CountryCode, NumberCalled, CallPrice, CallDuration
- A CSV file, this CSV file is the outcome of and outputs: Country, MinutesUsed, TotalPrice, NumberOfCalls
- A JSON feed of the data so that you can use this in any server scripts you have running
Please let me know if you have any questions or issues.
TL:DR: Python3 Script that examines a date range to work out what countries have been called and in what frequency.