Hi,
I was facing this issue very frequently. I have 250 advertiser accounts and
I need to pull Shopping Performance Report from all the accounts. I was
trying to complete this from yesterday but not able to success. I tried to
run parallel process downloading which is not working in windows. Looks
like there was an issue with one of python libraries and I have raised a
ticket for the same.
Now I am out of options and getting delayed, my downstream applications are
waiting on this data. Please help me how to avoid this error.
The following code is the one which I am running for all accounts, first
getting all advertiser accounts and looping the code.
def download_Performance_Criteria_Report():
for client_customer_id in list(set(account_list)):
print client_customer_id
o2client = GoogleRefreshTokenClient(adc['client_id'],adc['client_secret'
],adc['refresh_token'])
client=AdWordsClient(adc['developer_token'],o2client,'OBI',
client_customer_id=client_customer_id)
_fpath=os.path.join('D:/adwords/temp/Adwords_Shopping_MMA_'+str(
client_customer_id)+'_'+datetime.datetime.now().strftime( "%Y%m%d%H%M") +
'.csv')
## client = AdWordsClient.LoadFromStorage('googleads.yaml')
rep_downloader = client.GetReportDownloader(version='v201710')
report = {
'reportName' : 'SHOPPING_PERFORMANCE_REPORT',
'dateRangeType' :'CUSTOM_DATE',
'reportType': 'SHOPPING_PERFORMANCE_REPORT',
'downloadFormat': 'CSV',
'selector': {
'fields': ['AccountDescriptiveName','AdGroupId',
'AdGroupName','AggregatorId','Brand','CampaignId','CampaignName',
'CategoryL1','CategoryL2','CategoryL3','CategoryL4','CategoryL5',
'CountryCriteriaId','CustomAttribute0','CustomAttribute1','CustomAttribute2'
,'CustomAttribute3','CustomAttribute4','ExternalCustomerId',
'LanguageCriteriaId','MerchantId','OfferId','ProductTypeL1','ProductTypeL2',
'ProductTypeL3','ProductTypeL4','ProductTypeL5','StoreId','Date',
'AverageCpc','Clicks','ConversionRate','Conversions','ConversionValue',
'Cost','CostPerAllConversion','CostPerConversion','CrossDeviceConversions',
'Ctr','Impressions'],
'dateRange' : { 'min': '20171225' , 'max' : '20171225'}
}
}
_f=open(_fpath,'wb')
rep_downloader.DownloadReport(report,output=_f,skip_report_header=False,
skip_column_header=False,skip_report_summary=True)
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/61cdf7c9-93e1-4752-8cf6-cff861021c03%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
