Weekly Wisdom: Time-Saving SEO Hacks by Ross Tavendale

Weekly Wisdom: Time-Saving SEO Hacks by Ross Tavendale

HomeSemrushWeekly Wisdom: Time-Saving SEO Hacks by Ross Tavendale
Weekly Wisdom: Time-Saving SEO Hacks by Ross Tavendale
ChannelPublish DateThumbnail & View CountDownload Video
Channel AvatarPublish Date not found Thumbnail
0 Views
Learn about content strategy, SEO tips and more http://smr.sh/Kdv
Watch our latest video: How to go viral on Quora https://bit.ly/ViralOnQuora1

Subscribe to our YouTube channel! http://smr.sh/KdD

For transcription and extras: https://www.semrush.com/blog/weekly-wisdom-with-ross-tavendale-time-saving-seo-hacks/?utm_sourceyoutube_channel&utm_mediumyoutube_description&utm_campaignyoutube_paid_weekly_wisdom_time saving_seo_hacks

0:35 How to find all the URLs that have ever existed for a specific website: creating a CSV report from web.archive.org data
2:00 Import data from web.archive.org into Google Sheets using formula magic
3:00 Import data from Sitemap into Google Sheets
3:20 Add Majestic to the mix: what's the right formula to use in Google Sheets?
4:30 Use add-ons: Supermetrics SEMrush – “organic keywords for domains” for the win
5:00 Add a pinch of Google Search Console
5:40 Applying the “UNIQUE” formula to have all data on one sheet

Hello everyone, it's Ross here from Type A Media, welcome to another Weekly Wisdom video. Type A Media is known for our four-day work weeks, and the way we can get away with that is by cutting all the fat out of our daily processes. So in this Weekly Wisdom video, I'm going to discuss ways I can save a second here, a minute here, an hour here. With some of these tips and hacks, as well as some of the tools we used to cut things up a bit and get straight to the point, so we can get the data in there and analyze it, and more importantly, get it live on the our client site's website so we can rank them.

So without further ado, let's get into it. One of the things I think people spend a lot of time on is finding all the URLs that have ever existed for their website. Now they typically search the site to see what's there and maybe look at the XML sitemap. Maybe they'll jump to Search Console, look into that. Maybe jump to Majestic to see all the pages with links, and that's cool, but what if the client has been migrated six times in the last 12 years? Do you have that information? Is it somewhere? Of course, you can go to something like archive.org and find that and pull it out, but that's also a little slow, so I'm going to show you a really quick way to put all these things together.

#Weeklywisdom #SEO #TechnicalSEO

Follow us on social media:

Facebook: https://bit.ly/2D1w7Nn
Twitter: https://bit.ly/3g8GMnI
LinkedIn: https://bit.ly/2XaiVfP

#semrush #seo #digitalmarketing #seotools

Please take the opportunity to connect and share this video with your friends and family if you find it helpful.