ResponsiveSearchAdDescriptions, ResponsiveSearchAdHeadlines data not retrieved correctly

[はるちゃん]

The following code is executed to attempt to retrieve the data.

function main() { const sheet = SpreadsheetApp.openByUrl("Insert the URL of the spreadsheet we just created here.");
AdWordsApp.report('SELECT ResponsiveSearchAdDescriptions, ResponsiveSearchAdHeadlines' + ' FROM AD_PERFORMANCE_REPORT '
+ ' WHERE AdType = RESPONSIVE_SEARCH_AD ').exportToSheet(sheet.getActiveSheet());
}

After executing this code, you will see a lot of [object Object] on the spreadsheet.
This function is currently not working properly.

Does anyone know how to fix this?

Below is the logger.

ResponsiveSearchAdDescriptions ResponsiveSearchAdHeadlines ["[object Object]","[object Object]","[object Object]","[object Object]"] ["[object Object]","[object Object]","[object Object]","[object Object]","[object Object]","[object Object]","[object Object]","[object Object]","[object Object]","[object Object]","[object Object]","[object Object]","[object Object]","[object Object]","[object Object]"]

[Google Ads Scripts Forum]

Reposting the last inquiry (https://groups.google.com/g/adwords-scripts/c/yJLbKl3HA28) from the forum as it wasn't routed to our support queue.

Regards,

Google Ads Scripts Team

[Google Ads Scripts Forum]

Hi,

It appears that you have not yet migrated your query to the new Google Ads scripts experience. The new experience has a completely rewritten backend to take advantage of new features in the Google Ads API (https://developers.google.com/google-ads/api). In your case, your queries are still in AWQL, the new experience is now using the GAQL(https://developers.google.com/google-ads/api/docs/query/overview). You can use our Query migration tool(https://developers.google.com/google-ads/scripts/docs/reference/query-migration-tool) to translate the AWQL query to GAQL. You can also refer to this updated query:

SELECT ad_group_ad.ad.responsive_search_ad.descriptions, ad_group_ad.ad.responsive_search_ad.headlines FROM ad_group_ad WHERE ad_group_ad.ad.type = "RESPONSIVE_SEARCH_AD"

If this issue persists, you may send us privately, the following information below, using the Reply to Author option or via our email: (googleadsscr...@google.com)

• Ads ID
• Script name
• Shareable link of the involved spreadsheet (if applicable), you may follow this guide [https://support.google.com/docs/answer/2494822?hl=en&co=GENIE.Platform%3DDesktop#zippy=%2Cshare-a-file-publicly] on how you can get the said shareable link.

Regards,
Google Ads Scripts Team