Just a tip following an email from Paola clarifying how to read Adwords (automated) csv reports.

The csvs won't load just by dragging and loading in the DataManager space and results in the data coming out with weird symbols. This is because the csvs follow a different set of encoding, you will have to amend this by selecting "UTF-16LE" and change the separator value to "\t". Also make sure to set the Header row accordingly (should be 6, this may vary).

See image below for what the configuration looks like, you can use the "Batch Append File" too but do check to make sure that the header rows are always on the same row number for each file.