Problem A client needed to simplify the management of their massive Google Ads shopping feed. The client is running this setup: They have around 300,000 unique items in their feed. In reality, there are “only” around 12,000 unique physical products spread over 23 different combinations of e-shop domains and countries. The client needs to frequently […]
Category: Excel/Google Sheets Functions
Simple 404 Checker in Google Sheets with Scheduler
Checking for broken links is one of the boring tasks every digital marketer should do on a regular basis so his/her budget is not wasted on people landing to broken pages. The common question I’ve been getting is: “How can we check for broken links in Google Sheets on regular basis?” Well, today, I’m releasing […]
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.
Google BigQuery: Automation Powerhouse for Google Ads
This article describes potential use cases of Google BigQuery for automating management of your Google Ads accounts. It’s based on 4 months of personal intensive experience. I don’t know everything but I know enough to share some thoughts and basic directions. Before deep diving into BigQuery, you have to know SQL If you don’t know […]
Send Google Sheet File as Attachment in Scheduled Email with Supermetrics
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 […]
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 […]
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 […]
How to Do VLOOKUP in Power Query?
Sooner or later, everyone needs to match data from one table to another based on a common key. In standard Excel, VLOOKUP function would be used. In Power Query, “Merge” function needs to be used. So how does “Merge” in Power Query work? Simpler than you think. It is actually simpler than then writing VLOOKUP […]