Author: Nils Rooijmans

Recognize this?

Every time you start with a new client, you spend the first hours setting and rearranging the columns in the different tables. 

• For campaigns, you click Modify columns, check the columns you want in your table, and re-arrange the order of columns.
• Then for ad groups, you click Modify columns, check the columns you want in your table, and re-arrange the order of columns.
• Again for keyword view, you click Modify columns, check the columns you want in your table, and re-arrange the order of columns.
• Rinse and repeat for each and every table.

Horrible hassle.

Now, imagine you could set all this once at your manager account level (MCC) and be done with it!

Well, you can.

“If you use a Google Ads manager account, your viewing preferences are synchronized across the accounts within your manager account. For example, if you update the date range in one account, the same date range will be applied to all accounts within your manager account. Google Ads started saving these preferences at the manager account level since October 2019.

The following account viewing preferences are synchronized across accounts within your manager account:

– Date range
– Page size
– Home page
– Synchronized across accounts by table and campaign type:
  – Columns in the table and their relative order
  – Segments in the table
  – Sort order of the table
  – Metrics selected in Charts“

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

I like to keep all my sub-account views consistent and this feature has been a major time saver for me.

Here’s where to click to sync your columns:

NOTE: It seems you only get to use this option once — before you make changes to the default columns in a client account. Once you’ve made a change, the sync opt-in does not appear anymore (at least not in my experience).

– Nils

My 3-second answer to end the discussion is this:

SKAGs if, and only if, you have a single keyword that is responsible for >80% of the conversions on your lander.

– Nils

The date was July 5th, 2014.

The night had been warm and sweaty, and I just had my first cup of coffee.

The phone rang.

“Nils! We’ve been without any leads last five days. What’s going on?!”

“Uhhh, uhm, I don’t really know Jeff. Let me have a quick look. I’ll get back to you in a bit.”

It turned out the Adwords account had not been serving any ads for five days due to declined credit card payments.

And I hadn’t noticed. For FIVE days.

To me, that was unacceptable. Jeff was paying a fair amount of coins for me to handle his ads. 

For Jeff, it was more than unacceptable. It was a matter of staying alive. He was in the roofing business and just got started.

You can imagine how I felt when I needed to pick up the phone and explain to him what happened.

Jeff took it lightly and finished our second call:

“It’s all good. I can feel you understand the importance of this issue for my business. I am confident you will not make the same mistake again.”

We all need more Jeffs in our lives.

Now, here’s the thing: I’ve always been obsessed with preventing my clients from noticing any issue before I notice them myself.

And no surprise here, scripts are my go-to tools for that.

Check out this great script from our friends at Optmyzr: https://bitbucket.org/snippets/fvallaeys/nLEoj/check-if-account-is-offline

What it does:

It checks whether a Google Ads account has gone offline, possibly due to a declined credit card, accidentally pausing all campaigns, or suspensions, among other things.

Why you’d care:

Accounts go offline for many reasons. Billing issues are a well-known problem in managing Google Ads accounts, especially for advertisers with smaller budgets. When this happens, you want to be alerted straight away so your client does not unnecessarily miss any leads and/or revenue.

– Nils

PS: What’s the worst PPC nightmare you want to prevent from happening at any cost? Hit reply, I’d love to know.

Want to know what one of my favorite productivity hacks is?

Read on.

Yesterday, you received my “This Email Intentionally Left Blank” message in your inbox. It triggered many reactions. You sent me replies like “WTF!?”, “LOL”, “Uhhh?”, “This made me think…”, and “Dude, there is nothing here!”

The last one was the bull’s eye.

My favorite productivity hack is exactly this. Empty. Blank. Space.

Blank space is the idea of blocking “empty” time in your calendar.

This empty time has no specific purpose and no specific task that needs to be completed.

Creating space within your PPC calendar allows you to slow down and reflect on strategy. 

It also allows you to simply click through the Google Ads interface or Analytics data and just have a look at what is happening in areas you do not visit frequently.

Blank space creates a sense of joy and gratitude because you can enjoy your time by simply following your curiosity. 

Without any exception, my blank spaces generate at least one new idea to improve either my Google Ads accounts’ performance or my workflow. That’s a productive win!

The best way to create blank space?

Simply add a 30-minute space to your calendar, and schedule to repeat it weekly or even daily.

Seriously, you should give it a try.

– Nils

Starting last June 1, a limited set of advertisers have become able to set monthly spend limits at the account level.

Finally! Google Ads changed something related to our budgets that is actually useful! 😀

You can find the details here: https://support.google.com/google-ads/answer/10178071

Now, let’s hope that Google does not decide to grant itself the “right to double your monthly spend limit” like they do with daily budgets… 

– Nils

PS: Are you curious as to what extent your daily budgets suffer from ‘overdeliveries’ by Google? If so, check out this script: https://nilsrooijmans.com/daily-budget-overdelivery-alerts-script/

You Pay Per Click.

Your click costs $1 on average.

Convert that click into a lead, and it is worth $50.

Make that lead into a sale, and it is worth $500.

Turn the sale into a lifetime customer, and it is worth $5,000.

Here’s the thing: the value of your PPC efforts is determined by what you can make out of that click.

Value your click.

– Nils

PS: Are you already tracking lifetime value? If so, hit reply — I would love to learn how you do it.

Over the years, I’ve received many questions from people who made a mistake when installing one of the scripts from my list.

It is my job to help you avoid the same mistakes they made.

The most common mistake has to do with configuring a spreadsheet URL.

You can read about it here:

https://nilsrooijmans.com/google-ads-scripts-faq/heres-why-you-get-invalid-argument-url-file-code-gs-line-xx-errors/

– Nils

Are you tired of manually adding Responsive Search Ads to every one of your ad groups?

If so, this script will save you many hours and headaches: https://adsscripts.com/scripts/google-ads-scripts/create-responsive-search-ads

The script runs through all Search campaign ad groups in your account. You can use labels to select the ad groups you want to be processed. 

For the ad groups that don’t already have an RSA, it adds a Responsive Search Ad based on the headlines and descriptions in your existing ETA ads. 

This way, the new ads will immediately be relevant in all ad groups.

You can put backup headlines and descriptions in the script. These will be included in the new ad only if no 15 headlines or 4 descriptions have been used. 

In addition, you can also label the new ads. This way, you can easily find them later in your account.

Next time you need to add RSAs to tens or even hundreds of ad groups, consider this script.

– Nils

One of my coaching clients is an agency that is trying to double its number of clients without growing headcount.

A part of their efforts to grow the business was hiring an aggressive salesperson. 

Today, we got on a call to discuss his sales pitch. Here’s what he told me:

“One of the things I tell the prospect is that we keep the campaigns running 24/7 since the ads run 24/7.” 

The way he brought it up sort of implied that the agency employees are running 24/7 as well.

I recommended he not talk to any prospect again until our copy of R2-D2 is finished.

Here’s the thing: you can’t scale your PPC business without setting the right expectations. You can’t scale results without communicating relevant and reasonable targets.

24/7 support isn’t one of them. (Go tell your sales reps!)

If anything, scaling is all about managing the right expectations.

– Nils

Want to quickly see how your competitors are doing in your auctions?

Google Ads auction insights offer some amazing data, but the numbers are hard to compare and do not show trends over time. Analysing the data in the tables quickly becomes an excruciating exercise in number crunching.

Imagine having nice little graphs that show trendlines with your ‘impression share’ and ‘top of page rates’ compared to your competitors. A picture says more than a thousand numbers, right?

Luckily for us, our friends at Optmyzr created a nice little tool to help us out — enter the Auction Insights Visualizer:

https://www.optmyzr.com/free-tools/auction-insights-visualizer/

This tool allows you to drag and drop the data from Google and instantly turn it into a series of customizable charts that are suitable for sharing with a client or manager.

Here’s a 5-minute video that shows you how to quickly understand how competitor behavior has changed over time:

https://www.youtube.com/watch?v=SgycHrR5diU

ACTION: Why not take a 10-minute break and try this for last month’s auction data in your top campaign?

– Nils

Here’s your PPC productivity tip for the day:

You can use the Shared library in your MCC manager account to create, edit, and remove negative keyword lists that can be applied to your client accounts.

If you’ve been laboriously adding the same lists of negative keywords to your client accounts manually, this is for you. I use them to share generic negative keyword lists that are not client-specific, like a list of words that are HR-related (e.g., ‘jobs’, ‘resume’).

Here’s how: https://support.google.com/google-ads/answer/7519927?hl=en

NOTE: When you create negative keyword lists in your manager account, they’re added to the Shared library of all your client accounts by default. Your clients can see all the shared lists in your manager account.

– Nils

PS: if you like this post, be sure to check out my Google Ads Script for Negative Keyword Suggestions.

Recognize this?

You inherit an account with thousands and thousands of negative keywords spread all over the place like spaghetti sauce. No clue as to whether or not all these keywords still make sense, or will be blocking your newly-discovered golden growth opportunities.

Here’s the thing: as a GAds account grows, so does the amount of keywords, both positive and negative.

Managing all these negative keywords is boring as dog sh!t, a gear-grinding time sink, and prone to error.

Luckily, the Google developers were sensitive to some of this negative energy and came up with a script to relieve a part of the burden:

https://nilsrooijmans.com/negative-keyword-conflicts-alert-script-update/

This script checks your negative keywords to see if you are blocking any valuable keywords that are relevant to your audience. The script will find and save all conflicts to a Google Sheet, which is then sent to you via an email alert. 

The next step for you is to take action to remove these conflicts — either remove the terms from your negative keyword list or pause the keyword.

If you are not yet running this script in all your accounts, I highly recommend you do. It will only take a couple of minutes and three sips of coffee to set them up.

What are you waiting for?

– Nils

PS: I am looking for new scripting ideas to optimize the management of negative keywords. What tasks would you like to see automated?

Google announced that in some countries and languages, the new Phrase Match is already rolled out.

“As of April 2021, the updated phrase match behavior is available in the following languages: English, German, Spanish, French, Italian, Dutch, Portuguese, and Russian” 

…and,

“After July 2021, legacy BMM keywords will continue to serve, they’ll just behave as if they were phrase keywords.” 

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

To see how this new phrase-matching behavior differs from BMM, I decided to run some campaign experiments where the only difference is that BMM keywords in the Experiment are replaced by Phrase match versions.

In theory, this should help me predict what will happen to my BMM keywords in July, and anticipate the change in match type behavior.

Who wants to join me in the experiment and share results?

– Nils

Pivot tables are an essential tool for any PPC specialist.

Luckily, the teachers’ teacher Brad Geddes created a short video explaining the pivot magic.

It covers creating a pivot table, calculating fields, pivot table charts, filtering pivot tables, and refreshing your data.

Here’s the link: https://www.youtube.com/watch?v=CbAeq_rac48

NB: even if you feel you are already familiar with pivot tables, it is probably still worth watching. Play it at 2x the speed.

– Nils 

PS: Are you a fan of pivot tables? If so, what is your favorite use case? I would like to learn about it. Thanks!

Every Monday, I ask myself: “What can I do to be more productive?”

Today I realized, subconsciously, I translate this question into a different one: “How can I be more efficient at things that are more effective?”

Here’s my take on these concepts:

Productivity is pure quantity.
There’s GOOD productivity and there’s BAD productivity. The good sort is where quantity meets quality; you’re producing high-quality output (result) that matters, in an efficient way. The bad sort is where you produce output that doesn’t really matter, or you’re wasting a lot of time and energy.

Effectivity is a measure of quality.
Effectivity measures the proportion of your output that works as intended — how much it contributes to the goal.

Efficiency is a measure of cost.
Just because you produce some output, it doesn’t mean you do it well, though it may prove workmanlike. If you are spending tons of resources (input like time, energy, and money) on something great, but it could be done in a way that consumes fewer resources, you’re not efficient.

If, this week, you are able to get more outputs from the same inputs, you are probably doing a great job.

– Nils 

Let’s say you’re Google and you’ve got a smart advertiser who is using a target ROAS bidding strategy.

The campaign is running smoothly, ROAS targets are crushed, and the campaign budget leaves room for a lot more spending.

What’s keeping you from setting a crazy high bid for that click in the next auction? Not much, right?

According to Google’s documentation, target ROAS bidding will 
“set maximum cost-per-click (max. CPC) bids to maximize your conversion value while trying to achieve an average return on ad spend (ROAS) equal to your target.”  

So, if the average ROAS is above target and the budget is not yet spent… guess what, extremely high CPCs are not an exception. We are all in it for the money, right?

Luckily for us, there is a slightly hidden secret to prevent this from happening: you can set a max CPC bid if you are using a portfolio version of the target ROAS smart bidding!

(It’s under “Settings > Advanced options” in your Portfolio bid strategy.)

– Nils

PS: Do you currently monitor for high actual CPCs in your account? If so, please let me know. I’d love to learn how you do it.

Wouldn’t it be nice to have a list of the best scripts out there when it comes to Shopping campaigns?

Based on many requests from the community and Google search data, the answer is probably “Yes.”

So, I’ve started collecting scripts and am working on a list with the best ones I can find.

Here’s the first, “Exact Match For Shopping”: https://searchengineland.com/keywords-back-google-shopping-campaigns-230973

The script reads a list of exact match keywords for Shopping campaigns from a Google Doc and then excludes any search queries from your Shopping campaigns if they do not match those keywords by adding them as a negative.

Using this script, you could run a Shopping campaign just for your best-performing search terms and spend as little as possible on clicks from other search terms. 

But it also means that you can run your Shopping campaigns sort of like separating Broad and Exact campaigns. The “Exact” Shopping campaigns will bring in your high conversion traffic, and your Broad ones will bring in the less predictable long-tail queries. 

If you really want to take control over your Shopping campaigns, you can even use this script to map each user query to a specific product that you would like Google to show for that query.

Note: in my experience, this strategy does not scale very well and only works for shops with a limited number of items (<100).

– Nils

PS: The author shares a lovely insight at the end -> “Someone should tell Google that keywords are a great way to manage online advertising campaigns.” 

Want to get up to speed on everything that was announced at Google Marketing Livestream 2021? 

Here you go: https://officialppcchat.com/2021/05/28/google-marketing-live-2021-resources/

What’s your biggest take from the event? I would love to know.

– Nils