How to report on multiple Google Analytics accounts and currencies

Olga Tsubiks Analytics

Dealing with multiple Google Analytics accounts and currencies is something international ecommerce companies have to deal with on a daily basis. With some organizations tied to an official currency exchange rate constantly varying and different than those set in Google Analytics 360, working with multiple Google Analytics accounts, currencies, and maintaining dashboards, can be a challenge. One of our customers, …

Converting your time zone to local time in Google Analytics

Olga Tsubiks Google Analytics Data Leave a Comment

Visitors come to a website at different times of day. The heat map below represents a typical profile of a B2B company in North America. Users mostly come to the website during the week, whilst weekends have low traffic. The busiest time of the day is the morning, between 9:00 AM and 12:00 midday. This makes sense, as businesses engage …

Detecting and avoiding sampling in Google Analytics just got easier

James Standen Analytics Canvas Tool, Avoiding sampling 1 Comment

Sampling in Google Analytics helps speed up the response from GA, but it can serious affect the accuracy of the data you are looking at. Fortunately, Google Analytics has a great API, and with Analytics Canvas you can use a visual interface to get at your data, know when sampling is happening, and in many cases eliminate it. In our …

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

Olga Tsubiks Analytics, Google Analytics API, Tableau Leave a Comment

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 …

Understanding Google Analytics Conversion Funnels with Analytics Canvas

Olga Tsubiks Analytics, Analytics Canvas Tool, ecommerce Leave a Comment

The beauty of analyzing conversion funnels in Analytics Canvas is that you don’t have to wait for the data to be collected after you’ve set up your goals. You can create any funnel you want. Start by identifying your biggest funnel. Look at how the majority of visitors end up on your site: where they came from, and where they …

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

Olga Tsubiks Analytics, GA Metrics and Dimensions Leave a Comment

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 Tsubiks Analytics, Google Analytics API, Google Analytics Data Leave a Comment

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 Tsubiks Analytics, 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 quickly prepare your data for Tableau

Olga Tsubiks Tableau Leave a Comment

Do you need to prepare your data for Tableau? Sometimes getting there can be a tedious task. Extracting data from a variety of data sources, combining data from flat files, relational databases, CSV files and other data sources, cleansing, converting and aggregating, merging and splitting data just to get ready to load data into Tableau to search for insights. Does …