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
One of the most useful tutorial videos I've seen... thank you!
Glad it was helpful!
Nice tutorial. I am researching reporting tools and this was exactly what I was needing. Subscribed!
Great to hear! I'm glad it was helpful. Let us know if there are other topics or tools that you would like to learn more about.
Your videos are so helpful.
Thanks a lot, you helped me a lot!!
Glad to hear that!
Amazing! It's really a great stuff! Thanks a lot!
Glad it was helpful!
It's really a great stuff! Thanks a lot!
Glad it was helpful!
What interesting video, I dont know english but I understand very well. Thank u
Thank you!
Thanks again.
thanks for the initial laughter!
great tutorial!!!
Glad you liked it!
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 😀
Thx for the video
I hope it was helpful!
that is very good , thanks
Glad you like 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!
Very helpful content. Could you please create a video for a non e-commerce website. You had mentioned that websites might use lead forms/blogs/articles. It would be really helpful to know what metrics might be relevant for such websites
Sure! Great idea.
Thank you for the video :D
My pleasure! I hope it's useful for you.
0:23 @@apothecamarketing
Hello :) Thank you for a helpful content :) Do you know why average position in Looker Studio isn't the same as in Google Search Console?
It depends on how you're pulling that data into Looker Studio. If you're using the data connector for GSC, then it should be the same if you're looking at the same dates. However, if you're pulling the data from GA4, there is often latency in the reporting by at least 24 hours. Some other factors that could impact this are: date ranges, filters or segmentation.
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.
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
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.
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 (ua-cam.com/video/zDyzPFCvwEQ/v-deo.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! ua-cam.com/video/si4j6USTcVc/v-deo.html
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!!
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!!
+1 subscriber! Any ideas on how to do a comparison on page 2 only for the clicks in the table, rather than all the columns?
Unfortunately the comparison is for the entire chart/table, so it will apply to all columns. You can create a table or card that just shows clicks, but otherwise the comparison applies to all the data.
@@apothecamarketing Thanks for a quick answer, I am waiting for more looker studio videos!
Let me know what you'd like to see in Looker.
@@apothecamarketing Maybe you can help me out? I am trying to do a calculation between two fields sessions and filtered organic sessions to show what percentage SEO traffic takes. And I cannot find a way to do it with filter applied (with the one you showed). Any ideas?
That's an interesting problem. Let me do some digging and get back to you.