So you’ve been running your Facebook campaign for a while and now it’s time to make a simple dashboard in Google Sheets. The main question is: How can I download Facebook Ads data to Google Sheets? The answer is Supermetrics for Google Sheets. The Process First of all, you need to install Supermetrics for Google […]
Finally, BigQuery users have option to save their custom functions so they can be re-used across the project. Up until now, you could only create a UDF function within a query but you could not save the query as a view for example. Luckily, the times are changing now. But why should you care?
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, […]
Have you ever imagined how nice it would be if you did not have to create your Power BI calendars in DAX or in Power Query? Here is the solution. FREE Always updated calendars in Google Sheets for everybody.
In April 2019, Supermetrics team announced their new product called Supermetrics for BigQuery. So let’s have a look on what this thing does and why it could be useful for you – especially when you run massive accounts. Here some of the questions you might be asking: Why the hell should I care? I am […]
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 […]
Many of 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 […]
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. […]
Update on 2019-04-30: Recent Excel updates caused the version 1 of the tool stop to work. I updated the files but I recommend you use Excel 2016 on Windows and install all the updates. If you still experience issues, let me know and I will try to troubleshoot individually. Search term report is a useful […]
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 […]