Build an SEO Dashboard in Looker Studio (Data Studio)

Рет қаралды 15,449

9 ай бұрын

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

Пікірлер: 64

@robinwatts8374 6 ай бұрын

One of the most useful tutorial videos I've seen... thank you!

@apothecamarketing 6 ай бұрын

Glad it was helpful!

@ThomasGrantMacDonald Ай бұрын

Nice tutorial. I am researching reporting tools and this was exactly what I was needing. Subscribed!

@apothecamarketing Ай бұрын

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.

@JohannBerby 3 ай бұрын

Your videos are so helpful. Thanks a lot, you helped me a lot!!

@apothecamarketing 3 ай бұрын

Glad to hear that!

@hasnainwaqass Ай бұрын

Amazing! It's really a great stuff! Thanks a lot!

@apothecamarketing Ай бұрын

Glad it was helpful!

@DataStadium0902 4 ай бұрын

It's really a great stuff! Thanks a lot!

@apothecamarketing 4 ай бұрын

Glad it was helpful!

@seo-tvg 7 ай бұрын

What interesting video, I dont know english but I understand very well. Thank u

@apothecamarketing 7 ай бұрын

Thank you!

@iikingvegasii 4 ай бұрын

Thanks again.

@alineproenca9606 4 ай бұрын

thanks for the initial laughter!

@codrutispasoiu 3 ай бұрын

great tutorial!!!

@apothecamarketing 3 ай бұрын

Glad you liked it!

@hadikhabir3654 3 ай бұрын

love your video bro it is so useful we need more like this Quick Note : Love your Smile Keep the good work bro

@apothecamarketing 3 ай бұрын

Thank you so much 😀

@DipshiChakraborty-m3c 21 күн бұрын

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

@apothecamarketing 21 күн бұрын

Sure! Great idea.

@adanbouzoua 9 ай бұрын

Thx for the video

@apothecamarketing 9 ай бұрын

I hope it was helpful!

@user-mh8br2it5w 5 ай бұрын

Thank you for the video :D

@apothecamarketing 5 ай бұрын

My pleasure! I hope it's useful for you.

@Roman-cc8fh 5 ай бұрын

0:23 @@apothecamarketing

@ahmedmadbouly409 5 ай бұрын

that is very good , thanks

@apothecamarketing 5 ай бұрын

Glad you like it!

@WeJackDan 7 ай бұрын

Great video, thank you!

@apothecamarketing 7 ай бұрын

Glad you liked it! Let us know what other content you'd like to see.

@WeJackDan 7 ай бұрын

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

@apothecamarketing 7 ай бұрын

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".

@WeJackDan 7 ай бұрын

@@apothecamarketing ok, i'll take a look at it. Thank you for your answer, have a nice day!

@aymanmahmoud6865 7 ай бұрын

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

@apothecamarketing 7 ай бұрын

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.

@BoQbL1k 5 ай бұрын

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

@apothecamarketing 5 ай бұрын

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

@AseaFerreira 3 ай бұрын

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?

@apothecamarketing 3 ай бұрын

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.

@bozcze83 28 күн бұрын

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?

@apothecamarketing 28 күн бұрын

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.

@user-ve6nn3ho3y 8 ай бұрын

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?

@apothecamarketing 8 ай бұрын

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 (kzfaq.info/get/bejne/sKqprbN3qNzbdYU.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.

@nitishsingh8679 7 ай бұрын

@@apothecamarketingwe definitely have this issue. Are you still making a video on this?

@apothecamarketing 7 ай бұрын

We did! kzfaq.info/get/bejne/qc9knZmGuLrHhpc.html

@raiden6156 6 ай бұрын

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?

@apothecamarketing 6 ай бұрын

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.

@raiden6156 6 ай бұрын

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

@apothecamarketing 6 ай бұрын

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.

@Sheobiii 2 ай бұрын

So helpful!!!! How about a blog analytics dashboard? We want to track the success of our blog posts in our e-commerce site.

@apothecamarketing 2 ай бұрын

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.

@Sheobiii 2 ай бұрын

@@apothecamarketing EXCITED FOR THE VIDEO!!

@hvac1649 5 ай бұрын

THIS IS SO FKING USEFUL.

@apothecamarketing 5 ай бұрын

Thanks! I'm glad you find it useful. Let us know what other content you'd like to see.

@tarikkhaan6255 4 ай бұрын

Please guide me how to get work by having a skill looker studio?

@apothecamarketing 4 ай бұрын

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.

@user-od8jq5nz2o 8 ай бұрын

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!

@apothecamarketing 8 ай бұрын

Noted!

@BayuHendra-wb2zx 5 ай бұрын

Hallo me only thas information