Visual Insights: Downloading data

Follow
Available for User roles Super Admin, Admin, Team Member
Packages All Lever packages

Downloading data from Visual Insights allows you to keep your own records and run your own calculations with your recruitment information outside of your LeverTRM environment. Readers of this article will learn about:

As you are reading, refer to our LeverTRM Glossary for definitions of the key terms and concepts used in this article.

Methods for downloading data

There are 3 methods for downloading data from Visual Insights.

Method 1: Downloading data from charts

To download data from a chart, click the three stacked dots ⠇in the upper-right corner of the chart tile and click Download data.

Pipeline snapshot chart with Download data button extended from upper right corner.

A modal will appear in which you will be prompted to select an export format for the download. Once you have selected a format, click the Download button.

Method 2: Downloading data from drill down tables

Drill down tables appear when you click into a value on a chart. The table contains records for the opportunities, postings, or requisitions to which the events, measurements, or objects contributing to the drilled value are associated. Click the Download in the upper-right corner of the drill down table, select an export format for the download in the modal that appears, and then click Download button.

Drill down table with Download button highlighted.

Note that drill down tables can list a maximum of 500 records. If the drilled value is comprised of data from more than 500 records, and you wish to download data from all records that comprise that value, follow these instructions before clicking the Download button in the modal:

  • Click ▸ Advanced data options beneath the export format menu. 
    • Note: This button will not appear if you have selected the PNG export format for the download.

Data download modal with arrow pointing to Advnaced data options beneath export format menu.

  • Select the All results option under the Number of rows to include header.

Expanded advanced data options menu with all results selected under number of rows to include heading.

For full details, refer to our help article on drill downs.

Method 3: Running bulk data exports

 

Bulk data exports can only be run by users with Super Admin level access or those that have had export permissions configured as such by a Super Admin.

To download data associated with the objects and forms in your LeverTRM environment, you may consider running a bulk data export. These exports contain granular information fields and are ideal for data back-ups and record keeping. To run a bulk data export, click the download icon () in the left-side navigation and select the type of data export you wish to run from the menu that appears.

Arrow pointing to download button in left-side navigation of Visual Insights interface

To initiate an export, fill out any required fields on the export page and click the Generate Export button. Pop-ups will appear in the lower-left corner of the screen to indicate that generation of the export is in progress. When generation is complete, click the Download file button on the pop-up. For descriptions of the 9 export types and the data included in each, check out our help article on bulk data exports.

Data export formats

If you are downloading data directly from a chart or a drill down table (see methods 1 and 2 above),  you will be required to select an export format in the modal that appears. The default selection is a TXT file format, however you will notice there are a number of other export formats from which you can choose.

Download modal with file format menu expanded.

When choosing an export format, it is best to think of the 7 available options as being divided into two categories - Standard and Developer.

Standard export formats

TXT, Excel, CSV and PNG are considered 'Standard' export formats. In most cases, we recommend downloading data in a standard export format so you can easily manipulate the data with tools that are readily available to you, Standard export file types do not require additional applications or technical expertise in order to work with them.

Developer export formats

JSON, HTML, and Markdown are considered 'Developer' export formats. In most cases, we advise against downloading data using these export formats, as the generated files require development tools in order to access and manipulate the data. If you find that you are regularly need to download data in a developer export format, consider making use of Lever's Data Warehouse Sync option available with the LeverTRM for Enterprise Plus package (or Lever Enterprise legacy edition) as well as the Advanced Analytics add-on.

Getting developer assistance with an HTML export

In the event that you require data in an HTML export format, note that you will need the assistance of a developer at your organization to link the values in the file back to the Visual Insights dashboard from which you downloaded it. To do this, they must open the HTML file in an editor and update the 'href' (located between the <a> tags) with the URL for the dashboard from which the download originated.

For example, if you downloaded data from a chart on the Overview dashboard in an HTML export format, the code in the export...

<a href='/explore/lever_reporting/opportunity_progress_events_dash? target='_self'>
0
</a>

...would have to be updated to:

<a href='https://hire.lever.co/visual-insights/overview' target='_self'>
0
</a>
Was this article helpful?
0 out of 1 found this helpful