Export RSA headlines and descriptions with impression metric

[Kevin Brinkman]

I'm trying to export RSA headlines and descriptions with impression metric. When I run the script below I only get one headline and one description per ad group. Not all of them. Is there any why I get all headlines and description with the number of impressions of each headline/description?

 let ss = SpreadsheetApp.openByUrl(sheetUrl);

 var query = AdsApp.report(
  `
  SELECT
    campaign.name,
    ad_group.name,
    ad_group_ad.ad.responsive_search_ad.headlines,
    ad_group_ad.ad.responsive_search_ad.descriptions,
    metrics.impressions
  FROM ad_group_ad
  WHERE
    segments.date DURING LAST_30_DAYS
    AND campaign.status = 'ENABLED'
    AND ad_group.status = 'ENABLED'
  `
 );

 query.exportToSheet(ss.getSheetByName('Assets'));
  

[Amina Khalif]

ok

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/b7b4173f-476b-459c-85c2-f29f9df7f9d1n%40googlegroups.com.

[Google Ads Scripts Forum Advisor]

Hi,

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

By reviewing your query, I understand that looking for support for your script. Please provide the below details for further investigation.

• Google Ads account ID / CID.
• Name of the script (Tools and Settings > Bulk Actions > Scripts).
• Screenshot of the issue.(if any).

 

This message is in relation to case "ref:!00D1U01174p.!5004Q02q94Ly:ref"

Thanks,
 

Google Ads Scripts Team

 

[Sigurd Fabrin]

Yes and no. See https://groups.google.com/g/adwords-scripts/c/oRRHrOLvnRI/m/BPBtbqPjAwAJ

[Kevin Brinkman]

@Sigurd thank you. I was able to export all headlines and descriptions to a sheet with the performance label. Unfortunately, exporting the impression per asset isn't possible with a script.