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 SELECTORS COLUMNS

Posted by: RcBuilder  /   Category: Adwords Scripts / JAVASCRIPT / SELECTORS & ITERATORS / SEM   /   No Comments
06
Jun
2014

Adwords scripts SELECTORS COLUMNS AdGroup * AverageCpc double * AverageCpm double * AveragePageviews double * AveragePosition double * AverageTimeOnSite double * BounceRate double * Clicks long * ConversionRate double * Conversions long * Cost double * Ctr double * Impressions long * Status enum (see 'STATUS (enum)') * Name string * CampaignName string * KeywordMaxCpc double * CampaignStatus enum (see 'STATUS (enum)') * LabelNames string Budget * AverageCpc double * AverageCpm double * AveragePageviews double * AveragePosition double * AverageTimeOnSite.

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