Build an SEO Dashboard in Looker Studio (Data Studio)

Поділитися
Вставка
  • Опубліковано 24 гру 2024

КОМЕНТАРІ • 90

  • @JohannBerby
    @JohannBerby 8 місяців тому +2

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

  • @robinwatts8374
    @robinwatts8374 11 місяців тому +2

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

  • @ThomasGrantMacDonald
    @ThomasGrantMacDonald 7 місяців тому +2

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

    • @apothecamarketing
      @apothecamarketing  7 місяців тому +1

      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.

  • @DipshiChakraborty-m3c
    @DipshiChakraborty-m3c 5 місяців тому +1

    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

  • @hasnainwaqass
    @hasnainwaqass 7 місяців тому

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

  •  Місяць тому

    Hi, I'm trying to build the report. At timestamp 10:20, you bring in a field 'USER CONVERSION RATE.' This field does not show up in my Looker Studio. Do you know how to fix this?

    • @apothecamarketing
      @apothecamarketing  29 днів тому

      If it hasn't been defined in your reporting, you can create a calculated field. If you click on the metric box, at the bottom there is an option for "add calculated field". You can just create your formula there (e.g., transactions/users).

  • @hadikhabir3654
    @hadikhabir3654 8 місяців тому

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

  • @saadalibhatti7606
    @saadalibhatti7606 Місяць тому

    really awesome. it helps me alot

  • @iikingvegasii
    @iikingvegasii 9 місяців тому +1

    Thanks again.

  • @fasihuddinmehsood7095
    @fasihuddinmehsood7095 8 місяців тому

    my subscription count to 999 Nice Video

  • @kfseomedia
    @kfseomedia Місяць тому

    Thank you!

  • @seo-tvg
    @seo-tvg Рік тому

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

  • @AseaFerreira
    @AseaFerreira 9 місяців тому

    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
      @apothecamarketing  9 місяців тому

      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.

  • @alineproenca9606
    @alineproenca9606 9 місяців тому

    thanks for the initial laughter!

  • @garciagonzalo1534
    @garciagonzalo1534 2 місяці тому

    Poco pelo pero mucha sabiduría. Una joya perdida en UA-cam.

  • @MaheshReddy-uj8fm
    @MaheshReddy-uj8fm 2 місяці тому

    Hi, I would like to set revenue conversion tracking in Google Analytics to my e-commerce website. I am unable to setup it. Could you please share some inputs Thanks for this video!

    • @apothecamarketing
      @apothecamarketing  2 місяці тому +1

      How conversion tracking gets set up is really based on the platform that you're using. For instance, if you have a Shopify site, you can use the Google & UA-cam app to send shopping cart and purchase data to GA4. For other platforms, you'll need to implement a data layer that sends that information to GTM and GA4 via javascript. Let me know what platform you're using, and we can look at doing a video for that.

    • @MaheshReddy-uj8fm
      @MaheshReddy-uj8fm 2 місяці тому

      @@apothecamarketing Thanks for response.

  • @DataStadium0902
    @DataStadium0902 9 місяців тому

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

  • @bozcze83
    @bozcze83 6 місяців тому

    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
      @apothecamarketing  6 місяців тому +1

      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.

  • @aymanmahmoud6865
    @aymanmahmoud6865 Рік тому

    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
      @apothecamarketing  Рік тому +1

      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.

  • @didigirl84
    @didigirl84 Місяць тому

    When I apply the filter always they show missing data when i reopen the report ?
    What is the solution for this?
    I am unable to share the report with the customers because of this problem

    • @apothecamarketing
      @apothecamarketing  Місяць тому

      It's difficult to say without seeing your report, but you may need to ensure that there's not another report-wide or dashboard controller or setting that is overriding your filter.

  • @codrutispasoiu
    @codrutispasoiu 8 місяців тому

    great tutorial!!!

  • @GleniLame-n4q
    @GleniLame-n4q Рік тому

    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
      @apothecamarketing  Рік тому +3

      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.

    • @nitishsingh8679
      @nitishsingh8679 Рік тому

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

    • @apothecamarketing
      @apothecamarketing  Рік тому

      We did! ua-cam.com/video/si4j6USTcVc/v-deo.html

  • @Sheobiii
    @Sheobiii 7 місяців тому

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

    • @apothecamarketing
      @apothecamarketing  7 місяців тому +1

      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
      @Sheobiii 7 місяців тому

      @@apothecamarketing EXCITED FOR THE VIDEO!!

  • @raiden6156
    @raiden6156 11 місяців тому

    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
      @apothecamarketing  11 місяців тому +1

      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
      @raiden6156 11 місяців тому

      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
      @apothecamarketing  11 місяців тому +1

      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.

  • @BoQbL1k
    @BoQbL1k 11 місяців тому

    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
      @apothecamarketing  11 місяців тому +1

      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

  • @BrianKenyon
    @BrianKenyon 2 місяці тому

    I always point out that bounce rate is just the opposite of engagement rate. It’s the opposite side of the same coin.

    • @apothecamarketing
      @apothecamarketing  2 місяці тому

      We like to look at engagement rate because the default Users metric in your GA4 traffic reporting is actually Engaged Users, not Total Users. Initially bounce rate wasn't available in GA4, but they brought it back, probably after a lot of complaints.

  • @WeJackDan
    @WeJackDan Рік тому

    Great video, thank you!

    • @apothecamarketing
      @apothecamarketing  Рік тому

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

    • @WeJackDan
      @WeJackDan Рік тому

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

    • @WeJackDan
      @WeJackDan Рік тому

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

  • @BenFischer-r5u
    @BenFischer-r5u 10 місяців тому

    Thank you for the video :D

    • @apothecamarketing
      @apothecamarketing  10 місяців тому

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

    • @Roman-cc8fh
      @Roman-cc8fh 10 місяців тому

      0:23 ​@@apothecamarketing

  • @semponmanickam5924
    @semponmanickam5924 4 місяці тому

    Can i get a month wise report in keyword page?

    • @apothecamarketing
      @apothecamarketing  4 місяці тому

      I'm not sure what you mean by "month wise". But if you'd like to compare your results to a previous month, you can just select the "compare" dropdown in the chart settings on the right side. If you mean something different, just let me know and I'll try to clarify.

    • @semponmanickam5924
      @semponmanickam5924 4 місяці тому

      @@apothecamarketingStep by step instruction to build the following SEO REPORT IN Google looker studio from the search console dataset
      CATEGORIZED Average position (LIKE BELOW AND COUNTS by each month

  • @tarikkhaan6255
    @tarikkhaan6255 10 місяців тому

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

    • @apothecamarketing
      @apothecamarketing  10 місяців тому

      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.

  • @ahmedmadbouly409
    @ahmedmadbouly409 11 місяців тому

    that is very good , thanks

  • @adanbouzoua
    @adanbouzoua Рік тому

    Thx for the video

  • @hvac1649
    @hvac1649 10 місяців тому

    THIS IS SO FKING USEFUL.

    • @apothecamarketing
      @apothecamarketing  10 місяців тому

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

  • @CesarToloza-t6i
    @CesarToloza-t6i Рік тому +1

    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!

  • @cristianburca2730
    @cristianburca2730 4 місяці тому

    best

  • @BayuHendra-wb2zx
    @BayuHendra-wb2zx 10 місяців тому

    Hallo me only thas information

  • @اكرم-ح1ن
    @اكرم-ح1ن Рік тому

    وإذا كنت لااملك كمبيوتر فقط هاتف 😮

    • @apothecamarketing
      @apothecamarketing  Рік тому

      I think this is one situation where you will need a desktop to effectively work with Looker Studio.

  • @astravelercom
    @astravelercom 4 місяці тому

    +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?

    • @apothecamarketing
      @apothecamarketing  4 місяці тому +1

      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.

    • @astravelercom
      @astravelercom 4 місяці тому

      @@apothecamarketing Thanks for a quick answer, I am waiting for more looker studio videos!

    • @apothecamarketing
      @apothecamarketing  4 місяці тому

      Let me know what you'd like to see in Looker.

    • @astravelercom
      @astravelercom 4 місяці тому

      ​@@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?

    • @apothecamarketing
      @apothecamarketing  4 місяці тому

      That's an interesting problem. Let me do some digging and get back to you.