Forum Moderators: martinibuster
Apparently they are planning for more output formats so CSV is no longer enough.
You have to add "&outputFormat=TSV_EXCEL" to the destination URL.
Tested working. Enjoy...
[1]
putenv('TZ=US/Pacific'); $randate=mktime(0, 0, 0, date("m"), date("d")-rand(3,26),date("Y"));
$destination="/adsense/report/aggregate?product=afc&dateRange.simpleDate=thisweek&dateRange.dateRangeType=custom&dateRange.customDate.start.month="
.date("n",$randate)."&dateRange.customDate.start.day=".date("j",$randate)."&dateRange.customDate.start.year="
.date("Y",$randate)."&dateRange.customDate.end.month=".date("n")."&dateRange.customDate.end.day=".date("j")
."&dateRange.customDate.end.year=".date("Y")."&unitPref=page&reportType=property&null=&groupByPref=date&null=Display+Report&csv=true&outputFormat=TSV_EXCEL";
[/1] the random date is to defeat any caching on Google's part