Classic: Number Utilization Reporting


Chase Greiser


This article references the ‘Classic’ interface in the Bandwidth Dashboard. Looking for the ‘New’ experience? Click here!

In this article, you will learn how to review your telephone number inventory and report on end-user assignment. In the upper right-hand corner of the Bandwidth Dashboard, you will see a widget titled ‘End-user number utilization’ with your number utilization percentage.

We’re looking for you to report on which phone numbers are assigned to a specific end-user. You may find this process helpful to determine which phone numbers you no longer need.

API docs.


  1. Click 'Reports' on the top navigation menu, then 'Reports Dashboard.'
  2. There are a couple of new reports here, but let’s focus on the report that will give you a list of your Assigned, Pending Assignment, and Unassigned telephone numbers.
  3. Double-click on the END-USER PHONE NUMBER ASSIGNMENT report.Screen_Shot_2019-04-26_at_12.08.57_PM.png
  4. On the END-USER PHONE NUMBER ASSIGNMENT report, change your Status(es) and you will see the following options:
    • Assigned are phone numbers where Bandwidth can see traffic, or numbers you’ve already marked as assigned with an end-user.
    • Pending Assignment are numbers where Bandwidth cannot see traffic (these are the numbers you will want to report on).
    • Unassigned are numbers that you have previously marked as unassigned meaning they do not have an end-user.
  5. To begin this report, choose Pending Assignment as your status, keep your date range as ALL TIME, and your file format as CSV.
  6. Then click Generate Report and your report should begin processing in the upper right hand side of your screen, under Past reports.
  7. Click on the CSV icon to download your report. The file will download into your web browser. Double-click to open.
  8. Upon opening, you will receive a list of telephone numbers, their assignment status and status expiry date. The ‘Expiry date’ will only populate on assigned numbers.
    • Please note that phone number assignment statuses will expire after 120 days.


Take your time to curate your list of telephone numbers, removing the ones that are not assigned to an end-user.


  1. When you’re finished, save your .CSV file and head back to the Bandwidth Dashboard.
  2. From the top navigation bar, click 'Numbers', and then 'End-user assignment'
  3. To label your numbers as assigned, we have a few different options:
    • You can either upload your spreadsheet, leverage our APIs, or copy and paste your Numbers.
  4. The easiest option is copy/paste. To do this, all you need to do is copy the list of phone numbers from your excel file (ignoring the header), and paste them in the ‘List phone numbers’ section of the tool.
  5. Then Click ‘Label Numbers as Assigned’
    • Please Note: You can update up to 5,000 phone numbers at a time.

If you would like to import this as a spreadsheet.

  1. Change cell A1 from TN to Number. And remove columns B and C. It should look like this:image8.png
  2. Save this file as a .CSV.
  3. From the Number Assignment page, Click CHOOSE A FILE and browse to your spreadsheet and click ‘Open’
  4. If you’d like, you may provide a Custom Order ID.
  5. When you’re satisfied, click LABEL NUMBERS AS ASSIGNED

Success! You have labeled your phone numbers as assigned to an end-user. This status will be retained for 120 days.

Please Note: the phone number status may take some time to process and may not show up as assigned immediately.

While this isn’t mandatory, if this exercise has prompted you to disconnect any unassigned phone numbers, perform the following steps:

  1. Navigate to 'Numbers' > ‘Disconnect.’
  2. From here, paste the list of phone numbers you wish to disconnect and click 'Disconnect.'
  3. If you’d like to disconnect any unassigned phone numbers, Click 'Numbers' in the navigation bar, then click 'Disconnect.' From here, paste the list of phone numbers you wish to disconnect.
  4. Click 'Disconnect.'

Article is closed for comments.