Environment
Onomondo app: Usage
External platform:
Microsoft Excel
Google Sheets
Question
Can I see data usage split by country?
Can I get an overview of our data usage per country in the previous months?
Can I see monthly usage grouped by country displayed as text / table?
Answer
See a map of your monthly usage at the bottom of the Usage page.
To acquire a data sheet on current and previous months' usage - download a CSV report and map the MCC values to specific countries.
Go to Usage.
Apply filters:
Month.
Tag (optional).
Click on "Download CSV report".
Select "Download report grouped by network".
βImport the CSV into Excel, Google Sheets, or any spreadsheet editor.
Download the sheet: MCC_Country (attached below).
Import the above sheet into the same file.
Use MCC values in a VLOOKUP formula to map your usage records to specific countries.