function getCompPages() { var mypage = "myurl"; var competitor = "competitor_domain"; var limit = 200; var keylim = 500; var key = "API-TOKEN"; var engine = "SEARCH-ENGINE"; mypage = mypage.replace("/", "%2F"); mypage = mypage.replace("/", "%2F"); mypage = mypage.replace("/", "%2F"); mypage = mypage.replace("/", "%2F"); mypage = mypage.replace("/", "%2F"); mypage = mypage.replace("/", "%2F"); mypage = mypage.replace(":", "%3A"); var pages = new Array(); var jsondat = UrlFetchApp.fetch("http://api.serpstat.com/v3/url_competitors?query="+mypage+"&token="+key+"&page_size="+limit+"&se="+engine); var object = JSON.parse(jsondat.getContentText()); for (var i = 0; i < object["result"]["hits"].length; i++) { var cd = object["result"]["hits"][i]["domain"]; if (competitor==cd) { var ss = pages.length; pages[ss] = new Array(); pages[ss][0] = object["result"]["hits"][i]["url"]; Logger.log("PAGE: "+pages[ss]); pages[ss][0] = pages[ss][0].replace("/", "%2F"); pages[ss][0] = pages[ss][0].replace("/", "%2F"); pages[ss][0] = pages[ss][0].replace("/", "%2F"); pages[ss][0] = pages[ss][0].replace("/", "%2F"); pages[ss][0] = pages[ss][0].replace("/", "%2F"); pages[ss][0] = pages[ss][0].replace("/", "%2F"); pages[ss][0] = pages[ss][0].replace("/", "%2F"); pages[ss][0] = pages[ss][0].replace("/", "%2F"); pages[ss][0] = pages[ss][0].replace(":", "%3A"); pages[ss][0] = pages[ss][0].replace("+", "%2B"); pages[ss][0] = pages[ss][0].replace("+", "%2B"); pages[ss][0] = pages[ss][0].replace("+", "%2B"); pages[ss][0] = pages[ss][0].replace("+", "%2B"); pages[ss][1] = object["result"]["hits"][i]["cnt"]; } } var myWords = new Array(); myWords[0] = new Array(); myWords[1] = new Array(); myWords[2] = new Array(); var jsondat = UrlFetchApp.fetch("http://api.serpstat.com/v3/url_keywords?query="+mypage+"&token="+key+"&page_size="+keylim+"&se="+engine); var object = JSON.parse(jsondat.getContentText()); for (var i = 0; i < object["result"]["hits"].length; i++) { var ss = myWords[0].length; //myWords[ss] = new Array(); myWords[0][ss] = object["result"]["hits"][i]["keyword"]; myWords[1][ss] = object["result"]["hits"][i]["position"]; myWords[2][ss] = object["result"]["hits"][i]["region_queries_count"]; Logger.log("MY KEY: "+myWords[0][ss]+" : "+myWords[1][ss]+" : "+myWords[2][ss]); } var compWords = new Array(); for (var z=0; z-1) { var ps = rez[z].length; rez[z][ps] = new Array(); var mc = myWords[0].indexOf(compWords[z][0][i]); rez[z][ps][0] = compWords[z][0][i]; rez[z][ps][1] = myWords[1][mc]; rez[z][ps][2] = compWords[z][1][i]; rez[z][ps][3] = compWords[z][2][i]; Logger.log("REZ : "+compWords[z][0][i]+" : "+myWords[1][mc]+" : "+compWords[z][1][i]+": "+compWords[z][2][i]); } } } var ot = 0; var rezo = new Array(); for (var i=0; i