PPC Scripts

by Lynt services

You are here: Home / Uncategorized / Script for getting more keyword suggestions

Script for getting more keyword suggestions

od 24 Comments

This script is useful for getting more search suggestions. It will generate a CSV with many keywords for you to use.

To begin, you will need a simple spreadsheet with only one column called Keywords.

In the settings of the script, input your source spreadsheet URL and the sheet name, which will be used in the final CSV name.

Paste the code into this column and run the script.

JavaScript
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
/* SETTINGS */
 
//Your own copy of our template -
var SPREADSHEET_URL = "";
var SHEET_NAME = "Keywords";
var LANG = "de";
/* ------ */
 
function main(){
 
var output = [];  
var spreadSheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
var sheet = spreadSheet.getSheetByName(SHEET_NAME);
 
var numRows = sheet.getDataRange().getLastRow();
 
  for (var i = 2; i <= numRows; i++ ) {
  keyword = sheet.getRange(i, 1).getValue();
  var response = UrlFetchApp.fetch("http://suggestqueries.google.com/complete/search?&client=chrome&hl="+LANG+"&q="+keyword);
  var json = response.getContentText();  
  var data = JSON.parse(json);
    for (var j = 0; j< data[1].length; j++){
      output.push([data[0],data[1][j]]);
    }
  Utilities.sleep(20);  
  }
doCSV(output,"Suggestions - "+SHEET_NAME+".csv");
 
}
 
function doCSV(input,name) {
var data = input.join("\n");
var file = DriveApp.createFile(name, data);
Logger.log(file.getUrl());
}

 

 

Reader Interactions

Comments

  6. borvestinkral says

    Hello there, I discovered your site via Google whilst looking for a similar subject, your site got here up, it seems good. I’ve bookmarked it in my google bookmarks.

    Reply

  7. borvest inkral says

    Great – I should definitely pronounce, impressed with your site. I had no trouble navigating through all tabs as well as related info ended up being truly simple to do to access. I recently found what I hoped for before you know it in the least. Reasonably unusual. Is likely to appreciate it for those who add forums or something, site theme . a tones way for your client to communicate. Excellent task.

    Reply

  8. borvest inkral says

    I?¦ll right away grasp your rss as I can’t find your e-mail subscription hyperlink or newsletter service. Do you’ve any? Kindly allow me recognize in order that I may just subscribe. Thanks.

    Reply

  11. Tubebuddy says

    Tubebuddy The Tag- and Thumbnail- Generator will bring your video up in the ranking on Youtube, is awesome. Many more tools only for one goal, grow your Channel Much more Subscribers, Views, and Watch time It`s a Free tool, and Very useful plugin for Youtubers.Much more Subscribers, Views, and Watch time on Youtube.Much more Subscribers, Views, and Watch time on Youtube.Much more Subscribers, Views, and Watch time on Youtube.Much more Subscribers, Views, and Watch time on Youtube.FREE FREE FREE FREE FREE.

    Reply

  12. the sims 4 creating kitchen says

    the sims 4 creating kitchenThe Sims 4 is the fourth major title in life simulation video game the sims 4 creating kitchen series The Sims, developed by Maxis the sims 4 creating kitchen and The Sims Studio and published by Electronic Arts. The Sims 4 was originally announced on May 6, 2013, and was released in the sims 4 creating kitchen North America on September 2, 2014 for Hello, Very Nice Site with a lot of Information https://www.youtube.com/watch?v=IBxIRaaVEYE of the sims 4 creating kitchen the sims 4 creating kitchen is very easy to the sims 4 creating kitchen learn much of the Game The Sims 4 create a Kitchen and more. The game has the same concept as its predecessor, The Sims 3; players control their Sims in various activities and can form the sims 4 creating kitchen relationships. The game, like most of the series, does not have a defined final goal; gameplay is nonlinear. The Create-a-Sim and Build Mode tools have been redesigned to allow more versatility when creating game content. Emotional state plays a larger role in game play than in previous games in the series, with effects on social interaction, user interface o date EA has released four expansion packs, with the most recent (Cats & Dogs) being released in November 2017. There have also been several “game packs” released, including Parenthood which allows the players to shape the characters’ children and teenagers as they go through life, as well as free updates that include major changes such as the addition of a toddler life stage. See You the sims 4 creating kitchen

    Reply

  13. Tubebuddy says

    Tubebuddy The Tag- and Tubebuddy Thumbnail- Generator will bring your video up Tubebuddy in the ranking on Youtube, is awesome. Many more tools only for one goal, Tubebuddy grow your Channel Much more Subscribers, Views, and Watch time It`s a Free tool, and Very useful plugin for Youtubers Tubebuddy .Much more Subscribers, Views, and Watch time on Youtube.Much more Subscribers, Views, and Watch time on Youtube.Much more Subscribers, Views, and Watch time Tubebuddy on Youtube.Much more Subscribers, Views, and Watch time on Youtube.FREE Tubebuddy FREE Tubebuddy FREE FREETubebuddy FREE.

    Reply

  23. Jean says

    I as well as my pals happened to be viewing the best key points found on your website then quickly got an awful feeling I had not thanked the site owner for those tips. Those ladies happened to be consequently happy to see them and have quite simply been tapping into them. Appreciation for actually being really thoughtful and also for considering variety of quality themes millions of individuals are really eager to be aware of. My sincere regret for not saying thanks to earlier.

    Reply

  24. free movie download says

    There are amazing improvements on the layout of the website, I certainly enjoy it. My own is dealing with how to watch movies online and generally there are lots of stuff to be done, I’m yet still a beginner in website development. Take care!

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *