Configuring a Visitor Data Mart Scheduled Export

You can schedule exports of data from a Visitor Data Mart in the form of a CSV file. Each scheduled report can include data from a single named query.

For more information about creating and using named queries, see the Visitor Data Mart On Demand User's Guide on the Webtrends Documentation page.

Predefined named queries and any user-configured named queries that have been created in Webtrends Analytics 9 are available for export using scheduled reports. To configure named queries or see a list of user-configured named queries, click Web Analysis > Visitor Data Mart > Named Queries in the left pane.

  1. In the left pane, click Administration > Job Scheduler > Scheduled Jobs.
  2. Click New.
  3. Click Scheduled Report.
  4. In the Profile dialog, select a Visitor Data Mart profile.
  5. In the General dialog, provide a description and owner for the scheduled report job.
  6. In the Report Destination dialog, specify how you want to deliver the scheduled report.
    Note: If you want to deliver the report using secure FTP, you may need to configure public-private key encryption.
  7. In the Queries dialog, select the name of a named query.
  8. In the Time Range dialog, select the range of data you want to export. This dialog is only available if the named query you selected includes a date parameter.
  9. In the Query Parameters dialog, specify values for any query parameters associated with the named query.
  10. In the Schedule dialog, specify when and how often you want Webtrends Analytics 9 to run the named query and export the results.
  11. In the Host Binding and Priority dialog, specify the priority for the job and what computers it can run on.