How do I download & filter BDRs and MDRs?


Douglas Sessions



The Bandwidth Dashboard can provide rated call detail reports called Billing Detail Records (BDRs) for voice and Message Detail Records (MDRs) for messaging. To download them:

  1. Log into the Bandwidth Dashboard.
  2. In the top navigation menu, select Insights and click Billing.
  3. Under Type, select either BDR or MDR.
  4. Under Date range, choose if you want to download the report for the Previous Month, Month to Date, or a Custom time frame.
  5. Click Submit.
  6. This will download a CSV file into your browser. If you don't see it, please check the Downloads section in your browser or the Downloads folder on your computer. 

How do I turn BDRs & MDRs into filterable charts?

When you first open the file, all of the data may appear in a single column. If that's the case, here's how you can format it so that each piece of data appears in a separate column:

  1. Highlight Column A. 
  2. Click the Data tab and select Text to Columns
  3. This will open a new Text to Columns wizard. For Step 1, choose Delimited and click Next
  4. Under the Delimiters section, choose Other and use Shift + Backslash on your keyboard to enter a vertical bar (|) into the textbox.
  5. Click Finish. Now your spreadsheet data has been organized into separate columns
  6. With any cell in the first row selected, navigate to the Home tab and hit "Sort & Filter" (or for Windows users, CTRL + Shift + L) to make the headers filterable.

For more information about what each column means, please see BDR field descriptions or MDR field descriptions.

Questions? Please open a ticket with your Bandwidth Support Team or hit us up at (855) 864-7776!

Article is closed for comments.