ad_group_ad.ad.responsible_search_ad.descriptions becomes undefined

[Keita Yagi]

I am trying to output a report to a spreadsheet using Google Ads Script and Google Ads API.

When I run the following code, I get

ad_group_ad.ad.responsive_search_ad.descriptions

ad_group_ad.ad.responsive_search_ad.headlines

results are returned as undefined.

​function main() {

  var spreadsheet = SpreadsheetApp.create("report output");  

  var query = "SELECT campaign.name, ad_group.name, ad_group_ad.ad.name, ad_group_ad.ad.responsive_search_ad.descriptions,  ad_group_ad.ad.responsive_search_ad.headlines, " + 

                       "metrics.impressions, metrics.clicks, metrics.conversions, metrics.ctr, metrics.average_cpc" + 

                        " FROM ad_group_ad "+

                       "WHERE segments.date > '20210101' AND segments.date < '20220407'";

  var report = AdsApp.report(query);

  report.exportToSheet(spreadsheet.getActiveSheet());

  

  var rows = report.rows();

  console.log(rows)

   while (rows.hasNext()) {

     var row = rows.next();

     console.log(row)

   }

}​

Please see also "logOutput1.png".

External service, but the following service will return the value.

https://www.awql.me/gaql

Please see also "logOutput2.png".

Am I doing something wrong in my implementation?

Any help would be appreciated.

[Google Ads API Forum Advisor]

Hi Keita,

Your query has reached Google Ads API support. This support channel can only support direct raw API communications. From your 2nd screenshot it appears that the query gets the raw data correctly. You may reach out to your spreadsheet populating code support and Google Ads Scripts Forum for assistance.

With that being said, my hunch is that the spreadsheet code doesn't allow for a returned list of assets in its population of the spreadsheet and that only a string populates the cell.  ad_group_ad.ad.responsive_search_ad.descriptions is a list of assets, not a string and so is ad_group_ad.ad.responsive_search_ad.headlines. You can see what is returned in your 2nd screenshot.

Regards,

Aryeh Google Ads API Team

ref:_00D1U1174p._5004Q2a2kH6:ref

[Keita Kobayashi]

Hi, Aryeh,

Thank you for your reply.

I posted same question for Google Ads Scripts Forum.

In general, how do I get string data from  list of assets in Google Ads Script?

Please let me know.

Thanks,

Keita

ᐧ

2022年4月13日(水) 22:44 Google Ads API Forum Advisor <ads...@forumsupport.google>:

[Google Ads API Forum Advisor]

Hi Keita,

Thanks for getting back to us.

We will be able to address concerns specific to AdWords API/Google Ads API on this forum channel. Since you’re looking to get string data from a list of assets in Google Ads Script, I suggest monitoring your created thread in Google Ads Scripts Forum. They are appropriate to support your concern.

Let us know if you have any questions related to our API’s.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2a2kH6:ref