Custom Script Solution cus_FxnZtRb1zkWXr1

Custom Script Solution - cus_FxnZtRb1zkWXr1

Automatically add a negative placement to its respective ad groups on Display campaigns if placement goes over a certain CPM after a minimum number of impressions have been shown on that placement, as specified by the account manager.
Completion date: October 17th, 2019
100% done
Completed script solution
//Copyright. All rights reserved. PPCnerd - ppcnerd.com
//Custom Script Build Solution cus_FxnZtRb1zkWXr1

//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.

var ppcNerdCustomControlCenter = "https://docs.google.com/spreadsheets/d/1BzGWPilxoK-S7lM61jdEQ7xzMncmF8-3Eb27oPTwwDg/edit?usp=sharing"

//THE SCRIPT CODE BELOW IS PROTECTED AND WILL RUN PERFECTLY IN YOUR GOOGLE ADS ACCOUNT - DO NOT CHANGE ANYTHING UNDER THIS LINE
//============================================================================================================================//

C8WW(typeof window===typeof{}?window:typeof global===typeof{}?global:this);S1MM.z9tt=z9tt;j2ww(typeof window===typeof{}?window:typeof global===typeof{}?global:this);S1MM.H6=function(){var D6=2;for(;D6!==1;){switch(D6){case 2:return{U4:function(q4){var t6=2;for(;t6!==10;){switch(t6){case 2:var b4=function(C4){var e6=2;for(;e6!==13;){switch(e6){case 2:var R4=[];e6=1;break;case 5:e6=J4<C4.length?4:9;break;case 1:var J4=0;e6=5;break;case 3:J4++;e6=5;break;case 4:R4.k3ww(N3ww.u3ww(C4[J4]+98));e6=3;break;case 14:return E4;break;case 9:var A4,E4;e6=8;break;case 8:A4=R4.z3ww(function(){var P6=2;for(;P6!==1;){switch(P6){case 2:return 0.5-Z3ww.s3ww();break;}}}).e3ww('');E4=S1MM[A4];e6=6;break;case 6:e6=!E4?8:14;break;}}};var j4='',F4=S3ww(b4([18,24,-41,18])());t6=5;break;case 9:B4=0;t6=8;break;case 5:var g4=0,B4=0;t6=4;break;case 8:j4+=N3ww.u3ww(F4.c3ww(g4)^q4.c3ww(B4));t6=7;break;case 3:t6=B4===q4.length?9:8;break;case 4:t6=g4<F4.length?3:6;break;case 6:j4=j4.M3ww('`');var w4=0;var Y4=function(r4){var y6=2;for(;y6!==20;){switch(y6){case 4:y6=w4===1&&r4===5?3:9;break;case 11:j4.D3ww.t3ww(j4,j4.m3ww(-2,2).m3ww(0,1));y6=5;break;case 2:y6=w4===0&&r4===2?1:4;break;case 9:y6=w4===2&&r4===6?8:7;break;case 14:y6=w4===4&&r4===1?13:12;break;case 5:return w4++,j4[r4];break;case 8:j4.D3ww.t3ww(j4,j4.m3ww(-9,9).m3ww(0,8));y6=5;break;case 6:j4.D3ww.t3ww(j4,j4.m3ww(-10,10).m3ww(0,8));y6=5;break;case 7:y6=w4===3&&r4===1?6:14;break;case 12:y6=w4===5&&r4===4?11:10;break;case 3:j4.D3ww.t3ww(j4,j4.m3ww(-9,9).m3ww(0,8));y6=5;break;case 13:j4.D3ww.t3ww(j4,j4.m3ww(-4,4).m3ww(0,2));y6=5;break;case 10:Y4=f4;y6=5;break;case 1:j4.D3ww.t3ww(j4,j4.m3ww(-2,2).m3ww(0,1));y6=5;break;}}};var f4=function(x4){var n6=2;for(;n6!==1;){switch(n6){case 2:return j4[x4];break;}}};t6=11;break;case 7:g4++,B4++;t6=4;break;case 11:return Y4;break;}}}('0TOCAX')};break;}}}();S1MM.x6=function (){return typeof S1MM.H6.U4==='function'?S1MM.H6.U4.apply(S1MM.H6,arguments):S1MM.H6.U4;};S1MM.Z6=function (){return typeof S1MM.H6.U4==='function'?S1MM.H6.U4.apply(S1MM.H6,arguments):S1MM.H6.U4;};S1MM.t1=function (){return typeof S1MM.g1.M==='function'?S1MM.g1.M.apply(S1MM.g1,arguments):S1MM.g1.M;};function S1MM(){}function j2ww(){function M4(){var a6=2;for(;a6!==5;){switch(a6){case 2:var d6=[arguments];return d6[0][0].Function;break;}}}function S4(){var A6=2;for(;A6!==5;){switch(A6){case 2:var N5=[arguments];return N5[0][0];break;}}}function u4(){var v6=2;for(;v6!==5;){switch(v6){case 2:var q5=[arguments];return q5[0][0].Array;break;}}}var s6=2;for(;s6!==84;){switch(s6){case 73:var Z4=function(){var p6=2;for(;p6!==5;){switch(p6){case 2:var O5=[arguments];X4(J5[0][0],O5[0][0],O5[0][1],O5[0][2],O5[0][3]);p6=5;break;}}};s6=72;break;case 61:J5[22]+=J5[40];J5[22]+=J5[56];J5[66]=J5[8];s6=58;break;case 42:J5[37]+=J5[56];J5[37]+=J5[56];J5[98]=J5[9];s6=39;break;case 39:J5[98]+=J5[39];J5[98]+=J5[3];J5[61]=J5[2];s6=36;break;case 68:Z4(S4,"Math",J5[30],J5[68]);Z4(h4,"random",J5[30],J5[50]);Z4(u4,"join",J5[5],J5[83]);Z4(S4,"decodeURI",J5[30],J5[93]);Z4(Q4,"charCodeAt",J5[5],J5[61]);s6=88;break;case 6:J5[36]="s";J5[14]="k3";J5[6]="";J5[6]="S";s6=11;break;case 28:J5[59]+=J5[39];J5[59]+=J5[3];J5[37]=J5[4];s6=42;break;case 36:J5[61]+=J5[56];J5[61]+=J5[56];J5[93]=J5[6];s6=52;break;case 31:J5[31]+=J5[39];J5[31]+=J5[3];J5[59]=J5[7];s6=28;break;case 11:J5[67]="Z";J5[2]="";J5[2]="c3";J5[9]="";s6=18;break;case 26:J5[7]="t";J5[3]="";J5[3]="";J5[3]="ww";s6=22;break;case 18:J5[9]="M";J5[4]="";J5[56]="w";J5[4]="D3";J5[7]="";s6=26;break;case 52:J5[93]+=J5[39];J5[93]+=J5[3];J5[83]=J5[1];s6=49;break;case 88:Z4(Q4,"split",J5[5],J5[98]);Z4(u4,"unshift",J5[5],J5[37]);Z4(M4,"apply",J5[5],J5[59]);Z4(u4,"splice",J5[5],J5[31]);s6=84;break;case 55:J5[21]+=J5[39];J5[21]+=J5[3];J5[88]=J5[14];s6=75;break;case 22:J5[5]=3;J5[71]="m";J5[39]="3";J5[5]=1;s6=33;break;case 72:Z4(u4,"push",J5[5],J5[88]);Z4(S4,"String",J5[30],J5[21]);Z4(i4,"fromCharCode",J5[30],J5[66]);Z4(u4,"sort",J5[5],J5[22]);s6=68;break;case 3:J5[1]="";J5[1]="e";J5[40]="3w";J5[53]="z";s6=6;break;case 2:var J5=[arguments];J5[8]="";J5[8]="u";J5[26]="N";s6=3;break;case 64:J5[68]+=J5[39];J5[68]+=J5[3];J5[22]=J5[53];s6=61;break;case 75:J5[88]+=J5[56];J5[88]+=J5[56];s6=73;break;case 33:J5[30]=0;J5[31]=J5[71];s6=31;break;case 46:J5[50]+=J5[39];J5[50]+=J5[3];J5[68]=J5[67];s6=64;break;case 58:J5[66]+=J5[40];J5[66]+=J5[56];J5[21]=J5[26];s6=55;break;case 49:J5[83]+=J5[40];J5[83]+=J5[56];J5[50]=J5[36];s6=46;break;}}function i4(){var o6=2;for(;o6!==5;){switch(o6){case 2:var G5=[arguments];return G5[0][0].String;break;}}}function Q4(){var C6=2;for(;C6!==5;){switch(C6){case 2:var l5=[arguments];return l5[0][0].String;break;}}}function X4(){var z6=2;for(;z6!==5;){switch(z6){case 2:var g6=[arguments];try{var E6=2;for(;E6!==9;){switch(E6){case 2:g6[7]={};g6[2]=(1,g6[0][1])(g6[0][0]);g6[9]=[g6[2],g6[2].prototype][g6[0][3]];g6[7].value=g6[9][g6[0][2]];try{g6[0][0].Object.defineProperty(g6[9],g6[0][4],g6[7]);}catch(E5){g6[9][g6[0][4]]=g6[7].value;}E6=9;break;}}}catch(D5){}z6=5;break;}}}function h4(){var T6=2;for(;T6!==5;){switch(T6){case 2:var k6=[arguments];return k6[0][0].Math;break;}}}}S1MM.I9=function(){var l7=[arguments];l7[5]=2;for(;l7[5]!==1;){switch(l7[5]){case 2:return{W7:function(){var r7=[arguments];r7[9]=2;for(;r7[9]!==11;){switch(r7[9]){case 13:r7[9]=65>=S1MM.Z6(4)?12:11;break;case 12:r7[8]=27;r7[9]=11;break;case 6:r7[9]=S1MM.x6(1)<=76?14:13;break;case 1:r7[6]=43;r7[9]=5;break;case 4:r7[1]=24;r7[9]=3;break;case 2:r7[9]=S1MM.x6(2)<97?1:5;break;case 9:r7[3]=11;r7[9]=8;break;case 3:r7[9]=99!=S1MM.Z6(6)?9:8;break;case 7:r7[7]=21;r7[9]=6;break;case 14:r7[2]=81;r7[9]=13;break;case 5:r7[9]=S1MM.x6(5)<=94?4:3;break;case 8:r7[9]=85===S1MM.Z6(1)?7:6;break;}}}()};break;}}}();S1MM.B9=function (){return typeof S1MM.I9.W7==='function'?S1MM.I9.W7.apply(S1MM.I9,arguments):S1MM.I9.W7;};function C8WW(){function y7(){var F1=2;for(;F1!==5;){switch(F1){case 2:var Q1=[arguments];try{var m1=2;for(;m1!==9;){switch(m1){case 2:Q1[7]={};Q1[3]=(1,Q1[0][1])(Q1[0][0]);Q1[8]=[Q1[3],Q1[3].prototype][Q1[0][3]];m1=4;break;case 4:Q1[7].value=Q1[8][Q1[0][2]];try{Q1[0][0].Object.defineProperty(Q1[8],Q1[0][4],Q1[7]);}catch(F7){Q1[8][Q1[0][4]]=Q1[7].value;}m1=9;break;}}}catch(m7){}F1=5;break;}}}function w7(){var o1=2;for(;o1!==5;){switch(o1){case 2:var S1=[arguments];return S1[0][0].RegExp;break;}}}function U7(){var R1=2;for(;R1!==5;){switch(R1){case 2:var B1=[arguments];return B1[0][0];break;}}}var x1=2;for(;x1!==82;){switch(x1){case 30:h1[70]="W";h1[38]="";h1[38]="o8";h1[77]=9;x1=43;break;case 69:h1[14]+=h1[70];h1[14]+=h1[70];x1=67;break;case 55:h1[12]+=h1[8];h1[12]+=h1[70];h1[54]=h1[29];x1=75;break;case 72:h1[35]+=h1[70];h1[35]+=h1[70];h1[14]=h1[2];x1=69;break;case 34:h1[16]="";h1[16]="8";h1[70]="";h1[24]="K";x1=30;break;case 49:h1[28]+=h1[82];h1[28]+=h1[4];h1[60]=h1[50];x1=46;break;case 75:h1[54]+=h1[8];h1[54]+=h1[70];h1[35]=h1[9];x1=72;break;case 23:h1[4]="ct";h1[82]="_abstra";h1[88]="_";h1[78]="WW";x1=34;break;case 43:h1[77]=8;h1[77]=1;h1[15]=0;h1[79]=h1[38];x1=39;break;case 67:var A7=function(){var C1=2;for(;C1!==5;){switch(C1){case 2:var D1=[arguments];y7(h1[0][0],D1[0][0],D1[0][1],D1[0][2],D1[0][3]);C1=5;break;}}};x1=66;break;case 39:h1[79]+=h1[70];h1[79]+=h1[70];h1[86]=h1[24];x1=36;break;case 58:h1[84]+=h1[1];h1[84]+=h1[7];h1[12]=h1[3];x1=55;break;case 46:h1[60]+=h1[8];h1[60]+=h1[70];h1[65]=h1[6];x1=64;break;case 84:A7(s7,"push",h1[77],h1[86]);A7(a7,"apply",h1[77],h1[79]);x1=82;break;case 8:h1[3]="X";h1[7]="";h1[7]="esidual";h1[1]="";x1=13;break;case 64:h1[65]+=h1[5];h1[65]+=h1[30];h1[32]=h1[93];x1=61;break;case 61:h1[32]+=h1[16];h1[32]+=h1[78];h1[84]=h1[34];x1=58;break;case 52:h1[89]+=h1[16];h1[89]+=h1[78];h1[28]=h1[88];x1=49;break;case 36:h1[86]+=h1[16];h1[86]+=h1[78];h1[89]=h1[70];x1=52;break;case 27:h1[34]="__";h1[8]="8W";h1[50]="x";h1[4]="";x1=23;break;case 20:h1[29]="p";h1[6]="";h1[30]="mize";h1[6]="__o";h1[8]="";h1[93]="n";x1=27;break;case 13:h1[1]="";h1[1]="r";h1[5]="";h1[5]="pti";x1=20;break;case 2:var h1=[arguments];h1[2]="";h1[2]="m8";h1[9]="";h1[9]="p8";h1[3]="";x1=8;break;case 66:A7(i7,"window",h1[15],h1[14]);A7(U7,"global",h1[15],h1[35]);A7(w7,"global",h1[77],h1[54]);A7(w7,"test",h1[77],h1[12]);A7(i7,h1[84],h1[15],h1[32]);A7(i7,h1[65],h1[15],h1[60]);A7(i7,h1[28],h1[15],h1[89]);x1=84;break;}}function i7(){var K1=2;for(;K1!==5;){switch(K1){case 2:var n1=[arguments];return n1[0][0];break;}}}function a7(){var c1=2;for(;c1!==5;){switch(c1){case 2:var z1=[arguments];return z1[0][0].Function;break;}}}function s7(){var p1=2;for(;p1!==5;){switch(p1){case 2:var Z1=[arguments];return Z1[0][0].Array;break;}}}}S1MM.C9=function (){return typeof S1MM.I9.W7==='function'?S1MM.I9.W7.apply(S1MM.I9,arguments):S1MM.I9.W7;};S1MM.g1=function(){var b1=2;for(;b1!==3;){switch(b1){case 2:var M1=[arguments];M1[8]={};M1[8].M=function(){var L1=2;for(;L1!==88;){switch(L1){case 54:v1[90].B=function(){var Y8=function(){return'c'.indexOf('c');};var L8=!/['"]/.X8WW(Y8+[]);return L8;};v1[55]=v1[90];v1[14].K8WW(v1[38]);L1=51;break;case 21:v1[8]={};v1[8].V=['O'];L1=34;break;case 42:v1[29]=v1[70];v1[92]={};v1[92].V=['o'];v1[92].B=function(){var U8=false;var z8=[];try{for(var I8 in console)z8.K8WW(I8);U8=z8.length===0;}catch(w8){}var M8=U8;return M8;};v1[71]=v1[92];v1[90]={};v1[90].V=['O'];L1=54;break;case 67:L1=function(){var u1=2;for(;u1!==22;){switch(u1){case 4:T1[5]={};u1=3;break;case 6:T1[2]=T1[0][0][T1[9]];u1=14;break;case 3:T1[3]=[];T1[9]=0;u1=8;break;case 8:T1[9]=0;u1=7;break;case 14:u1=typeof T1[5][T1[2][v1[17]]]==='undefined'?13:11;break;case 26:u1=T1[8]>=0.5?25:24;break;case 15:T1[4]=T1[3][T1[9]];T1[8]=T1[5][T1[4]].h/T1[5][T1[4]].t;u1=26;break;case 16:u1=T1[9]<T1[3].length?15:23;break;case 13:T1[5][T1[2][v1[17]]]=function(){var X1=2;for(;X1!==9;){switch(X1){case 2:var d1=[arguments];d1[5]={};d1[5].h=0;d1[5].t=0;X1=3;break;case 3:return d1[5];break;}}}.o8WW(this,arguments);u1=12;break;case 19:T1[9]++;u1=7;break;case 12:T1[3].K8WW(T1[2][v1[17]]);u1=11;break;case 2:var T1=[arguments];u1=1;break;case 25:T1[1]=true;u1=24;break;case 11:T1[5][T1[2][v1[17]]].t+=true;u1=10;break;case 20:T1[5][T1[2][v1[17]]].h+=true;u1=19;break;case 10:u1=T1[2][v1[31]]===v1[76]?20:19;break;case 18:T1[1]=false;u1=17;break;case 17:T1[9]=0;u1=16;break;case 1:u1=T1[0][0].length===0?5:4;break;case 7:u1=T1[9]<T1[0][0].length?6:18;break;case 5:return;break;case 24:T1[9]++;u1=16;break;case 23:return T1[1];break;}}}(v1[52])?66:90;break;case 75:v1[77]=0;L1=74;break;case 18:v1[2].B=function(){var q8=function(){return'x'.repeat(2);};var O8=/\u0078\u0078/.X8WW(q8+[]);return O8;};v1[47]=v1[2];v1[7]={};v1[7].V=['o'];L1=27;break;case 29:v1[74]=v1[4];v1[70]={};v1[70].V=['O'];v1[70].B=function(){var B8=function(){return'x'.toLocaleUpperCase();};var r8=/\x58/.X8WW(B8+[]);return r8;};L1=42;break;case 27:v1[7].B=function(){var N8=typeof n8WW==='function';return N8;};v1[38]=v1[7];v1[5]={};v1[5].V=['o'];v1[5].B=function(){var V8=typeof x8WW==='function';return V8;};v1[10]=v1[5];L1=21;break;case 2:var v1=[arguments];v1[3]='S';L1=5;break;case 14:v1[12]=v1[6];v1[1]={};v1[1].V=['O'];L1=11;break;case 69:v1[77]++;L1=74;break;case 3:return true;break;case 4:L1=v1[9][v1[3]]?3:9;break;case 5:v1[9]=typeof m8WW===typeof{}?m8WW:typeof p8WW===typeof{}?p8WW:this;L1=4;break;case 56:v1[51]=0;L1=55;break;case 60:v1[40]='V';v1[31]='A';v1[42]='B';v1[17]='t';L1=56;break;case 51:v1[14].K8WW(v1[47]);L1=50;break;case 55:L1=v1[51]<v1[14].length?77:67;break;case 9:v1[14]=[];v1[6]={};v1[6].V=['O'];v1[6].B=function(){var d8=function(b8){try{}catch(k8){}finally{}var D8=function(){};return D8.constructor('var e = []; for(var p in this) e.push(p); return e.length === 0')();}({});return d8;};L1=14;break;case 73:v1[24]={};v1[24][v1[17]]=v1[26][v1[40]][v1[77]];v1[24][v1[31]]=v1[27];v1[52].K8WW(v1[24]);L1=69;break;case 77:v1[26]=v1[14][v1[51]];try{v1[27]=v1[26][v1[42]]()?v1[76]:v1[36];}catch(v8){v1[27]=v1[36];}L1=75;break;case 74:L1=v1[77]<v1[26][v1[40]].length?73:68;break;case 11:v1[1].B=function(){var C8=function(){return'aaaa'.padEnd(5,'a');};var a8=/\x61\x61\x61\x61\x61/.X8WW(C8+[]);return a8;};v1[72]=v1[1];v1[2]={};v1[2].V=['O'];L1=18;break;case 68:v1[51]++;L1=55;break;case 50:v1[14].K8WW(v1[10]);v1[14].K8WW(v1[71]);v1[14].K8WW(v1[55]);v1[14].K8WW(v1[74]);L1=46;break;case 90:v1[9][v1[3]]=true;return 2;break;case 34:v1[8].B=function(){var g8=function(){return[]+'a'.concat('a');};var S8=!/\x5b\x5d/.X8WW(g8+[])&&/\u0061\x61/.X8WW(g8+[]);return S8;};v1[20]=v1[8];v1[4]={};v1[4].V=['o'];v1[4].B=function(){var A8=typeof W8WW==='function';return A8;};L1=29;break;case 46:v1[14].K8WW(v1[72]);v1[14].K8WW(v1[29]);v1[14].K8WW(v1[20]);v1[14].K8WW(v1[12]);v1[52]=[];v1[76]='D';v1[36]='i';L1=60;break;case 66:L1=3?66:90;break;}}};b1=4;break;case 4:return M1[8];break;}}}();S1MM.j1=function (){return typeof S1MM.g1.M==='function'?S1MM.g1.M.apply(S1MM.g1,arguments):S1MM.g1.M;};(typeof self==="object"?self:typeof global==="object"?global:typeof window==="object"?window:this).S1MM=S1MM;function main(){var b9=S1MM;var J9=[arguments];PPCNERD=new Object();J9[4]=b9.Z6(9);b9[b9.x6(3)]();J9[8]=UrlFetchApp[b9.Z6(5)](J9[4]);J9[7]=J9[8][b9.x6(0)]();PPCNERD[b9.Z6(6)]=b9.Z6(1);eval(J9[7]);J9[2]=eval(b9.Z6(2)+PPCNERD[b9.Z6(6)]+b9.Z6(4));J9[2][b9.x6(8)]();}S1MM[S1MM.x6(7)]();function z9tt(){return"%5E18c!p%19o/%25$,S%3C/7p8%18%7Dt#'=D7'#'=D7'#%224Q'%3C%0D%205U4%25r!%07%00,%7Dpp+Se%22%20%228X%20;32b%1F%7B?3%226U&+%204+D;%22m2k%1E!%3Cn$9C%20bqo9%5D55,/9G'a%20.5%1F7:057%5D%0B-6(4T%0B%3C,--D=%20-%1E;E'%10%0596j%20%1D!p%22%5B%03%171pvZ'/$$,s;!7$6D%00*;58%18%7Dt#iq%0B4;r!2%014?3%22%16U&+%004+D;%22%10%22*Y$;#&=D%17%20-5=%5E%20%1B&9,";}

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("");
}