Using and Navigating a Billing Analytics Report

September 23, 2019
Want to download your data? Click here for directions.

Logging into the eSquared Customer Portal

1. Go to and click on login

2. Enter email address, followed by username and password. If you are having difficulties logging in please see the following link for help:

3. Once in the customer portal, click on the Billing Analytics button to get to the analytics section

4. Once there click on the file to load (note in most cases you will see one file, if multiples exist they will be labeled with which division the report is for: WMS,TMS or MTM)

All Billing Tabs will have a few common pieces.

Clicking on any of the tabs will take you to the corresponding report page or pop-up menu.

Filter Pop-up Menu:

Clicking on the Filter icon on any tab will display the filter menu, this allows you to focus data on a specific time period, device type, or carrier. Clicking on the menu again, will cause the menu to close.

Each tab will have different graphs and tables but most interactions between data and their tools are common throughout the report.


While you can filter data using the Filter Pop-Out, you can also filter data interactively throughout the report, by utilizing different visualization's elements.


Let's filter Total Data Usage by iPhones.

  • If we click on the section of this Tree Map labeled iPhone,

  • We see that the data use line graph has now changed, representing usage solely from iPhones.

Note: All visualizations that are capable to be filtered by iPhones on the report would be until clicking on the tree map visual again to reset the temporary filter.

Downloading Data

In some cases, you may want to extract or download the data used in the billing analytics display.

  • On any chart or graph, you may click on “…” to access the more options menu.

  • The first option will be to export the data.

  • This will take you to a menu allowing to download either the summarized data, or the underlying data.

  • Summarized data will give you access to only the data represented in the visualization you are attempting to download, underlying data will give you access to much more “granular” information, it is all the data we used to prepare the report.
  • We recommend summarized data for Excel users not use to working with large data sets, and Underlying data for users use to larger data sets.
No available tags for this post.