I want to output a list of offline conversions to a Spreadsheet using Google Ads Script.

[李埈宇]

https://developers.google.com/google-ads/api/docs/conversions/upload-summaries?hl=ja

https://developers.google.com/google-ads/api/fields/v16/offline_conversion_upload_client_summary_query_builde

We are developing a function for our company to obtain a report using GAQL described on this page and output it to a spreadsheet.

We use Google Ads Script from Google Ads.

We have already succeeded in distributing the results of Campaign and Ad Group.

However, this process does not return the intended result.

So I have the following two questions.

① Will this GAQL work with Google Ads Script?
② The returned data seems to be in JSON format, but there is no value. How can I get the number of successful and failed uploads?

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

Kindly note that GAQL will provide the response in JSON format, so you have to write your script code in such a way that it should be accessible to the response data.

You can utilize the client libraries. This client library provides high-level views and the basic building blocks of Google Ads API functionality, making it easier to develop apps quickly. Please note that you have to enable logging if you are using a client library to get the number of successful and failed uploads, or by using REST interface requests, you can enable logging via the curl command by using the -i flag.

This message is in relation to case "ref:!00D1U01174p.!5004Q02tIrDS:ref" (ADR-00233415)

Thanks,
 

Google Ads API Team