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!