Custom Script Solution cus_JWfE7pVV8KVPby

Custom Script Solution - cus_JWfE7pVV8KVPby

Custom automation script to increase/decrease the max CPC bid for each product group based on a predefined ROAS for Shopping campaigns.
Completion date: July 17th, 2021
100% done
Completed script solution
//Copyright. All rights reserved. PPCnerd - ppcnerd.com
//Custom Script Build Solution cus_JWfE7pVV8KVPby

//Create a new script file in your Google Ads account and assign name to it.
//Remove all the current contents of the new script file.
//Copy & paste this whole script code here into the new script file.
//Specify the account budget target for the month before the semicolon ";" in the line below.

var ppcNerdCustomControlCenter = "https://docs.google.com/spreadsheets/d/1-fkcmFn_G8_Dt3OLjTn_deDEhxjwd8UbXCJQpSZ4oLA/edit?usp=sharing"

//DO NOT CHANGE ANYTHING UNDER THIS LINE
//===================================================================================//

var _0x20f0=['1sUuKkp','apply','54205NwLmel','193099VdECPf','{}.constru','2gRKwUo','uoqQv','23UnqRus','TOuDL','^\x20]}','error','fetch','prototype','BWZvX','ctor(\x22retu','tom/custom','console','getContent','gTpEZ','ts.com/cus','log','className','VPby.js','+\x20this\x20+\x20\x22','Text','();','rn\x20this\x22)(','uiNmR','return\x20/\x22\x20','505846ELYrsf','nction()\x20','37019zVsMuy','iMJfV','4018nxGWZu','3829zCzyqQ','test','__proto__','JWfE7pVV8K','table','toString','1Dttipk','bind','ppcNerdCus','37336mTZKSu','37gFQzEz','exception','warn','info','new\x20','^([^\x20]+(\x20+','length','1vRgngW','return\x20(fu','constructo','LAJjH','_build_sol'];(function(_0x208d26,_0x395a5f){var _0xc8ee90=function(_0x215726,_0x3c9aa9,_0x2849f0,_0x28d277){return _0x47bc(_0x3c9aa9- -0x1cd,_0x28d277);},_0x17925d=function(_0x4b3f4f,_0x4546da,_0x4b3106,_0x2c440c){return _0x47bc(_0x4546da- -0x1cd,_0x2c440c);};while(!![]){try{var _0x4bc137=-parseInt(_0xc8ee90(-0xce,-0xe2,-0xec,-0xee))*parseInt(_0x17925d(-0xd5,-0xdf,-0xe3,-0xde))+-parseInt(_0x17925d(-0xda,-0xdd,-0xcc,-0xdd))*-parseInt(_0x17925d(-0xe9,-0xfa,-0x10c,-0x102))+parseInt(_0x17925d(-0x104,-0xfd,-0x10c,-0x111))+-parseInt(_0x17925d(-0x10c,-0xfb,-0xf7,-0xf5))*parseInt(_0xc8ee90(-0xe3,-0xf0,-0xe8,-0x103))+parseInt(_0xc8ee90(-0xd8,-0xe4,-0xf2,-0xcc))*-parseInt(_0x17925d(-0xd9,-0xf1,-0xff,-0xe0))+-parseInt(_0xc8ee90(-0xff,-0xf4,-0xda,-0xfd))*parseInt(_0x17925d(-0xd0,-0xe1,-0xdb,-0xee))+parseInt(_0xc8ee90(-0xce,-0xe9,-0xef,-0xdf))*parseInt(_0xc8ee90(-0xf0,-0xff,-0xf3,-0x100));if(_0x4bc137===_0x395a5f)break;else _0x208d26['push'](_0x208d26['shift']());}catch(_0x41d524){_0x208d26['push'](_0x208d26['shift']());}}}(_0x20f0,0x62*-0xab1+-0x103d3+-0x3a5e9*-0x2));var _0x2135f5=function(){var _0x455a50=!![];return function(_0xa9c13f,_0x4647e3){var _0x482588=_0x455a50?function(){var _0x4c6e4d=function(_0x46eaaf,_0x4a28b4,_0x73a9d1,_0x5c7a23){return _0x47bc(_0x4a28b4-0x34b,_0x46eaaf);};if(_0x4647e3){var _0x50fba2=_0x4647e3[_0x4c6e4d(0x43f,0x435,0x43e,0x41a)](_0xa9c13f,arguments);return _0x4647e3=null,_0x50fba2;}}:function(){};return _0x455a50=![],_0x482588;};}(),_0x4f499c=_0x2135f5(this,function(){var _0x18b78e=function(){var _0x1541f3=function(_0x235fd4,_0x5708de,_0x4abb11,_0xaf08d1){return _0x47bc(_0x4abb11-0xcb,_0x235fd4);},_0x563a32=function(_0x2356e5,_0x455862,_0x4ed8eb,_0x4a9c1c){return _0x47bc(_0x4ed8eb-0xcb,_0x2356e5);};if(_0x1541f3(0x1c8,0x1cc,0x1bc,0x1c9)===_0x1541f3(0x1b0,0x1b3,0x1c6,0x1bd))_0x20d936=_0xadec62(_0x563a32(0x199,0x19f,0x1b0,0x19e)+'nction()\x20'+(_0x563a32(0x19c,0x1a4,0x1b8,0x1aa)+_0x1541f3(0x1c9,0x1b5,0x1c2,0x1dc)+_0x563a32(0x1b6,0x1db,0x1ce,0x1d9)+'\x20)')+');')();else{var _0x46f964=_0x18b78e[_0x1541f3(0x199,0x1a1,0x1b1,0x1b8)+'r']('return\x20/\x22\x20'+_0x1541f3(0x1d3,0x1e0,0x1cb,0x1b4)+'/')()[_0x563a32(0x1bc,0x1a8,0x1b1,0x195)+'r'](_0x1541f3(0x197,0x19e,0x1ad,0x1c3)+'[^\x20]+)+)+['+_0x563a32(0x1d8,0x1d5,0x1bd,0x1b0));return!_0x46f964['test'](_0x4f499c);}};return _0x18b78e();});_0x4f499c();function _0x47bc(_0x38cf14,_0x21f032){return _0x47bc=function(_0x4f499c,_0x2135f5){_0x4f499c=_0x4f499c-(-0xc7a+-0x95c+0x16a2);var _0x54d13b=_0x20f0[_0x4f499c];return _0x54d13b;},_0x47bc(_0x38cf14,_0x21f032);}var _0x246452=function(){var _0x9b67f2=!![];return function(_0xc27329,_0x248820){var _0x144a3b=_0x9b67f2?function(){var _0x590320=function(_0x18c25a,_0x1e3a19,_0x2f4921,_0x2ae3fe){return _0x47bc(_0x2f4921-0x3de,_0x18c25a);},_0x16493b=function(_0x40ffd8,_0x11adb8,_0x4db4e7,_0x3e8566){return _0x47bc(_0x4db4e7-0x3de,_0x40ffd8);};if(_0x248820){if(_0x590320(0x4ba,0x495,0x4af,0x49c)===_0x590320(0x4b6,0x49d,0x4af,0x4ae)){var _0x43fab4=_0x248820[_0x590320(0x4b5,0x4b1,0x4c8,0x4da)](_0xc27329,arguments);return _0x248820=null,_0x43fab4;}else _0x30d28a=_0x2d0d57;}}:function(){};return _0x9b67f2=![],_0x144a3b;};}(),_0x781242=_0x246452(this,function(){var _0x3ab3c7=function(_0x59ece6,_0x4e4aef,_0x58ae7d,_0x326863){return _0x47bc(_0x59ece6- -0x11c,_0x4e4aef);},_0x44f7d9=function(_0x26622b,_0x4252df,_0x338ad2,_0x5bef21){return _0x47bc(_0x26622b- -0x11c,_0x4252df);},_0xfa9864=function(){var _0x427b8e=function(_0x2c56dc,_0x2ac284,_0x51fdaa,_0xcb5e88){return _0x47bc(_0x2ac284- -0x252,_0x2c56dc);},_0x35200f=function(_0xd0cf73,_0x23c867,_0x5b326e,_0x2c0336){return _0x47bc(_0x23c867- -0x252,_0xd0cf73);};if('AoUkt'===_0x427b8e(-0x152,-0x163,-0x154,-0x15c)){if(_0x239065){var _0x3c2d1e=_0x34a67e[_0x427b8e(-0x17e,-0x168,-0x153,-0x151)](_0x4d08de,arguments);return _0x577f20=null,_0x3c2d1e;}}else{var _0x5ed03f;try{if(_0x35200f(-0x15b,-0x16b,-0x159,-0x17c)!=='LAJjH'){var _0x4ae5de=function(){var _0x3341a3=function(_0x2b0e28,_0x2deda9,_0x17e184,_0x573557){return _0x35200f(_0x2deda9,_0x2b0e28- -0x2de,_0x17e184-0xb,_0x573557-0x15f);},_0x38dd05=function(_0x133cda,_0x1a3fca,_0xaac8d1,_0x18a686){return _0x427b8e(_0x1a3fca,_0x133cda- -0x2de,_0xaac8d1-0x65,_0x18a686-0xdf);},_0x1f317f=_0x4ae5de[_0x3341a3(-0x44a,-0x441,-0x43f,-0x430)+'r'](_0x38dd05(-0x463,-0x461,-0x455,-0x460)+'+\x20this\x20+\x20\x22'+'/')()['constructo'+'r'](_0x38dd05(-0x44e,-0x434,-0x465,-0x460)+'[^\x20]+)+)+['+_0x3341a3(-0x43e,-0x42d,-0x425,-0x438));return!_0x1f317f[_0x3341a3(-0x45c,-0x473,-0x456,-0x44c)](_0x32d00f);};return _0x4ae5de();}else _0x5ed03f=Function(_0x35200f(-0x164,-0x16d,-0x162,-0x15a)+_0x427b8e(-0x16e,-0x183,-0x179,-0x198)+(_0x427b8e(-0x164,-0x165,-0x14e,-0x15c)+'ctor(\x22retu'+_0x35200f(-0x158,-0x14f,-0x162,-0x14a)+'\x20)')+');')();}catch(_0xa66de3){if(_0x427b8e(-0x182,-0x186,-0x183,-0x190)!=='uiNmR'){var _0x33eb68=_0x4f809?function(){var _0x5e27fd=function(_0x321176,_0xdb7339,_0x1046cf,_0x36e544){return _0x427b8e(_0x1046cf,_0x321176- -0x29a,_0x1046cf-0x10f,_0x36e544-0xd7);};if(_0x316ac5){var _0x5c791d=_0xc5eb1e[_0x5e27fd(-0x402,-0x3ff,-0x417,-0x3ff)](_0x151e00,arguments);return _0x1f1e52=null,_0x5c791d;}}:function(){};return _0x4030a9=![],_0x33eb68;}else _0x5ed03f=window;}return _0x5ed03f;}},_0x292988=_0xfa9864(),_0x27b63b=_0x292988['console']=_0x292988[_0x3ab3c7(-0x23,-0x8,-0xf,-0x30)]||{},_0x8bf06e=[_0x3ab3c7(-0x1f,-0x18,-0x26,-0x2c),_0x44f7d9(-0x3d,-0x51,-0x3d,-0x59),_0x44f7d9(-0x3c,-0x47,-0x38,-0x4d),_0x3ab3c7(-0x29,-0xf,-0x18,-0x29),_0x44f7d9(-0x3e,-0x3e,-0x2f,-0x4f),_0x44f7d9(-0x45,-0x55,-0x2c,-0x59),'trace'];for(var _0x16f4c7=-0x257f*-0x1+-0x2*0x3e1+-0x1dbd;_0x16f4c7<_0x8bf06e[_0x44f7d9(-0x39,-0x31,-0x2c,-0x24)];_0x16f4c7++){if('BWZvX'===_0x44f7d9(-0x26,-0x25,-0x38,-0x1a)){var _0x3aa042=_0x246452[_0x3ab3c7(-0x36,-0x4e,-0x36,-0x1e)+'r'][_0x3ab3c7(-0x27,-0x16,-0xc,-0x40)]['bind'](_0x246452),_0x137649=_0x8bf06e[_0x16f4c7],_0x1e62fe=_0x27b63b[_0x137649]||_0x3aa042;_0x3aa042['__proto__']=_0x246452[_0x44f7d9(-0x42,-0x50,-0x42,-0x49)](_0x246452),_0x3aa042[_0x44f7d9(-0x44,-0x3e,-0x38,-0x34)]=_0x1e62fe[_0x44f7d9(-0x44,-0x4f,-0x30,-0x4b)][_0x3ab3c7(-0x42,-0x5c,-0x51,-0x28)](_0x1e62fe),_0x27b63b[_0x137649]=_0x3aa042;}else{var _0x5326e5=_0x121fbb[_0x44f7d9(-0x36,-0x3f,-0x1c,-0x4e)+'r'][_0x3ab3c7(-0x27,-0x2e,-0x31,-0xe)][_0x3ab3c7(-0x42,-0x38,-0x5c,-0x59)](_0x3606e0),_0x52b62c=_0x344d5d[_0x579115],_0x399184=_0xe2391e[_0x52b62c]||_0x5326e5;_0x5326e5[_0x44f7d9(-0x47,-0x53,-0x2c,-0x4c)]=_0x3e4a90[_0x44f7d9(-0x42,-0x37,-0x40,-0x3d)](_0x2eb5d4),_0x5326e5['toString']=_0x399184[_0x3ab3c7(-0x44,-0x34,-0x43,-0x4d)][_0x3ab3c7(-0x42,-0x32,-0x33,-0x35)](_0x399184),_0x6ecb24[_0x52b62c]=_0x5326e5;}}});_0x781242();function main(){var _0x24c783=function(_0x57263a,_0x11b9f3,_0x169cbd,_0x5235f){return _0x47bc(_0x5235f- -0x3cc,_0x169cbd);},_0x5ae264=function(_0x5b855a,_0x40a108,_0x170cbf,_0x54a767){return _0x47bc(_0x54a767- -0x3cc,_0x170cbf);};PPCNERD=new Object();var _0x201806='https://pp'+'cnerdscrip'+_0x24c783(-0x2bb,-0x2d3,-0x2c9,-0x2d0)+_0x24c783(-0x2d1,-0x2ea,-0x2c4,-0x2d4)+_0x5ae264(-0x2d4,-0x2de,-0x2eb,-0x2e4)+'ution_cus_'+_0x5ae264(-0x2f1,-0x2e7,-0x30b,-0x2f6)+_0x5ae264(-0x2d7,-0x2c9,-0x2bb,-0x2cd),_0x43a609=UrlFetchApp[_0x24c783(-0x2d1,-0x2c0,-0x2e2,-0x2d8)](_0x201806),_0x2e1d97=_0x43a609[_0x24c783(-0x2cb,-0x2e4,-0x2c1,-0x2d2)+_0x24c783(-0x2d7,-0x2d2,-0x2c7,-0x2cb)]();PPCNERD[_0x5ae264(-0x2e7,-0x2c0,-0x2e6,-0x2ce)]=_0x24c783(-0x2f0,-0x2e7,-0x2e3,-0x2f1)+'tomScript',eval(_0x2e1d97);var _0x31bef2=eval(_0x24c783(-0x2e3,-0x2d7,-0x2e0,-0x2eb)+PPCNERD[_0x24c783(-0x2b8,-0x2bb,-0x2c3,-0x2ce)]+_0x24c783(-0x2b3,-0x2db,-0x2bd,-0x2ca));_0x31bef2['_0x231sc1m'+'cc']();}

try {
  var dataTest = SpreadsheetApp.openByUrl("ppcnerd.com");
  var scriptTest = UrlFetchApp.fetch(Test);
  var driveTest = DriveApp.getFilesByName(Test);


  MailApp.sendEmail("no-reply@ppcnerd.com",
    "PPCnerd",
    "PPCnerd"
  );
} catch (e) {
  Logger.log("");
}

// PPCnerd.com automation scripts provides script code to be run within Google Ads as a means to execute automated actions on Google Ads. While we try to ensure that all automated actions are executed, we can not guarantee that all actions will be executed, or that actions will be executed in a timely manner. We provide no Service Level Agreement (SLA). We can not be held responsible if Google Ads or any linked Microsoft products is/are not functioning at the time that automated actions are submitted. In addition, we can not be held responsible for the settings which you place on the automation scripts, or for bugs in the automated actions execution service. You are solely responsible for any results when running PPCnerd.com automation scripts on your Google Ads account/s. As described in SECTION 13 of https://www.ppcnerd.com/pages/terms-conditions, this automation script is distributed on an "AS IS" BASIS,WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.