10 SEO Workflow Tips

Introduction

This tool requires some initial set-up. Basically, you must have five columns in a "csv" file, in this order and with these exact names "URL", "Title", "Link From", "Link To", and "Anchor". Then you upload your file into the Google Collab file I am sharing with you. I'll list the steps below.

1. Crawl the Webiste

Use Screaming Frog or a homemade crawler/scraper to get the internal links from the website you want to analyze.

2. Organize Your Data

You need to organize your data in these exact columns "URL", "Title", "Link From", "Link To", "Anchor". Once you've done that, export the data to a "csv" file.

3. Upload the File to the Script

Upload the "csv" file to the script, specify the path to your file and run the script.

4. Plan New Links

Plan your links. Click on the first node and then on the second node to create new internal links.

5. Export and Implement

Once you are done, click on the "Export Links" button and you will receive a "csv" file with the new internal links. Then you can go ahead and implement them on your website.

Here's an Instructional Video

Enables you to visualise your internal links structure. Makes planning new internal links much easier.

Here's the Free Script

You can access the script through this link. Then make a copy of your own and feel free to use it. Cheers!

About the Author

Hi, I'm Nenad Markovic, a digital marketing enthusiast trying to make an impact in the SEM industry.

Tools to Use

Ahrefs

Ahrefs is THE tool if you want to do in-depth SEO and get the most data.

Read Review

Semrush

Semrush is THE tool if want to do SEO as an agency.

Read Review