Author: Nils Rooijmans

1. What tasks take up most of your time? Why do you still do them?

2. What have you learned about your audience in the past year? How did it change anything in your account?

3. When was the last time you created an experiment that kept you up at night? How did it feel?

– Nils

Your honest answer please:
how often do you look at the age performance data in your account?

Personally, I schedule to have look at the data at the account level at least once every quarter.

And I use the report editor to generate a report that looks like this:

This table immediately shows lower performance for Age 55+. 

Here’s the thing:
Reports like this create highly actionable insight in minutes!

We could show different ads and/or products to this audience, or simply exclude it.

You can get the same insights in minutes.
Simply create the report via report editor, save and schedule to have it send to your email every day/week/month.

Go ahead, give it a try and see if your Age segments show widely different performance.

It only takes 5 mins!

– Nils

Next Wednesday Sep 27, 6 PM CET (9 AM PST) I will join Frederick Vallaeys in Optmyzr’s PPC Town Hall to talk about ChatGPT and Scripts.

Here’s the announcement:

And here’s the link:
https://www.youtube.com/watch?v=Hs7szTIfjSg

You can join us live and ask Fred or me any questions in the chat.

See you there?

– Nils

Did you know?

Even when your advanced location options are set to “People in or regularly in your targeted locations”, you might still see a few clicks from random places. It can add up over the year. 

More importantly (especially with PMax), even without clicks you might get chunks of impressions that could hurt ad quality score.

Here’s how that could look:

And here’s how I learned about this:

Yep, that’s Ed Leake’s GTA Performance Framework, helping me again to fix an account I just took over. 

Curious to learn: do you get a significant chuck of clicks or impressions from outside your targeted locations? 

Go ahead, check it right now. It only takes 2 mins!

– Nils

PS:

Ed actually has 400+ more valuable items on his checklist. They are part of the God Tier Ads Framework. If you want to simplify account management, take back control, and improve results (or your money back) -> sign up for Ed’s God Tier Ads.  

Use my discount code “NILS100” at checkout for $100 off. Pay once, get lifetime access to everything.

I’d still share these tips without the kickback… Ed’s pro tips have made me way more money than I’ll ever see from commissions, but a few extra bucks is nice!

Here’s the link again: https://app.godtierads.com/gta-bonus-bundle/apnnu

– Nils

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

“Google simply cannot be trusted!”

There. I said it. 

And I will say it again.

Back in 2019, I was invited to the Great Day event to speak about this issue.

In my presentation titled “Keeping an Eye on Google’s AI using Scripts“,  I spoke about my methodology and scripts to monitor and analyze the impact of Google’s AI, mitigate some of the risks, and regain control.

The first slides talk about the different stakeholders in the Google Ads game, and how their goals aren’t aligned.

Recent revelations in the US antitrust trial against Google stress the importance of the matter.

Don’t believe me?

Read this: 

“Bloomberg’s Leah Nylen has the details of Google ads executive Jerry Dischler’s testimony, where he describes statements he made under oath in 2020. 

Dischler says Google tweaks its auction process in ways that may have raised prices in the past by 5 percent for the typical advertiser and could potentially have raised them by 10 percent for some queries. 

The parties buying the ads would have been unaware of these “tunings” of prices; “we tend not to tell advertisers about pricing changes,” Dischler said.“

Source: https://www.theverge.com/2023/9/19/23880275/google-search-ads-competition-auction-prices-doj-trial-antitrust

I hate to say it again, but you simply cannot trust Google to spend your ad budget in a way that benefits you the most.

Keep an eye on Google’s AI.

– Nils

Here’s a nice little tool I came across today: https://by-edoardo.com/google-ads-script-generator

It helps you create a very simple script that automatically generates a Google Sheet with your campaign stats.

1. Select the fields, metrics, and date range
2. Hit “Get Your Script”
3. Copy to clipboard
4. Paste in your Google Ads Script editor (for more instructions, visit my “How to install and run your first script” guide)
5. Create a Google Sheet and add the URL to the script (follow the instructions in the top section of the code)
6. Authorize, Preview
7. Schedule to run daily/weekly/monthly
8. PRO TIP: Ask ChatGPT to add some code to send you an email with a link to the sheet every time the report has been generated

– Nils

PS: 

Want to learn how to create your own scripts via ChatGPT? Join my “5-Day ChatGPT and Scripts Challenge”.

More details: https://nilsrooijmans.com/5-day-chatgpt-and-google-ads-scripts-challenge/

I am on my way to Berlin for my session at the SMX Advanced event.

During the event, I will release my Google Ads Script to connect to the GPT API.

It’s not out in the open yet, but since you are on my list…

Here’s a sneak preview: https://nilsrooijmans.com/gpt-api-example-script.txt

Expect more details and example use cases soon!

– Nils

PS: I will also be announcing the “5-Day ChatGPT and Scripts Challenge”! More details here: https://nilsrooijmans.com/5-day-chatgpt-and-google-ads-scripts-challenge/

“Ask not what this keyword can do for you, ask what you can do for this keyword.”

– Nils

“Never fails that you inspire, uncontrollable desire” 

Rosie Gaines taught us some 30 years ago: “close” is what we desire.

Ed Leake and I are no different. 

We like to be close.

Not literally, him and me.

Ed likes to live as a solitary Hebride on rainy Scottish islands so I doubt we’ll ever meet.

BUT…

Close to clicks? Yes.

Close to conversions? Even better.

I’ll let Ed explain:

– Nils

PS:

Ed actually has 22 more pillars of great ad copy to get more clicks and conversions. They are part of GTS.

If you want to simplify account management, take back control, and improve results (or get your money back) -> sign up for Ed’s God Tier Ads. 

Use my discount code “NILS100” at checkout for $100 off. Pay once, get lifetime access to everything.

I’d still share these tips without the kickback… Ed’s pro tips have made me way more money than I’ll ever see from commissions, but a few extra bucks is nice!

Here’s the link again: https://app.godtierads.com/gta-bonus-bundle/apnnu

– Nils

Here’s a pro tip from fellow Google Ads Scripter Stefan Neefischer:

“Add soft conversion events to your ads account, e.g. engaged user (not bouncing after some seconds), and use this for making the n-gram analysis. You will identify a lot of totally off-topic patterns thanks to Google’s changes in the match types / close variants”

I agree and can confirm. N-gram analysis based on micro conversions allow you to reduce wasted ad spend much quicker.

Watch how the Shopping, DSA, and Broad-match algorithms match your products, pages, and keywords to user queries.

A great example of how you can use scripts to “Keep an Eye on Google’s AI“!

– Nils

PS: Here’s the link to my updated version of Brainlabs’ N-gram analysis script: https://nilsrooijmans.com/updated-google-ads-script-brainlabs-search-query-mining-for-n-gram-analysis/

“Is there a trend in the number of impressions for my top 5 search terms this year?”

This question popped up while analyzing some Google Ads data today.

“Well, why not ask ChatGPT?”

And so I did.

I downloaded my search term data, opened up ChatGPT, enabled Advanced Data Analysis (formerly known as Code Interpreter), and…

Two prompts and five minutes later, this is what I got:

TWO prompts. FIVE minutes.

Thank you ChatGPT!

– Nils

Are you creating custom or recommended events for tracking via GA4?

This cheat sheet is a goldmine for understanding event parameters, key dimensions, and metrics in GA4.

I really love the interactive interface and the details of the information.

Example use case: click on a metric or dimension and it will tell you if it’s available in Looker Studio, if it’s calculated, etc. At the top of the page you can also choose “Data Studio” in the dropdown and it will filter to show all available metrics/dimensions.

Here’s the link: https://data.ga4spy.com/

Quick, precise, and as far as I can tell, very up to date.

Enjoy your PPC day!

– Nils

If you aren’t using Code Interpreter in ChatGPT yet: You Should.

Here’s a 20 min video that will, without any doubt, convince you to start playing with this super-tool: https://www.youtube.com/watch?v=O8GUH0_htRM

It is REALLY worth the watch.

Code Interpreter is the next best thing to a cold beer on a hot and sunny afternoon.

I already use it on a lot of my PPC data.

Today I created this n-gram analysis graph, in 5 mins:

Here’s the thing: Normally, creating this graph would easily take HOURS. Thanks to Code Interpreter I created it in 5 MINS!

This is only the top of the iceberg of what is possible with the combination of ChatGPT and Code Interpreter. 

– Nils

Last two years I’ve been lucky enough to be part of God Tier Ads, hosted by Ed Leake.

Ed and I share a passion for sharing the knowledge of PPC professionals. 

We both agreed, PPC Pros look beyond what is visible in the Google Ads interface.

So we decided I should share some of Ed’s insights on landing page design with you.

Here’s Ed:

“Questions to ask yourself before creating your page:

• Who is my ideal customer?
• What problem do they have?
• Without your product/service what would they be doing?
• How is your product/service unique?
• What do you want them to do on your landing page?

Page Structure (above the fold)

• Headline focused on benefits
• Product/service example in image(s)
• Fears addressed so visitors don’t just leave
• Call to action
• Social proof such as a testimonial or rating

Copywriting

• Plain simple language (no buzzwords)
• Speak the language your prospects use
• Highlight pain – the current way, or before vs after
• Focus on the why and your USP
• Show benefits first, features come after

Call to action

• Focus on one goal
• CTA is clear and contrasts with the page
• Optional: secondary CTA for those not yet ready to act
• Repeat primary CTA before site footer
• Optional: CTA in sticky-header menu so it’s always visible
• Use sub-text to address doubts near your CTA

Sign-up form 

• Try to reduce form fields (ask for the bare minimum)
• For larger forms retarget people who part-complete sign up
• If your form is larger, consider 2-steps
• Ask low threat questions first, not contact details

 Performance 

• Aim for a score of >90 on https://developers.google.com/speed/pagespeed/insights/

That’s it!“

Is this the most extensive checklist you’re going to find?

Not at all.

What I like about it, and what discriminates Ed’s work from the rest, is that it gets you _thinking_ about what is _really_ important. Who is my ideal customer? What problem do they have? Without your product/service, what would they be doing?

The list is concise, concrete, and actionable. Another thing Ed and I both appreciate. 

Here’s my advice: next time you open your Google Ads interface, navigate to Landing Pages, sort by Cost desc, open the top landing page, and work your way through this checklist!

– Nils

PS:

Ed actually has 7 more checks to level up your landing page. They are part of his GTA course. If you’re really serious about upping your PPC skills and want to get more PPC nuggets like this, sign up for Ed’s God Tier Ads.

Use my discount code “NILS100” at checkout for $100 off. Pay once, get lifetime access to everything.

I’d still share these tips without the kickback… Ed’s pro tips have made me way more money than I’ll ever see from commissions, but a few extra bucks is nice!

Here’s the link again: https://app.godtierads.com/gta-bonus-bundle/apnnu

“Will AI replace me in my PPC job?”

No.

You won’t be replaced by an AI.

BUT, you almost certainly will be replaced by the guy that uses AI in your current job.

– Nils

Here’s a creative use case for custom columns in your Google Ads UI: the Increased Competition Detector.

This custom column looks at decreases in click-through rate (>10%) and increases in CPC (>10%) to gauge potential market competition and activity. 

It is extremely helpful for monitoring activity on brand keywords (e.g., competitor poaching), but it’s valuable information for key non-brand terms as well.

Here’s what it looks like:

Here’s how to create it:

And here’s the formula for easy copy-pasting:

if(and((Avg_CPC.between_dates(report_range_end, report_range_end) / Avg_CPC.between_dates(report_range_start, report_range_start)- 1 ) > 0.1, (CTR.between_dates(report_range_end, report_range_end)/CTR.between_dates(report_range_start, report_range_start)-1  ) < -0.1 ), "incr comp", "-")

Go ahead, add it to your custom column set, it only takes 3 mintues!

Hat tip to Laura Schiele for sharing this on SEL earlier this year.

– Nils

Performance Max is a black box. Extremely little data about its performance is shared with us via the Google Ads interface.

Yet, we all crave this data. 

In fact, if I had to choose between a Google Sheet with yesterday’s PPC stats and my morning coffee… well, my Harrar French press would win.

BUT, the thing is:

We are PPC professionals. We want to optimize based on performance data. Reduce wasted ad spend in areas with low click value. Increase clicks from targets that show great results.

Yet Google is making it harder to do our jobs each and every day by hiding valuable data in the interface.

Luckily for us, the Google Ads API allows us to pull some more data from the Google Ads platform.

And we can use a script to do some nice things with this data!

Imagine having a Google Sheet at your fingertips that shows what search categories are trending in your Performance Max campaigns.

–> Easily see how the PMax algorithm is changing, and matching your assets to new user queries.
–> Quickly see what types of searches these newly inserted products are being matched to.
–> Promptly respond to downward trends in search terms that showed great conversion value in the past.

And there’s more.

You can use the insights to:

– Add trending search categories as new (broad) keywords to your standard search campaigns 
– Tailor your creatives based on trends
– Add popular search categories to your landing pages and Merchant Center feed descriptions to boost performance

I will take any additional insight I can get since Google gives so little on PMax. That’s why I created this script.

Here’s a script to monitor how Performance Max is matching your assets to user queries, and what is changing in the search behavior of your audience.

The script creates a report in Google Sheets. The report lists the search categories that show a significant increase or drop in impressions. It compares last week’s data to the week before.

LINK: https://nilsrooijmans.com/google-ads-script-pmax-trending-search-categories/

– Nils

Here’s a question I get asked a lot: “What PPC tools do you use?”

I like to test many, but stick to the bare essentials.

Here’s what PPC tools I actually _use_ on a daily/weekly basis.  

From the Google stack:  
– Google Tag Manager  
– Google Analytics (GA4)  
– Google Merchant Center
– Google Ads  
– Google Ads Editor  
– Google Ads Scripts (I use them A LOT!)  
– Google Sheets  
– Google Docs
– Google Looker Studio 
– Google Big Query (for the bigger accounts with loads of data)
– Google Lighthouse

Feed management:
– Channable

Chrome extensions:
– page load times
– keywords everywhere
– keyword modifier
– tag assistant
– analytics debugger
– toggle case

What PPC tools that you can’t live without did I forget?

– Nils