Omfg... this video is so well thought out. Step by step you show everything. This is extremely useful for people who are just starting the adventure with GDS. Thank you sooo much!
May I suggest a video - I like your teaching style from some others. 1. Relationship with what we learn X / Y ... i.e. X = "Dimensions" 2. When you have a Header of years 4 Quarters - How do I get Dimensions / X, to Have the 4 Qtrs - and the make tY the total Sum value? I 'm still looking how to do this Thank you!
Thanks for detail explaination.. Can you also help me how to enable the Restricted access to users for which the dynamic filter on 'Medium' (Source) attribute from the analytics model
Hello, thanks for the tutorial and helps a lot. I noticed that the conversion rate and the page view metric are not available in GA/Data Studio connection. Can you advise on this?
What if I only want to track specific conversions and not every single one of them. Can that be done? Or I think the right question is how can that be done?
What I really miss and where I have not yet found a solution are the missing costs as a KPI and all cost-based KPIs (CPC, Cost/Conv., ROAS). Doesn't anyone miss this? How do GA4 and Data Studio get together in this matter?
Hello, This video is very helpful. Thank you for sharing. I'm trying this on my own after watching your video but unsuccessful. How to show number of new customers on a particular web page vs. returning customers of each date for one week?
I have a problem. I connect with LS google sheet data in percentage terms e.g - sales realization 49%, but in Looker charts i see - sales realization 0,49. How to change numbers for % ?
Until they’re available in the GA4 API they won’t be available in Looker Studio, so you can either stick with GA4, recreate them using calculated fields, or wait until they’re added.
Excellent video! One question: DS is not giving me the option to group my elements, both using the right-click function and the arrange section. Any ideas on why this might be?
Thank you so much, Appreciate that you took the time to make it. Can you please help me with my query. I have created dashboards with Google Data Studio and we have integrated in the application, now everyone can able to view my Dashboards, now the new requirement, I have 100 users login in the application for each user how can i show the dashboard on that users data only.
What is the difference between Google analytics and Universal Analytics ? :) 2nd: If you have several websites, do you make 1 new gmail account per website and then send the data to the Data studio?? Thanks,
Hey man, this is a great video! Thanks a lot! I have an additional question, not entirely related to the content of this video but maybe you can help. So, in Data Studio I have a list of Final URLs from Google Ads. The list contains a bunch of different domains, some have , some are , some have the www. and others do not have the www. It makes the data quite messy and not aggregate nicely. In addition to this, many of the urls also end with a '?' followed by a bunch of paramenters after that. I am trying to figure out how to make a single regex replace formula that will do the following: 1) Remove the '.com' and all of the characters that preceed the .com 2) Remove the ? and all of the characters that come after the ? So far I have figued out how to only get rid of the ? and characters that come after it using this formula: REGEXP_REPLACE(Final URLs,"[?].*","") I have found that this other formula also does the same thing just as effectively: REGEXP_REPLACE(Final URLs, '\\?.+', '') So the question to you is: How can I edit either of these formulas to also remove the .com and everything before it?
I have never watched a tutorial that is explained in as much detail as you teach. Salute
Thank you so much!
The most helpful and comprehensive tutorial I've ever watch....kudos ! to "Loves Data" Channel :)
Omfg... this video is so well thought out. Step by step you show everything. This is extremely useful for people who are just starting the adventure with GDS. Thank you sooo much!
Thank you. I'm so a fan of your videos. Clear, simple and right to the point!
That's great to hear Max. Thank you for watching!
Wow!!
wonderful explanation👍
Thank you, That was very helpful for me.
Extremely useful and thoughtfully structured video. Thank you so much!
thanks for video , i would like to ask about how do you get actionable insights based on data?
This guys voice is so soothing and its make me sleepy
thank you for the explananation a tutoriall. so fun and clear
Loves Data, is always on point!
May I suggest a video - I like your teaching style from some others.
1. Relationship with what we learn X / Y ... i.e. X = "Dimensions"
2. When you have a Header of years 4 Quarters - How do I get Dimensions / X, to Have the 4 Qtrs - and the make tY the total Sum value?
I 'm still looking how to do this
Thank you!
Congratulations. This video has been so powerful to me. Appreciate that you took the time to make it.
Very well made tutorial & explanation. Subscribed
Super video, thanks very much! You are an excellent teacher.
Muchas gracias, saludos desde Buenos Aires.
Wow, almost 70K subs... Subbed:)
I love your videos and the way you teach! Thank you so much for your content.
Thanks for the video, it helped me a lot!
Thanks for detail explaination.. Can you also help me how to enable the Restricted access to users for which the dynamic filter on 'Medium' (Source) attribute from the analytics model
Explained very nicely
Thank you
Awesome, thank you!
Thanks for taking the time to make this. It was super helpful!
GREAT tutorial thank you!
Hello, thanks for the tutorial and helps a lot. I noticed that the conversion rate and the page view metric are not available in GA/Data Studio connection. Can you advise on this?
What if I only want to track specific conversions and not every single one of them. Can that be done? Or I think the right question is how can that be done?
This is an amazing video. I have a question though; my website has different subfolders by country, how can I pull the data from a specific subfolder?
Is it possible to create “real time” dashboards (the same way GA3 can show real-time traffic)?
What I really miss and where I have not yet found a solution are the missing costs as a KPI and all cost-based KPIs (CPC, Cost/Conv., ROAS). Doesn't anyone miss this? How do GA4 and Data Studio get together in this matter?
Thank you for these very nice and helpful training my question is where this google analytics data created ?
Wonderful
Great video, helpful indeed. Thanks a lot.
Hello, This video is very helpful. Thank you for sharing. I'm trying this on my own after watching your video but unsuccessful. How to show number of new customers on a particular web page vs. returning customers of each date for one week?
Thanks for the tutorial I love it
very useful! thank you!
This was really useful, thanks a lot
Hi
Can I connect 3 different google analytics accounts to 1 data studio dashboard?
I have a problem. I connect with LS google sheet data in percentage terms e.g - sales realization 49%, but in Looker charts i see - sales realization 0,49. How to change numbers for % ?
This is gold 👍
Hello, I noticed that the conversion rate and the page view metric are not available in GA/Data Studio connection. Can you advise on this?
Until they’re available in the GA4 API they won’t be available in Looker Studio, so you can either stick with GA4, recreate them using calculated fields, or wait until they’re added.
Hello! Will it be possible to extract this GA4 data to the Tableau? Thanks
Excellent video! One question: DS is not giving me the option to group my elements, both using the right-click function and the arrange section. Any ideas on why this might be?
Try simple cmd or ctrl + g
Thank you so much, Appreciate that you took the time to make it. Can you please help me with my query. I have created dashboards with Google Data Studio and we have integrated in the application, now everyone can able to view my Dashboards, now the new requirement, I have 100 users login in the application for each user how can i show the dashboard on that users data only.
Great!
What is the difference between Google analytics and Universal Analytics ? :)
2nd:
If you have several websites, do you make 1 new gmail account per website and then send the data to the Data studio??
Thanks,
Hi, thank you for your video. Its really helpful.
Do you mind sending your sample. It would make the practice better.
thank you so much
Help please
This does not seem like a ground level tutorial. Like what are those properties and when and where did he define those. Absolutely overwhelming 👎🏻
Hey man, this is a great video! Thanks a lot! I have an additional question, not entirely related to the content of this video but maybe you can help. So, in Data Studio I have a list of Final URLs from Google Ads. The list contains a bunch of different domains, some have , some are , some have the www. and others do not have the www.
It makes the data quite messy and not aggregate nicely. In addition to this, many of the urls also end with a '?' followed by a bunch of paramenters after that. I am trying to figure out how to make a single regex replace formula that will do the following:
1) Remove the '.com' and all of the characters that preceed the .com
2) Remove the ? and all of the characters that come after the ?
So far I have figued out how to only get rid of the ? and characters that come after it using this formula:
REGEXP_REPLACE(Final URLs,"[?].*","")
I have found that this other formula also does the same thing just as effectively:
REGEXP_REPLACE(Final URLs, '\\?.+', '')
So the question to you is: How can I edit either of these formulas to also remove the .com and everything before it?