How to get Headline, Desc1, Desc2, Display URL in a single sheet

[John Paul]

Hi, 

I'm trying to modify the Ad performance Report sheet to show Headline and Destination URL in one sheet. Kindly help me how to modify the code.

[Matt Greenland]

Hi,

Could you provide a bit more detail about what you're trying to do?

If you need all the fancy bits in that solution (i.e. charts and all that), then a change like this could get pretty involved, since the structure of that code is tied pretty tightly to the structure of the spreadsheet.

If all you need is a spreadsheet that shows stats for ads along with their headline and destination URLs, then that can be more easily done with a report (https://developers.google.com/adwords/scripts/docs/reference/adwordsapp/adwordsapp#report_2). An example of that might be something like this:

AdWordsApp.report('select Headline, Description1, Description2, CreativeDestinationUrl, Clicks from AD_PERFORMANCE_REPORT during LAST_7_DAYS');