This article describes potential use cases of Google Big Query 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 Big Query, you have to know SQL If you […]
Category: Excel/Google Sheets Functions
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. […]
Supermetrics for Google Sheets & PowerBI: 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 & PowerBI 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
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 files where multiple people can work at the same time. You would like to use this reference sheet as data source in Power […]
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 […]
Commonly Used Excel & Google Sheets Functions in PPC Industry
The attached file in this article lists all the handy functions used in the PPC industry. The functions are separated into 5 categories: Logic + Text functions Date functions Sum + Count functions LookUp functions Query function Grab a FREE working copy of the file here: https://goo.gl/DiOe4p Drop your comments below if you want to see […]