Back to Mavenlink.com Blog Tour Status

Insights Scheduled Data Exporter

 

Overview

The Mavenlink Insights Scheduled Data Exporter is a tool designed to automate the flow of data from Mavenlink to your external business intelligence tool, data warehouse, or other external system.


insights-scheduled-data-exporter-diagram.png


You can use the Scheduled Data Exporter to export both standard and custom reports from Insights. You can set up scheduled exports yourself from within Mavenlink, or through the Mavenlink API .

You can also automate dataflows using FTP, Amazon S3, and other services by integrating scheduled exports with your business intelligence tool of choice, such as Power BI, Domo, or Tableau. Contact your Client Success Manager to learn more.

Note that the Scheduled Data Exporter run time is based on the timezone you have set in your Mavenlink profile.


Scheduling Exports from within Mavenlink

As an Account Administrator, you can set up hourly or daily exports of reports to feed into your business intelligence tool, data warehouse, or other external system.

  1. Hover over Settings in the left-side nav and select Insights. settings-insights.png
  2. If you have not scheduled any exports yet, the Scheduled Exports tab on the Settings | Insights page will appear empty. insights-settings-data-exporter-tab_copy.png
  3. To set up an export, click the Add Schedule button. settings-insights-data-exporter-add-schedule-button.png
  4. A set of fields appear. Give the export a Name, and select the appropriate Insight Report Source from the drop-down, or by searching for it directly. settings-insights-data-exporter-report-source.png
  5. You can add a Description to help clarify what is in the export. This can be helpful if you create another schedule for a report with a similar sounding name, or as a reminder of which reports you have scheduled to run Hourly or Daily. settings-insights-scheduled-exports-description.png
  6. By default, Schedule is set to Hourly. You can change it to Daily, and then change the Time to suit your preference. settings-insights-data-exporter-time-schedule_copy.gif
  7. When ready, click Add Schedule. settings-insights-data-exporter-add-schedule-button.png
  8. After you add exports, they appear in a table on the Scheduled Exports tab. settings-insights-scheduled-exports-table.png
  9. When an export has finished, a timestamp appears. settings-insights-scheduled-exports-run.png
  10. You can make changes, delete, and download when the report has run by selecting the More icon (" "). settings-insights-scheduled-exports-more-icon.png
  11. Your export downloads as a compressed .CSV file. Decompress or unzip it first, and then import it into your business intelligence tool, data warehouse, or other external system.

Any Insights export created within Mavenlink is also accessible via the Mavenlink API , and ones created with the Mavenlink API are viewable and accessible within Mavenlink.

NOTE

Mavenlink Insights does not store historical data or snapshots of data for most data sets. For example, the resource allocation dataset does not contain historical values or deleted records of allocations. There are no records of the deletion or changes that were made and therefore these records cannot be exported out using Insights.

Related Articles

Standard Dashboards

Step-by-Step

Mavenlink API

 

Created on