I’m using the code below, to extract product schema only – I can export to excel and filter the URLs containing product schema, but don’t have the aggregaterating:
The Magento configuration file is a critical document that contains important settings and directives for the operation of the Magento website. It acts as a site control panel where relevant information is stored and managed. As an SEO professional, even without a strong background in coding or server management, a basic understanding of this file can enable you to understand how the various technical aspects of a website work.
Here is a division of its purpose and functionality:
Stores basic settings: The Magento configuration file records key information such as database details (including data on products, customers and orders), security protocols, and caching mechanisms that affect site speed.
Regulates functionality: Directs Magento behavior by specifying preferences such as the language used, the currency displayed, and the activation status of certain features.
SEO considerations: URL structure: Some configurations affecting URL generation on a site can be managed here, which contributes to a cleaner, more optimized URL layout.
MTPuTTY Explained for Beginners (non-coders)
MTPuTTY (Multi-Tabbed PuTTY) is a tool that helps manage multiple server connections at the same time.
Here’s how it works in a simple, non-technical way:
By allowing users to open several tabs, MTPuTTY streamlines the process of connecting to various remote servers without the hassle of switching between different windows or applications. This means that you can seamlessly work on multiple projects concurrently, enhancing productivity and efficiency. Each tab operates independently, so you don’t lose your connection when navigating between tasks. Additionally, MTPuTTY provides a user-friendly interface, making it easier for newcomers to grasp the basic functionalities, while still offering advanced features for experienced users. This combination of simplicity and versatility makes MTPuTTY an invaluable tool for anyone who needs to maintain numerous server connections at once.
What is PuTTY?: PuTTY is software that enables developers or server administrators to connect to a server remotely, such as accessing the back-end of a Magento website to make changes or check performance.
What does MTPuTTY do?: MTPuTTY is like an upgraded version of PuTTY that allows people to open multiple server connections at once in different tabs. It’s particularly useful for someone managing several servers, because it keeps everything organized and easily accessible.
How is it relevant to you?:
You won’t likely use it, but developers or technical SEO experts might. They use tools like this to access your website’s server and make behind-the-scenes optimizations that can impact website speed, performance, and security, all of which are important for SEO.
For example, if your site is running slowly, they might use MTPuTTY to connect to your server and make improvements, which could help with SEO by improving site speed.
In summary: MTPuTTY is just a tool that helps manage technical tasks on servers. While you don’t need to know how to use it, it’s helpful to understand that your team might use this tool to maintain your website’s health, which indirectly affects SEO performance.
Google follows links and sitemaps provided in search console to crawl websites.
Pages are revisited to check if they have changed
The crawlers needs to prioriterise what and when to crawl different pages, and different domains/websites.
Successfully crawled pages are passed to the index
Google computes crawl rate of your website – according to what traffic your site can handle.
Crawl Stats Report
Provides stats about Googles crawling of your site.
Looks out for errors and drops & spikes in graphs.
Login to Search Console and click on settings
THIS REPORT IS ONLY AVAILABLE FOR PROPERTIES AT THE DOMAIN LEVEL – that don’t include https etc in the address
Look for spikes and drops in the data
E.g. to determine if robots.txt has been updated incorrectly – if there’s a sudden drop.
That’s about it.
Oh, check your server/host is ‘working okay’ too –
Find the above report by clicking “settings” on the left hand side-bar/menu > Crawl Stats > Choose a “host” in the middle panel (usually just your homepage address) > then “Host status”.
It’s good to check crawl stats and average response time before and after a migration or redesign.
Average Response Time:
Under 200ms: Excellent. Site is well optimized for crawling by Google etc.
200ms-500ms: Acceptable. That’ll do pig, that’ll do.
500ms-1s: Slightly too slow, especially if your site is 1,000 pages+
Rich Results Test: Validate your structured data using the Rich Results Test.
URL Inspection Tool: Use the URL Inspection tool in Google Search Console to ensure your page is accessible and not blocked by robots.txt or noindex tags.
Step 4: Deploy Your Page
Deploy your summary page and a few detail pages.
Use the URL Inspection tool to request indexing of your new pages.
Step 5: Submit a Sitemap
Create a sitemap including your summary and detail pages.
Submit the sitemap through Google Search Console to ensure Google knows about all your pages.
Had to categorise some keywords, if there’s a quicker way of doing it – please let me know
Paste keywords into column A
In column D – Paste all relevant words for a category. For example – I pasted all the words I could think of relating to gardening – such as “tree”, “fruit”, “garden”, “bush”, etc. – There were 18 words in total
In cell E2 paste the formula:
=IF(SUMPRODUCT(--ISNUMBER(SEARCH($D$1:$D$19,A2)))>0, "Contains value from range", "Does not contain value from range")
Now drag the formula down
Filter column E to “contains value for range”
Colour in the keywords green – or a chosen, relevant colour
Add another list of relevant words – for example, above I have added sports, to highlight sports netting keywords.
Small Business Dad 
