Google Data Studio vs. Power BI

***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.*** 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 […]

IF Function in Power Query for Advanced

***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.*** In the previous article, we looked at IF function basics. Today, it is time to look at more advanced stuff. Spoiler alert: nested formulas (aka “vnořené funkce”) included. For all the samples, […]

Using Google Sheets as Data Source in Power Query

***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.*** Google Sheets have replaced Excel in a lot of companies so how do Google Sheets get along with Power Query? Actually pretty well. Sample scenario: You store reference sheets via Google Sheets […]

Free 404 URL Checker

***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.*** 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, […]