Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function main() {
- var spreadsheet;
- var report;
- var label;
- var date = new Date();
- function createReport (labelname, tabellenid) {
- label = AdWordsApp.labels()
- .withCondition("Name ="+labelname)
- .get().next();
- report = AdWordsApp.report(buildSelect(label.getId()));
- spreadsheet = SpreadsheetApp.openById(tabellenid);
- spreadsheet.insertSheet((date.getMonth() + 1) +' '+ date.getYear()).activate();
- report.exportToSheet(spreadsheet.getActiveSheet());
- };
- createReport ("Ost", "1WQmcF-FYtnG5shQ3tZeiaYRkqud5kgjRBU6EvlUo52s") +
- createReport ("West", "1ldElXG0TYuMatbptGHE6VGcbDY59MNyGBfnSB4R2orE");
- }
- function buildSelect(id) {
- return 'SELECT CampaignName, Clicks, Conversions, Cost, CostPerConversion ' +
- 'FROM CAMPAIGN_PERFORMANCE_REPORT ' +
- 'WHERE Impressions > 0 AND Labels CONTAINS_ANY [' + id + '] ' +
- 'DURING THIS_MONTH';
- };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement