RcBuilder@walla.com
call centre: 054-5614020

Adwords scripts – demo script

Posted by: RcBuilder  /   Category: Adwords Scripts / CHARTS / EMAIL / ENTITIES / JAVASCRIPT / REPORTS / SELECTORS & ITERATORS / SEM / STATISTICS   /   No Comments
08
Jun
2014

Create Chart based on the TOP 10 Most Expensive Keywords data and send via email var EMAIL = 'rcbuilder@walla.com'; function main() { var data = Charts.newDataTable() .addColumn(Charts.ColumnType.STRING, 'Name') .addColumn(Charts.ColumnType.NUMBER, 'Cost') .addColumn(Charts.ColumnType.NUMBER, 'Impressions') .addColumn(Charts.ColumnType.NUMBER, 'Clicks'); var date_range = 'ALL_TIME'; var chart_Title = 'TOP 10 Most Expensive Keywords'; var keywords = AdWordsApp.keywords().orderBy('Cost DESC').forDateRange(date_range).withLimit(10).get(); while (keywords.hasNext()) { var keyword = keywords.next(); var stat = keyword.getStatsFor(date_range); data.addRow(); //Logger.log(keyword.getText() + ',' + stat.getCost() + ','.

Read more

Adwords scripts – demo script

Posted by: RcBuilder  /   Category: Adwords Scripts / EMAIL / ENTITIES / JAVASCRIPT / REPORTS / SELECTORS & ITERATORS / SEM / SPREADSHEET / UTILITIES   /   1 Comment
08
Jun
2014

Create Report as PDF and send via email var EMAIL = 'rcbuilder@walla.com'; function main() { var spreadsheet = SpreadsheetApp.create("My Report"); // create new spreadsheet var sheet = spreadsheet.getActiveSheet(); // get active sheet var report = AdWordsApp.report("SELECT AdGroupId, Impressions, Cost FROM SEARCH_QUERY_PERFORMANCE_REPORT DURING LAST_30_DAYS"); // execute report report.exportToSheet(sheet); // fill sheet with the report data var last_row = sheet.getLastRow(); var last_column = sheet.getLastColumn(); var range.

Read more

Adwords scripts – demo script

Posted by: RcBuilder  /   Category: Adwords Scripts / ENTITIES / JAVASCRIPT / REPORTS / SELECTORS & ITERATORS / SEM   /   1 Comment
08
Jun
2014

increase cpc in 10% for display words with conversion rate less than defined var P_CONVERSION_RATE = 0.3; function main() { var report = AdWordsApp.report( 'SELECT Id, AdGroupId ' + 'FROM DISPLAY_KEYWORD_PERFORMANCE_REPORT ' + 'DURING LAST_30_DAYS'); var ids = , row]); } //Logger.log(ids.length); var keywords_f1 = AdWordsApp.keywords().withIds(ids); var keywords = keywords_f1.withCondition("ConversionRate < " + P_CONVERSION_RATE).forDateRange("ALL_TIME").get(); while (keywords.hasNext()) { var keyword = keywords.next(); var cpc = keyword.getMaxCpc(); var new_cpc = cpc *.

Read more

Adwords scripts – demo script

Posted by: RcBuilder  /   Category: Adwords Scripts / ENTITIES / JAVASCRIPT / SELECTORS & ITERATORS / SEM   /   1 Comment
08
Jun
2014

Reach the First Page by Increasing the first page cpc by 20% function main() { var keywords = AdWordsApp.keywords().get() while (keywords.hasNext()) { var keyword = keywords.next(); var cpc = keyword.getMaxCpc(); var first_page_cpc = keyword.getFirstPageCpc(); var cpc_new = first_page_cpc * 1.2; if(!AdWordsApp.getExecutionInfo().isPreview()) keyword.setMaxCpc(cpc_new); Logger.log(keyword.getText() + ' FIRST PAGE NEEDED PRICE : ' + first_page_cpc + ' -> OLD PRICE : ' + cpc + ', NEW.

Read more

Adwords scripts – demo script

Posted by: RcBuilder  /   Category: Adwords Scripts / EMAIL / ENTITIES / JAVASCRIPT / REPORTS / SELECTORS & ITERATORS / SEM / SPREADSHEET / UTILITIES   /   No Comments
08
Jun
2014

create sheet from report and read specific fields function main() { var spreadsheet = SpreadsheetApp.create("My Report"); var sheet = spreadsheet.getActiveSheet(); var report = AdWordsApp.report( "SELECT AdGroupId, Impressions, Cost " + "FROM SEARCH_QUERY_PERFORMANCE_REPORT " + "DURING LAST_30_DAYS"); // execute report report.exportToSheet(sheet); var range = sheet.getRange(1, 3, 7, 3); var values = range.getValues(); for(r in values) for(c in.

Read more

Adwords scripts – demo script

Posted by: RcBuilder  /   Category: Adwords Scripts / ENTITIES / JAVASCRIPT / REPORTS / SELECTORS & ITERATORS / SEM / UTILITIES   /   No Comments
08
Jun
2014

Send PDF Report Based on HTML Content via email var EMAIL = 'rcbuilder@walla.com'; function main() { var html = "<h1>Report Header</h1>" + "<p>this report created via adsense script</p>" + "<p>" + new Date() + "</p>"+ "<p>word A : 300 clicks</p>"+ "<p>word B : 263 clicks</p>"+ "<p>word C : 109 clicks</p>"+ "<p>END OF THE REPORT</p>"; var blob = Utilities.newBlob(html, MimeType.HTML); var pdfBlob = blob.getAs(MimeType.PDF); MailApp.sendEmail(EMAIL, 'HELLO FROM ADWORDS.

Read more

Adwords scripts Examples

Posted by: RcBuilder  /   Category: Adwords Scripts / CHARTS / DriveApp / EMAIL / ENTITIES / JAVASCRIPT / REPORTS / SELECTORS & ITERATORS / SEM / SPREADSHEET / STATISTICS / UTILITIES / XML DOCUMENT   /   No Comments
08
Jun
2014

Adwords scripts Examples // get campaigns by ids + print their name and id var campaigns = AdWordsApp.campaigns().withIds().get(); while (campaigns.hasNext()) { var campaign = campaigns.next(); Logger.log(campaign.getId() + ' ' + campaign.getName()); } -------------------- // Get each campaign’s cost and clicks last month var campaigns = AdWordsApp.campaigns().forDateRange("LAST_MONTH").get(); while (campaigns.hasNext()) { var campaign = campaigns.next(); Logger.log(campaign.getName()); var stats = campaign.getStatsFor("LAST_MONTH"); Logger.log("cost " + stats.getCost() + " | clicks " + stats.getClicks()); } -------------------- //.

Read more

Adwords scripts SPREADSHEET write read

Posted by: RcBuilder  /   Category: Adwords Scripts / JAVASCRIPT / SEM / SPREADSHEET   /   No Comments
08
Jun
2014

 Adwords scripts SPREADSHEET write read WRITE * get row or cell (see 'GET ROW/CELL') * use setValue() to set the cell content example : // set cell B4 value to be 'ROBY' sheet.getRange('B4').setValue('ROBY'); example : // set all cells in range A1 to E1 background to green(#8f8) sheet.getRange("A1:E1").setBackground("#8f8"); READ * get row or cell (see 'GET ROW/CELL') * use getValues() to get the range values * use indexes.

Read more

Adwords scripts SPREADSHEET

Posted by: RcBuilder  /   Category: Adwords Scripts / JAVASCRIPT / SEM / SPREADSHEET   /   No Comments
08
Jun
2014

Adwords scripts SPREADSHEET CREATE NEW * in order to create new spreadsheet for exporting reports we'll use 'create()' method of the 'SpreadsheetApp' class - SpreadsheetApp.create() - parameters : string example : var spreadsheet = SpreadsheetApp.create("My Report"); var sheet = spreadsheet.getActiveSheet(); EXPORT DATA * to fill a spreadsheet with report data we'll use 'exportToSheet()' method of the report - report.exportToSheet() - parameters : SpreadsheetApp.Sheet example : var.

Read more

Adwords scripts SPREADSHEET SHEET Entity

Posted by: RcBuilder  /   Category: Adwords Scripts / JAVASCRIPT / SEM / SPREADSHEET   /   1 Comment
08
Jun
2014

Adwords scripts SPREADSHEET SHEET Entity * activate() * appendRow(row) * autoResizeColumn(col_index) * clear() * clear(options) * clearContents() * deleteColumn(col_index) * deleteColumns(col_index, Quantity) * deleteRow(row_index) * deleteRows(row_index, Quantity) * getLastColumn() * getLastRow() * getName() * getParent() * getRange(row, column) * getRange(row, column, row, column) * getValues() * getLastColumn() * getLastRow() * getRange(string) * insertChart(chart) * insertColumnAfter(col_index) * insertColumnBefore(col_index) * insertColumns(col_index) * insertColumns(col_index, Quantity) * insertColumnsAfter(col_index, Quantity) * insertColumnsBefore(col_index, Quantity) * insertImage(url, col_index, row_index) * insertRowAfter(row_index) * insertRowBefore(row_index) * insertRows(row_index) * insertRows(row_index, Quantity) * insertRowsAfter(row_index, Quantity) * insertRowsBefore(row_index, Quantity) * setColumnWidth(col_index, width) *.

Read more
  • פיתוח מערכות
  • פתרונות טכנולוגים
  • קידום אתרים
  • בניית אתרים