DocumentationAnalyticsComponents Guide

Classification data export via FTP

Last update: Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User
  • Admin

The FTP option provides more flexibility in downloading data sets, including the ability to download data from multiple report suites and to download data set files larger than 50,000 data rows. Before downloading classification data via FTP, create an FTP account.

Consider the following issues when applying data filters:

  • You can use wild cards when defining the data filter. Use an asterisk * to match zero or more characters and a question mark ? to match exactly one character. Use ?* to match one or more characters.

  • Typically, when applying both types of data filters to a download, only rows that match both rules are downloaded. However, the following exceptions apply:

    • If Rows with empty column = All Columns, then all columns except the column specified in the first rule are checked for emptiness. This exception ensures that the tool downloads any row with a column that matches the first rule that also has all other columns empty.
    • When downloading data rows based on empty columns, all columns except those specified in the first rule are checked for emptiness.
    • If the same column is specified for both filter rules (it is almost impossible to meet both criteria) then only rows that match the first rule are downloaded.
    • FTP exports have a 30-column limit.

Export classifications using FTP

These steps describe how to export (download) classifications from Adobe Analytics using FTP.

  1. Create an FTP account.
  2. Go to Admin > Classification Importer.
  3. Click the FTP Import tab.
  4. Configure fields for the FTP Export.
  5. Click Export File.
  6. Save the data set to your local system.

Field descriptions

Element
Descriptions
Select Report Suite
Select the report suite from which you want to export the report data.
Data Set to be classified
From the drop-down menu, select the data set that you want to classify.
Select Number of Rows

Specify how many rows of data to export.

  • Select All to download all report data.
  • Select Limit Data Rows To if you want to specify a specific number of rows to download.
Filter by Date Received
(Optional) Filter data by the date it was received. Specify the date range for which you want to download data.
Apply Data Filter
(Optional) Filter the data set by data criteria. You can filter the download to include data rows that include a specific value or data rows with unassigned column (classification) values.
Date Filter
(Optional) Filter data by campaign data.You can download data only from active campaigns, or select campaigns that begin (or end) in a specific date range.
Export Numeric 2
You can import Numeric 2 classifications into the system using the importer. Numeric 2 classifications are useful for variables that change over time for different items, such as cost and budget values for the Marketing Channel report.
FTP Account
Specify the FTP server information where you want Adobe to download the data file, including host name and port, path to the destination directory, username, and password.
Notification
Specify the email address to receive notifications about this FTP download.
Encoding
Select the character encoding for the data file. The default encoding format is either UTF-8 or ISO-8859-1, based on the encoding that was uploaded for the classification. UTF-8 to UTF-16 converts your UTF-8 encoded classifications to UTF-16 encoding. ISO-8859-1 to UTF-16 converts your ISO-8859-1 encoded classifications to UTF-16 encoding.
Note: If you select to convert to UTF-16, the source encoding must match the encoding of the original upload or you may get unexpected results. We recommend encoding all uploaded files in UTF-8 without BOM.
recommendation-more-help
46b8682c-fda6-4669-9355-1a44923e549e