Are you wondering how to send Google Sheet files as attachments in scheduled emails? If you are a coder, you can code your own GoogleApps script. However, not everyone is a coder right? (yet). So what about dummies like me who cannot really code? Well, there might be an easy to use solution for you. […]
N-Gram Analyzer for PPC Search Terms
Search term report is a useful source of information – based on search terms, you can add new positive KWs into your account or you can add new negatives. We all know that. There is one more thing you can do with your search terms (or keywords). You can create an “N-Gram” report to see […]
How to Process Auction Insights Data from AdWords in Bulk
Analyzing Auction Insights data from AdWords is painful because you cannot segment the data by campaign. At the same time, the data is not accessible by API. So what if you want to analyze Auction Insights for X campaigns at once? Power Query is here to help. In today’s article, I will provide you with […]
Supermetrics for Google Sheets & Power BI: The Ultimate PPC Reporting Combo
Everyone is currently playing with Google Data Studio. However, there is also an alternative reporting combination which no one is using: Supermetrics for Google Sheets & Power BI from Microsoft. So let’s have a look on this solution. In this article, I will cover some advantages and disadvantages of this combination and I will walk you […]
Creating Loops/Iterations in Power Query
Ever wondered how to iterate over a series of objects in Power Query? Let’s have a look on that. In this article, I will be covering how to create loops/iterations in Power Query. In our sample example, we will have a simple flat table with 3 columns: Country, Variant, Clicks. The goal is to determine […]
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 […]
Power of Filters in Power Query
Filters are important part of every Power Query project and should not be underestimated. Let’s have a look on how to easily build & optimize your filters. As usual, the difficulty will increase with every following example. ***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign […]
Web.Contents Function: Secret Web Crawling Weapon in Power Query
From time to time, you need to work with data which is living somewhere online so let’s have a look on how Power Query can help you. I will be describing various scenarios which I personally tested multiple times. ***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can […]
Recommended Power Query Settings
One should never underestimate settings in Power Query. So let’s have a look on few recommendations which can save you lots of pain in future. This articles covers only the most relevant settings (not all). Settings not covered in this articles are usually self-explanatory. How to Navigate to Power Query Settings In Power Query, follow […]