How do I download and format MDRs?

Follow

Douglas Sessions

Updated

How do I download MDRs?

Message Detail Record (MDR) is a report that documents the details of your messaging traffic. To download it, complete the following steps:

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

How do I format MDRs?

Once you open an MDR file, the data may appear in a single column. In that case, you can follow the instructions below to format it so that each piece of data appears in a separate column. For more information about the meaning of each column, see MDR field descriptions.

  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 select Sort & Filter (CTRL + Shift + L in Windows) to make the headers filterable.

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

Article is closed for comments.