Google Data Studio complete FREE tutoria - Made for marketers, by marketers.
Вставка
- Опубліковано 23 лип 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, UA-cam, 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... - Наука та технологія
Even though it's for marketing, it's the ultimate guide intro for G-Studio I have seen so far. Thank you, Sir!
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!
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.
Wow! That was some tutorial! Explained in a super simple way and crisp. Thank you so much Juan!
This is terrific information - I love your encouragement - you're an excellent teacher!
We are glad it was helpful!
Man...normally i warch 2x speed, but here its so fast with so much value, i cant keep up. great stuff
Great tutorial! Thank you very much! Just what I needed!
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/
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
Excellent tutorial, Thank you! 👍
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!
Great job, Juan! Thanks a lot. Very useful!
Best tutorial in UA-cam! Please make more!
Simple, organised and to the point thanks so much
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!
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
Very helpful to define the dimension and metrics! Thank you :D
Happy to help!
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
Awesome tutorial amigo. Muchas gracias and keep grinding!
well done, excellent presentation. can feel the passion through the video. well done again!
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!
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.
Absolutely amazing teaching skills. Well done!!!!
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/
Huuuge like! Juan, really great job!
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 tutorial, thank you so much !
We are glad you enjoyed it!
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/
Sooo amazing! Thank you so much, bro!
Really well-made and helpful tutorial. Many thanks
Thank you Pratish! we are launching new videos very soon about Google Data Studio
Absolutely fantastic!!!
amazing tutorial.. great work (y)
This is one of the best tutorials!!! Very detailed and clear!!! Thanks a lot Juan!!!!
You're very welcome!
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. Thank you
Excellent video. Exactly what I needed to start using Data Studio. Thank you!
Glad it was 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/
Great video, We could understand what is Data Studio with this single video.TQ
Thank you Gopal! new content is coming soon :)
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 so much sir, your content is gold
Great tutorial Juan!
Thank you very much! :)
You are awesome! Thank you for all your tricks.
Glad you like them!
Thank you for the very informative and easy to follow tutorial.
Glad it was helpful!
Holistic, very useful indeed
Thank you
Great video thank you. Do you have a tutorial to show how to add date comparisons to tables?
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!
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
Muy bueno y facil de entender. Gracias!
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!
great video, thumb up :)
Wonderful, Thanks for sharing
This is incredible
Great tutorial Juan, thanks
Glad you liked it!
By: Juan
Very helpful! Thanks Juan! Ah vengo de Platzi
¡Excelente! ¿Ya empezaste a automatizar tus reportes?
Thank you very much... a fantastic video.
Glad you liked it!
Incredible content.
This is very helpful, unfortunately there is no double like for this hahahah, good job man.
I appreciate that!
Great tutorial :)
Thank you! Cheers!
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
¡Muchas gracias!
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!
Very good!
Thanks!
great, thanks
excellent tutorial!!!
Thanks for watching it, Michele! Many more coming.
God bless you!!!
Gracias gracias gracias!!!
hi, bro in the drop-down menu if I'm not selecting anything that time also value showing??? single-selection ???
Its awesome.
Good video for modelling diferent type of data ...now ..what about actionable insights on that data? For e-commerce example
Thanks and May Allah bless you...
That's helpful thanks
Happy to help
Thank you
Gracias por el tutorial !!
¡Gracias Chistian!
Chingon tutorial!
Me inspiras!! No tienes campo para un discípulo...? A la orden...
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!
very nice explanation. Great
Glad it was helpful!
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
What formula would I use to create a new field as a rolling 7 day average?
Too good
Good ideas
Hello, how big the data file that could be able to connect from google sheet to google data studio?
Can we automate the dashboard dynamically in Datastudio with Big query as datasource
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
I have been trying to add a report level filter to page 1 that would effect all other pages. I have multiple accounts with large data. I would like the user to go to page 1, apply the filters they would like by parent account first, and then select the child account and it will apply to the whole report. I don't see a way to add a drop down list that will apply to all of the pages. Is this possible?
This is lit af
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 Good tutorial.
Thank you Sebastian!
I'm from Germany and we have quite strict data policy rules. Do you have info how'd be if I'd connect it with our channels based in Germany?
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
REALLY VERY NICE EXPLANATION .BUT HOW CANI ACCESS CRM TEMPLATE
I was not able to find the crm template. Can you help please?
Could you help me out how to arrange the months in chronological order in a graph chat. I'm only able to sort the month by ascending or descending but not JFM... and so on.
Are the fields set as Year Month or is it a text string?
Cool Paisano :)
Thanks Luis!!
Hi,
I have two fact tables (data sources), factACTUAL and factBUDGET, and two dimension tables, dimCOA and dimDate. I can link/blend one of the two dimension tables to both fact tables, but I can only link the second dimension table to one of the two fact tables.
Has anyone overcome this problem before?
I can't find the data set you used in google sheet connector
hi may i know how to make funnel chart?
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/ :)
Please how to do I connect my shopify data to google data studio?