Supermetrics for Google Data Studio: a Biased Review from a Power BI Fan

If you are a frequent visitor of this blog, you probably already know by now that I’m a big Power BI fan thanks to its endless customization options, especially in the Power Query editor. However, I will take a step back today. Not everybody needs to have an advanced and super-customized reports. In this article, […]

Generate PPC Keyword Lists with SQL in BigQuery

If you run massive search accounts with millions of keywords created based on templates, it can get really tricky to regularly generate such keyword lists on scale on daily basis for example. You can: Write your keywords manually. Good luck with that. Do some copying and pasting in Excel/Google Sheets. Good luck with making no […]

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

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