In this post, we’re going to create a tool that calls the Fathom Analytics API and pastes website traffic data into Google Sheets:
But first, a quick backstory:
Earlier this year (2022), Google announced the sunsetting of the old implementation of Google Analytics, in favor of GA4.
At the time I was running the old Google Analytics software, implemented through Google Tag Manager (along with Facebook’s pixel tracker).
It was time for me to update my web analytics software.
But I didn’t want to just shove GA4 into my existing tag manager setup. From what I’d heard, GA4 was difficult to use and way overblown for my needs.
So I cast around for alternative analytics software and landed on Fathom.
Fathom Analytics is a lightweight, easy-to-use, privacy-focused analytics software that is perfect for my website.
It was ridiculously easy to set up and I’ve been delighted with how easy it is to use. I jump in and can quickly see everything I need to know for my website:
Continue reading How To Get Fathom Analytics Data Into Google Sheets, Using Apps Script
Since Google Sheets are files in the cloud, not on your desktop, you can’t click on a cell in a different Sheets file to connect them.
Instead, you use the IMPORTRANGE function in Google Sheets to connect Google Sheet files and import data from one Sheet file into another.
Once set up, the function will automatically sync with the source data so that changes are reflected in the destination Sheet.
If you look closely, you’ll see a URL in the formula — the URL of the source Google Sheet file, where the data is being imported from.
Continue reading How To Use The IMPORTRANGE Function In Google Sheets To Transfer Data From One Sheet To Another
In this post, you’ll learn how to copy only visible cells in Google Sheets so that you only paste the results you want and don’t include any hidden data.
For this tutorial, we’ll use this dataset, shown in full to begin:
Now suppose that columns B and C, and rows 6 – 9, are hidden so the data looks like this:
If you just highlight this data and copy it, then when you paste it elsewhere the hidden data shows up.
So, how do you copy only visible cells?
Continue reading How To Copy Only Visible Cells In Google Sheets
In this post, you’ll learn how to find and highlight the top 5 values in Google Sheets.
For all the examples that follow, we’ll use this dataset, which is available in the downloadable template at the end of this post:
We’ll see how to highlight the rows with the top 5 values, as well as how to extract those values using SORTN.
Continue reading How To Highlight The Top 5 Values In Google Sheets With Formulas
The SEQUENCE function is a useful function in Google Sheets. It’s a powerful way to generate numbered lists.
=SEQUENCE(rows, columns, start, step)
As arguments for the SEQUENCE function, you specify 1) the number of rows, 2) the number of columns, 3) a start value, and 4) a step size.
Arguments 2, 3, and 4 are optional. However, if you want to set them you need to include the previous ones (e.g. if you want to set a step size in argument 4, then you need to set 1, 2, and 3 as well).
Keep this order in mind as you look through the examples below and you’ll soon understand how the function works.
1. Ascending list of numbers
Continue reading Build Numbered Lists With The Amazing SEQUENCE Function