Visitor Data Mart data requests
can be scheduled using the Data Scheduler. Each data request
requires you to select a business object based on a website event such as an ad click or
campaign conversion. You can then decide which data fields to extract.
To use this feature, you need the Data Scheduler Warehouse
Data Extracts user right. To download your extracted data files, you need the Data Scheduler Available
Files (SFTP) user right.
To schedule a Visitor Data Mart data
In the left pane of Administration, click Import/Export.
Expand Data Scheduler in the
left pane and click Upcoming.
In the Name of this Extract
field, provide a name.
In the Description field,
provide a description (255 characters maximum).
Select the profile from which you want to extract data.
Select the segment on which to base the extract (skip to Step
in the Object list, select
the business object for which you want to request data. Each business object is
based on a website event such as an ad or a shopping cart remove. If you want
to export data for more than one business object, you can schedule multiple
In the Included Fields list,
select one or more check boxes identifying the database fields to include for
the currently selected business object. Database fields are based on event
attributes such as time or visitor IDs. To include all fields, check Select All.
Using the Filters settings,
create any filters you want to use to limit the data:
- To see only unique rows, select Exclude duplicate
- Set a geographic filter. For example, limit the data to
traffic from Quebec by setting the filter State Province - Visitor
Attributes equals Quebec.
- Click + to add more filters. Click - to delete a filter.
Filters use a Boolean AND. For example, you could add the filter Result
Count Greater Than Equal 1 to extract only data with successful on-site
searches from Quebec.
Note: You can apply a maximum of 5 filters to each data
For Time Period and Frequency, select the
unit for which you want to extract data.
Extract data for the Day Once a day: Data for the
previous day is extracted at 2 a.m. the following day.
Extract data for the Day Twice a day: Data is extracted
at 2 p.m and 2 a.m. the following day.
Extract data for the Day Three times a day: Data is
extracted at 10 a.m., 6 p.m. and 2 a.m. the following day.
Extract data for the Day Four times a day: Data is
extracted at 8 a.m., 2 p.m., 8 p.m. and 2 a.m. the following day.
(Optional) Click Edit after
the File Properties drop-down to change the
File Properties defaults for the CSV file created for the extract (Name, Include
Header Rows, Column Delimiter, New Line Delimiter, Text Qualifier, and Escape
Character). Check the Available in
check box to make segments available in Optimize.
If you want to notify other Webtrendsusers by
email about the success or failure of your data extract, use the Notify fields to create notification rules. By
default, only you are notified on success of the extract. Click + to add more rules. Click - to delete a rule.
Note: You can notify a maximum of 10 users per data
extract. To notify more users, you can send a notification
to a distribution list.
Click Schedule. After the
selected time period of your extract is complete, the extract is initiated 3
hours after midnight (12 A.M.) in the time zone of the profile for which you are
extracting data. The 3-hour delay ensures that any outstanding hits are