***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** The problem I am solving today is replicating this 3 years old script Free Google Ads Script for Building Negative Keyword List to Negate Bad Search Terms entirely in Integromat. You might be wondering why I […]
Category: Build Ups & Edits
Make/Integromat in Performance Marketing World
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** Integromat is a super powerful tool for automating your marketing workflows. However, the term “marketing” can mean many things. In the generic form, “marketing automation” with Integromat is usually about pushing contacts from a source system […]
Google Sheets to Google Ads Uploader
Have you been dreaming of how nice it would be to be able to upload new ad groups, keywords, or ads directly to Google Ads from a Google Sheet? Dream no further. Here is a solution. I am introducing a new Google Ads script which allows you to upload new ad groups, keywords, and expanded […]
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 […]
5 No Longer Secret Power Query Tricks
In this article, I will be covering 5 random tricks which I find very useful for all kinds of queries. This tricks are: Parameters IF Function for Steps IF Error “Side” Steps Adding Comments into the Code Note that this article is for advanced users. Manual edits of the code are needed but you can […]
How to Connect Excel to Google Ads with Power Query
Have you been dreaming of how smooth it would be to have Excel connected to Google Ads? There might be a reliable workaround solution for you. This article is for more advanced users but don’t be scared – why don’t you just become advanced user by trying all of this stuff? You don’t have to […]
Free Excel 404 URL Checker
Frequently, we are building PPC search campaigns pointing to many different URLs. How cool would it be to be able to check our dataset for 404 pages BEFORE we upload to AdWords, to Bing, or to Sklik? Read more to find out! Situation: You just build your search campaign for an e-shop. Your final URLs point […]
Autoclassify Keywords into Ad Groups with 1 Click – Try Now!
Everyone has gone through this: You just got hundreds and hundreds of new KWs which are supposed to be allocated into ad groups. You can do it either manually. Or as always… you can use some Power Query magic to help you out. ***Tip: Have a question? Ask in the comment section below or in […]
Generate Keywords Like a Boss!
Ever tried to build a massive KW list consisting of thousands and thousands of KWs by copying and pasting? Not fun, right?! There might a better way to do it. As you can see in the video below, it is relatively easy to build a custom refreshable & expandable KW generator in Excel which avoids […]
Excel & Power Query Campaign Builder for Paid Search: Step By Step Demo
In today’s post, we will have a look at a step by step demo of Power Query campaign builder. Watch the 4 minute video below showing how the campaign builder is built from nothing to full campaign setup. As you could see, all you needed is 6 sample tables to start with, then the entire […]