Skip to content
Roman Prokashev.

This is an archive of the Last Click City blog, which was published at lastclick.city from 2019 to 2024.

Category

Google Analytics

From the Last Click City archive.

Myths About Bounce Rate.

June 30, 2020

Before evaluating your website efficiency with the bounce rate, define your website goals clearly. Does your goal involve multiple-page visits or events (in other words, multiple requests to the GA servers)? If it doesn’t, a high bounce rate will probably be acceptable. Continue reading

Reverse Page Path in Google BigQuery.

May 7, 2020

BigQuery export for Google Analytics is one of the most powerful tools, which can show you up to three of the steps preceding goal completion. But, to my bewilderment, there isn’t an option to obtain a similar report which can show you the reverse top paths to a particular page. Such reports can undoubtedly be useful in many cases when a user’s journey to a specific page needs to be analyzed. Let’s try to build it using BigQuery. Continue reading

Google Analytics user-based events funnel in BigQuery.

April 24, 2020

There are a few ways to create an event funnel in Google Analytics. The first is the default events flow report but everyone who has tried this report will know that it’s only suitable for the superficial analysis of small resources. When you work with data of a significant size it’s impossible to avoid sampling and therefore, it is challenging to analyze certain events. Continue reading

Custom Dimensions in Google Analytics.

February 22, 2020

Google Analytics provides us with a large number of useful dimensions that help us understand what is happening on the website. But to make full use of GA opportunities, you should definitely use custom dimensions. Only custom dimensions will allow you to get a lot of data that are not tracked automatically, e.g., you can export some information from your CRM or add some domain-specific dimensions. Continue reading

Campaign Timeout: A Google Analytics Setting That Matters

August 16, 2019

Usually, Google Analytics implementation includes a few steps such as testing the tag, configuring the settings in the Admin panel and setting up all necessary permissions and integrations. It can be quite easy – especially if you are new to GA – to miss something important. Continue reading

Pulling out the next page visited by new users in Google BigQuery.

June 28, 2019

Suppose that you have a particular landing page on your website, and you want to understand how it works for new users: how often they abandon the site after visiting this page or, for those who continue, which pages they visit afterwards. You could try to find these data in Google Analytics – it appears that the Navigation Summary report was invented for exactly this purpose and, to some extent, this is true. Continue reading

Top Conversion Paths in Google Analytics and BigQuery.

February 5, 2019

Understanding top conversion paths can be a crucial part of the customer journey analysis and an important step towards better understanding of how marketing channels cooperate. It is particularly useful to know the top paths to conversion when planning marketing and advertising budgets. Continue reading