Export view data


Prerequisites

  • AnalyticsData Export > All 
  • Reporting > customParticipantAttributes > view to export custom participant attributes 
  • Any prerequisites needed for the view you want to export. For more information, see each view’s article.

Export the data from selected views as a .csv file delivered to your inbox in PureCloud. You can export all of the data from a view or export only the data from selected columns. The .csv files can be opened in spreadsheet software,  such as Excel. 

You can export data from the following views, including aggregate performance data for the detail views listed:


  1. (Optional) Filter by date, queue, language, skills, or other interaction details. The exported file uses these filters for the exported data. For more information about filtering data in a view, see the article for the view you want to export.
  2. Click Export . The Export pane opens. 
  3. Change the name of the file or keep the default file name in the Enter File Name field. The default file name includes the date and the name of the view. If you export data from the same view multiple times in one day, then all of those files have the same default name. 
  4. If the view contains a duration column, time values are formatted in milliseconds. To format time values in HH:MM:SS.mmm, select the Format Durations option on the Export pane. 
  5. To export only the columns shown in the view, select Selected Columns. The columns are exported in your preferred order, shown in the view.  
  6. Select the Include Custom Attributes check box to include custom participant attributes in the export.
  7. If you are viewing the data as a group (View as group) of agents, queues, or DNIS numbers, for the export to include the group aggregate data for all the filters plus the individual data for each of the filters, in the Export pane, select Split Filters.
  8. To convert time values in the export file from the time zone set on your machine to a different time zone, select a time zone option in the box for your export file.
  9. You can set the locale for the data exported from a view. The locale setting displays text, and date and time formats in the selected language. Select the language in the locale box.
  10. Click Export csv. The file appears in your inbox. 


In the inbox, you can see the status of your exports, including a progress bar displaying what percentage of the export that is complete.

Symbol Status Description
Export submitted Submitted PureCloud received your request for the export and will create the export. 
Export in progress In Progress PureCloud is creating your export. 
Canceling PureCloud is in the process of canceling the export. 
Canceled PureCloud canceled the export. 
Export failed-error Error An error occurred during the creation of the export. 
Export complete- download Complete The export is complete and you can download it. 
Partial results The export contains partial results and can be downloaded.


PureCloud completes exports in the order that you request them. To start another export, cancel a current long-running export. 

  1. On the sidebar, click Inbox.Inbox icon
  2. In the Inbox pane, click Exports .
  3. Beside an in-progress export, click More In-progress view export More
  4. Click Cancel. PureCloud starts the next export waiting to run. 
  5. To clear the canceled export, click the X beside the export.Cancel export- clear export

Note: You cannot restart a canceled export. If you cancel an export and then create the same export again, PureCloud places it at the end of the queue of exports to run. 


  1. On the sidebar, click Inbox.Inbox icon
  2. In the Inbox pane, click Exports .
  3. Beside the export you want to download, click Download. The system downloads the export to your computer’s Downloads folder. Exported file in inbox download
  4. To delete or mark the file as read, click More .Exported file in inbox More


Notes
  • Views that contain large data sets can take longer to generate and may not be available to download immediately. These exports appear as in-progress the inbox, and after PureCloud finishes creating it, are downloadable from the inbox.
  • PureCloud automatically deletes the exported file from your inbox 10 days after you create it.
  • The export file contains all of the exported data available in the view, with the following differences:
    • The export contains all rows for the view, not just the rows visible on the current page.
    • The columns in the exported file remain constant even if you have hidden or rearranged the columns in the view. When you select Selected Columns, only the columns shown in the view are exported, in the order you preferred. 
    • If you use filters, such as skill or language, then the exported file’s filter column lists which filters you used. If you did not use filters, then the filter column remains empty.
    • The export displays time values in milliseconds. 
    • Views display time values in minutes and seconds. When exporting views with a duration column, the time values are formatted in milliseconds. If you want time values formatted in HH:MM:SS.mmm, select the Format Durations (HH:MM:SS) option on the Export pane.
    • The export displays percentage values as decimals, while views display them as whole numbers. For example, the export displays 0.8 for 80%.
    • If the view shows the current interval, then the Interval Complete column in the export says FALSE.
    • Exporting from Interactions views only exports historical data, typically > 1 day old. When you filter by date, such as Today and Yesterday, due to the source and volume of Interactions data, there might be a difference between what is shown in the view and what is exported. If there is a difference, you will receive a partial result indication, and the file shows the partial result date and time, including the most recent available transaction. A partial file is not run again. Because a partial export only includes data that is greater than one day old, when the data is available you need to create a new export based on the partial export time stamps, to include missing transactions.  A partial result indication can still return the full result set, and the Partial Result Timestamp, indicating the most recent transaction, shows the data fell within the requested interval.
  • The Interactions views’ export file contains two additional columns: Full Export Completed, and Partial Result Timestamp. For more information about these columns, see Interactions viewAgents Interactions Detail viewQueues Interactions Detail view.  
  • The Interactions views’ export file contains a Wrap-up Notes column that includes agent after call work notes.