function main() { var emailAddress = 'thomas.gruebel@inbiz.de'; var eMailSubject = 'Betreff'; var eMailMessage = 'Mailnachricht'; // 1. Daten selektieren var report = AdWordsApp.report( "SELECT KeywordText, FirstPageCpc, MaxCpc " + " FROM KEYWORDS_PERFORMANCE_REPORT " + " WHERE Impressions = 0" + " DURING YESTERDAY " ); // 2. Daten in Spreadsheet schreiben var spreadsheet = SpreadsheetApp.create("0 Impressions"); report.exportToSheet(spreadsheet.getActiveSheet()); // auskommentieren, wenn es hier weiter gehen soll: return "1"; // 3. Daten selektieren var report = AdWordsApp.report( "SELECT CampaignName, Impressions, Clicks, Cost " + " FROM CAMPAIGN_PERFORMANCE_REPORT " + " WHERE Impressions > 0" + " DURING LAST_7_DAYS " ); // 4. Date per Schleife durchlaufen var rows = report.rows(); while (rows.hasNext()) { var row = rows.next(); var CampaignName = row['CampaignName']; var Impressions = row["Impressions"]; var Clicks = row["Clicks"]; var Cost = row["Cost"]; Logger.log(CampaignName+"; "+Impressions+"; "+Clicks+"; "+Cost); // Geht auch: Daten foratieren (Punkt / Komma) // Geht auch: Daten für Mail sammeln } // Daten per Mail versenden if(emailAddress) { MailApp.sendEmail(emailAddress, eMailSubject, eMailMessage); } }