Summary

Create a process, train, and implement project with Juniper to crawl all current ARI SEO customers, identify which pages have SEO content that needs to be migrated, document migration process, train and track Juniper to completion of the project

Work Done test sample: https://docs.google.com/spreadsheets/d/1_iKIft6_Vf6KBvUXPOmtg4h9kgyHBpWpaBQ014KvDbY/edit#gid=1389561772&fvid=1497022249 2/3 of pages canonical.

Target release

Priority

HIGH

Project status

Done

Progress

100%

Brand

ARI

Owner


Team


Status Note

Apr 12, 2023 Lance gave a training session to Juniper

Key Dates

Feb 13, 2023 Meet with Ashli to discuss possible Dev solution.
Feb 17, 2023 Determine process to identify the content that needs to be migrated.
Feb 17, 2023 Scope migration and communicate.
Apr 13, 2023 Starting canonical cleaning.

Resources


Expected impact


Actual impact


Page Properties

Description


Emoji :checkered_flag: Milestones / Project Timeline

Estimate manual
Document the process to build the page migration list.
Document the process to migrate the content.
Assign project owner.
Build migration tracker spreadsheet (use ARI customer list below)
Train project team.
Test migrations with doublechecks.
Start content migration.
Random spot checks.
Finish Content migration.


Emoji :check_mark: Next Actions


Emoji :question_mark: Questions

Questions

Answer

Who

When

Where

How long does it take on average to move content for a single page?

8 minutes (5-10 minutes)

Juniper



How long does it take per dealer to assemble the migration list?

4 minutes ()

Lance



What is the average number of pages to be migrated per dealer?

~11 pages (19, 18, 2, 4)

Lance



How many additional Screaming Frog licenses are required? What is their cost?

1-3

Lance



Who we/who do we need to alert that we will be implementing mass ARI website crawling?

No one. We are not doing a full site crawl. Impact will be limited.

Lance



What are the correct Screaming Frog settings for this project?

See Screaming Frog settings below.

Lance



Are there only certain packages that this is relevant to?

Yes, Katie has distilled out the migration list in the Files section.

Katie



What is the total count of customer in this project?

211. See customer list in Files below.

Katie




Decisions

Decision

Why

Who

When

Where

Do not do a full website crawl.

Returns a lot of noise, aka canonicalized pages that are not due to SEO optimization. What pages are returned relevant to SEO are incomplete and redundant of Client Sheet data.




Use Client Sheets as source of truth for crawl list.

See above. This is our best source of truth.





Assumptions

  • That reps are historically accurately optimized/modified Meta Descriptions.

  • That Client Sheets are sufficiently representative of the work that has been completed on SRPs.

Dependencies

  • Buy in for additional Screaming Frog Licenses.

  • Capacity

Files & Resources

https://arinet-my.sharepoint.com/:x:/r/personal/lance_shroyer_leadventure_com/_layouts/15/Doc.aspx?sourcedoc=%7B25AA6095-BAAD-40BC-84D1-B479C8C4F355%7D&file=ARI%20Customers%20w_ILP%20Optimization.xlsx&action=default&mobileredirect=true

Tracking sheet: https://docs.google.com/spreadsheets/d/1785CTy4WxxOvPZKUTbUnJXoj7VGHurAy5rn9HpVNPA4/edit#gid=194437849

Related Projects

Future Work




Notes

We will have to configure Screaming Frog to not crawl too aggressively to not negatively impact servers.


Migration Process

  1. Consolidate client sheet links & clean-up

    1. Content History, SEO Content Audit, SEO Work Done, Work Done Import

      1. Which columns. DON’t select columns. select entire sheet/tab contents!!!!

      2. remove none domain links if any

  2. Crawl all links with screaming frog to identify pages that need content migrated

  3. Migrate content

    1. For each page

      1. Go into the Search Component in the CMS and replace the URL portion in both the meta title and meta description with the new canonical link (section includes /search/inventory on).

      2. Go into the SEO Content Component in the CMS and replace the parameters of the desired component instance with the new canonical link parameters (includes only the filters section of the URL after /search/inventory/).

      3. To update on-page buttons, you will need to check which buttons exist on the page, then go into each of those component instances, which should all include buttons linking back to the page you are editing. Grab the entire canonical URL and replace the old Button Link Path with the new URL. This will ensure that all parent and child pages include buttons that direct the user to the optimized canonical page.

      4. Lastly, you can check the home page navigation bar to see if there are any links to pages that have had their URLs changed to canonical links. If there are any links present, go into Site → Navigation to replace the Custom URL line with the canonical URL (include the entire URL).

  4. Check off each customer when all content has been migrated

  5. Copy canonical page list from column “Canonical Link Element 1” paste at the bottom of the Work Done Import list. Add “Canonical fixed” to Content Focus column for each row.

Process Notes

Screaming Frog Setting

Set Mode: Mode-->List

Set User-agent: Configuration → User-Agent to Googlebot (Smartphone)

Save as default: File → Configuration → Save Current Configuration as Default

Screaming Frog Search

([Address] Contains 'search/inventory' And [Address] Not Contains '/page/' And [Meta Description 1] Not Contains 'Search Results' And [Indexability Status] Contains 'Canonical')


Migration Lift Estimation Math

Time to migrate each page: 12 minutes

Pages per dealer: 11 pages

Total dealers affected: 211

Total minutes: 27852

Hours: 464 hours

Days: 58 days

1 person: 11.6 weeks full-time

2 people: 5.8 weeks

3 people: 3.87 weeks

Extract urls from Client Sheet data

https://www.convertcsv.com/url-extractor.htm


Testing doc

https://docs.google.com/spreadsheets/d/13WFs2qnuqdNSWaDK92AYbOrtZSGDKuhvZNmdsu9dJyY/edit#gid=1461426475