10 Google Sheets Add-Ons That Make SEO Work Easier
10 Google Sheets Add-Ons That Make SEO Work Easier
Google Sheets is a go-to tool for SEO professionals. Why not use add-ons to save time and simplify tasks? Check out 10 add-ons that can help.
Google Sheets Formulas Tutorial
Learn how to use formulas and functions in Google Sheets.
– Access the spreadsheet I used if you’d like to follow along: https://docs.google.com/spreadsheets/d/1lRrxezy1dKcJLrZot5BxBBKffEP8Ys-c6qUMirM9OTA/edit?usp=sharing
– Read about all functions available in Google Sheets: https://support.google.com/docs/table/25273
0:33 Add & formula basics
4:37 Bring it all together
20:50 Today & Now
21:30 Len / character length
22:25 Wrap up
Watch related playlists and videos
– Google: https://www.youtube.com/playlist?list=PLlKpQrBME6xLGL3Ty_1Wbd3nTZ_q_OKFQ
Connect with me on social:
– LinkedIn: https://www.linkedin.com/in/kevinstratvert/
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
Subscribe to my YouTube channel
Want to watch again? Navigate back to my YouTube channel quickly
Support me with your Amazon purchases: https://amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel — the price to you is the same.
How to Optimize Your On-Page SEO in Less Than 10 Minutes
Today I’m going to teach you how to optimize your on-page SEO in less than 10 minutes.
RESOURCES & LINKS:
MASTERING ON-PAGE SEO (PLAYLIST):
On-page and technical SEO Part 1 – SEO Unlocked – Free SEO Course with Neil Patel: https://youtu.be/PXDPqXHLSOY
On-page and technical SEO Part 2 – SEO Unlocked – Free SEO Course with Neil Patel: https://youtu.be/utLaKIJKygA
Mastering Technical SEO Audits – On-page SEO Part 3 – SEO Unlocked – Free SEO Course with Neil Patel: https://youtu.be/k04rHijEPSw
So, I want you to first head over to ubersuggest.com or neilpatel.com/ubersuggest, whatever one, and type in your domain name. So, I’m gonna type in Neilpatel.com. And you’re going to see a report load. This is typically your traffic analyzer report that shows you your overall organic keywords, your monthly traffic, your domain score, your backlinks.
If you have a newer website, you’re probably not going to see any data here or here or even any rankings, but I’m not looking for you to look at this report or spend much time on it. Instead, I want you to go into the sidebar and under SEO analyzer, click on site audit.
Now I’ve already ran my site neilpatel.com. As you can see, it was ran recently, and you’ll see an on-page SEO score. The higher this number, the better. It goes from zero or one to 100.
The organic monthly traffic. Don’t worry about this too much because as you get more traffic, your numbers go up, and you as you optimize your site, your numbers will go up. Same with your organic keywords and your backlinks. As you can see here, I scan 150 pages. The tool can scan literally up to 10,000 pages, depending on what kind of account you have, if you’re on a premium account.
And you’ll see the health check of the healthy pages, broken pages, have issues, redirects, blocked. There’s some critical errors, some warnings, recommendations. The critical errors tend to be the ones you fix first. And then there’s of course your site speed. Try to get into the green area for both of them.
So, I want you to scroll down to the critical errors first and click on it. When you click on it, you’ll see all the pages that have issues. And whatever they may be, you can just hover over the what is this and how do I fix it, and click on it. And it tells you what issues this is.
So, if you look at what is this for low word count, without enough text on a page, Google will have trouble understanding what the content is about. If Google doesn’t know what the content is about, it won’t be able to rank the content for the search terms you are targeting. By adding more text you are telling Google’s crawlers and your end users more about what it is you have to offer.
Anything less than a few hundred words is considered thin content and will be nearly impossible to rank for. It doesn’t mean it’s impossible. I said nearly impossible because for some keywords like how to tie a tie, you don’t need a lot of text. Some images, videos that explain how to do it is probably actually better than text.
This is the A/B testing calculator. People don’t want a lot of words. They just want to figure out which variation of their page when they’re running an A/B test to see if which version converts better is winning or losing.
Solve the ones where it makes sense, especially when it comes to things like low word count. And as you fix them, what you’ll find is by fixing all these little errors, you’re going to rank higher and higher over time. And I just want you to go through them, all your SEO issues.
And you want to first start with the critical errors. And then after you do those, then go to the warnings, because the warnings don’t mean that you have to fix them. Sometimes it makes sense to fix them. Sometimes it doesn’t. Recommendations, the least important out of them, but start with critical errors, then warnings.
You want to make sure your site speed is in the green area. Talk to your developer. They can help you with it. Or if you want to do it yourself, you can hover over the question marks. It’ll tell you what they mean, and then you will work on it.
Then the next thing you want to do is after you finish making those fixes, you want to go on the right side, load up this site, audit report, go back to it. And what you’ll want to do is hit the recrawl website.
► If you need help growing your business check out my ad agency Neil Patel Digital https://npdigital.com/
►Subscribe: https://goo.gl/ScRTwc to learn more secret SEO tips.
►Find me on Facebook: https://www.facebook.com/neilkpatel/
►On Instagram: https://instagram.com/neilpatel/
#SEO #NeilPatel #DigitalMarketing
Best Google Drive Add-Ons
Learn how to power-up your Google Docs, Google Sheets, and Google Forms with the help of Google Add-Ons. In this tutorial you’ll learn about my favorite Google Add-Ons, including EasyBib, LucidChart, Word Cloud Generator, G(math), Split Names, Form Notifications, and Form Limiter. ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents
SEO Audits Or Grab Competitor Data Using Google Sheets
You’re probably familiar with Google Sheets. It’s Google’s free version of Excel. But it’s more than just a spreadsheet tool. Did you know that you can use Google Sheets to scrape content from a website? That’s right, you can pull valuable information for SEO audits, like title tags, H1 tags, and descriptions. And you can also use it to import pricing data, tables of information, and content like articles, product descriptions, author names, product reviews… You get the idea.
Google Sheets Formulas:
Learn More About Apotheca Marketing:
Check Out Our Podcast!
Join us on social media!
00:40 Import H1 Tags
02:12 Import Title Tags
04:17 Links on a Page
05:12 Import Product Names from a Page
08:10 Import Product Prices