how to add Google Ads ad schedules in bulk

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

Tired of clicking 140 categories to exclude Mobile App Placements? Here’s the quicker way.

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.

next time a Google Ads Rep reaches out, ask for this

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

Welcome 2025!

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

Free Streaming Tickets to ADworldExperience 2025

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:

1️⃣ Fill out this form.
2️⃣ Sit tight until January 6 at 4:00 pm CET.
3️⃣ 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

this is your job

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

[Google Ads Script] Performance Max Placement Exclusion Suggestions 

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

[Google Ads Script] Performance Max Placement Exclusion Suggestions 

(click image to enlarge)

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

Saving ROAS with Data Exclusions

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

How to blame Google

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?”

“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

Step, Step, Step, Pause

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

Is it a “lack of automation” problem?

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

a very quick and easy way to add promotions to your RSAs

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

Want me to create more free scripts next year?

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

What’s your biggest PPC nightmare?

Want some PPC horror stories?

Check out this terrifying thread on /r/PPC: https://www.reddit.com/r/PPC/comments/1ga58zk/whats_your_biggest_ppc_nightmare/

If nothing else, it will sharpen your awareness of some of the worst PPC mistakes our universe has to offer.

Here’s one of my recent painful mistakes:

I implemented consent management via CookieYes on a Shopify store. Configuration went smoothly. Preview in GTM. All seemed well. Except… CookieYes was missing the integration with Shopify Consent API. So, no conversions were being tracked anymore (even if the user did provide consent). Then, smart bidding decided to reduce bids to ALMOST ZERO! No clicks, no conversion, no smile on the client’s face.

Ouch!

You have to know: I dream of happy clients. 

Angry clients are nightmare fuel to me.

Your turn: what’s your biggest PPC nightmare?

– Nils

PS: I am thinking about doing a live webinar next week where I’ll show you how I create a Google Ads Script to prevent the most “popular” PPC nightmare. So, if you want to prevent your nightmare from coming true, be sure to respond!

Just Script It

Nike’s slogan, “Just Do It,” is arguably one of the most iconic taglines in advertising history. Introduced in 1988, it was designed to inspire athletes and individuals to push beyond their limits, embodying determination, confidence, and a proactive attitude. The phrase has since become synonymous with the Nike brand, encouraging people worldwide to take action and pursue their goals.

It’s because of that last part that I really love the slogan. 

Whenever I find myself in doubt or procrastinating, I tell myself: “Just Do It!”

I’ve decided to embrace a small variation of this brilliant piece of marketing history. From now on, expect to hear me say “Just Script It” more often than Google changes match types.

Are you tired of sifting through SQRs and negating search terms? Just Script It
https://nilsrooijmans.com/google-ads-script-negative-keyword-suggestions/

Spending countless hours researching new keyword candidates? Just Script It:
https://nilsrooijmans.com/google-ads-script-automated-gpt-keyword-suggestions/

Almost lost your job because of overspending the client’s budget? Just Script It:
https://nilsrooijmans.com/google-ads-script-monthly-budget-target-email-alert/

If Nike can inspire the whole world to take action and pursue all sorts of goals, surely I can inspire you to automate your work.

Just Script It!

– Nils

“Does it make sense to add bid adjustments to smart bidding campaigns?”

Here’s a question that pops up a lot:

“Does it make sense to add bid adjustments to smart bidding campaigns?”

Short answer: No. Almost never.

Longer answer: It depends.

Here’s a table that summarizes when bid adjustments CAN be added:

And here’s what Google has to say:

If you are using Smart Bidding strategies, powered by Google AI, including Target CPA, Target ROAS, Maximize conversions, and Maximize conversion value, you don’t need to make manual bid adjustments since those strategies automatically set bids to optimize for the conversion goal specified by the customer. 

If you make a manual bid adjustment to your automated Smart Bidding strategy, it won’t be supported.

Device bid adjustments for Target CPA allows you to modify the value of your CPA target, rather than the bids themselves.

Source: https://support.google.com/google-ads/answer/2732132?hl=en

– Nils