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.
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?
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
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
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.
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!!
Rock solid! Excellent primer...thank you! This really has my wheels turning.
Glad you like it!
oh man, you just save my life !! thanks a lot for this sharing!!
You're welcome!
Depending on your language configuration, (or something else), a coma "," may not work, so try with semicolon ";" that worked for me.
Hi, bro
Your videos are very informative. If anyway to track the keywords position via Google sheet. Kindly share it bro
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.
@@smamarketing can you please make a video for serp tracking
@@praveenchandrasekaran7064 Let me see what I can put together!
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?
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
Not really, it's pretty straightforward if you know what information you are looking for
Hi, great video thanks for sharing. Just a question: can Screaming Frogdo the same data extrapolation?
Yes and more!
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
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.
sorry if I'm slow here...where is the code you mentioned that needs to be placed in the bookmark?
You can find it here: www.smamarketing.net/blog/how-to-use-google-sheets-for-serp-analysis
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?
Try it without the transpose.
URL extractor code is not working for me :(
alfie solomon
What is on you lip
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!!
Here are the code you're looking for www.smamarketing.net/blog/how-to-use-google-sheets-for-serp-analysis