fields = ['Status', 'AdNetworkType1', 'Name', 'Amount', 'Clicks', 'Impressions', 'Ctr', 'AverageCpc', 'Cost', 'AveragePosition', 'Conversions', 'CostPerConversion', 'ConversionRate', 'TotalConvValue', 'ViewThroughConversions', 'TotalCost']
report_option = {
'reportName': 'Performance Report',
'dateRangeType': 'CUSTOM_DATE',
'reportType': 'CAMPAIGN_PERFORMANCE_REPORT',
'downloadFormat': 'CSV',
'selector': {
'fields': fields,
'dateRange': {
'min': startDate.strftime('%Y%m%d'),
'max': endDate.strftime('%Y%m%d')
},
},
}
report = StringIO.StringIO()
report_downloader.DownloadReport(report_option, output=report, return_money_in_micros=False)
content = report.getvalue().strip().split("\n")
cr = list(csv.reader(content))