Analytics

Knowing how users interact with your website can help you to see how well it is performing, and decide what changes to make in future to better achieve your goals. To do that you need to be able to collect data that is accurate and relevant, and then understand the story it is telling you. That, in layman's terms, is web analytics.

The two most popular web analytics tools are Adobe Analytics and Google Analytics, though only the latter is available as a free version.

19 July 2021
Using ARRAYFORMULA in your Google Sheets spreadsheet: why and how

The ARRAYFORMULA function in Google Sheets lets you perform the same operation on a range of cells without needing a formula in each cell.

13 June 2021
Permissions in Google Sheets: 'Viewers' can do even less than you might think

The Google Sheets 'Viewer' role stops you editing the content, but also means you can't resize rows or expand pivot tables.

12 May 2021
Finding your Cohort ID in Mixpanel - via the API or the interface

Using the Cohorts feature in Mixpanel? Here's how to find your Cohort ID, both via API and in the Mixpanel interface itself.

3 April 2021
Why your Google Analytics 'View' names are important... for Google Data Studio

How you name your Views in Google Analytics (Universal Analytics) can help avoid confusion in Google Data Studio later on.

27 November 2020
Tracking Forminator form submissions with Google Tag Manager (GTM)

How do you track Forminator form submissions as events in Google Analytics (Universal Analytics) using Google Tag Manager?

25 November 2020
Twitter data archive download: how long does it take and what does it contain?

Twitter lets you 'download an archive of your data'. Here's how long Twitter takes to prepare the data export (and what's in it).

16 November 2020
What does Google Analytics 4 mean for the GAIQ exam?

Google Analytics 4 has now been launched. How has the Google Analytics Individual Qualification (GAIQ) exam changed as a result?

11 October 2020
How to nest two (or more) REPLACE functions in one Google Data Studio formula

In Google Data Studio you can use more than one REPLACE function (or other functions if you like) within a calculated field formula. Just nest them!

4 October 2020
Google Analytics: how to filter out traffic from logged-in admins

You don't want your Google Analytics account to track your own activity. Rather than using an IP filter, just exclude traffic from logged-in admins.

19 July 2020
Spike in direct traffic? It could be Google Discover

Is Google Discover the cause of your 'direct' traffic spikes? Here's how to find out using Google Analytics and Search Console data.

James Clark
Hi! I'm James Clark and this is my website. Need help with your own website's analytics, SEO, content or ads? Contact me
Copyright © James Clark
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram