Exporting Report - can't sort by date order.[ Edited ]
November 2016 - last edited November 2016
Here is what I am doing:
1) Creating the report.
2) Sorting by date within AdWords report. http://imgur.com/a/9Oqjb
3) Exporting to Excel csv.
4) This is the result http://imgur.com/a/RPuZj.
Since the final 'Date' is not in Date Format, I can't sort it by Date in Excel. How do I rectify this, at either end?
Exporting Report - can't sort by date order.
Hi Ben S,
What's happening is the dates are being delivered as a quoted string when you use the excel csv option. That makes the imported data text instead of dates. You could edit the csv file and remove the quotes before importing, or you can import the csv file and create a macro to remove the leading quote in the cell.
My version of Excel is ancient, so I am not able to test with a current version.
Best of Luck!