Google Big Query: Automation Powerhouse for Google Ads

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 […]

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 […]

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:¬† Drop your comments below if you want to see […]