Login
    Contents x
    Exporting Your Analytics: Tips and Tricks
    • 06 Jun 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Exporting Your Analytics: Tips and Tricks

    • Updated on 06 Jun 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    • PDF
    • New
    Article Summary

    Excel can be a great tool for charting data, but sometimes the information in the exported sheets can be difficult to read. To fix this, you can format the date/time column correctly by going to "Format" and selecting "Format Cells" then choosing "Date". Additionally, if the last digit of ID columns is replaced with a 0, you can create a custom number format that has 16 digits and apply it to the ID column.

    Charting data in the Analytics menu will allow you to export additional reports. This can be an incredibly helpful tool. But sometimes, the information in the exported Excel sheets get a bit... murky. Here are some common troubleshooting tips and tricks.

    Formatting the date and time column correctly when using Excel

    Are you using Excel to read your exported analytics and having trouble reading the date/time column? 

    excel_1.png

    To format the date/time column in the CSV exports when using Excel do the following steps:

    On the "Home" ribbon go to "Format" and select "Format Cells"

    excel_2.png

    Then choose "Date" and select the format highlighted below.
    excel_3.png

    Now you will see delightfully human-readable dates and times.

    excel_4.png

    Adjusting the 0 digit in Call ID or Office ID

    You've exported data to Excel, but the last digit of the ID columns ("Call ID” or "Office ID") has been replaced with a 0. 

    What's going on?

    The spreadsheet software is applying a number format to the data. Good news — you can prevent this from happening. Here's how:

    1. Create a custom number format that has 16 digits.

    Screen_Shot_2021-10-21_at_13.18.28.png

    Screen_Shot_2021-10-21_at_13.17.07.png

    1. Select the ID column and apply the new number format to it.

    spreadsheet-demo.png

    Note:
    The images above were taken using Google Sheets, but the process and flow is the same for Excel.

    Was this article helpful?
    What's Next
    Ai that works for you.
    Products
    Company
    Top Features
    Dialpad Apps
    Need Help?
    Connect with Us
    © 2023 DIALPAD, INC.
    Change password!
    Changing your password will log you out immediately. Use the new password to log back in.
    Change profile
    Success!
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.
    Logout