If you’re interested, these are the things that you should do:
- Go to your Google Analytics Dashboard first then keep record of your Analytics ID. Open any Google Spreadsheet then go to Tools > Script Editor and paste this code.
- Save the entire code, close the Apps Script window then get back to the spreadsheet that you want to keep track of. Choose an empty cell by clicking it then put the Google Formula inside it.
- Lastly, open the Google Spreadsheet that you’re taking track of in a new window then go to Google Analytics Real-time Overview to see if the tracking code is working or not. Wait for a little while since the tracking also takes time before it gets recorded.
Once the tracking is in place and is in working condition, you’re now ready to go.