ARI Canonical - Historical Clean-up

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	ON TRACK
Progress	10%
Brand	ARI
Owner	Lance Shroyer
Team	Grant Gooch Katie Hill Gabriel Reyes Francisco Castro (Deactivated)
Status Note	12 Apr 2023 Lance gave a training session to Juniper
Key Dates	13 Feb 2023 Meet with Ashli to discuss possible Dev solution. 17 Feb 2023 Determine process to identify the content that needs to be migrated. 17 Feb 2023 Scope migration and communicate. 13 Apr 2023 Starting canonical cleaning.
Resources
Expected impact
Actual impact

Description

🏁 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.

Next Actions

Questions

Questions	Answer	Who
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

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
Crawl all links with screaming frog to identify pages that need content migrated
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).
Check off each customer when all content has been migrated
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