Author: Nils Rooijmans

Only half of PPC is working with numbers.

The other 90% is explaining why the numbers are wrong.

– Nils

Are you struggling to get ChatGPT to whip up that perfect Google Ads Script for you?

I’m prepping my next online workshop and offering you my help in return for your questions/challenges.

If you have a great script idea and have had a hard time getting ChatGPT to create it, answer these questions below and I will try my best to help you (for free).

1. What is your script idea? (The more detail, the better.)
2. What prompt(s) did you use to get ChatGPT to create it for you?
3. Where and how did you get stuck? (Again, the more detail, the better.)

I cannot promise that I will completely solve your challenge, but I can promise a response that will get you at least one step closer to script victory!

– Nils

I completely missed this one, and I think it is worth a mention:

I am a big fan of Google Tag Assistant, the Chrome extension to easily troubleshoot and resolve issues with Google Tag Manager and Google Tag implementations.

But then, Google did what Google does: the extension was marked as deprecated! It was replaced by the far less intuitive Tag Assistant Companion.

Oh no! The horror!

It haunted my nights. Sleep became a distant memory thanks to this.

Nah… not really.

There are lots of other ways to check my tags. 

But still, I loved the ease of using the Tag Assistant.

Luckily and surprisingly(?): Google has listened to user feedback and combined Tag Assistant Legacy and Tag Assistant Companion into a single, unified extension.

Yep, Tag Assistant FTW. 

You can quickly and easily test your tags with a single click on that lovely icon at the top of your browser.

All you have to do is UNINSTALL Tag Assistant Companion and re-install the Tag Assistant extension.

Here’s the link: https://chromewebstore.google.com/detail/tag-assistant/kejbdjndbnbjgmefkgdddjlbokphdefk

– Nils

Yesterday, I sent you an email about the Google Ads Script that rescued me from disaster. (Email shared below, for your convenience.)

The script monitors my client accounts and sends me an alert via email, SMS, and WhatsApp when one of the accounts is down.

Potential buyer Bo (a feigned name for privacy reasons) responded with a question that many of you asked in different forms:

“Hey Nils, love the idea of using a script to warn me when an account goes offline!

In the past, I’ve tried many (free) scripts and none of them seemed to be working for accounts that only run during business hours.

I got many false alerts and stopped using the scripts. 

Can your script handle campaigns that are only active during business hours? “

Short answer: Yes.

The script handles campaigns that are only active during business hours by looking at the impressions during “the last two hours today” and comparing them to “the same two hours on the same day one week ago.”

If the last two hours did not show impressions, and the same hours from the previous week also did not show a significant number of impressions, the script “thinks” this is intentional and scheduled via ad schedules.

So, if your ad scheduling for last week is the same as this week, you will not receive an alert.

Don’t let a silent Google Ads account be the death of your ROI or the reason for clients leaving you.

My script screams bloody murder the second any of your Google Ads accounts go down. Get it today at a $100 discount! 

Click here to secure your discount:
https://nilsrooijmans.gumroad.com/l/account-down-alerts

Use DISCOUNT CODE: 1of20

Get it now, this deal won’t last long!

– Nils

P.S. Here’s a copy of the email I mentioned: https://nilsrooijmans.com/daily/this-script-saved-my-ass-this-weekend-and-it-could-save-yours-too

What ranks top of the list of your worst PPC nightmares?

Next to calls from Google Reps, my guess is “account down during the weekend” also makes it to the top 10 of your list.

That’s exactly what almost happened to me last weekend.

Last Friday afternoon, Google Ads stopped showing ads for one of my clients.

The reason: “overdue account balance.”

The result: ZERO impressions, ZERO clicks, and ZERO conversions.

Extra stress factor: this client sells a highly seasonal product (ski clothing). With winter in full swing, it is PEAK SEASON. So, NOW is the time to pull in profits like a magnet in a scrapyard.

Luckily for me, I got saved by a script. My ‘account down alert’ script, to be precise.

Without it, I wouldn’t have caught the issue until my client called me on Monday, fuming about plummeting revenue.

PHEW…

THE SCRIPT: 
Account Down Alerts for both individual Client Accounts and Google Ads Manager (MCC) Accounts 

WHAT IT DOES:
The script checks your account(s) every hour, and if an account is down, it will send you an alert via email, SMS, and WhatsApp to alert you. You can configure the amount of alerts per account you want to receive per day.

The script normally sells for $270.

As a thank you for being a loyal subscriber, I am offering an exclusive $100 discount for the first 20 buyers of the script. Be among the first to grab this deal before it’s gone!

Click here to secure your discount:
https://nilsrooijmans.gumroad.com/l/account-down-alerts

Use this DISCOUNT CODE: 1of20

Don’t wait — this deal won’t last long.

Happy scripting,

– Nils

Last week, I shared a little tactic to quickly and easily exclude all mobile apps from your PMax campaigns. You can find the details here: https://nilsrooijmans.com/excluding-all-mobile-app-placements-the-quicker-and-easier-way/

A long-time member of the list, Hana Kobzová (name shared with permission), sent a question that was asked often on LinkedIn and Reddit:

“Why do you recommend adding all those values from your list? Doesn’t ‘mobileappcategory::69500’ already cover everything?”

Great question! I also use ‘mobileappcategory::69500’ a lot for Display campaigns. It’s a quick way to easily add all mobile app categories to the placement exclusions in Display.

However, here’s the thing: Performance Max campaigns DO NOT have the option to exclude placement at the campaign level.

To exclude placements from PMax, you need to add the exclusion at the account level.

Also, the little trick of entering ‘mobileappcategory::69500’ in your placement exclusions does not work at the account level. Currently, the Google Ads UI throws this message when you try to save the exclusion: “An error occurred. Please try again or check your targeting options.”

So, as far as I know, copy-pasting all the Mobile App Placement Exclusions from this list and adding them at the account level is the quickest way to exclude all mobile apps from your PMax campaigns.

– Nils

PS: Want to always be in the know when Performance Max campaigns are showing your ads on bad placements?  Check out my Google Ads Script for PMax Placement Exclusions.

Have you ever wanted to add the same ad schedule to tens of campaigns?

I did. Today.

And trust me, the Google Ads UI makes it very hard to do this without you wanting to send your mouse on a one-way trip to the wall! You literally have to click each and every individual campaign, and add the ad schedules for each individual campaign… over and over again.

Luckily, there’s a quicker way: using Google Ads Editor.

Here’s how you do it:

1) Create your desired ad schedule in one campaign
2) Open Google Ads Editor
3) Download your campaigns
4) Select “Campaigns” in the type list
5) Select the campaign with the ad schedule you want to copy
6) Select “Edit” > “Copy shell”
7) Select all the campaigns where you want to paste the schedule
8) Click the Paste icon in the edit panel next to “Ad schedule”

That’s it. This saved my mouse from its funeral today.

– Nils

Two weeks ago, we talked about excluding Mobile App Placements in your PMax campaigns. (Remember? You don’t want PMax to show your ads on apps that only attract accidental clicks from the under-aged).

As we learned, excluding Mobile Apps at the account level is currently the only way to exclude them from your PMax campaigns. And, excluding them at the account level requires you to check 140 (!) Mobile App categories in the Google Ads interface.

140+ clicks just to protect your PMax campaigns from these dreadful placements that only waste your budget. Talk about time sinks…

Not anymore!

Thanks to a suggestion by fellow list member Maciej Ilczyszyn (name shared with permission), I learned about a quicker solution.

I created a script to pull all Mobile App Categories from the Google API and report them in a Google Sheet so we can use them to exclude them more easily!

Here’s how to quickly and easily exclude ALL Mobile App Placements from your account (and PMax campaigns): simply go to this Google Sheet, copy all the values in column B ‘Mobile App Placement Exclusions’, and add them to your exclusions.

That’s it! No more checking 140 boxes.

More details here: https://nilsrooijmans.com/excluding-all-mobile-app-placements-the-quicker-and-easier-way/

Note: the script automatically updates the list daily with the latest Mobile App Categories. This way, we are always up to date. 🙂

– Nils

PS: Want to always be in the know when Performance Max campaigns are showing your ads on bad placements?  Check out the latest version of my Google Ads Script for PMax Placement Exclusions.

A new year often means new targets. New targets for your clients, new targets for you, AND new targets for Google Ads Reps!

Already, the reps are reaching out like crazy to me and my clients.

If the same thing is happening to you, here’s the reply I would recommend:

Hey {name},

Thanks for reaching out, and all the best for the new year to you as well!

To kick off the new year, we want to focus on reducing wasted ad spend. For starters: can you enable the ‘Negative Keywords in PMax Campaigns’ feature in our accounts?

Next to that, if you have any other concrete suggestions to reduce wasted ad spend (based on our account’s data), please share them via email.

This will also enable us to see if scheduling your suggested call would benefit us both.

Thanks a ton already,

This reply will either get the rep off your back, or actually give you some meaningful result.

And, yes, you read that right! Google is (finally!) rolling out Negative Keywords for Performance Max campaigns (still in Beta). See details here: https://support.google.com/google-ads/answer/15726455

If you want to see what negative keywords you should add to your PMax campaigns to reduce wasted spend, run my script: https://nilsrooijmans.com/google-ads-script-pmax-non-converting-search-term-alerts/

If you want to learn how to add negative keywords to your PMax campaigns, read this:
https://nilsrooijmans.com/how-to-add-negative-keywords-to-your-performance-max-campaigns/

– Nils

Happy New Year! I wish you all the best and PPC success in 2025 🙂

A question for you:

What is the biggest PPC lesson you have learned last year? 

(Bonus question: how will you apply this lesson in the new year?)

Hit reply and let me know!

– Nils

Hey PPC pros!

How does a $425 ticket to THE AdworldExperience 2025 sound?

(Spoiler: it sounds amazing, and IS amazing… I’ve attended 8 editions and absolutely LOVED each one.)

I am thrilled to offer 3 free streaming tickets to my newsletter subscribers for the PPC event of the year, happening October 2-3, 2025.

Find out more about the event at: https://www.adworldexperience.it/en/ 

Here’s the deal to get a free ticket:

 Fill out this form.
 Sit tight until January 6 at 4:00 pm CET.
 Cross your fingers.

The winners will be announced on January 7 and will receive an exclusive link to stream the event for free!

Don’t miss your chance to join the lottery — it’s quick, easy, and could save you $425!

https://forms.gle/MgabyEKbLi4YoQVS8

Good luck!

– Nils

Your job is to reduce wasted ad spend.

Here’s why:

The ad platforms are, by themselves, forces that increase your spend.

They do a pretty good job at it.

The extra spend can be both good and bad.

It is your job to make the distinction.

– Nils

Here’s what I’ve been working on in the last few days:

[Google Ads Script] Performance Max Placement Exclusion Suggestions 

What it does:
This script suggests placement exclusions for bad placements where your PMax ads showed. If new placement exclusions are suggested, the placement exclusions are reported via email. The email contains a link to a Google Doc spreadsheet documenting all the placement exclusions suggestions.

Why you’d care:
PMax is notorious for showing your ads on placements that are not safe for your brand and/or only deliver fraudulent clicks and leads. (Seriously, try the script and check for yourself.)

Why I created it:
Countless PPC professionals from all over the world have asked me to create a script that would help them exclude bad placements from their PMax campaigns. Last Friday, Friday the 13th, was our lucky day: Google finally enabled the PMax Placement Report via Google Ads Scripts. This means we can now use Google Ads Scripts to help us get rid of some of the terrible PMax placements.

URL: https://nilsrooijmans.com/google-ads-script-pmax-placement-exclusion-suggestions/

NOTE: In the next few days, I’ll be releasing many updates to the script for free. Let me know if you have any suggestions on what to include.

Happy scripting!

– Nils

GRRRRR…

One of my clients F#$KED-up his conversion tracking. In the last 3 days, roughly 40% of conversions reported a conversion value that was roughly 135% of the real conversion value.

Don’t ask me who, why, or how. He doesn’t know. I don’t know.

But, as we all do know, Google Ads Smart Bidding uses conversions and conversion value data to “help meet your goals.” Meaning, it needs accurate conversion data to predict the conversion value of a potential click and place your CPC bid.

Wrong conversion data -> wrong bid!

Wrong bid -> either too much traffic at a cost that will ruin our ROAS, or we get too little traffic because of CPC bids that are too low.

Luckily, Google offers an advanced tool to help with the kind of situation I was in these last few days. It’s called ‘Data exclusions‘ and it saved my client’s account from a dramatic drop in return on ad spend.

Google says: “You can use data exclusions to help reduce the impact that conversion tracking issues may have on Smart Bidding Performance.”

Here’s info about it from the horse’s mouth:
https://support.google.com/google-ads/answer/10370710?hl=en

The important part for you to realize is this: data exclusions apply to CLICKS. Your data exclusions must exclude clicks that could have had the affected conversions attributed to them. 

When these clicks are excluded, the associated conversions are also excluded.

So, here’s the thing: make sure to consider your conversion delay and exclude any days of clicks that may have been impacted. 

It’s a best practice to exclude 90% of clicks associated with impacted conversion data.

For example: if there was a conversion value tracking issue from Dec 9 to Dec 11, and 90% of conversions usually happen in 2 days, apply the exclusion as quickly as possible, including ALL days with impacted clicks. (In this case, you would exclude Dec 7 to Dec 11.)

Not obvious at all, if you ask me. However, smart bidding needs smart fixes.

Don’t hesitate to use data exclusions when your conversion tracking shows issues!

– Nils

The best way to tank your results is to blame Google for the situation your account is in — even if Google is doing evil:

• “Google defaulted to Broad Match campaign setting in my account. Look at all those clicks from completely irrelevant search terms!”
• “Google enabled Enhanced CPC on all my Manual bid campaigns after I created a new conversion action. My Avg CPC almost doubled, and not even a 20% increase in conversions!”
• “Google decided to auto-apply all its recommendations. Now look at this terrible ad copy that hurts my brand, for keywords it auto-added that didn’t make any sense!”

The best way to improve your account’s results is to acknowledge Google’s actions — and beat your competition:

• “So, Google is pushing PMax like crazy, having my competitors waste a ton of ad spend on non-converting clicks that are hidden by conversions that would have happened anyway. Let’s beat them with my Standard Shopping setup!”
• “Oookay Google! You’ve got my competitor’s non-brand phrase match keywords to start matching for my brand name. Let’s have this competitor waste buckets of coins on clicks from the prime spot by temporarily lowering the bids for my brand keywords!”
• “OiOiOi, Google added some more extremely fraudulent ‘built for AdSense’ websites to its Display Network. Let’s automatically exclude these terrible placements that only send click and lead fraud to me (and my competitor, who isn’t running any placement exclusion script)!”

– Nils

“What Google Ads scripts should I be using?”

It’s a question I get all the time, in all shapes and forms:

“Which are the best uses of Google Ads scripts?”
“What are the best scripts for Google Ads?”
“What Google Ads scripts do you use most?”
“What is your favourite Google Ads script?”

Sorry, there is no simple answer here. It’s a “how long is a piece of string” question and the only right answer is the infamous “it depends.”

I run over 40 custom-built scripts in my manager account that monitor my client account settings and performance. Some examples:

• monitoring conversion tracking
• spend versus budget alerts
• payment issues
• smart-bidding-gone-haywire alarm
• monitor campaign settings like ad rotation, search partners, etc.
• low QS keywords with significant spend alert

These scripts allow me to scale my business and still sleep well with the comfort of knowing that all things run smoothly. If any dramatic change happens, my scripts will alert me in no time.

Most of these scripts are custom-built by me, and not publicly available yet. However, I plan on developing a paid membership community that will let you have access to them soon, so stay tuned.

For now, I have created a short list of FREE scripts that typically benefit almost every account I come across:

1. Broken Link Checker
2. Negative Keyword Suggestions
3. Negative Keyword Conflicts Checker
4. Search Query Mining Tool (n-gram analyses)
5. Trending Search Terms Report

You can find the scripts here:

https://nilsrooijmans.com/google-ads-scripts-faq/what-google-ads-scripts-should-i-be-using/

Happy scripting!

– Nils

Swen taught me a valuable lesson today:

“Step, Step, Step, Pause”

I was trying to replicate his moves. Him being my salsa teacher.

(Surely you’ll understand, no link to a video recording here. At least not yet!)

His lesson reminded me of my answer to a very common question:

“How to test different bidding strategies for a Google Ads campaign?”

My answer dances to the same rhythm as Swen’s advice.

Step 1: Create a campaign experiment and change the bid strategy setting in your experiment to the thing you want to test (i.e., different strategy, or different target).

Step 2: Sync the experiment (Trial) with your original (Base) campaign. This way, changes you make in your Base campaign will automatically be included in your experiment.

Step 3: Schedule the experiment to run for at least 6 times the median of your conversion lag AND at least 14 days.

Step 4: Wait.

That last step will give your bidding strategy the time to find its rhythm, just like Swen helped me find mine.

– Nils

If you don’t have as much time as you’d like to finish your work, you might have a “lack of automation” problem.

Or… you might not.

How can you tell?

Let’s say you’re an individual freelancer or part of a small PPC team, and you’re already running multiple Google Ads Scripts that automate all the repetitive tasks…

…but you still don’t have enough time to finish your work.

In a case like this, I’d say a lack of automation probably isn’t your main problem.

Your main problem is probably one of the following:

– you’re biting off more than you can chew (or may be forced to)
– you don’t have a clear plan (strategy)
– you don’t have a clear process (SOPs)

Tinkering with Google Ads Scripts might be fun, but it might not improve your situation if it’s not the main problem.

– Nils

Do you want to apply your special Black Friday headline to all RSAs in just a few seconds? 

Instead of changing all your RSAs in different ad groups in different campaigns, you can simply use this little-known Google Ads feature:

Campaign Level Headlines (and Descriptions)

Here’s how I use it:

1. Create Black Friday headlines (e.g., ‘Crazy Black Friday Offer’, ‘40% Discount with Code BF40’)
2. Pin the headlines to Headline 1 and Headline 2 
3. Set start date and end date for the Headlines
4. Select the Headline in the Asset view, and Add it to all campaigns I want to apply it to

That’s it.

Our friends at Paid Media Pros created this awesome video that walks you through the process:
https://www.youtube.com/watch?v=m35xGQjTFpE

Here are more details from Google:
https://support.google.com/google-ads/answer/13548268?hl=en

Trust me, if you run Black Friday promotions, this is one of the quickest and easiest ways to promote them.

– Nils

Thank you for being here!

Your appreciation means a lot to me. It’s like a turbo on my scripting engine and keeps me motivated to share my PPC learnings in my daily emails.

Today, I’ve got a favor to ask.

If you’ve gotten some value out of my scripts and/or newsletter this year, and want to stimulate me to create more value next year, help me help you:

Please take 5 minutes to complete the survey at https://www.ppcsurvey.com/

…and vote for me as your PPC scriptfluencer of the year 🙂

That’s it.

Thanks a ton!

– Nils