Google Data Studio complete FREE tutoria - Made for marketers, by marketers.
Vložit
- čas přidán 29. 06. 2024
- 🚀Start reporting now on Google Data Studio with our free templates: portermetrics.com/en/templates/
Learn all you need to know to automate your marketing reports on Google Data Studio.
Google Data Studio is a free data visualization tool that will let you connect your marketing (or any) data from apps like Facebook, Google, CZcams, Instagram, LinkedIn, and more.
In this tutorial, we go through all the steps to automate your marketing reporting:
0:00 Introduction to Google Data Studio
11:50 How to create a Google Data Studio account and connecting data
20:47 Creating Charts and Graphs
30:06 Filters and Controls
36:30 Create Formulas
39:14 Case Statements / Case When
43:26 Regular Expressions / REGEX
47:47 Blending Data
53:15 Customize your Google Data Studio Report
58:40 Share your reports and learn how to schedule an automated mail to see your report
Additional resources🎁:
Google Data Studio connectors:
portermetrics.com/en/connectors/
Google Data Studio tutorial (blog post version): portermetrics.com/en/tutorial... - Věda a technologie
Juan, this is one of the best tutorials on ANY topic! I watch a lot of tutorials and you are truly gifted. You tell me what is going to be covered, you explain the reason you are doing things, and you don't make too many assumptions about my knowledge level. Truly amazing and greatly appreciated!
Man...normally i warch 2x speed, but here its so fast with so much value, i cant keep up. great stuff
Even though it's for marketing, it's the ultimate guide intro for G-Studio I have seen so far. Thank you, Sir!
Wow! That was some tutorial! Explained in a super simple way and crisp. Thank you so much Juan!
This was very clear and to the point. Thank you for approaching it from a complete beginner level and keeping a high level of motivation and positivity, even the more complex things were explained simply. clearly and concisely. I wish all tutorials could be like this!
This is a very comprehensive tutorial on Google Data Studio. It is by far the best tutorial I've had. Thank you so much.
Excellent tutorial, Thank you! 👍
This is terrific information - I love your encouragement - you're an excellent teacher!
We are glad it was helpful!
Best tutorial in CZcams! Please make more!
Great tutorial! Thank you very much! Just what I needed!
Simple, organised and to the point thanks so much
Gracias por el tutorial, me sirvio bastante para entender como crear reportes y poder desarrollar mejores dashboards para storytelling
Thank you for the tutorial, it was usefull to understand how to create automated reports and be able to develop bettrer dashboards for storytelling
Great job, Juan! Thanks a lot. Very useful!
Awesome tutorial amigo. Muchas gracias and keep grinding!
well done, excellent presentation. can feel the passion through the video. well done again!
This is exactly what I needed and you really did deliver it very well. And yeah pushing people to make the effort on things like case and regex which within a day or two of practice they'd get. Keep it up!
Glad it was helpful! Don't forget to subscribe for more content!
Very helpful to define the dimension and metrics! Thank you :D
Happy to help!
absolutely amazing tutorial man!!! cant explain more and better in 1 hour
Thank you Alberto! If you need to automate your marketing reporting, let us know ;) we are here to help
Probably one of the best Data Studio trainings out there. I've watched a few in the last 3 months and there are not many that are that good.
Hi Irene! thank you so much for your comment. At Porter we create free Google Data Studio templates for the community, if you want to take a look, here is the link: portermetrics.com/en/templates/
Great tutorial man - very helpful!
Thank you! If you want you can join to our Facebook group facebook.com/groups/learndatastudio. We discuss and answer questions about Google Data Studio
amazing tutorial.. great work (y)
Absolutely amazing teaching skills. Well done!!!!
Huuuge like! Juan, really great job!
Great tutorial Juan!
Excellant bro. I am going to use. You are the only boss for my Google data studio. Your way of speech and body language is awesome.
Great info. Subscribed! Looking forward to more content. Thank you!
Thank you Victoria! you can also subscribe to our weekly GDS templates at portermetrics.com/en/templates/
Great tutorial, thank you so much !
We are glad you enjoyed it!
Absolutely fantastic!!!
Sooo amazing! Thank you so much, bro!
This is very helpful, unfortunately there is no double like for this hahahah, good job man.
I appreciate that!
Muy buen tuto, Juan. Data Studio es una buena herramienta y la voy a utilizar en mi trabajo. Con esto aprendo lo que necesito para hacer gráficos y como ya sé R, lo único que necesito es vincular mis fuentes desde R con mis hojas de Google Sheets para tener unos dashboards robustos. ¡Gracias!
Great video. The best I have seen so far on this topic. Thanks a lot!!
Thank you so much! if you want free Google Data Studio templates visit us at portermetrics.com/en/templates/
Thanks Juan. This is a fantastic tutorial. I loved the entire tutorial and was glued to my screen throughout. Thanks so much.
Glad it helped!
Really well-made and helpful tutorial. Many thanks
Thank you Pratish! we are launching new videos very soon about Google Data Studio
Thank you Juan. You made it simple and straightforward. I never knew it was possible to write SQL case directly on looker
Glad you find it helpful!
Great tutorial, thanks buddy!!! God bless you
Thank you! Remember I have dozen of free templates for Google Data Studio on portermetrics.com/en/templates/
Juan, thank you for this fantastic GDS explanation! It's really useful for complete newbies like me. You not only lead us through GDS, but you also demonstrate how to create a report by beginning with questions. That's fantastic! Keep up the good job!
Glad it was helpful!
Great tutorial. Thank you
great video, thumb up :)
Holistic, very useful indeed
Thank you
thank you so much sir, your content is gold
Very good indeed. Very clear, understandable and informative. Well presented.
Hi! Thank you very much for watching it (I'm Juan, the instructor). Let me know if you have any questions :D
Thank you very much! :)
This is one of the best tutorials!!! Very detailed and clear!!! Thanks a lot Juan!!!!
You're very welcome!
Great video, We could understand what is Data Studio with this single video.TQ
Thank you Gopal! new content is coming soon :)
Excellent video. Exactly what I needed to start using Data Studio. Thank you!
Glad it was helpful!
Thank you for the very informative and easy to follow tutorial.
Glad it was helpful!
You are awesome! Thank you for all your tricks.
Glad you like them!
amazing tutorial video, you made points clear and easy to understand
Glad it was helpful!
Thanks a lot for creating such a nice tutorial. It was very helpful.
Glad it was helpful! if you need to automate your marketing reports, let us know
Very helpful! Thanks Juan! Ah vengo de Platzi
¡Excelente! ¿Ya empezaste a automatizar tus reportes?
Muy bueno y facil de entender. Gracias!
This is incredible
Wonderful, Thanks for sharing
Hey , This is first time in my life I watched such a long vdo till the end. Its eye opening and very helpful. Huge respect from bottom of my heart. Sekhar, India
Glad you liked it!
Hi Juan, thank you for your detailed tutorial, which is so helpful and just what I need to start from zero in Google Data Studio. Have a nice day.
You are welcome!
Great video thank you. Do you have a tutorial to show how to add date comparisons to tables?
Great tutorial Juan, thanks
Glad you liked it!
By: Juan
Incredible content.
Thank you very much... a fantastic video.
Glad you liked it!
Great tutorial :)
Thank you! Cheers!
excellent tutorial!!!
Thanks for watching it, Michele! Many more coming.
Very good!
Thanks!
¡Muchas gracias!
Chingon tutorial!
Me inspiras!! No tienes campo para un discípulo...? A la orden...
Its awesome.
great, thanks
Gracias por el tutorial !!
¡Gracias Chistian!
God bless you!!!
Gracias gracias gracias!!!
This is lit af
Too good
That's helpful thanks
Happy to help
very nice explanation. Great
Glad it was helpful!
Cool Paisano :)
Thanks Luis!!
Thanks and May Allah bless you...
Good ideas
Thank you
A Good tutorial.
Thank you Sebastian!
Excellent video, I loved it, thank you very much!!!!!
Doubt when you do the formula, I have two scorecards that come from the same field, but each of them has a different filter, one is by date of entry (sum all that came in on the day) and the other by date of exit (sum all that left work on the day), how do I do the operation to add me both amounts since GDS does not recognize them as individual fields? thanks for your help
Good video for modelling diferent type of data ...now ..what about actionable insights on that data? For e-commerce example
Nice video, Juan! I subscribed. What program are you using to do this presentation? It's very clean.
Thanks Andrey! We edited it with Adobe Premiere
Such a great video, but I think you should have made it in ESPAÑOL. Very helpful.
Juan, how do you create a DS dashboard for a specific URL or a range of URLs of a website?
And another question is, as we all know, GA4 has a brand new interface and the way it presents information and the way we consult that information is very different from GA3, so my question is if do reports in datastudio connecting GA4 , are designing the same way we do/did with GA3 and as you explained on the video? Or do we have to pay attention to any particular pointers? Do you have videos about it? Thanks!
REALLY VERY NICE EXPLANATION .BUT HOW CANI ACCESS CRM TEMPLATE
thank you.....:)
You're welcome 😊
Hi Juan I was wondering if you know how can we minimize the font of comparison kpi metrics 'from previous days' in google data studio. Thank you!
Plz guide us how we can add traffic light color on Max, Min, Average data as on data studio as we do in Pivot table
#amflearningbydoing awesome
What formula would I use to create a new field as a rolling 7 day average?
thank fot you video tutorials, i want to ask you about user login at google data studio. how to create it, could you make a tutorial. Thank you.
A comprehensive introduction to Data studio. At 38.55 how did you magically convert a scorecard to a timeline. I was not able to do this magically.
Se me acabó el tiempo en Platzi así que acá estamos! :)
Excelente, esperamos que puedas seguir aprendiendo de Google Data Studio!
Juan Jose for President!!
hi, bro in the drop-down menu if I'm not selecting anything that time also value showing??? single-selection ???
Hello, I am looking for a single sign on solution for Data Studio. We inserted a few DS reports on a website and are looking for a way for external users to sign onto the website once and access all the DS reports without us having to invite them to each report page separately
Can we automate the dashboard dynamically in Datastudio with Big query as datasource
hello!! Amazing video. i have a question. Why the currency value is in dimension at 21:01 shouldn't it be in metrics because it is a value?
Yes! actually, it's shown as a metric. You can confirm this with the '123' symbol beside the name of the metric.
Hello, how big the data file that could be able to connect from google sheet to google data studio?
Is there a way to do a time series chart that focuses on a specific url page views over time? If so, how do you do that? Or do you have a video explaining how?
Nicole, to do that you should insert your time series chart and choose the page views as the metric and the date as the dimension. Then, create an inner filter for the time series chart that only shows that specific url. If you have questions write us on our live chat on portermetrics.com/en/home/ :)
Did you not share the database? I was looking for it to follow the same reasoning as yours and of course, to practice.