Rock solid! Excellent primer...thank you! This really has my wheels turning.
@smamarketing
3 жыл бұрын
Glad you like it!
@xinluo1199
Жыл бұрын
oh man, you just save my life !! thanks a lot for this sharing!!
@smamarketing
Жыл бұрын
You're welcome!
@like.a.cactus
2 жыл бұрын
Depending on your language configuration, (or something else), a coma "," may not work, so try with semicolon ";" that worked for me.
@praveenchandrasekaran7064
3 жыл бұрын
Hi, bro Your videos are very informative. If anyway to track the keywords position via Google sheet. Kindly share it bro
@smamarketing
3 жыл бұрын
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
3 жыл бұрын
@@smamarketing can you please make a video for serp tracking
@smamarketing
3 жыл бұрын
@@praveenchandrasekaran7064 Let me see what I can put together!
@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?
@smamarketing
3 жыл бұрын
Try it without the transpose.
@janetbelmonte5348
2 жыл бұрын
URL extractor code is not working for me :(
@pincus1979
3 жыл бұрын
sorry if I'm slow here...where is the code you mentioned that needs to be placed in the bookmark?
@smamarketing
3 жыл бұрын
You can find it here: www.smamarketing.net/blog/how-to-use-google-sheets-for-serp-analysis
@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
Жыл бұрын
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. kzitem.info/news/bejne/q4pv16mPrJh9a4o
@nagrajkankonkar
9 ай бұрын
Not really, it's pretty straightforward if you know what information you are looking for
@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
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 kzitem.info/news/bejne/yISZtZp6r2qipoY I'll be doing more content around this soon.
@laupac
3 жыл бұрын
Hi, great video thanks for sharing. Just a question: can Screaming Frogdo the same data extrapolation?
@smamarketing
3 жыл бұрын
Yes and more!
@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
3 жыл бұрын
Here are the code you're looking for www.smamarketing.net/blog/how-to-use-google-sheets-for-serp-analysis
Пікірлер: 28