Exporting historical event data for a specified seasonal event to Microsoft Excel

Edit online

You can export historical event data for a specified seasonal event to a Microsoft Excel spreadsheet from a supported browser.

Before you begin

You first view seasonal events for which you want a list of historical events in the View Seasonal Events portlet. To access the View Seasonal Events portlet, users must be assigned the ncw_analytics_admin role.

About this task

In addition to exporting historical event data to a Microsoft Excel spreadsheet, you also export the seasonal event charts and seasonal event data and confidence levels for the seasonal event that you selected. Currently, there is no way to export only the historical event data.

Procedure

To export historical event data to a Microsoft Excel spreadsheet, complete the following steps.

  1. Open the View Seasonal Events portlet.
  2. Select a specific configuration from the configuration table.
  3. Select a seasonal event from the events table.
  4. Right-click the seasonal event and select Show Seasonal Event Graphs.
  5. From the Actions menu, select Export Seasonal Event Graphs.
    After a short time, the Download export results link displays.
  6. Click the link to download and save the Microsoft Excel file.

Results

The Microsoft Excel file contains a spreadsheet with the following tabs:

  • Seasonal Data: This tab contains the seasonal event data and confidence levels for the seasonal event that you selected.
  • Seasonality Charts: This tab contains the seasonal event graphs for the seasonal event that you selected.
  • Historical Events: This tab contains the historical event data for the seasonal event that you selected.
  • Export Comments: This tab contains any comments relating to the export for informational purposes (for example, if the spreadsheet headers are truncated, or if the spreadsheet rows are truncated).