Documentation

Use CSV as a data source

The CSV file must be in the format that can be brought in by our UI. The first three columns in the CSV file need to be:

Date in “YYYY-MM-DD” format

Provider (eg. “Amazon” )

Campaign Name

../../../../_images/csv_11.png

The metrics/column names in the rest of the file need to match how they are names in the report itself. You can find this in ‘Define Metrics’ button in the top right of the report. The datas in these columns need to be numeric (numbers only) and not strings (letters or a combination of letters and numbers).

../../../../_images/csv_21.png

The correctly formatted spreadsheet can then be uploaded to Improvado by going to ‘Edit Data Sources’ in the top right corner

../../../../_images/csv_31.png

Scroll down the various data sources you can add to a report and click on ‘CSV Import’

../../../../_images/csv_41.png

You can then drag the CSV file or upload it here

../../../../_images/csv_51.png