Can't retrieve ad_group_ad.ad.responsive_display_ad.long_headline via select clause

[VB]

Hi,

 

I'm using this code to post responsive display ad data to a Google sheet via a Google Ads script:

 

var report = AdsApp.report(
   "SELECT segments.date, campaign.name, ad_group.name, ad_group_ad.ad.type, ad_group_ad.ad.id, ad_group_ad.status, ad_group_ad.ad.responsive_display_ad.long_headline, ad_group_ad.ad.responsive_display_ad.headlines, ad_group_ad.ad.responsive_display_ad.descriptions, ad_group_ad.ad.final_urls, metrics.impressions, metrics.active_view_impressions, metrics.clicks, metrics.conversions, metrics.cost_micros, ad_group_ad.labels " +
   " FROM ad_group_ad " +
   " WHERE " +
   " metrics.cost_micros > 0" +
   " AND segments.date >= " + dateStart + " AND segments.date <= " + dateEnd);  
  var rows = report.rows();

 

Everything gets posted except for long headlines even though the same script does retrieve long headlines from the ads via "get" , just not via "select" method.

 

Could it be that it's not possible yet?

 

Thank you!

[Google Ads Scripts Forum Advisor]

Hi,

I'm from the Google Ads Scripts team.

Could you provide more information to this, such as the following, so we're able to further investigate this on our end and assist you? You may send these to us via Reply privately to author option.

• Google Ads account ID or CID
• Name of the script
• Screenshots showing the issue
• Shareable link of the spreadsheet the script is using, if there's any. You may follow this guide (https://support.google.com/docs/answer/2494822?hl=en&co=GENIE.Platform=Desktop#zippy=,share-a-file-publicly) under Share a file publicly.

 

This message is in relation to case "ref:_00D1U1174p._5004Q2lKjVk:ref"

Thanks,
 

Google Ads Scripts Team

[Sao Băng Liên]

yp8UKO7s4q