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 […]
Month: June 2017
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 […]