If you look at Google Analytics sessions to check for high level metrics such as sessions day over day, then you are probably fine and you don’t really experience any issues. The things start to get a little complicated and frustrating when you try to get more complex data involving multiple dimensions and metrics over […]
Category: Analytics
How to Get Data from BigQuery to Google Sheets?
As BigQuery becomes more popular many of you are asking a simple question: How does a person get data from BigQuery to Google Sheets on a regular basis? There are a couple options so let’s look at them on by one. Native Connector from Google If you are running “Enterprise Plus” or “G Suite Enterprise […]
Supermetrics: Which Product Is Right for You?
In today’s article, we’ll look at Supermetrics product portfolio. I will try to answer the basic question – which of the products is right for you? I still remember days when there was just Supermetrics for Google Sheets. Well, those days are gone and the product portfolio has grown quite a bit. The current list […]
Supermetrics for Excel: Quick Start Guide
Supermetrics for Excel is one of the last products from Supermetrics which I had not interviewed. In today’s article, I will walk you through its setup process, the good, and the bad of the DESKTOP version of the product. So please by seated and let’s start. Why Would You Even Want to Use Supermetrics for […]
How to Get CallRail Data to Google Sheets
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** Everyone running lead generating campaigns will sooner or later come to the point where calls need to be tracked and reported on. One of the widely used call tracking solutions is CallRail. The problem with CallRail […]
How to Get Facebook Ads Data to Google Sheets?
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 […]
Persistent User Defined Functions Now Supported in BigQuery!
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?
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, […]
FREE No-DAX Calendar for Power BI – No More Copying!
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.
Supermetrics for BigQuery: Step by Step Guide
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 […]