Page Comparison

This SOP is a work in progress. If you notice anything that is out of date, could be more clear or could be more efficient please update the SOP or add a comment to start a conversation.

Purpose

Purpose details…Provide instructions on creating and submitting a sitemap based on URLs affected by a client’s SEO package.

Procedure

Inputs:

Details…

Expand

title	Step #: Do something...

1: Copy the Sitemap Generator Template tab.

Navigate to the Sitemap Generator Template sheet from Ryan Kelner and copy the only tab there to the client sheet of the dealer you want to create an SEO sitemap for (Click on Existing spreadsheet).
Image AddedImage Added
When you copy a new tab to a client sheet the new tab goes all the way to the right of all existing tabs so make sure you move it near the Work Done Import and SEO Work Done tabs.
Make sure to also remove the “Copy of ”in the name of the tab.
Image Added

Expand

title	Step 2: Setup the sitemap generator tab

For the sitemap generator to work we need two things:
- Add the site URL to the A2 cell of the Sitemap Generator tab.
  Image Added
- Add all URLs from the old SEO Work Done tab to the new Work Done import tab:
  - Select all the cells on the SEO Work Done tab by clicking on the top left blank space and copy it by Ctrl+C or right-clicking and selecting Copy.
    Image Added
  - Visit the URL Extractor page and paste the contents of the SEO Work Done tab in the Step 1 box.
    Image Added
  - Go right into step 3 skipping step 2 and click on the copy to clipboard button to get all links extracted from the SEO Work Done tab.
    Image Added
  - Paste these links at the bottom of the oldest link or row in the Work Done Import tab adding a little note like “SEO Work Done URLs:”
    Image Added