Run Data Connector from the menu Add-ons > Data Connector for Adobe Analytics.

The workflow looks as follows:
1. Create a template.
2. Configure the template (sheet structure). For Clickstream and Data Sources you can add various variables by opening the Dimensions and Metrics menu that will display the variable selector.
3. Fill in the template with data.
4. Configure Settings.
5. Configure FTP accounts for Classifications and Data Sources.
6. Load the data to Adobe Analytics.

Clickstream and Data Sources
The templates for Clickstream and Data Sources are very similar. The first two rows should always be present.

The first row highlighted with yellow lets you name the columns as you want. For example, here you can enter the dimension and metric names for convenience.

The second row highlighted with grey indicates the actual variable names (dimension ID, metric ID) and SHOULD NOT be changed. Use it for reference but never update it as this will brake the data load.

The data values begin from the third row.

Classifications
The classification template should match the template you export from Adobe Analytics. The rows that begin with a hash (#) character are considered comments.

The data values begin right after the row with headers (classification names/ dimension names).

When you work with Clickstream and Data Sources templates, open the corresponding variable catalog and add the desired variables to the sheet.

Hover mouse cursor over the variable to see its description.

Note: after adding the variables to the sheet you can reorder the columns for convinience.

Clickstream
Both variables "Date and Time" and "Timestamp" are used to load timestamped data to Adobe Analytics. You can use only one of them in the template.

• Date and Time — allows to set date or date with time in the report suite time zone. Enter the value as a date.
  Examples: 01/01/2019, 01/01/2019 14:00:00

• Timestamp — choose this variable if you want to set date and time either in the Unix timestamp format or ISO-8601 standard.
  Examples: 1571498276, 2019-01-29T05:21:29-0700

Data Sources
The data loaded as a data source should always begin with the Date column. The date should be set in the report suite time zone. Enter the value as a date.
Examples: 01/01/2019, 01/01/2019 14:00:00

The Status and Processed columns are automatically appended to the Clickstream and Data Sources sheets when the data gets processed. These columns are to indicate whether the data row was loaded or not, and when the status was set last time.

The Classification sheet is not processed differently, this is why the Status and Processed values get added as the first row.

The columns and rows with the Status and Processed values do not affect the data loaded to Adobe Analytics.

LOADED — the data was successfully loaded. The classification sheet or Clickstream/ Data Sources rows will not be loaded next time unless you select load all rows.

SKIPPED — the row was not loaded because the date or timestamp set in one of the columns referred to a date in the future. The row will be processed again at the next data load run.

FAILURE — the data was not loaded. The error message explaining the problem is appended to this status. The sheet or rows with the FAILURE status will not be processed at the next data load run. Delete the status value to include the sheet or rows in the data load processing at the next run.

When the status get changed, the Processed value gets updated too to indicate when the sheet or its row was processed last time.