Build an SEO Dashboard in Looker Studio (Data Studio)
ฝัง
- เผยแพร่เมื่อ 12 ต.ค. 2023
- Pulling together your SEO reporting in GA4 can be a pain. Numerous clicks, less than spectacular data visualization can be a headache. We take a look at how to build a dynamic dashboard in Looker Studio (formerly Google Data Studio), Google's free data visualization tool, using data from GA4 and Google Search Console.
==============
Learn More About Apotheca Marketing:
www.apothecamarketing.com
==============
Check Out Our Podcast!
==============
Spotify: open.spotify.com/show/2DKfhZI...
Apple: podcasts.apple.com/us/podcast...
Google: podcasts.google.com/feed/aHR0...
Stitcher: www.stitcher.com/show/1026249
Pandora: www.pandora.com/podcast/real-...
Join us on social media!
==============
Facebook: / apothecallc
Instagram: / apothecamarmarketing
Twitter: / apothecallc
TikTok: / apotheca
![FULL Google Data Studio Course (2023) ➡️ rebranded to Looker Studio) [Compilation]](http://i.ytimg.com/vi/dsAVSsdYC10/mqdefault.jpg)
One of the most useful tutorial videos I've seen... thank you!
Glad it was helpful!
Your videos are so helpful.
Thanks a lot, you helped me a lot!!
Glad to hear that!
Thanks again.
What interesting video, I dont know english but I understand very well. Thank u
Thank you!
It's really a great stuff! Thanks a lot!
Glad it was helpful!
Thx for the video
I hope it was helpful!
great tutorial!!!
Glad you liked it!
Great video, thank you!
Glad you liked it! Let us know what other content you'd like to see.
Well i don't even know if it is possible, but i've created a tag on GTM which now appears on GA4 but i'd like to show this event performances on Looker Studio but i don't know how to link them so i could put in my looker studio dashboard @@apothecamarketing
For the new event to be available in your reporting you'll need to add it as a custom dimension in GA4. In the new admin setup go to Admin > Data display > Custom definitions > Custom dimensions tab and click "create customer dimension".
@@apothecamarketing ok, i'll take a look at it. Thank you for your answer, have a nice day!
thanks for the initial laughter!
Thank you for the video :D
My pleasure! I hope it's useful for you.
0:23 @@apothecamarketing
love your video bro it is so useful we need more like this
Quick Note : Love your Smile
Keep the good work bro
Thank you so much 😀
that is very good , thanks
Glad you like it!
thank you for this great video. One question. We have GA4 since July 2023, and universal analytics before that. And I believe this is what most people setup currently is. I wanna look at the year over year changes for all the metrics you showed. I do have both GA4 and universal analytics loaded on Looker Studio. How can I do this?
Great question. One thing to consider before doing this is that the metrics will not be exactly the same in Universal as they are in GA4, since GA4 fundamentally redefined how things like sessions, users, conversions, etc., are recorded (th-cam.com/video/zDyzPFCvwEQ/w-d-xo.html). You can pull in your historic data from UA, and then create two different data sources and cards/graphs in Looker. You could then blend that data to create a unified report. We'll look at doing a video to walk through this, since I'm sure other people are having this issue as well.
@@apothecamarketingwe definitely have this issue. Are you still making a video on this?
We did! th-cam.com/video/si4j6USTcVc/w-d-xo.html
Hi, thank you for this video. I have a question. Will this dashboard update in real time by itself? So in a weeks time, will one then see the current relevant data?
It will pull in all historical data as soon as you create it (if that data exists in your data source, such as GA4). You can control the date range of the report and the individual charts, so it updates based on the range that you provide. Keep in mind, however, that GA4 is typically 24 hours behind in its reporting.
Good evening, I have a question for our honorable professor. Is it possible, through Looker Studio, that I can enter data into a table as is the case in an Excel sheet? I have another question: Can I hide the Google Sheet file menus and toolbar from the user when entering data and he cannot show the menus such as the File, Edit, or Format menu? Thank you and we apologize for the length
You can connect your Looker Studio dashboard directly to a Google Sheet, so that when someone adds data it is reflected in your dashboard, The only input option directly in a dashboard is an input box, which essentially acts as a search box. I imagine that you could accomplish this data entry by using a Google Form, which would feed the data points directly to your Sheet without giving the user access to the spreadsheet.
So helpful!!!! How about a blog analytics dashboard? We want to track the success of our blog posts in our e-commerce site.
Great idea. We're actually working with a company that creates sites for blogs and publishing companies, so we can show what we've been building for them.
@@apothecamarketing EXCITED FOR THE VIDEO!!
I can't figure out how to create a field (not a row) in which the total amount will be calculated across the entire field and output to the gand total field
You'll need to use calculated metrics. Here's a quick link to Google's instructions. We'll also do a video on this since it's a question we get a lot. support.google.com/looker-studio/answer/9372465?hl=en
Hi. Can you explain how to create a chart that shows your impressions in various cities? Currently I have a chart that breaks down views, bounce rate, and engagement rate of various cities in California. However, when I try to add "organic Google search impressions" as a metric the chart breaks. Do I have to blend data? And if so, can you explain how to do that?
Impressions data, which comes from Google Search Console only reports on metrics by country. Theoretically, you'll need to blend User geo location from GA4 with impression data from GSC. I haven't tried this myself, so it may not work. We'll look at doing a video about this since I'm sure it would be useful for other folks as well.
I would greatly look forward to that video because I've been banging my head against the wall on this (still new to Looker Studio)
Thanks!@@apothecamarketing
It is frustrating, because some metrics that are available in GA4, are not available in Looker. We'll take a look and see if we can figure this out for a video.
THIS IS SO FKING USEFUL.
Thanks! I'm glad you find it useful. Let us know what other content you'd like to see.
Please guide me how to get work by having a skill looker studio?
That could be a lengthy conversation! There are many companies that can use assistance with setting up useful dashboards and reporting. One thing we've seen other companies doing is creating dashboard templates, which they then sell. So that's one possibility for you.
I like your video, but definitely you need to put a headshot and focus on the guide, it is not relevant to only see you talking about the GA4 platform etc, without being able to follow.
Thanks!
Noted!
Hallo me only thas information
وإذا كنت لااملك كمبيوتر فقط هاتف 😮
I think this is one situation where you will need a desktop to effectively work with Looker Studio.
my subscription count to 999 Nice Video
Nice! Thanks!!