For most people, 2 Billion rows is an incredible amount of data that they will never have to process, ever. Yet long before hitting the 1M row limit of an Excel workbook, the 5M cell limit of a Google Sheet, or the limits of a database, performance will seriously degrade. Then the trade-offs begin – process less data, or spend …
We are pleased to announce the release of Analytics Canvas Version 3.5.0! In this release we’ve dramatically increased the limits on the size of Data Studio datasets, introduced append and incremental load functionality to Data Studio exports, and prepared Canvas Desktop for the introduction of Analytics Canvas Online. Append + Incremental Load = 2 Billion Rows in Google Data Studio! …
Imagine Google Sheets without row limits and BigQuery without SQL As a data-prep tool with lots of connections into the Google ecosystem, we have quite a lot of customers using Google Sheets together with Google BigQuery, Google Data Studio and a number of other data sources. So we were delighted when we heard that Ben L Collins, a Google Developer …
Data Studio makes great looking reports and dashboards, and at a price point of free for everyone, Google is obviously making it easy to afford. But many organisations find a number of key challenges and “connection does not exist” errors when connecting Google Data Studio to a database… 3 serious problems when connecting Google Data Studio to a database Even …
There are lots of good reasons to pull Google Analytics data into spreadsheets or databases for reporting and analysis. You can get rich details not available in the web interface, you can blend it with internal data sources, you can extract large volumes of unsampled data in bulk, and so much more. For these reasons, Google Analytics APIs have been …