{"id":10069,"date":"2019-10-09T18:14:04","date_gmt":"2019-10-09T12:44:04","guid":{"rendered":"https:\/\/www.karooya.com\/blog\/?p=10069"},"modified":"2019-10-09T18:14:04","modified_gmt":"2019-10-09T12:44:04","slug":"ppcchat-all-about-google-ads-scripts-8th-october-2019","status":"publish","type":"post","link":"https:\/\/www.karooya.com\/blog\/ppcchat-all-about-google-ads-scripts-8th-october-2019\/","title":{"rendered":"PPCChat | All About Google Ads Scripts | 8th October 2019"},"content":{"rendered":"

Here is a recap of this week’s PPCChat session, hosted by @ThatSearchGuyNL<\/a> who drew experts attention towards favorite Google Ads scripts, Failure and success while using scripts, How to discover new scripts and more<\/p>\n

<\/p>\n

 <\/p>\n

Q1: Are you using Google Ads\/Bing scripts in your accounts? Why or why not?<\/strong><\/h4>\n

 <\/p>\n

I know that I am not using scripts as often or as well as I could be… Can’t wait to get some ideas and the courage to try them today! @NeptuneMoon<\/a><\/p>\n

We use scripts sparingly, but we\u2019ve begun to use tools like <\/span>@Optmyzr<\/a>\u00a0<\/span>and\u00a0@shape<\/a>\u00a0<\/span>in place of scripts because it\u2019s easier to pay their developers to fix things than us to troubleshoot and manage the scripts. @PPCKirk<\/a><\/p>\n

I’m using scripts to scale my (remote) agency and its performance without scaling headcount. <\/span> I could simply not run my business without them. @ThatSearchGuyNL<\/a><\/span><\/p>\n

Those who don\u2019t code, pay those who do. @PPCKirk<\/a><\/p>\n

100% I am. I once worked at an organization where they though giving me all 62 accounts was a good idea so using scripting to help me pinpoint problem accounts, help with bid adjustments etc was crucial for my sanity. @adwordsgirl<\/a><\/p>\n

yes, because I have to, as a (nearly) one woman show. I use them for reporting and data pulls, and occasional bid adjustments. The biggest hurdle is troubleshooting. I’m not a coder, so if I do something and it doesn’t work, that’s the end of the line for me. @JuliaVyse<\/a><\/p>\n

I am using a few small scripts but need to get way better at them. Been looking forward to this chat for a while! @Mel66<\/a><\/p>\n

Not as often as I want! Excited to learn about best use cases during this chat though. @DarthSamK<\/a><\/p>\n

Using both Google and Bing Scripts. Helps us do more with less people on the team then bigger agencies. @duanebrown<\/a><\/p>\n

I need to be using more of these, but I don’t know where to start learning more about them. This is why is<\/span>\u00a0so helpful. I love learning from the experts here. @RyBen3<\/a><\/span><\/p>\n

Shamefully no, it’s a combo of not believing in my skill set enough to build them, and my belief that I can work around them with self built strats and rules. @JonKagan<\/a><\/span><\/p>\n

I use to be so afraid of scripts but they have been such a time saver for me! @anna_arrow<\/a><\/p>\n

I tried getting into scripts but found it a bit intimid<\/span>ating. @bufoting<\/a><\/span><\/p>\n

 <\/p>\n

Q2: What is your favorite script and why do you like it? Or, if you don’t have any running yet: what would you loooove to have a script do for you?<\/strong><\/h4>\n

 <\/p>\n

That’s a hard one for me. I cannot live without my daily Ad Spend Report and Link Checker. Also, my weekly Declining Ad Groups & Account Performance scripts are a lifesaver. @adwordsgirl<\/a><\/p>\n

The only script I use with any regularity is one that tells me when performance is declining over a 3 week period. Handy. @Mel66<\/a><\/p>\n

Reporting. I HEART the simplicity of sucking all the data out, shoving it into a sheet and pulling it into Data Studio automatically. It helps me visualize and see trends way easier than manual. Plus, I had some fun with an ad copy script a while back. @JuliaVyse<\/a><\/p>\n

I’d love a script that alerts me when conversion tracking stops working. This is probably simple but I’ve not bothered to look for it..@Mel66<\/a><\/p>\n

Not using scripts but I’d love to be able to easily identify individual words or word pairs that are getting volume but not conversions in the search terms report. Have to do that in excel. @CJSlattery<\/a><\/p>\n

I would love something that helped identify queries that I should take a hard look at for possible inclusion in negative lists. @NeptuneMoon<\/a><\/p>\n

My all-time favorite is the broken link checker, because it automates a very important task that is simply impossible to do by hand. @ThatSearchGuyNL<\/a><\/span><\/p>\n

Another one i really like is one i created for one of my clients to automatically exclude placements in GDN that have a high probability of sending fraudulent clicks. Because we all know about the quality of these clicks, right? …@ThatSearchGuyNL<\/a><\/span><\/p>\n

Favorite is the out of stock checker. @ktzstyle<\/a><\/p>\n

I\u2019m not even sure if it\u2019s possible TBH, but I\u2019d love a script\/tool that regularly identifies Exact Match KWs that appear on SERPs where the client dominates organic results + no comp in auction insights so we can exclude the Exact Match terms. @PPCKirk<\/a><\/p>\n

Love N-gram for all our shopping campaigns but even keyword conflict, auction insights and budget overdelivery all help make accounts hum. Wrote about these scripts last year: <\/span>https:\/\/<\/span>takesomerisk.com\/google-scripts-ecommerce-ad-account<\/span>\u2026<\/span><\/a>\u00a0@duanebrown<\/a><\/p>\n

Also did one post just on N-Gram and how we use it on all our eCommerce clients. N-Gram is the script you didn’t know you needed. @duanebrown<\/a><\/p>\n

What is an N-Gram you may be asking? Hell I didn’t know what it was 3 years ago. An n-gram is a phrase made of n words: a 1-gram is a single word, a 2-gram is a phrase made of two words…ect. For example, \u201cthis four word\u201d has two 2-grams (\u201cthis four,\u201d \u201cfour word,\u201d)\u00a0 & one 3-grams (\u201cthis four-word\u201d. Script adds up the clicks, impress, cost, converted clicks and conversion value of each query containing the n-grams. Does the black arts to give you a performance report based on n-grams you request. If you tell the script to find @duanebrown<\/a><\/p>\n

Would love to build a script to automatically filter out ad inappropriate placements on MSAN\/YT\/GDN. @JonKagan<\/a><\/span><\/p>\n

 <\/p>\n

Q3: When thinking about scripts, what benefits are most important to you (please rank with percentages, try to get to 100%) <\/strong><\/h4>\n

A> reduce manual labour <\/strong><\/h4>\n

B> increase account performance <\/strong><\/h4>\n

C> prevent mistakes <\/strong><\/h4>\n

D> other, namely \u2026<\/strong><\/h4>\n

 <\/p>\n

A 50%, B 20%, C 30% @Mel66<\/a><\/p>\n

My breakdown would be A> reduce manual labour 40% B> increase account performance 30% C> prevent mistakes 30% In other words, all of the above, please! @NeptuneMoon<\/a><\/p>\n

It’s nearly 100% about reducing manual labour for me. @JuliaVyse<\/a><\/p>\n

Hard one to rank but this is how I think about it. Scripts help you have an extra hands and eyes in an account. A> reduce manual labour: 30% B> increase account performance: 20% C> prevent mistakes: 40% D> What I can not think of: 10% @duanebrown<\/a><\/p>\n

For me it’s B (40%), A (40%), C (20%) @ThatSearchGuyNL<\/a><\/p>\n

A> Reduce Manual Labour: 40% B> Increase Account Performance: 30% C> Prevent Mistakes: 30% @adwordsgirl<\/a><\/p>\n

Prevent manual labor….@JonKagan<\/a><\/span><\/p>\n

 <\/p>\n

Q4: How do you discover new scripts?<\/strong><\/h4>\n

 <\/p>\n

Following people who specialize in scripts and blog posts. Sometimes it’s just having an issue and looking around for a script that may help. @adwordsgirl<\/a><\/p>\n

With YouTube becoming a bigger play. Plus what will people think of for Discovery Ads. As automation takes over… more N-Gram scripts will pop up to help us manage all that new found data and find interesting trends. @duanebrown<\/a><\/p>\n

Attending conference sessions on the topic, following people who are experts in the area, and of course following. @NeptuneMoon<\/a><\/p>\n

Way back when it was all about <\/span>http:\/\/<\/span>freeadwordsscripts.com<\/a>, now it’s google searches, podcasts, and following people who know their stuff. @JuliaVyse<\/a><\/span><\/p>\n

Even if you can’t attend conferences, the slides are almost always publicly shared and some events offer live feeds so you can “attend” a session from afar! @NeptuneMoon<\/a><\/p>\n

I scour the PPC blogs, forums and do regular Google searches for new ones. @ThatSearchGuyNL<\/a><\/p>\n

[SHAMELESS PLUG] This has resulted in a Google Sheet that i think contains the most extensive list of Google Ad Scripts out there, with over 250 free scripts. You can find it here: <\/span>https:\/\/<\/span>nilsrooijmans.com\/free-google-ads-scripts-the-ultimate-list\/<\/span>\u2026<\/span><\/a>\u00a0@ThatSearchGuyNL<\/a><\/p>\n

Us Redditers on r\/pcc have a cool list of scripts from around the internet. It could use more love to be maintain but another option: <\/span>https:\/\/<\/span>twitter.com\/duanebrown\/status\/988528702580342785<\/span>\u2026<\/span><\/a>\u00a0@duanebrown<\/p>\n

literally learn about them on this thread. @JonKagan<\/a><\/span><\/p>\n

Following industry leaders. Blogs. Conference presentations. Researching for a script to meet a need. @anna_arrow<\/a><\/p>\n

 <\/p>\n

Q5: What has been your biggest WIN using scripts? Or, what are you hoping to get out of it?<\/strong><\/h4>\n

 <\/p>\n

My biggest wins are reducing a looot of wasted ad spend by using scripts to alert me on things like: low conversion rate search terms\/n-grams, sudden drops in ROAS, monitoring Search Partner performance, automatically negating irrelevant close variants. @ThatSearchGuyNL<\/a><\/p>\n

Rebuilding search campaigns in less time based on tons of shopping data and seeing performance change faster. That is the power of n-gram. I doubled an ad accounts CR inside of 30 days with this script. @duanebrown<\/a><\/p>\n

In my very limited experience, scripts have alerted me to performance issues in my accounts. @Mel66<\/a><\/p>\n

1. weather-based bidding. It made a WILD difference for a local plumbing client who suddenly would have to call me to turn off ads when they had too much business. 2. a colleague built an ad copy builder for a car dealership that was bonkers good. @JuliaVyse<\/a><\/p>\n

I also use scripts to monitor the impact of Google pushing it’s AI upon us. The AI is great, but definitely always improving performance. You can hear me speak about this topic (incl slides) : <\/span>https:\/\/<\/span>greatdayevent.com\/2019\/talks\/rooijmans\/<\/span>\u2026<\/span><\/a> @ThatSearchGuyNL<\/a><\/p>\n

I really think that’d be finding broken links before clients remember to tell me that they may have changed the LP URL. @adwordsgirl<\/a><\/p>\n

To get that smug jerk “carl” to shut up because he thinks his scripts help in pace better…you know who you are “carl” @JonKagan<\/a><\/span><\/p>\n

In general, love anything that can auto-flag issues that aren’t brought to light by default. Dead URLs, negative conflicts, etc. Second, getting stricter budget controls. @timothyjjensen<\/a><\/p>\n

 <\/p>\n

Q6: What is your biggest FRUSTRATION with scripts?<\/strong><\/h4>\n

 <\/p>\n

Love the many free resources I can copy and paste from but would also love to get to the point where I’m knowledgeable enough to write some myself. Barrier is setting aside the time. @timothyjjensen<\/a><\/p>\n

That I haven’t used them and that I now feel like I am terrible at my job. @CJSlattery<\/a><\/p>\n

So, sometimes getting a script I thought would be useful but really wasn’t to stop running has been a challenge… @NeptuneMoon<\/a><\/p>\n

My script frustrations: – Not all operations you can do in the interface are supported by scripts. Ie we had to wait years to get support for price extensions – 30 min execution limit can be a PITA sometimes – No version control in the Google IDE. @ThatSearchGuyNL<\/a><\/span><\/p>\n

Breaking something in my account. Troubleshooting when I don’t understand the script language. Competing scripts cannibalizing each other. @JuliaVyse<\/a><\/p>\n

Still troubleshooting. If one tiny piece doesn’t work, there’s nothing I can do. That and accidental overspends, but that’s a risk with any tool. @JuliaVyse<\/a><\/p>\n

They don’t always work if you don’t have data or if you are me,… so jazzed to use it that I don’t slow down and fill out all the required fields. @duanebrown<\/a><\/p>\n

Hands down, troubleshooting. Sometimes the fixes are simple and sometimes I want to walk into a brick wall. @adwordsgirl<\/a><\/p>\n

So, sometimes getting a script I thought would be useful but really wasn’t to stop running has been a challenge… @NeptuneMoon<\/a><\/p>\n

I heard someone say that Facebook will get scripts. That was amazing to hear….don’t know if it’s true of course. @duanebrown<\/a><\/p>\n

H<\/span>aving to make them. If enough people are making these, then the engines need to make them a real function. @JonKagan<\/a><\/span><\/p>\n

 <\/p>\n

Q7: Before you started using scripts, what was the main thing keeping you from it? Or, what is keeping you from using scripts right now?<\/strong><\/h4>\n

 <\/p>\n

It’s always been a concern that it requires heavy programming knowledge to use. My CS background ended in high school. @CJSlattery<\/a><\/p>\n

Thought you had to be a coder and that is not the case. Took me 4 tries to get my first script going in 2013 and I never looked back. It was a negative keyword conflict one. Small details matter in making scripts work. @duanebrown<\/a><\/p>\n

Coding and troubleshooting. I’m just out here on an island all alone, and not all the great folx on <\/span>#ppcchat<\/a><\/span> are NDA’d to look at my accounts if I need help @JuliaVyse<\/a><\/span><\/p>\n

Main roadblock for me is if I start the process and then it doesn’t work. There are lots of instructions on how to set it up (though they could also be dumbed down…) but not much on what to do if you followed the instructions & it doesn’t work. @NeptuneMoon<\/a><\/p>\n

Time. I was always busy managing my clients\u2019 accounts. That was until I realized I could actually use scripts to create time to develop more scripts to save more time and increase performance. @ThatSearchGuyNL<\/a><\/p>\n

Lack of knowledge as mentioned before. Also, we have 3rd party tools that do a lot of the same things that scripts do. And troubleshooting as mentioned before. If it doesn’t work, I’m stuck. @Mel66<\/a><\/p>\n

At that time, I was still new to everything and didn’t really know the power they had. A developer mentioned it to me and it changed my professional life (maybe my personal life a little haha). @adwordsgirl<\/a><\/p>\n

The creation part was just to damn intimidating. @JonKagan<\/a><\/span><\/p>\n

 <\/p>\n

Q8: If you are already using scripts, what advice would you give others with zero scripting experience to get started?<\/strong><\/h4>\n

 <\/p>\n

Find a simple script someone else has made, add it to your account, and start playing with it! Best way to learn is by doing. Preview results before running it to make sure it’s working as expected. @timothyjjensen<\/a><\/p>\n

Don\u2019t be afraid to start experimenting and get a feel for the potentialn of Google Ads Scripts … @ThatSearchGuyNL<\/a><\/span><\/p>\n

Via the Preview option you can run scripts and see what they do without the script changing anything in your account. That way you can be sure the script does no harm and you can start experimenting without any risk. It\u2019s literally as simple as copy-paste. @ThatSearchGuyNL<\/a><\/p>\n

Also, stick with scripts that send alerts or populate data in spreadsheets vs. actually making changes in the account, to start. That way you have less risk of unanticipated changes in account right off. @timothyjjensen<\/a><\/p>\n

A service to set up scripts and troubleshoots when the break. Price it for consultants or small agencies. @NeptuneMoon<\/a><\/p>\n

 <\/p>\n

PPCChat Participants:<\/strong><\/p>\n