Google Analytics Calculated Metrics: Why limit yourself to 5 metrics per view when you can get as many as you want?

Olga TsubiksAnalytics, GA Metrics and Dimensions

Currently in beta and available only for properties using Universal Analytics, Calculated Metrics are user-defined metrics that are calculated from existing Google Analytics metrics, such as sessions or hits. If you are using Universal Analytics, you can set up Calculated Metrics by going to Admin > View > Calculated Metric. You will then be asked to define the formula, provide …

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 …

Join Us for the Tableau Conference

Olga TsubiksAnalytics, Tableau

We are excited to be a Kilobyte Sponsor for the Tableau conference in Las Vegas from 19th to 23rd October. Visit our booth #502, and talk to us about the importance of data preparation and automation of your Tableau dashboards – and of course to pick up one of our free t-shirts! Do you have dirty data? Are you dreaming …

How to boost Facebook page engagement

Olga TsubiksAnalytics, Tableau

Are you managing a large number of Facebook pages for your clients? Curating, posting, crafting and scheduling content, listening to and engaging with fans, measuring and analyzing your effort…it can be time-consuming and laborious. And it can be hard to grasp the preferences of fans for each page. In order to help you cut through the noise, we’ve created a system that …

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 …

Content Analysis on high traffic websites using BigQuery

James StandenAnalytics, Analytics Canvas pro tips, Google BigQuery

Using Analytics Canvas and Google BigQuery, it is possible to do detailed content analysis for sites with 10s of millions of annual visitors, even with Google Analytics Standard. In this blog post we outline how to avoid sampling and load detailed content analysis data into BigQuery. Analytics Canvas provides the solution. Google Analytics Premium obviously gives you many more options …

Google Analytics unsampled reporting Automation

James StandenAnalytics, Automation, Avoiding sampling, Google Analytics Premium, unsampled reports

If you are a Google Analytics Premium user and hate all the clicking and downloading involved with unsampled reporting, you’ll be happy to hear that Analytics Canvas fully supports the complete automation of unsampled reports thanks to functionality newly released by Google. As a Google Analytics technology partner and part of the trusted testers program, we’ve been working with a …

BigQuery SQL Generation demo at GA Summit

James StandenAnalytics, Google Analytics Premium, Google BigQuery

A few weeks ago, hundreds of die hard Google Analytics types converged on San Francisco from all over the world for the Google Analytics Summit. The attendees included Google Analytics Certified Partners, Google Analytics Premium customers, and a small group of Technology partners (including Analytics Canvas). We were invited by Google to present our latest developments to the attendees, and …

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, …