How to segment report data using AdWords Script?

I need to create a report that shows me the cost of advertising. I need to separate this data using Placement (DisplayName) and AdType and Device and AdvertisingChannelType. I searched the documentation in detail, and I found out that there is no single report that can cross all these dimensions. In the user interface, I can simply create a segment, no matter how I figure out how to do it, using a script. I tried this:

var placementReport = AdWordsApp.report(
     'SELECT AdGroupName, AdvertisingChannelType, AdGroupId , AdType, device, DisplayName, Cost ' +
     'FROM   PLACEMENT_PERFORMANCE_REPORT ' +
     'WHERE DisplayName CONTAINS "mail.google.com" ' +
     'DURING 20151022,20151022');  

But it just doesn't work.

How to break a report in segments?

I need to get very specific data. Iā€™m looking for a way to segment the cost of advertising by device, placement and type of ads, for example:

AdId: 320930902 > Device: Mobile > Placement: Youtube > adtype: Ad Text > Cost: $35.00
AdId: 320930902 > Device: Mobile > Placement: Youtube > adtype: Ad Image > Cost: $5.00
AdId: 320930902 > Device: Computer > Placement: Youtube > adtype: Ad Image > Cost: $45.00
AdId: 320930902 > Device: Computer > Placement: Youtube > adtype: Ad Text> Cost: $50.00

And so on ... Any ideas?

Thanks!

+4

Source: https://habr.com/ru/post/1612965/


All Articles