ETL Google Analytics data into your data warehouse

Ameet WadhwaniAnalytics Canvas Tool, Google Analytics API

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 …

How to create an In-Page Analytics Report using Google Analytics API and Tableau

Olga TsubiksAnalytics, Google Analytics API, Tableau

The In-Page Analytics Report provides a valuable visual representation of the performance of a particular web page. It is very handy for making a quick visual assessment of how users are interacting with the page. And it is a crucial report for web page optimization and testing. Do you want to include In-Page Analytics into your Tableau reports? We are …

Answer These 4 Questions To Help Uncover Your Conversion Funnels

Olga TsubiksAnalytics, Google Analytics API, Google Analytics Data

What is it that turns website visitors into paying customers? What is the process they go through to become subscribers or customers? These two questions are of paramount importance for e-commerce companies, but what if your website does not have a shopping cart? How do you analyze conversion funnels for non e-commerce websites? Chances are, you’ve found the answers to …

Session vs Page level dimensions in Google Analytics

Olga TsubiksAnalytics, Google Analytics API

Google Analytics provides a huge list of dimensions and metrics in its API, but it is important to understand the different levels of granularity represented. Some dimensions are session level dimensions- they relate to entire sessions, and some dimensions are page level dimensions and relate to a specific page. Lets look at an example- we can look at a report …

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 …

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 …

Analytics Canvas V1.6 Released- Cost upload, advanced funnels and easy access to hundreds of GA profiles

James StandenAnalytics Canvas Tool, ecommerce, Google Analytics API

We are pleased to announce the latest release of Analytics Canvas, with new features and upgrades that provide even more powerful access to your analytics data. Google Analytics Cost upload and Bing Ads API connectivity Advanced funnel Analysis Enhanced GA profile management for those accessing hundreds of profiles at once Advanced query partitioning to avoid sampling Cost Upload into Google …

Avoiding sampling in Google Analytics for your year end reporting

James StandenAnalytics Canvas Tool, Avoiding sampling, Google Analytics API

Are you working on year end reporting? If you use Google Analytics, and had more than 500,000 visitors this year and want to use an advanced segment in your reporting (and you should use segments, because segments rock) then it means it is also time to deal with sampling. A query trying to see Non-paid search by source ignores 94% …