How to create an SEO analysis?
This article offers valuable insights into the process of conducting a comprehensive SEO analysis. The article dives into the importance of SEO analysis and outlines step-by-step guidelines on how to perform it effectively.
Terminology
SEO: SEO, or Search Engine Optimization, is the practice of improving a website's visibility and ranking on search engines like Google. It involves optimizing various aspects of a website, such as content, keywords, and technical elements, to increase organic (non-paid) traffic. The goal is to attract more visitors and ensure the website appears prominently in search results.
ScreamingFrog: A software tool that crawls websites to identify and analyze common SEO problems, allowing you to enhance onsite SEO. It acts as a website auditor, scanning for issues like broken links, duplicate content, and missing meta tags. It helps optimize your website for better search engine performance.
SEMRush: A platform that offers a suite of features that allow users to analyze their website’s performance, track keywords, monitor competitors, and identify opportunities to increase online visibility. SEMRush provides detailed reports on factors like website traffic, backlinks, and keyword rankings, helping businesses optimize their content and strategies to rank higher in search engine results, attract more visitors, and ultimately grow their online presence.
Assets needed
- ScreamingFrog software. (You will need a license to correctly perform the analysis. )
- SEMRush login.
- Current client’s website URL.
What is a SEO Analysis?
A SEO Analysis is an initial step taken during website creation to gather crucial information before building begins. It involves assessing a client's existing website to identify valuable content that can be utilized in the new website. This analysis helps shape the website's structure, content strategy, and optimization techniques for improved search engine visibility and user experience.In this SOP, you will find the step by step guide on how to perform a SEO Analysis:
1. Preparing for the SEO Audit
1.1 Install and Verify Screaming Frog License
- Ensure Installation: Confirm that the latest version of Screaming Frog SEO Spider is installed.
- Verify License: Check that the Screaming Frog license is up to date under the "Enter License" section. If necessary, obtain an updated license key from the appropriate contact (e.g., Chris Lee or Magen Toole).
1.2 Configure Screaming Frog for Optimal Crawling
- Initial Setup:
- Open Screaming Frog and navigate to "Configuration" > "Crawl Configuration."
- Customize settings to focus on critical elements by unchecking boxes for crawling images, CSS, and JavaScript unless relevant to the audit.
- Link Settings:
- Ensure both internal and external hyperlinks are selected for crawling under the "Page Links" tab. This is crucial for identifying broken links.
- Content Checks:
- Enable spelling and grammar checks in the "Content" section to catch errors that could harm the site’s credibility. Use U.S. English for these checks.
1.3 Final Setup Before Crawling
- Additional Considerations:
- Periodically review settings to ensure they match current needs. For media-rich sites, consider including videos or PDFs in the crawl.
- Saving Configuration:
- Save the configuration by selecting "File" > "Save As" and naming the settings appropriately for future use.
2. Executing the Site Crawl
2.1 Accessing the Task in HubSpot
- Locate the Assigned Task:
- Find your SEO analysis task in HubSpot. It will include the client’s name and the website URL to be audited. For example, "Cosmetic Dentistry of Hayward."
2.2 Initiating the Crawl in Screaming Frog
- Copy and Paste the URL:
- Copy the website URL from HubSpot and paste it into Screaming Frog’s URL entry field, ensuring correct subdomain usage (e.g., www or non-www).
- Start the Crawl:
- Begin the crawl by clicking "Start." Monitor the overview section to confirm that relevant content is being analyzed, excluding unnecessary elements like JavaScript, CSS, and images unless they are integral to the site.
2.3 Reviewing and Exporting Crawl Data
- Analyze Crawl Results:
- After the crawl is complete, review the results in the "Internal" tab to focus on crawled URLs. Check the "Status Codes" column to identify any 404 errors or 301 redirects.
- Use the "Content" tab to review page content details, including word counts, readability scores, and the presence of spelling or grammar errors.
- Export Crawl Data:
- Export the data to a file, saving the internal URLs as internal_all.csv and content details as content_all.csv.
3. Setting Up the SEO Analysis Spreadsheet
3.1 Utilizing the SEO Analysis Template
- Access and Duplicate the Template:
- Access the standard SEO analysis template stored in a shared location, such as the “Buildouts” folder in the "Dental Marketing" section of the shared drive.
- Make a copy of the template by selecting "File" > "Make a Copy." Rename it to reflect the client and task (e.g., "Cosmetic Dentistry of Hayward SEO Analysis - New") and save it in the appropriate project folder.
3.2 Importing Data into the Spreadsheet
- Importing Internal Data:
- Open a new Google Sheets document and import the internal_all.csv file into the internal data sheet. Focus primarily on the "Address" column listing all URLs.
- Importing Content Data:
- Similarly, import the content_all.csv file into a separate sheet. Pay particular attention to the "Address" and "Word Count" columns for analyzing content quality.
3.3 Organizing and Labeling Data
- Sorting URLs:
- Sort the URLs alphabetically (A-Z) within the "Address" column. This helps identify duplicate pages, PDFs, or other files that may need special attention.
- Labeling and Categorization:
- Copy the URLs into the main SEO analysis sheet and label each URL based on the required action:
- New: Create new content for the page.
- Keep: Recreate the existing page content as it is.
- Consolidate: Merge similar pages to reduce redundancy.
- Redirect: Set up a 301 redirect to another relevant page.
- Organize URLs by Type:
- General Pages: About Us, Contact Us, Meet the Doctor, etc.
- Service Pages: Pages dedicated to specific dental services (e.g., "/services/cosmetic").
- Blog Pages: Individual blog posts.
- Copy the URLs into the main SEO analysis sheet and label each URL based on the required action:
4. Detailed Review and Content Quality Check
4.1 Organizing and Labeling in the SEO Analysis Sheet
- Transfer and Organize URLs:
- Clean up the URLs by removing the domain portion, file extensions (e.g., .php, .html), and any trailing slashes.
- Example: toothdoctor.com/about-us.html becomes /about-us
- Transfer cleaned-up URLs to the main SEO analysis sheet under 'Target.' Label each URL according to the action required (New, Keep, Consolidate, Redirect), ensuring all URLs align properly.
- Clean up the URLs by removing the domain portion, file extensions (e.g., .php, .html), and any trailing slashes.


4.2 Content Quality Review
- Assessing Word Count and Readability:
- Review the word counts for each page, focusing on service pages. Aim for a minimum of 500 words per service page, with 1,000 or more being preferable for SEO purposes.
- Evaluate readability. Pages with low word counts or poor readability should be marked for rewriting or consolidation.
- Note essential pages that may require additional content to meet SEO standards.
5. Conducting a SEMrush SEO Audit
5.1 Purpose of the SEMrush SEO Audit
- The SEMrush SEO audit supplements the Screaming Frog data by providing a broader view of the website’s SEO health. This helps identify additional issues and gives a comprehensive understanding of the site’s strengths and weaknesses.
5.2 Setting Up the SEMrush Audit
- Login and Navigate: Log in to SEMrush, go to the "SEO Dashboard," and find the "Site Audit" tool under "On-Page SEO" and "Tech SEO."
- Create a New Project: Click "Create Project," enter the website domain (e.g., "Cosmetic Dentistry of Hayward"), and set the audit to cover 100 pages.
- Configure Settings: Use the default settings and skip scheduling or email notifications, as this is a one-time audit.
5.3 Running the Audit and Reviewing Results
- Start the Audit: Click "Start Audit" and wait for SEMrush to process the pages. Review the overall site health score and key metrics like crawlability, core web vitals, and internal linking.
- Identify Issues: Focus on critical errors such as missing H1 tags, broken links, and content issues like missing meta descriptions or low word counts.
5.4 Documenting and Acting on Findings
- Capture Key Issues: Take screenshots of significant issues (errors, warnings, and the general overview) and add them to a dedicated tab in your SEO analysis spreadsheet.
- Share Links to PDFs: Whenever possible, save PDFs of the Overview and Errors reports, upload them, and link them beneath the screenshots for easy reference.
6. Completing and Closing the Task
6.1 Update HubSpot
- Update and Save: Return to HubSpot, locate the SEO analysis task, and update it with the link to the final analysis sheet. Click ‘Save.’
- Mark Task as Complete: Ensure that all relevant parties are notified of the task's completion by marking it as complete in HubSpot.
Content Requirements
Service pages should be 500 words or more for maximum SEO value. If they are less than 500 words, we will not recreate them and create a 301 redirect to the homepage.
Content Types
General Pages
- Practice Information Pages: About Us, Insurance/Financing, Meet Our Doctor/Doctors, Your First Visit, New Patient Specials, Office Tour, Reviews, and Blog.
- Examples
- lakeparkdentistry.com/about-us
- doctordebby.com/insurance
- dentalhouse.com/specials
- toothdoctor.com/testimonials
- Additional Pages: Can include amenities, community events, patient resources, and more, provided they meet content requirements.
- Examples
Service Pages
- Examples: Dental Checkups, Braces, Invisalign, Crowns & Bridges, Root Canals, Teeth Whitening, Veneers.
- Examples:
- lakeparkdentistry.com/emergency
- doctordebby.com/services/dental-implants
- dentalhouse.com/our-services/cosmetic-dentistry
- toothdoctor.com/general-dentistry/dental-checkups
- Examples:
Blogs
- Blogs are typically formatted with titles like articles
- Examples
- lakeparkdentistry.com/blog/2014-10-20/teeth-whitening-faqs
- doctordebby.com/articles/root-canal-facts
- dentalhouse.com/blog-post/why-dental-implants-are-the-best-choice
- toothdoctor.com/post/04-12-2021/
- Examples
- Format all blogs to comply with the following structure
- /blog/example-blog-title
- Redirection: Set all tags, categories, authors, and unnecessary data to redirect to the main blog page (/blog).
Target Match
- Filling Out: In the Target Match column, fill out the page title based on the URL or corresponding pages used in Webflow.
- Examples
- lakeparkdentistry.com/about-us → About Us
- doctordebby.com/services/dental-implants → Dental Implants
- dentalhouse.com/our-services → Dental Services
- Examples
Labels
New
- Pages to Create: Pages that require new content will be labeled as New. These include About Us, Insurance/Financing, Location/Office Hours, Sterilization Practices, Dental Services, and specific service pages like Dental Checkups, Orthodontics, Dental Implants, Veneers, Teeth Whitening, and Emergency Dentistry.
Keep
- These are pages that we are going to keep while building the new website
- General Pages, Blogs, and services besides the ones listed under "New" will be labeled as Keep.
Consolidate
- On rare occasions, we will consolidate a series of URLs
- To consolidate a series of URLs into a single page, set all of the selected URLs to redirect to the chosen page
- To consolidate a series of URLs into a new page we will create, set all of the selected URLs to redirect to the new URL
301 Redirect
- Redirect Pages: Pages that are being redirected to / (the homepage) should be marked with this label.
Managing Special Cases
- For URLs with '?' and a series of characters (e.g., https://www.dentalwebsite.com/?_rnd=133130840238939527), set the Target URL to /
- For PDF files, set the redirect to / and make a note to upload the file into the project to be added to the site
- For sitemap URLs, set the redirect to /sitemap.xml
We invite you to put your knowledge to the test about SEO analysis! Challenge yourself by filling out the following questionnaire and see how well you've grasped the key concepts discussed in this session. It's a great way to reinforce your understanding and discover areas where you excel or might want to explore further.


