How do I download and format MDRs?
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:
- Log into the Bandwidth App.
- In the side navigation menu, select Insights and click Billing.
- Under Type, select MDR.
- Under Date range, select if you want to download the report for the Previous Month, Month to Date, or Custom time frame.
- 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.
- Highlight column A.
- Click the Data tab and select Text to Columns.
- This will open a new Text to Columns wizard. For Step 1, choose Delimited and click Next.
- Under the Delimiters section, choose Other and use Shift + Backslash on your keyboard to enter a vertical bar (|) into the textbox.
- Click Finish. Now your spreadsheet data has been organized into separate columns
- 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.