Browser export

Last update: February 17, 2022

CREATED FOR:

  • User
  • Admin

Browser export lets you export your classification data to a tab-delimited file.

Admin > Classification Importer

The data set file is a tab-delimited data file (.tab filename extension) that most spreadsheet applications support.

NOTE
Browser exports have a 30-column limit.

Field descriptions

ElementDescriptions
Select Report SuiteSelect the report suite from which you want to export the report data.
Data Set to be classifiedFrom 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 (up to 50,000 rows).
  • Select Limit Data Rows To if you want to specify a specific number of rows to download.

If you want to download more than 50,000 data rows, use the FTP download option.

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. 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 system 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.
Data Filter(Optional) Filter data by campaign data. You can download data only from active campaigns, or you can select campaigns that began (or ended) in a specific date range.
Important: This option is not available for report suites enabled for the New Classification Architecture.
Export Numeric 2You 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. See Numeric 2 Classifications for information about uploading data using numeric 2 classifications.
EncodingSelect 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.
Quote OutputSpecifies version 2.1 for the classification file. This setting places quotes around special characters to ensure that exports work in Excel when a line break exists in the eVar values. You can identify whether a classification file is version 2.1 by opening the downloaded file. You will see v2.1 in the header. For example: ## SC SiteCatalyst SAINT Import File v:2.1

Export classification data using the browser

  1. Click Admin > Classification Importer.
  2. Click the Browser Export tab.
  3. Specify the data set details.
  4. Click Export File.
  5. Save the data set to your local system.

Analytics