Skip to main content

Can I see data usage split by country?

See the map in the Usage tab and download the monthly CSV report for additional insights.

Written by Jakub Kubinski
Updated over 7 months ago

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.

  1. Go to Usage.

  2. Apply filters:

    1. Month.

    2. Tag (optional).

  3. Click on "Download CSV report".

  4. Select "Download report grouped by network".
    ​

  5. Import the CSV into Excel, Google Sheets, or any spreadsheet editor.

  6. Download the sheet: MCC_Country (attached below).

  7. Import the above sheet into the same file.

  8. Use MCC values in a VLOOKUP formula to map your usage records to specific countries.

Attachment icon
MCC_Country.xlsx
Did this answer your question?