Hi,
I'm not able to pull any data except adgroup name from Ad Performance Report, the other 3 columns are blank. All other data is showing up just fine on my other sheets.
Here's the bit that's not working,
function Ads(){
var SHEET_NAME = 'Ads';
var sheet = spreadsheet.getSheetByName(SHEET_NAME);
var report = AdWordsApp.report(
" SELECT AdGroupName, Headline, Description1, Description2 " +
" FROM AD_PERFORMANCE_REPORT"+
" WHERE Impressions > 10"+
" AND AdNetworkType1 = SEARCH"+
" DURING " + dateRange);
report.exportToSheet(sheet)
}
Please let me know if i'm missing something.