Problem Yet another customer approached me to solve their reporting needs when it comes to digital marketing campaigns. The customer wanted to aggregate these sources: Google Ads (ad group level) Microsoft Advertising (ad group level) Ringba (call tracking and routing system) A few reference tables in Google Sheets The expected outcome was a nice Power […]
Category: Power BI & Power Query
Case Study: Solving Digital Marketing Agency Reporting in 2 Weeks
Problem A client approached me with an evergreen problem: “My agency reporting sucks, can you help?”. Oh, I so had not heard that one before! (Actually I had). This was the client’s situation: Digital marketing agency is servicing around 20 customers. All reporting used to be done in standalone Excel files on client level. First […]
Make/Integromat in the BI World: Will It Work?
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** I’ve always wondered whether you can use Integromat for making your life easier in the BI/analytics world where I am partially coming from. As I’ve been becoming more familiar with Integromat ecosystem I can say “yes“. […]
FREE No-DAX Calendar for Power BI – No More Copying!
Have you ever imagined how nice it would be if you did not have to create your Power BI calendars in DAX or in Power Query? Here is the solution. FREE Always updated calendars in Google Sheets for everybody.
Merge vs. Append in Power BI in Power Query Editor
Let’s get to Power BI basics today. You might be wondering, what’s the difference between “Merge” and “Append” button in Power BI‘s Power Query Editor. This article will explain that. The short story is that: The Merge button is an equivalent of JOIN in SQL. It’s also similar to LOOKUP function in Excel, but behavior […]
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 […]
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 […]