|
|
Data Extract ActivityFrom $1Table of contents
What Is a Data Extract ActivityA data extract is an activity that creates a file of information for you to use outside of the application. This activity can also be used to transform an XML file to a comma-delimited, tab-delimited, or pipe-delimited file for import into your account. The activity deals with files in your File Transfer Location that you specify in your Account Settings. For example, the activity can put a file of extracted tracking data on to your FTP server. You must include the data extract activity in a scheduled program along with a file transfer activity to place the data in your file location of choice. You can set this program to run once or on a regular schedule. PropertiesWhen you define a data extract activity, you provide the following information: Name, External Key, and DescriptionYou enter these values to identify the data extract activity. The name and description help you identify the activity when you're working in the application itnerface. The external key uniquely identifies the activity so it can be referenced in API code. File Naming PatternYou enter a file naming patterns so that the activity knows what to name the file it creates. You can choose to enter a static name-such as tracking.txt-or you can choose to include placeholder for the date. Including placeholders for the date lets you have a unique filename for each extract file without changing the activity definition. For example, if you create the file naming pattern tracking%%Month%%%%Day%%.txt, then on November 20 the extracted file is named tracking1120.txt. Extract RangeYou choose the period of time, ending with the time of the data extract, for which to extract tracking data. For example, if you choose an extract range of 7 days, the activity extracts tracking information for the last seven days from the time of the activity running. Not all extract types utilize a date range. Some extracts are purely for file tranformation and are not bound by date. Extract TypeThe extract type determines what the activity does. You can choose from the data extract types that are available in your account. For example, Tracking Extract, Data Extension Extract and Convert XML are extract types. The extract type that you select determines the information that you specify in the Fields section. Available extract types include:
FieldsThe configuration settings for the data extract appear in this area when you select a value in the Extract Type field. The configurations vary for each extract type. If the data extract you choose includes the columnDelimiter field, insert the character you wish to use as a delimiter within the data extract. Valid choices include the following characters:
This page was last updated by Josh Cloud on Tue, 03 May 2011 13:01:18 GMT. If you're having an application issue, please contact Global Support. To send Josh direct feedback, fill out the form below:
Tags: (Edit tags)
|
Powered by MindTouch 2010 |