😃 AdWords Script for Negative Keyword List Conflicts 😃
– If you’ve been running AdWords accountsfor any period of time,and are using negative keyword lists,you know that sometimesit’s difficult to knowif your negative keyword list conflictswith your actual keywordsthat you’re running on the account. You may accidentally have added somethingthat conflicts, and thenyou’re restricting trafficor throttling trafficthat you actually wanted. Now, if you’re just adding negativesto the account or ad group level,typically, AdWords will notifyyou that there’s a conflict,but we actually don’t reallydo that very often at ParaCore. We use negative lists because we findthat they’re easier to manage, control,apply to multiple accounts,and it just kind of createsa centralized locationfor doing negatives. So, one way to get around that,instead of just hoping thatthings are gonna work out okay,is to use an AdWords script,and the AdWords scriptthat we use is called,sorry, I’m gonna movemy recording here a bit,Negative Keyword Conflicts. This is the single accounts version. I’m gonna link to this inthe description of the video. AdWords actually has a numberof scripts that you can usethat are super helpful. But I’m actually gonna clickon the Manage Your Account version,because that’s what we use,and if you’re an agency,you probably havemultiple accounts running. Now, the way an AdWordsscript works is thatyou basically can snag these scripts,especially if they’re already done. There’s some source code here. This looks like, this is development code,and you have labels andemails and things like that,and I’ll show you that in just a second. And then, you basicallycopy this entire thing here,you copy the entire section in gray,and then you paste itinto your AdWords accountso that you can run the script. So, for example, we only runa couple differentscripts here at ParaCore,and these are the main ones. Now, there might bedifferent scripts runningon an individual account,checking for different things,but these are some of theglobal ones that we run. Now, so here’s thenegative keyword conflicts,the master version. So, if you want to add this script,you would basically copy the entire thing. Not gonna do it right this second. And then, you would hit New. And sometimes, this takes a second,so we’re just going to havea sip of our coffee hereand wait for the script screen to load. However, one way you will need to dois authenticate your accountwith the AdWords main account,so script changes on userbehalf must be authorized,so you might need to dosome sort of authorization. But essentially, what you end up doing is,you take all of this gray, you copy it,and then you just paste it right here,and you do Close, and it’s pretty easy. Now, before you do close,you’re actually going to want toput in some information,some various sentences. So, I’m gonna show you ours. Or, excuse me, you do, yeah, you close,because you’ve already set it. So, for ours,we have a number ofdifferent things that we do. So, when the negative script runs,it actually creates aspreadsheet, and it says,”Hey, we found some conflicts. “Sends you an email notifyingyou of the conflicts,and then lists them allout in the spreadsheet. And if you have 50 or100 AdWords accounts,it lists the account, the campaign,the ad group, thekeyword and the negative,and how they conflict, so you can fix itreally quickly and easily. That’s all done in a Google sheet. So, you need to identify one Google sheetthat’s gonna be the holderof these errors and this information,which is pretty easy to do. You just create one and paste the link in. And then, when that Google sheetis added to your account, thenAdWords is gonna update it andit’s gonna send you an email. So, here’s ours. You can see there’s aGoogle sheet right there,and this, so, you paste yourGoogle spreadsheet right here,and then you do the recipient email. We have this sema@paracore. com email. That is a distribution list, so basically,every account manager atParaCore gets that email. And then, the account label that we useis just Negative_Checker. So, if we bring on an account,or we start an account,whatever the case may be,and we add that account label,the next time that this script runs,it runs every single day,every account that has thatlabel associated with itis then going to check the keywordsversus the negative list,which is what we usebasically exclusively,like I was telling you,and then send an email to, in this case,all of our accountmanagers, letting them know,”Hey, there have beenissues with this account”or not this account. “And it’s awesome, because itupdates you on a regular basis,and you just know if you added something. Literally, within a day,if you added somethingyou shouldn’t have added, you’regonna be notified about it. We have also used this whenwe’re auditing accounts. So, if the client approves it,and they’re open to us doingcertain audit techniques,then we will actually justapply that label to an account. You’re gonna hit the Runbutton right here, run it,and then it’ll also notify usif there are any conflicts. So, this script is pretty amazing. It really protects you,as an AdWords agencyor as an account manager, frommaking any major mistakes. It’ll notify you right awayif you have any issues. So, definitely check it out. As usual, if you enjoy thevideo or find it valuable,please like and subscribe. If you have any comments or questions,please leave those below,and thanks for watching.