Ad Performance Report Script

[Linda Corzo]

Hello,

I'm using the script from this page: https://developers.google.com/google-ads/scripts/docs/solutions/ad-performance and it's working, but every time the script runs it creates the data in a new sheet. 

Is it possible instead to overwrite the data in the specified template sheet and not create a new one every single time? 

Thanks!

[Mike Rhodes]

Yes it's possible - but you'd have to change a few bits of the code (to clear the sheet, to tell it which sheet/tab to use, possibly more that I'm not thinking of...!)

[Google Ads Scripts Forum Advisor]

Hello,

I’m James from the Google Ads scripts support team. Thank you for contacting us.

I concur with Mike that it is possible.  I made some adjustments to our solution script in order for it to overwrite data in an existing spreadsheet. That said, can you please try to implement the attached script below and let me know how it goes on your end?

Regards,

James Howell Google Ads Scripts Team

ref:_00D1U1174p._5004Q2exZQJ:ref

[Linda Corzo]

Hi James,

Thank you for sharing this, unfortunately, this is the error code I am receiving:

10/6/2022 2:20:28 PM	Using template spreadsheet - https://docs.google.com/spreadsheets/d/1acE4CyRU5ri0_imq27vO3XAtFmBdXdRgHUUT-Lvxz8c/edit#gid=12.
10/6/2022 2:20:33 PM	TypeError: segments is not iterable at outputSegmentation (Code:213:29) at main (Code:108:5)

Also, is there a way to see this by campaigns or campaign types?

Thank you for all your help, very much appreciated!

[Linda Corzo]

Hi James,

Is there a reason that the script isn't working?

Also, is there a way to see this by campaigns or campaign types?

Thank you for all your help!

[Google Ads Scripts Forum Advisor]

Hello,

Can you please share with us the following items below so that we can further check the issue?

• Google Ads Account  ID / CID
• Script name

On the other hand, regarding your additional question, could you please provide more details to it so that we can provide an accurate response?

Regards,

[Linda Corzo]

Hi James,

Please see below:

• Google Ads Account  ID: 757-897-5336  / CID: 617-777-2956
• Script Name: Modified Ad Performance Report

In regards to my question, I was wondering if we can segment this report further by campaign or campaign type.

Thank you!

--
-- 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 a topic in the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-scripts/D4XqEy2927w/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/NsmO6000000000000000000000000000000000000000000000RJVZJS00MddeMifQQPGDB0zfGUVuiQ%40sfdc.net.

--

Linda Corzo | SEM Manager

Tel: (800) 316-2220

10940 Wilshire Blvd. Los Angeles CA 90024

[Maxime Grimler]

Hey Linda,

You need to replace this line 

return adGroupAd.ad.responsiveDisplayAd.longHeadline

by this line

return adGroupAd.ad.responsiveDisplayAd.longHeadline.text;

For the responsive display ad, the longHeadline has to be returned as text format and not as object, this will solve your issue with "segments is not iterable"

Regards,

[Linda Corzo]

Hi Maxime,

Thank you, that worked! My question was if there was a way to segment the headlines further by campaign or campaign type.

Appreciate your help!

--
-- 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 a topic in the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-scripts/D4XqEy2927w/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-scrip...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/f246c92f-eacb-493b-a37f-91cb4f6f5f05n%40googlegroups.com.

[Linda Corzo]

Hi James,

Just wanted to follow up and see if we can segment this report further by campaign or campaign type.

Thanks!

[Google Ads Scripts Forum Advisor]

Hello,

I believe that it is feasible to segment your report by campaign name or campaign type. You just need to add the campaign.name or campaign.advertising_channel_type field as a filter within the GAQL query under processAccount function.

Let me know if you have any further questions.

Regards,