Advertisement
Guest User

Untitled

a guest
Dec 9th, 2016
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. function main() {
  2. var spreadsheet;
  3. var report;
  4. var label;
  5. var date = new Date();
  6.  
  7. function createReport (labelname, tabellenid) {
  8. label = AdWordsApp.labels()
  9. .withCondition("Name ="+labelname)
  10. .get().next();
  11.  
  12. report = AdWordsApp.report(buildSelect(label.getId()));
  13. spreadsheet = SpreadsheetApp.openById(tabellenid);
  14. spreadsheet.insertSheet((date.getMonth() + 1) +' '+ date.getYear()).activate();
  15. report.exportToSheet(spreadsheet.getActiveSheet());
  16. };
  17.  
  18. createReport ("Ost", "1WQmcF-FYtnG5shQ3tZeiaYRkqud5kgjRBU6EvlUo52s") +
  19. createReport ("West", "1ldElXG0TYuMatbptGHE6VGcbDY59MNyGBfnSB4R2orE");
  20. }
  21.  
  22. function buildSelect(id) {
  23. return 'SELECT CampaignName, Clicks, Conversions, Cost, CostPerConversion ' +
  24. 'FROM CAMPAIGN_PERFORMANCE_REPORT ' +
  25. 'WHERE Impressions > 0 AND Labels CONTAINS_ANY [' + id + '] ' +
  26. 'DURING THIS_MONTH';
  27. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement