The ARRAYFORMULA function in Google Sheets lets you perform the same operation on a range of cells without needing a formula in each cell.
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.
The ARRAYFORMULA function in Google Sheets lets you perform the same operation on a range of cells without needing a formula in each cell.
The Google Sheets 'Viewer' role stops you editing the content, but also means you can't resize rows or expand pivot tables.
Using the Cohorts feature in Mixpanel? Here's how to find your Cohort ID, both via API and in the Mixpanel interface itself.
How you name your Views in Google Analytics (Universal Analytics) can help avoid confusion in Google Data Studio later on.
How do you track Forminator form submissions as events in Google Analytics (Universal Analytics) using Google Tag Manager?
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).
Google Analytics 4 has now been launched. How has the Google Analytics Individual Qualification (GAIQ) exam changed as a result?
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!
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.
Is Google Discover the cause of your 'direct' traffic spikes? Here's how to find out using Google Analytics and Search Console data.
