Last week, I was in the Italian Alps for skiing.
Standing at the top of the Matterhorn, Europe’s highest ski-lift mountain, is thrilling.
But hearing the news of being voted #1 PPC influencer by fellow PPC’ers from up here? Now that’s next-level altitude sickness!
I’m humbled by the incredible support of fellow PPC’ers who voted me #1 in the community vote of this year’s Top 50 PPC Influencers — and thrilled to land at #5 in the overall standings.
Thanks to all of you who voted for me!
“Influence” to me means using my voice to make PPC life easier, more performant, and more fun for others.
That’s why scripting is such a passion of mine: a good Google Ads Script doesn’t just automate tasks — it increases performance and opens doors for the fun parts of PPC: creativity and strategy.
I’m celebrating today by giving back: sharing one of my favorite scripts that I haven’t shared publicly before.
It’s a script that saved me from dropping off a cliff many times:
[Google Ads Script] Conversion Drop Alerts
URL: https://nilsrooijmans.com/scripts/Conversion-Drop-Alert.txt
What it does:
This script runs daily and checks if yesterday’s conversion performance is significantly lower than the historical average for the same day of the week, based on standard deviation. If a significant drop is detected, an alert will be sent via email.
Why you’d care:
Unintended dramatic decreases in conversions are nightmare fuel for any PPC specialist. They will probably upset your client, might hurt your smart bidding strategies, and look bad in your reports. There can be many issues causing big drops in conversions, not among the least are technical issues with your conversion tracking setup. Other potential causes include payment/budget issues, website issues, inventory issues, manual mistakes inside the account, etc. When this happens, you want to be the first to know.
How I use it:
The single-account version of this script is free. I use the (paid) MCC version in my manager account that allows me to monitor all my clients and also receive alerts via SMS and WhatsApp for unexpected ZERO conversion events.
Thanks again for your appreciation. I hope you like the script and vote for me again next year 🙂
Happy scripting!
– Nils