Frequently, you will find yourself creating a same IF function (or any other function) over and over and over and over… So why don’t we just create the function ONCE and then keep re-using this function over and over and over…? Read more to find out how to build your own custom function exactly fitting […]
Excel Tranining for PPC? Try Power Query Instead
Looking for Excel training for PPC? Try Power Query instead and stay miles ahead of your competition. Power Query (aka Get & Transform) is a set of Excel features which can totally replace standard Excel which is slow, inefficient and too complicated to use. Power Query (Get & Transform) is an official Excel extension built […]
List Functions: an Elegant Way to Manipulate Text
List functions can become your favorite set of functions if you often need to manipulate text (aka “keywords”). You are now probably wondering what “list” function even means in Power Query. Basically, a “list” is a special object whose elements can be easily manipulated separately. ***Tip: Have a question? Ask in the comment section below […]
Google Data Studio vs. Power BI
Google Data Studio has been public for a while. It has already changed PPC reporting routines of many people. But how does Google Data studio compare with Microsoft’s Power BI which has been on the market for few years? Read more to find out. This article will NOT tell you which tool is better or the […]
IF Function in Power Query for Advanced
In the previous article, we looked at IF function basics. Today, it is time to look at more advanced stuff. Spoiler alert: nested formulas included. For all the samples, we will be using the following image as basis: A sample Excel file with applied IF functions can be downloaded here: Text Editor Is Better than […]
IF Function in Power Query for Beginners
The best function of all times. IF function. Everyone has heard about it but only few can use it. So how does IF function work in Power Query? Well, there is a button for that. As usual. You will be able to complete basic IF conditions purely with the “IF function help wizard”. For the […]
Power Query vs. Excel Functions Cheat Sheet
I often get questions such as “Is Excel function XYZ available in Power Query as well?”. Well, you are now about to find out. Let’s focus on functions which we frequently use in the PPC industry. ***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up […]
Using Google Sheets as Data Source in Power Query (Power BI)
Google Sheets have replaced Excel in a lot of companies so how do Google Sheets get along with Power Query (Power BI)? Actually pretty well. Sample scenario: You store reference sheets via Google Sheets files where multiple people can work at the same time. You would like to use this reference sheet as data source […]
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 […]
Should You Start Using Power Query for PPC?
No, if you have Mac. Unfortunately, PQ is not supported on Mac yet. More information here. You can still use virtual Windows machine but it is quite cumbersome. So how about old school Windows users? Hell yes, you should! In this article, I will cover why I think PQ is good (maybe the best) tool for […]