A new script is out! Managing shared negative keyword lists is still a clunky experience in Google Ads. Today, I’m releasing a new script which will ease some of your pains. These are the problems the script is solving: You can fit all negative keywords lists onto one screen (=one sheet in Google Sheets). You […]
Category: Tools
Simple 404 Checker in Google Sheets with Scheduler
Checking for broken links is one of the boring tasks every digital marketer should do on a regular basis so his/her budget is not wasted on people landing to broken pages. The common question I’ve been getting is: “How can we check for broken links in Google Sheets on regular basis?” Well, today, I’m releasing […]
Below First Page Bid Checker Script for Google Ads
A new script is out! Do you find it difficult to monitor your top keyword bids so you always stay above the first page bid? This new script is here to help you. What does it do? It pulls all keywords with impressions from your account (not MCC level!). It finds the top X keywords. […]
How to Get Google Ads Lead Forms to Google Sheets and Get Notified via Email?
Google has recently released a new extension type called “Lead form extensions”. The new extension allows your customers to submit contact forms directly from the search engine without having to visit your page. This is a great addition to the extension portfolio especially for the service oriented businesses. This article will help you automate processing […]
How to Get Facebook Leads to Google Sheets and Get Notified via Email?
Have you ever wondered how to get Facebook Leads into Google Sheets and also send the leads via email immediately after the lead is recorded by FB? In this article, I will show you one of the many options to solve the problem within 30-45 minutes.
Supermetrics for Google Data Studio: a Biased Review from a Power BI Fan
If you are a frequent visitor of this blog, you probably already know by now that I’m a big Power BI fan thanks to its endless customization options, especially in the Power Query editor. However, I will take a step back today. Not everybody needs to have an advanced and super-customized reports. In this article, […]
FREE No-DAX Calendar for Power BI – No More Copying!
Have you ever imagined how nice it would be if you did not have to create your Power BI calendars in DAX or in Power Query? Here is the solution. FREE Always updated calendars in Google Sheets for everybody.
Supermetrics for BigQuery: Step by Step Guide
In April 2019, Supermetrics team announced their new product called Supermetrics for BigQuery. So let’s have a look on what this thing does and why it could be useful for you – especially when you run massive accounts. Here some of the questions you might be asking: Why the hell should I care? I am […]
Free Google Ads Script for Building Negative Keyword List to Negate Bad Search Terms
I have just scored 200th subscriber for this website and it’s time to celebrate with a free Google Ads script. I wrote a script for building negative keyword list which is free to use by anybody. Here is what the script does: It creates a new shared negative keyword list (if the list does not […]
Generate PPC Keyword Lists with SQL in BigQuery
If you run massive search accounts with millions of keywords created based on templates, it can get really tricky to regularly generate such keyword lists on scale on daily basis for example. You can: Write your keywords manually. Good luck with that. Do some copying and pasting in Excel/Google Sheets. Good luck with making no […]