How to Use Google Sheets for SERP Analysis

Поделиться
HTML-код
  • Опубликовано: 7 сен 2024

Комментарии • 28

  • @j_yh
    @j_yh 3 года назад +1

    Rock solid! Excellent primer...thank you! This really has my wheels turning.

  • @xinluo1199
    @xinluo1199 Год назад

    oh man, you just save my life !! thanks a lot for this sharing!!

  • @like.a.cactus
    @like.a.cactus 2 года назад +1

    Depending on your language configuration, (or something else), a coma "," may not work, so try with semicolon ";" that worked for me.

  • @praveenchandrasekaran7064
    @praveenchandrasekaran7064 3 года назад +3

    Hi, bro
    Your videos are very informative. If anyway to track the keywords position via Google sheet. Kindly share it bro

    • @smamarketing
      @smamarketing  3 года назад +1

      Tracking the positions is a little tougher. You can use APIs to pull them, link SEMRush. You used to be able to pull directly from the SERPs into Google Sheets, but that no longer works.

    • @praveenchandrasekaran7064
      @praveenchandrasekaran7064 3 года назад +1

      @@smamarketing can you please make a video for serp tracking

    • @smamarketing
      @smamarketing  3 года назад

      @@praveenchandrasekaran7064 Let me see what I can put together!

  • @kumarharshkumar
    @kumarharshkumar Год назад

    This video's examples and explanations are beyond comprehension. However, using this approach will take a lot of time. Could you provide us with some tools that can help us identify the features of our rivals' SERPs?

    • @mishraanshika
      @mishraanshika Год назад

      The video by Rankwatch showcases how their tool allows you to effectively identify the SERP features your competitors are ranking on, providing you with valuable information to enhance your SEO strategy. ruclips.net/video/JT9quYsfL8U/видео.html

    • @nagrajkankonkar
      @nagrajkankonkar 9 месяцев назад

      Not really, it's pretty straightforward if you know what information you are looking for

  • @laupac
    @laupac 3 года назад

    Hi, great video thanks for sharing. Just a question: can Screaming Frogdo the same data extrapolation?

  • @yunusshaikh218
    @yunusshaikh218 3 года назад

    But important thing is that, does only meta data is a ranking factor. We can get idea what intent Google is taking on priority and we can plane accordingly.
    If you can explain how we can use this data to create awesom content that will be better

    • @smamarketing
      @smamarketing  3 года назад

      Great comment, Meta data is only one factor but the information we extract can help us build a page that better matches both Google expectations and user intent. Here is a video. I did on the role of content in semantic search ruclips.net/video/gNcOfDv8qsQ/видео.html
      I'll be doing more content around this soon.

  • @pincus1979
    @pincus1979 3 года назад

    sorry if I'm slow here...where is the code you mentioned that needs to be placed in the bookmark?

    • @smamarketing
      @smamarketing  3 года назад

      You can find it here: www.smamarketing.net/blog/how-to-use-google-sheets-for-serp-analysis

  • @jaynetan6589
    @jaynetan6589 3 года назад

    My link is on A4 so I tried =TRANSPOSE(IMPORTXML(A4,'//title'))
    Could I know what went wrong? Is it because they don't allow me to scrape info?

  • @janetbelmonte5348
    @janetbelmonte5348 2 года назад

    URL extractor code is not working for me :(

  • @arevev
    @arevev 3 года назад

    alfie solomon

  • @jahidparves5850
    @jahidparves5850 3 года назад +1

    What is on you lip

  • @jaynetan6589
    @jaynetan6589 3 года назад

    Hey SMA Marketing, I can't reply to your previous comment so I'm creating a new comment. I tried with this link www.viator.com/Australia-tours/Wine-Tasting-and-Winery-Tours/d22-g6-c21 and without the transpose but still can't.
    Also, how do you install the 'extract url'? Are there links you can share with us so we can bookmark them on the top panel of Google?
    Thanks for the valuable content!!

    • @smamarketing
      @smamarketing  3 года назад

      Here are the code you're looking for www.smamarketing.net/blog/how-to-use-google-sheets-for-serp-analysis