Downloading XML and CSV reports using the new Ads API

[Stepanian]

Is it possible to download XML and/or CSV reports using the new Ads API Java client (or any other client or raw endpoints)? I couldn't find an example or an API reference. It is currently possible to do that using the AdWords API Java client. Thanks.

[Stepanian]

Just to clarify, my question is: Once we migrate to the new Ads API and use its client SDK (Java or otherwise), will there be a way to programmatically request and download XML and/or CSV reports?

[googleadsapi...@google.com]

Hello,

Thank you for reaching out to us. Unfortunately, downloading CSV or XML reports is not yet available in Google Ads API. For now, I would suggest you to keep an eye on our blog post for the latest news and updates. Should you have further clarifications, feel free to write back.

Regards,

Dave Paurillo
Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@googlegroups.com
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 and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
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/07f93d1c-ba4b-4f2f-b8ac-d36feb87800f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Stepanian]

Thank you very much for the response. I realize that you may not know the answer to this, but should we count on this functionality eventually be available in the Ads API before the AdWords API is deprecated? Or should we change our business logic to work around this limitation? Thanks.

On Sunday, March 31, 2019 at 11:11:25 PM UTC-7, Stepanian wrote:

[googleadsapi...@google.com]

Hi,

Unfortunately, I could not provide any comment about the upcoming features with regards to the Google Ads API. I have filed a feature request on your behalf. Take note that this will not guarantee that the feature will be implemented. Should you have any other concerns, feel free to write back.

Regards,
Dave Paurillo

Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

--

--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@googlegroups.com
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 and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
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/93b3c08b-1a45-4334-ab59-b9717ba89467%40googlegroups.com.

[googleadsapi...@google.com]

Hi Stepanian,

Upon checking with the team, this feature will not be supported in Google Ads API as it can be done using the languages utility functions. This said, you would have to implement this on your end using the tools provided in the client library.

Should you have any other concerns, feel free to write back and we'll be happy to assist you.

Regards,
Dave Paurillo

Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/

On 04/04/19 02:30:45 ra...@spinneret.com wrote:

--

[UK Analytics]

Hi Dave,

Could you please clarify what you mean by "it can be done using the languages utility functions"?

Thanks,

Adam

[googleadsapi...@google.com]

Hi Adam,

It means that you could implement this on your end by using the tools and libraries that are available in the language(Java, Python, Ruby, etc). Should you have further clarifications, feel free to write back.

Regards,
Dave Paurillo
Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/ef6e41d3-6ce0-4bdb-a677-2f3269267e21%40googlegroups.com.

[Stepanian]

Thank you for the response. I am not sure I follow completely, but it appears from your answer that there actually is a way to download XML and CSV reports. We can definitely write the necessary code to accomplish that. We just don't know where to start in the new Ads API. Is there an example? If it's not an endpoint, and it's not included in the client libraries (e.g. Java), how do we go about accomplishing that? What endpoint would we connect to? Thanks.

[googleadsapi...@google.com]

Hi,

I'm sorry for the confusion. It is correct that there is a way to download CSV/XML reports but it should be done on your end using a client library of your choice. For example, in Java, you would need to use its core utilities (eg. java.io.Writer, java.io.FileWriter) to create the method. This being said, Google Ads API will only be responsible for generating the JSON data you need for your report. Then, you would need to have a method that creates a CSV/XML file and another method that gets the JSON result from Google Ads API and write it to your CSV/XML file. Should you have further clarification, feel free to write back.

Regards,

Dave
Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/7b1fdfae-6d31-4eff-85b6-6d565de72eab%40googlegroups.com.

[Stepanian]

Hi Dave, 

Thanks for the response. We can definitely convert JSON to CSV and save it to a file using Java code. That is not our concern. Our main issue is the practicality of downloading huge amounts of data using paged request/responses. Our client is a VERY big AdWords advertiser. We have automated systems that download very large reports throughout the day and use them for various purposes. I am very concerned that getting the same data in paged records would be impractically slow. I am not even sure if the Java client SDKs provided support multithreaded downloads of the paged data. Writing our own code to use the Ads API endpoints directly using threaded parallel requests for pages of the same data would be complicated and may risk exceeding various quotas associated with the API. 

Again, we are not concerned about writing the necessary code. We feel that getting the large amounts of data we currently get using reports using paged endpoints may prove to be impractical. 

Thanks again.