In cooperation with our partner project www.MythicalReports.com, we are launching our first ever product for the masses: a free add-on for Google Sheets called “BigQuery Uploader for Google Sheets”. If you work a lot with Google BigQuery, you probably know by now that it is a bit cumbersome to get multiple sheets from one Google Spreadsheet […]
Category: Analytics
Having Troubles with Setting Up Your PPC Reporting Architecture?
Many of us are trying to solve the same problem: How do I get world class PPC reporting which is reliable. relatively cheap and is not complicated to manage? Well, I have been through this as well. Where did I end up? Read more to find out. Stage 0: No reporting Basically, you have no […]
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 […]
How to Process Auction Insights Data from AdWords in Bulk
Analyzing Auction Insights data from AdWords is painful because you cannot segment the data by campaign. At the same time, the data is not accessible by API. So what if you want to analyze Auction Insights for X campaigns at once? Power Query is here to help. In today’s article, I will provide you with […]
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 […]
Google Data Studio vs. Power BI
Google Data Studio has been public for a while. It has already changed PPC reporting routines of many people. But how does Google Data studio compare with Microsoft’s Power BI which has been on the market for few years? Read more to find out. This article will NOT tell you which tool is better or the […]
How To Build Excel Refreshable Reports in 5 Minutes Without Macros
In today’s post, we will look at building simple Excel refreshable reports WITHOUT using any macros. Typical scenario: You get files with performance data on a regular basis (daily, weekly). E. g. CSVs, TXTs, XLSs, XLSXs… You just want to take these files, drop them into a folder and refresh your pivots without copying & pasting […]