Data source files have the following properties:
#’, and are optional.
Any row that starts with ‘
#’ is a comment. When downloading a data source template file, the first two lines are comments.
All comment rows are ignored by Adobe when the file is processed, so you can remove the template comments or add your own throughout the file. Only full rows can be commented; you cannot comment out individual fields or partial rows.
When uploading data source files, column headers are required. These column headers are not case-sensitive, but required spaces are necessary (For example,
eVar1 is an invalid header, while
EVAR 1 is valid). Column headers apply to all report suites. Use the following tables to make sure that each header in your data source file is set correctly.
You can make a data sources file from scratch if you include the correct headers in your data source file. There is no limit to the number of headers that you can include within a single file; however, each row can only have a maximum of 4096 bytes.
|Dimension||Data source header|
|eVar1 - eVar250||
|Marketing Channel Detail||
Dimensions and metrics go into the same header row.
|Metric||Data source header|
Adobe does not support data sources for any other dimensions or metrics. If variables beyond what are listed in the above tables are required, consider using the Bulk data insertion API instead.
The first value in every row must be the date. Date format must be in one of the following formats:
Omitting the hours/minutes/seconds automatically sets the timestamp to 12 PM for that day.
A single data source file supports up to 90 unique days. If you want to include more than 90 unique days in an upload, split your data into multiple files.
Subsequent values after the date in each row contains the data that you want to upload. Every row corresponds with that respective timestamp. Make sure that the same number of tabs exist on every row. Columns can be in any order; make sure that the data in each row aligns with the headers at the top. The maximum amount of data a single row can have is 4096 bytes.
Dimension data cannot contain semicolons (
;). Rows that contain semicolons are skipped.
File upload: Learn the process to upload a data sources file for ingestion by Adobe.