Negative Keyword Conflicts Alert Script – UPDATE

One of my favorite use cases for scripts is managing negative keywords.

I use scripts to:
– suggest negative keywords candidates
– allow for easy management of negatives via Google Sheets
– do n-gram analyses to discover potential negative candidates
– keep exact match keywords exact (super handy for brand campaigns to prevent non-brand from matching your brand keyword)
– automatically add positive keywords to a negative keywordlist that is attached to my DSA campaigns to prevent cannibalization
– auto-negate converting search terms in HIGH prio Shopping campaigns, so that the queries get funneled into higher bid MED prio campaigns
– automatically add positive keywords to a negative keywordlist that is attached to my DSA campaigns to prevent cannibalization
– …and a ton of other things.

Occasionally, me or my team members make the unfortunate mistake of accidentally adding a negative keyword that blocks one or more positive keywords.

Not good.

So, I use another script to alert me when that happens: the Negative Keyword Conflicts script.

What it does:
Email alert if an account has positive keywords which are blocked by negative keywords. The script saves all such conflicts to a spreadsheet and sends out the email alert.

Why you care:
Negative keywords are intended to prevent ads from showing on irrelevant search queries, but they may inadvertently block normal keywords from matching relevant search queries, making your campaigns less effective.  

The original script is developed by Google, but it has a major drawback;
it also looks at keywords in campaigns that have ended (ie: ended experiment campaigns).

This results in a lot of false alerts, making you want to ignore them altogether.

So I decided to fix this issue by changing the script to only look at campaigns that are still serving.

This fix was easy. The only thing I need to add was the condition to only look at campaigns with serving_status = ‘SERVING’.

In the code that means one extra condition in the GAQL query (extra condition in green):

`WHERE campaign.status = "ENABLED" AND campaign.serving_status = "SERVING" AND ad_group.status = "ENABLED" `+
"All the scripts you publish save my life, SO MANY THANKS , great job!!!!!!"

Marta Sabaté Méndez, PPC/SEM Manager & Digital Analyst - Barcelona, Spain

Nils Rooijmans
2023-05-04T07:40:54+00:00

Marta Sabaté Méndez, PPC/SEM Manager & Digital Analyst - Barcelona, Spain

"All the scripts you publish save my life, SO MANY THANKS , great job!!!!!!"
0
0
Nils Rooijmans

Here’s the complete code of the script:

Continue reading “Negative Keyword Conflicts Alert Script – UPDATE”

Google Ads Script – Change History Alerts

Be in the know when someone, or something makes changes in your Google Ads account.

Change happens.

Some changes are good. Other changes…not so much.

Occasionally, some of the most terrible changes pop up in your change history.

And the worst thing…they do so without you noticing!

Remember that last client of yours? That stubborn, overly self-confident ego-driven maniac?
He decided he knows best.
Made some “minor” changes to your carefully optimized account.
All by himself.
Changing ad copy, reducing test budgets, and adding non-brand keywords to your BRAND campaign…the horror.

Or maybe that overly ambitious intern that joined your team last week…Negating keywords all over the place!

And let’s not forget the worst of the worse; your colleague accidentally hitting the ‘Apply’ button next to one of Google’s Recommendations.

Oh dear.

Here’s the thing:

It is your job to manage and optmize your account.
Therfore you want be in the know when someone else makes any unanticipated change.
And you want to know immediately!

Thankfully, there’s a script for that!

Today I am sharing a stripped-down version of one of my favorite scripts in my private stack:

Continue reading “Google Ads Script – Change History Alerts”

Google Ads Performance Max Audit Checklist

Need to audit or set up Performance Max campaigns in your Google Ads account?

Use this checklist to increase you chance of success:

PART 1

    • implement gtag.js on your site
    • add Google Ads conversion tracking code
    • setup dynamic remarketing
    • make sure the product id matched your feed id
    • include hashed email
    • add the new_customer parameter to your tag
    • customize ad_personalization_signals to comply with regulations
    • enable consent mode modeling
    • enable enhanced conversion tracking
    • set attribution to data-driven
    • make sure to have GA4 implemented and linked to your account
    • create Performance Max segment in GA4
    • <more…>

NEED HELP IMPROVING PMAX PERFORMANCE? 

Want to beat your current Pmax Performance?

👉👉 LET ME SHOW YOU HOW TO BEAT PERFORMANCE MAX! (click here)

Continue reading “Google Ads Performance Max Audit Checklist”

The Best Google Ads Scripts of 2022

top google ads scripts 2022
top google ads scripts 2022

With TONS of scripts out there where do you even begin?! 

Let me spare you the pain of endlessly searching for, installing, and testing the best Google Ads scripts that came out in 2022, all ready to boost your PPC performance in 2023!

Here’s a list of my favorites.

Be sure to also check out my all-time list of over 400(!) Google Ads Scripts.

Continue reading “The Best Google Ads Scripts of 2022”