Download Campaign Performance(COST) data

[Hao Long]

Hi Team,

i am trying to download campaigns cost data under one MCC account from Google Ads API and i have below questions:

1. the INSERT_CUSTOMER_ID_HERE parameters in ads.properties file should assign MCC account value?

2. as example showed(https://developers.google.com/google-ads/api/docs/samples/get-hotel-ads-performance) it only print returned result. we need save as file. there have saveToFile tools as below could use in adwards API, how about Ads API?

ReportDownloadResponse response = reportDownloader.downloadReport(reportDefinition);
response.saveToFile(reportFile);

[Google Ads API Forum Advisor]

Hi Hao,

"api.googleads.loginCustomerId" is for the MCC that you are logging in from. I raised your request with my team for a method to convert Ads API JSON to CSV flat format. You may monitor our blog for an update.

Regards,

Aryeh Baker Google Ads API Team

 

ref:_00D1U1174p._5004Q2QFFGf:ref

[Hao Long]

Thanks Baker,

is there any ETA for this request? as currently each GAQL returned iterator object, we need handle row by row. lot's of redo work happen everyday

[Google Ads API Forum Advisor]

Hi Hao,

Thanks for the follow up on the feature request.

However, I’ve received the update from our team. You’ll need to do this on your side using an appropriate tool for your environment. Since the API returns results in JSON format, you would need to process it however you wish such as JSON to CSV flat format. The said feature isn't going to be implemented on the API side.

Let us know if you have any further questions.

Regards,
Reminder: Share your feedback about the Google Ads (AdWords) API! Take the 2021 Google Ads API and AdWords API Annual Survey
 

Yasar Google Ads API Team

 

 

ref:_00D1U1174p._5004Q2QFFGf:ref