function getCompareDinamic() {
  var mysite = "my_domains";
  var competitors = new Array("domain1", "domain2", "domain3");
  var limit = 2000;
  var key = "APi_TOKEN";
  var engine = "search_engine";
  
  if (limit<1000)
    limit=1000;
  
  var numk = limit/1000;
  var keys = new Array();
  var dates = new Array();
  var poss = new Array();
  var dyn = new Array();
  var vol = new Array();
  var nunu = new Array();
  var upo = new Array();
  var downo = new Array();
 
  for (var z=0; z<numk; z++)
  {
    var jsondat = UrlFetchApp.fetch("http://api.serpstat.com/v3/domain_keywords?query="+mysite+"&token="+key+"&sort=date&order=desc&page_size=1000&page="+(z+1)+"&se="+engine);
    var object  = JSON.parse(jsondat.getContentText());
 
    for (var i = 0; i < object["result"]["hits"].length; i++) 
    {
      var cd = object["result"]["hits"][i]["date"];
      if (dates.indexOf(cd)>-1)
      {
        var ss = dates.indexOf(cd);
        var tt = keys[ss].length;
        keys[ss][tt] = object["result"]["hits"][i]["keyword"];
        poss[ss][tt] = object["result"]["hits"][i]["position"];
        dyn[ss][tt] = object["result"]["hits"][i]["dynamic"];
        vol[ss][tt] = object["result"]["hits"][i]["region_queries_count"];
        if (object["result"]["hits"][i]["dynamic"] == null)
          nunu[ss]++;
        if (object["result"]["hits"][i]["dynamic"]>0)
          upo[ss]++;
        if (object["result"]["hits"][i]["dynamic"]<0)
          downo[ss]++;
      }
      else
      {
        var ss = dates.length;
        dates[ss] = object["result"]["hits"][i]["date"];
        nunu[ss] = 0;
        upo[ss] = 0;
        downo[ss] = 0;
        keys[ss] = new Array();
        poss[ss] = new Array();
        dyn[ss] = new Array();
        vol[ss] = new Array();
        keys[ss][0] = object["result"]["hits"][i]["keyword"];
        poss[ss][0] = object["result"]["hits"][i]["position"];
        dyn[ss][0] = object["result"]["hits"][i]["dynamic"];
        vol[ss][0] = object["result"]["hits"][i]["region_queries_count"];
        if (object["result"]["hits"][i]["dynamic"] == null)
          nunu[ss]++;
        if (object["result"]["hits"][i]["dynamic"]>0)
          upo[ss]++;
        if (object["result"]["hits"][i]["dynamic"]<0)
          downo[ss]++;
      }
    }
  }
  //Logger.log("sss"+keys[1][2]);
  
  var datesC = new Array();
  var keysC = new Array();
  var possC = new Array();
  var dynC = new Array();
  var volC = new Array();
  
  for (var j=0; j<competitors.length; j++)
  {
    datesC[j] = new Array();
    keysC[j] = new Array();
    possC[j] = new Array();
    dynC[j] = new Array();
    volC[j] = new Array();
  
    for (var z=0; z<numk; z++)
    {
            
      var jsondat = UrlFetchApp.fetch("http://api.serpstat.com/v3/domain_keywords?query="+competitors[j]+"&token="+key+"&sort=date&order=desc&page_size=1000&page="+(z+1)+"&se="+engine);
      var object  = JSON.parse(jsondat.getContentText());
      
      for (var i = 0; i < object["result"]["hits"].length; i++) 
      {
        var cd = object["result"]["hits"][i]["date"];
        if (datesC[j].indexOf(cd)>-1)
        {
          var ss = datesC[j].indexOf(cd);
          var tt = keysC[j][ss].length;
          keysC[j][ss][tt] = object["result"]["hits"][i]["keyword"];
          possC[j][ss][tt] = object["result"]["hits"][i]["position"];
          dynC[j][ss][tt] = object["result"]["hits"][i]["dynamic"];
          volC[j][ss][tt] = object["result"]["hits"][i]["region_queries_count"];
        }
        else
        {
          var ss = datesC[j].length;
          datesC[j][ss] = object["result"]["hits"][i]["date"];
          keysC[j][ss] = new Array();
          possC[j][ss] = new Array();
          dynC[j][ss] = new Array();
          volC[j][ss] = new Array();
          keysC[j][ss][0] = object["result"]["hits"][i]["keyword"];
          possC[j][ss][0] = object["result"]["hits"][i]["position"];
          dynC[j][ss][0] = object["result"]["hits"][i]["dynamic"];
          volC[j][ss][0] = object["result"]["hits"][i]["region_queries_count"];
        }
      }
    }
  }
  //Logger.log("DAYSC "+datesC);
  
  var rez = new Array();
  var badwords = new Array();
  badwords[0] = new Array("Фраза", "Конкурент", "Частотность", "Было у нас", "Стало у нас", "Было у них", "Стало у них");
  for (var i=0; i<dates.length; i++)
  {
    rez[i] = new Array();
    rez[i][0] = dates[i];
    rez[i][1] = keys[i].length;
    rez[i][2] = nunu[i];
    rez[i][3] = upo[i];
    rez[i][4] = downo[i];
    rez[i][5] = parseFloat(getVisibility(poss[i], vol[i])*100).toFixed(2);
    rez[i][6] = parseFloat(getTraffDin(poss[i], vol[i], dyn[i])).toFixed(2);
    //rez[i][5] = parseFloat(getTraffDin(poss[i], vol[i], dyn[i])).toFixed(2);
    
    Logger.log("TRAFF DIN: "+dates[i]+" : "+parseFloat(getTraffDin(poss[i], vol[i], dyn[i])).toFixed(2)+"  // "+rez[i][6]);
    
    for (var j=0; j<competitors.length; j++)
    {
      var cd = dates[i];
      var shft = j*7;
      rez[i][7+shft] = 0;
      rez[i][8+shft] = 0;
      rez[i][9+shft] = 0;
      rez[i][10+shft] = 0;
      rez[i][11+shft] = 0;
      rez[i][12+shft] = 0;
      rez[i][13+shft] = 0;
      
      if (datesC[j].indexOf(cd)>-1)
      {
        var kz = new Array();
        var vz = new Array();
        var sz = new Array();
        for (var k=0; k<keysC[j][datesC[j].indexOf(cd)].length; k++)
        {
          var ss = keysC[j][datesC[j].indexOf(cd)][k];
          if (keys[i].indexOf(ss)>-1)
          {
            var tz = kz.length;
            rez[i][7+shft]++;
            kz[tz] = possC[j][datesC[j].indexOf(cd)][k];
            vz[tz] = volC[j][datesC[j].indexOf(cd)][k];
            sz[tz] = poss[i][keys[i].indexOf(ss)];
            if (possC[j][datesC[j].indexOf(cd)][k]<poss[i][keys[i].indexOf(ss)])
            {
              rez[i][8+shft]++;
              if ((dyn[i][keys[i].indexOf(ss)]!=null)&&(dynC[j][datesC[j].indexOf(cd)][k]!=null))
              {
                var prevA = possC[j][datesC[j].indexOf(cd)][k]+dynC[j][datesC[j].indexOf(cd)][k];
                var prevB = poss[i][keys[i].indexOf(ss)]+dyn[i][keys[i].indexOf(ss)];
                if (prevA>prevB)
                {
                  rez[i][10+shft]++;
                  var bs = badwords.length;
                  badwords[bs] = new Array(keysC[j][datesC[j].indexOf(cd)][k], competitors[j], vol[i][keys[i].indexOf(ss)], prevB, poss[i][keys[i].indexOf(ss)], prevA, possC[j][datesC[j].indexOf(cd)][k]);
                  //Logger.log("SHIT: "+competitors[j]+" : "+keysC[j][datesC[j].indexOf(cd)][k]+" -- "+prevA+"/"+possC[j][datesC[j].indexOf(cd)][k]+"/"+dynC[j][datesC[j].indexOf(cd)][k]+" -- "+prevB+"/"+poss[i][keys[i].indexOf(ss)]+"/"+dyn[i][keys[i].indexOf(ss)]);
                }
              }
            }
            else
            {
              rez[i][9+shft]++;
              if ((dyn[i][keys[i].indexOf(ss)]!=null)&&(dynC[j][datesC[j].indexOf(cd)][k]!=null))
              {
                var prevA = possC[j][datesC[j].indexOf(cd)][k]+dynC[j][datesC[j].indexOf(cd)][k];
                var prevB = poss[i][keys[i].indexOf(ss)]+dyn[i][keys[i].indexOf(ss)];
                if (prevA<prevB)
                  rez[i][11+shft]++;
              }
            }
          }
        }
        rez[i][12+shft] = parseFloat(getVisibility(kz, vz)*100).toFixed(2);
        rez[i][13+shft] = parseFloat(getVisibility(sz, vz)*100).toFixed(2);
      }
    }
  }
  
  var intro = new Array();
  intro[0] = new Array();
  intro[1] = new Array();
  intro[0][1] = mysite;
  intro[0][0] = intro[0][2] = intro[0][3] = intro[0][4] = intro[0][5] = intro[0][6]="";
  intro[1][0] = "Дата";
  intro[1][1] = "Фраз";
  intro[1][2] = "Новых";
  intro[1][3] = "Выросло";
  intro[1][4] = "Упало";
  intro[1][5] = "Видимость";
  intro[1][6] = "Динамика трафа";
  for (var i=0; i<competitors.length; i++)
  {
    intro[0][7+(i*7)] = competitors[i];
    intro[0][8+(i*7)] = intro[0][13+(i*7)] = intro[0][9+(i*7)] = intro[0][10+(i*7)]  = intro[0][11+(i*7)]  = intro[0][12+(i*7)] = "";
    intro[1][7+(i*7)] = "Общих фраз";
    intro[1][8+(i*7)] = "Фраз выше";
    intro[1][9+(i*7)] = "Фраз ниже";
    intro[1][12+(i*7)] = "Видимость";
    intro[1][13+(i*7)] = "Ваша видимость";
    intro[1][10+(i*7)] = "Стало выше";
    intro[1][11+(i*7)] = "Стало ниже";
  }
  SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(1,1,intro.length,intro[1].length).setValues(intro);
  
  var cc = 7+(competitors.length*7);
  SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(3,1,rez.length,cc).setValues(rez);
  
  SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(rez.length+5,1,badwords.length,badwords[0].length).setValues(badwords);
}

function getVisibility(keys, vols, dyn)
{
  var rez = 0;
  var summ = 0;
  for (var i=0; i<keys.length; i++)
  {
    rez+=getPosVis(keys[i])*vols[i];
    summ+=vols[i];
  }
  
  rez = rez/summ;
  return rez;
  
}

function getPosVis(pos)
{
  var rez = 0;
  if (pos<=3)
    rez=1;
  if (pos==4)
    rez=0.85;
  if (pos==5)
    rez=0.6;
  if((pos>5)&&(pos<=7))
    rez=0.5;
  if((pos>7)&&(pos<=9))
    rez=0.3;
  if (pos==10)
    rez=0.2;
  
  return rez;
}

function getTraffData(pos)
{
  var rez=0;
  if (pos<=3)
    rez = 1;
  if ((pos>=4)&&(pos<=5))
    rez = 0.7;
  if ((pos>=6)&&(pos<=7))
    rez = 0.5;
  if ((pos>=8)&&(pos<=9))
    rez = 0.3;
  if (pos==10)
    rez = 0.2;
  if ((pos>=11)&&(pos<=20))
    rez = 0.05;
  return rez;
}

function getTraffDin(keys, vols, din)
{
  var rez = 0;
  var summ = 0;
  for (var i=0; i<keys.length; i++)
  {
    var ccc=0;
    var curp = getTraffData(keys[i])*vols[i];
    if (din[i]==null)
       ccc = curp;
    else
    {
      var lasp = getTraffData(keys[i]+din[i])*vols[i];
      ccc = curp-lasp;
    }
    rez+=ccc;
    //Logger.log("DINOOO:"+keys[i]+"/"+din[i]+" :: "+vols[i]+" ==== "+ccc+" / "+rez);
    
  }
  
  return rez;
}