5 Tips For Emergency Plumbing Situations
24 November 2023
Protecting Sensitive Data In Office Environments
21 November 2023
83 Black Friday Software Deals 2023
21 November 2023
Reduce Workplace Injuries On Construction Sites
20 November 2023
Trending Music Hashtags To Get Your Posts Noticed
24 August 2018
How To Fix iPhone/iPad Only Charging In Certain Positions
05 July 2020
Trending Wedding Hashtags To Get Your Posts Noticed
18 September 2018
Trending Fashion Hashtags To Get Your Posts Noticed
05 April 2018
Tracking Google Sheets Views With Google Analytics
So you've gotten used to Google Analytics and have been happily tracking your visitors (or page views) on your website, but the buck usually stops there. Any property you do not personally own can't be tracked, and you may be losing out on valuable insights. If you're someone who uses GA sheets extensively especially for external use like creating templates then you would want to know how well they're doing, right?
The way I see it you have two options, one option is to just give up on gathering that data or try option two with a little bit of grit you can track views inside Google Spreadsheets. All you would need to do is insert a little snippet of tracking code inside your spreadsheet, and when someone opens the sheet, that visit will be recorded permanently in your Google Analytics account.
Tracking within properties, you do not own
How to track Google sheet views
- To get started you will need to have your Google Analytics tracking ID on hand.
- Next open any Google Spreadsheet that you wish to track and go to Tools, Script Editor and copy-paste the following code. This is a custom Google Spreadsheet function that will embed the 1×1 tracking GIF image in our spreadsheets.
- Save the code, close the Apps Script editor window and return to the spreadsheet.
- Click an empty cell and insert the following formula. The cell will be blank, but it contains an embedded image.
Note: You may want to change the background colour so it is easy to figure out which cell in the spreadsheet contains the tracking formula.
Test your tracking
Now open the spreadsheet in a new browser window and go to Google Analytics, Real Time, Overview to test if the tracking is working. If you would like to see all the visits and historical data, go to Behavior – Events – Overview and click on the Google Spreadsheets category.
For those trying to mask their usage
This tracking method will work even if the user has enabled ad blocking because of they way google Google Spreadsheets is set up. Like Gmail, Google sheets serves images through a proxy server. The downside is that you will never know the location of the visitor since all visits will show up as United States (the location of Google servers).
For more uses for this method check out our post - How To Track Email Open Rate With Google Analytics
If you want to know more about tracking options for your site, don’t be shy we’re happy to assist. Simply contact us