Posts

Import Google Analytics 4 (GA4) Data to Google Sheets for free

Image
We already know when Google Analytics Universal will stop working, but Google still didn't share free add-on like for Google Analytics Universal which enables downloading data directly in Google Sheets and most important to schedule it. Maybe my solution isn't perfect but it's for free and you don't need to use any servers etc. What did I do? 1) Under Extension  I selected   Apps Script 2) I added new Service AnalyticsData (v1beta version) 3) I clicked See documentation to find good example how to apply it in Google Apps Script https://developers.google.com/apps-script/advanced/analyticsdata?authuser=0  4) I copied code from the documentation into my sheet and launched some changes - instead of creating a new sheet every time I seleced a sheet name where generated data should be pasted (marked by pink) 5) Last step was running the code - before it is run for the first time you will be asked about permission  This is example of very simple report in GA4, without ...
Post a Comment
Read more

Connecting Blogger to GTM and creating tag for linkClick

Image
I already can see that some events are being sent automatically via GA4, but never enough, i decided to create a GTM  container as well. I didn't work with GTM for a while and never felt proficient with this tool so maybe now i'll learn something.  Here's what i did: 1) Created a new container (nothing complicated) 2) I followed by inctructions given by Google, i opened code editing section the same as last time (Theme --> edid HTML [drop down list close to 'customize' button] I pasted code excatly as it says, but i got an error, but i was not the only one with this error, I found solution  here . I also got recomendation from GTM to use Tag Assistant Companion extension, which i did. Turning on Preview mode in GTM This is how preview mode should look after correct GTM code implementation let's try to tag something! Let's say i want to tag Read more  button: 1) I turned on Preview mode 2) I clicked Read more on the blog, which opened in the new window 3...
Post a Comment
Read more

Connecting Blogger to Google Analytics 4

Image
 Okay,  i'll try to connect to the GA and i will describe this (with timing to build a pressure for myself) 25.04.2022 20:43 I googled how to connect blogger to GA - i decided to go with this one:  https://blogtimenow.com/blogging/add-google-analytics-blogger-blog/ 20:47 (there was a setting which allows to create GAU, but in advanced options, i know that GA4 is still not perfect but i'll try) 20:52   I decided not to follow the instructions because the article was about GAU, and I've done this before (a long time ago), so maybe I'll get away with it. My step by step adventure: 1) I selected web, because it's a blog (you should be automatically directed to settings, if no try:  Admin -> Data Stream (in property section) 2) I created a new stream  Okay, i did it before for GAU, to do it for GA4 i had to watch a   video    Here's what i learned: 3) You have to select your data stream details in the Admin section 4) Then copy gtag.js fro...
Post a Comment
Read more

Test

Hello! This post is to see if I'm able to track blog events, I haven't connected it to Google Analytics yet (GA4, [can I still create a GAU or GA3 as it's called lately?]), but luckily I was able to change the background to a nice color link: test test
Post a Comment
Read more