Constructing SQL Queries Using Google BigQuery Scripting
Let’s start with a simple question: for each tool in my product what fraction of daily active users per day visits the tool? Maybe not so simple so let me add some assumptions to simplify the solution. Daily active user is the one who visits at least one tool per day. You have a lot of tools in the product and you add some new tools from time to time....