Use Google Sheets for Tracking and Analytics 📉📊📈
Google Sheets is an awesome cloud-based Spreadsheet App that you can use to do analyse data. But it can also be use as a light-weight tracking solution. We can send data in and store it in a spreadsheet - In this video we are going to show you how
OUTLINE:
0:00 - Introduction
1:16 - Prepare Your Google Sheet
2:28 - Pull Data to Google Sheets from GTM Using Google AppScript
2:40 - Create Your Script
4:05 - Publish
5:02 - Add Static Query Parameters to Your URL
6:10 - Add Dynamic Query Parameters to Your URL
6:38 - Create a Google Sheet Tag in GTM
7:51 - Testing
MENTIONED LINKS
Google Sheet Dashboard for GA • Google Analytics Dashboard with Google She...
Pass dynamic data to Google Sheets using Google Tag Manager http://www.ganotes.com/pass-dynamic-d...
🎓 Measure Masters Membership: https://measureschool.com/measure-mas...
❓ Take Our GA4 Quiz: https://measureschool.com/google-anal...
FREE Tag Manager Course: https://measureschool.com/products/fr...
FREE Analytics Course: https://measureschool.com/products/fr...
🔀 GTM Copy Paste - Our Chrome extension https://chrome.google.com/webstore/de...
🚀 Hire us: https://measureschool.com/services/?u...
📚 Recommended Measure Books: https://kit.co/Measureschool/recommen...
📷 Gear we used to produce this video: https://kit.co/Measureschool/measures...
📡 Our Live Streaming Software: https://restream.io/join/YXLM2
👍 FOLLOW US
Facebook: / measureschool
Twitter: / measureschool
LinkedIn: / measureschool