Make/Integromat Case Study: Web App to Simplify Management of PPC Shopping Feed

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

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

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