Analytics Canvas Google Sheets add-on released

James StandenGoogle Spreadsheets add-on

We’re very excited today to release Analytics Canvas for Sheets, a Google Sheets Add-on. You can get Analytics Canvas for sheets here. If you love Sheets, and you love Google Analytics, we think you’re going to love our Add-on, a way to very quickly define a dashboard template, and share it, switching effortlessly between different GA views and mixing and …

Google Analytics adds demographic data and minute level resolution to Core Reporting API

James StandenGoogle Analytics API

Google announced some new dimensions recently, and thanks to the Google Analytics meta data API support in Analytics Canvas they were available immediately to all Analytics Canvas users. One of the interesting developments is an increase in the time resolution from hour to minute. This opens up all sorts of time of day analysis to sites using Google Analytics. It …

Google Analytics isMobile and isTablet have left the building

James StandenGoogle Analytics API, Google Analytics Data

Google has announced a very important change is coming to your Google Analytics data- if you track device types using isMobile and isTablet dimensions they have been eliminated. But don’t worry, you’ll still be able to understand what devices are being used by using the new deviceCategory dimension, and you have at least 6 months as per the Google Analytics …

Analytics Canvas V1.6.7 with Google Spreadsheet and PostgreSQL connectivity

James StandenAnalytics

Google Docs is a powerful solution and provides an amazing colaborative environment. We are thrilled to announce that Analytics Canvas now connects to Google Docs, allowing users to import data directly from Google Spreadsheets. Check out the video of it in action. PostgreSQL is the most advanced open source database and a key part of the Ruby on Rails stack, …

Understanding Google Analytics Sampling- Sample Size and Sample Space

James StandenAvoiding sampling, Under the Hood

Understanding Google Analytics Sampling, Sample Size and Sample Space Nobody likes sampled data if they can have the exact data. Using Analytics Canvas, in the vast majority of cases you can eliminate sampling from Google Analytics. The Google Analytics core reporting API has some new features in the area of sampling that will let Analytics Canvas users understand exactly how …

Analytics Canvas V1.6.4 released with Automation Wizard

James StandenAnalytics Canvas Tool, Automation, Data warehousing

Are you spending huge amounts of time just getting the data ready, rather than actually doing analysis? You can eliminate mindless work by automating your data extraction using Analytics Canvas Automation Wizard. Imagine coming in on Monday morning and being able to get right into analysis- rather than first having to spend hours or days exporting, cleaning and combining data …

The key difference between segments and filters

James StandenAnalytics Canvas pro tips, Google Analytics API, Under the Hood

In the Google Analytics API, there are two important ways to focus in on a particular slice of your analytics data. Segments and filters. In many cases, the result of these two very different functions are the same. But they are fundamentally different, and it is important to understand how they work particularly when looking deep into your data using …

New Google Analytics Dimensions and Metrics- Analytics Canvas V1.6.3 has them

James StandenAnalytics Canvas Tool, Google Analytics API

Today Google announced 40 new dimensions and metrics that are now available in the Google Analytics API, and we’re pleased to release Analytics Canvas V1.6.3 that provides access to all of them. Our clients expect us to keep up with the API in all respects, and we’re proud to be able to same day release new features thanks to being …

Google Analytics and Google BigQuery- Oh My!

James StandenAnalytics Canvas Tool, Google Analytics Premium, Google BigQuery

Googles announcement at Google IO that session and hit data was going to be available in Google BigQuery marks a significant milestone in Google Analytics relentless drive into the Enterprise analytics market. UPDATE: Check out how Analytics Canvas is the tool for BigQuery GA Premium integration with SQL Generation. Google mentions a number of scenarios that become possible with this …

Can’t Wait for the Migration Guide? Combine GA and UA with Analytics Canvas.

Ameet WadhwaniUniversal Analytics

The team at nModal was at the Google Analytics Partner summit in October 2012 when Google first announced Universal Analytics. We were floored. The implications of this change are simply enormous. Actually measuring offline to online conversion? Tying the use of a loyalty card in store to purchases online? Tracking a visitor across multiple channels and devices to see how …

Access Multiple Google Analytics Accounts, Properties, and Views to Create Summary Reports

Ameet WadhwaniMultiple GA Accounts

There are many use cases for having multiple Google Analytics accounts, properties and views. A consumer goods company with a website for each brand, a hotel chain with a site for each location, or an agency with many clients, for example. Google’s front-end solution provides a summary of each individual view and allows you to access and export the data …

How to eliminate sampling by using the Google Analytics API

James StandenAnalytics Canvas Tool, Avoiding sampling, Google Analytics Premium

Sampling can drastically reduce the accuracy of data queried from Google Analytics, but by using the API in many cases it can be eliminated. Google Analytics is clearly an enterprise capable analytics platform. As higher and higher traffic websites take advantage of its features, Google has put in place some limits on how much data can be included in a …