Here you go –
most common – 404 – Not found, 301 – redirect (permanently moved the webpage to this new one)

You can scrape reviews if they are :
– In Schema
– Have their own specific class of <p> tag
e.g. class=”review-tex text-base font-secondary”
Yes, you can scrape the reviews if they are formatted in schema markup (like Review, AggregateRating, etc.) or if they belong to a specific class. Screaming Frog’s Custom Extraction feature will allow you to do this.
✅ How to Scrape Reviews in Schema or Specific HTML Classes Using Screaming Frog
1️⃣ Enable Structured Data Extraction (for Schema Reviews) If the reviews are in schema markup (JSON-LD, Microdata, or RDFa), Screaming Frog can directly extract them:
✔ Open Screaming Frog SEO Spider.
✔ Navigate to Configuration > Spider > Enable Structured Data.
✔ Start a crawl, and Screaming Frog will pull JSON-LD, Microdata, and RDFa formats.
✔ Once the crawl is finished, go to Reports > Structured Data > Review Schema to export the data.
2️⃣ Extract Reviews from a Specific Class (e.g., class=”review-text text-base font-secondary”) If the reviews are located within a specific tag that has a class, you can use Custom Extraction to get them:
✔ Open Screaming Frog and go to Configuration > Custom Extraction.
✔ Select XPath or CSS Selector based on your data structure. ✔ Use these extraction methods: 📝 Option 1: Using CSS Selector (Ideal for Class-Based Extraction) css Copy Edit p.review-text.text-base.font-secondary ✔
This will retrieve all tags that have the class review-text text-base font-secondary. 📝 Option 2: Using XPath (For More Complex Queries) xpath Copy Edit //p[contains(@class, ‘review-text text-base font-secondary’)] ✔
This will locate all elements with a class that includes “review-text text-base font-secondary”.
3️⃣ Run the Crawl and Export the Review Data
✔ Start the crawl and allow Screaming Frog to extract the reviews.
✔ After it’s done, go to Custom Extraction > Export Data.
✔ Open the resulting file in Excel or Google Sheets for further analysis. 🚀 Alternative Approach: Scraping JSON-LD Schema Reviews If the reviews are included in JSON-LD schema markup, you can extract them using: Custom Extraction (JSON-LD): xpath //script[@type=’application/ld+json’]/text()
✔ This extracts all JSON-LD data, which you can filter for reviews.
✔ Use JSON formatting tools (like jq or Python json.loads()) to clean and parse the data.
🔹 Summary: Can Screaming Frog Scrape Reviews?
✅ YES, if reviews are inside Schema Markup (JSON-LD, Microdata, RDFa).
✅ YES, if they have a specific class, using Custom Extraction.
✅ YES, if the reviews are static HTML, meaning they exist in the page source.
❌ NO, if reviews are loaded dynamically via JavaScript (use Selenium instead).
Marie also encourages community engagement, suggesting that producing authentic, user-focused content will be a key driver of success in the evolving search landscape.

Natural Language Processing (NLP) is a branch of artificial intelligence that focuses on the interaction between computers and humans through natural language. In the context of SEO and content creation, NLP tools help analyze and understand the nuances of language, enabling better alignment of your content with what users are searching for.
Searcher intent refers to the primary goal a user has when typing a query into a search engine. Understanding and aligning your content with this intent ensures that your pages meet the needs of your audience, leading to higher engagement, better rankings, and increased conversions.
Delta reports in SEO are comparative analyses that track changes in your website’s performance metrics over specific periods. By comparing data before and after a Google core update (or any significant change), you can identify which queries and landing pages experienced fluctuations in traffic.
Running Delta reports helps you pinpoint the exact areas of your website that are affected by algorithm changes. Understanding these changes allows you to take targeted actions to recover lost traffic and optimize your site for future updates.
By integrating NLP-based content analysis and Delta reporting, you can create a robust SEO strategy that not only aligns your content with user intent but also allows you to proactively identify and address issues arising from algorithm updates. Here’s a step-by-step approach to combining these strategies:
Implementing these strategies effectively can lead to improved search rankings, better user engagement, and sustained organic growth. By continuously aligning your content with user intent and proactively monitoring your site’s performance, you can navigate algorithm updates with greater confidence and resilience.
If you have any further questions or need assistance with specific tools or techniques, feel free to ask!
This is our inhouse protocol, it might differ in normal places…
Open FileZilla – connect to M2 server (magento 2, rather than our magento 1 server)
Click domains folder –
Select relevant domain
Select Rewrites
Right Click – Config folder and click View/Edit – Open in a text editor like Sublime
Add redirects in the following format:
#Note to say who did redirects on what date
rewrite ^/rwl-x-la-new-member-starter-pack.html$ /gym-equipment.html permanent;
rewrite ^/rwl-x-la-ultimate-starter-pack-intermediate.html$ /gym-equipment.html permanent;
rewrite ^/rwl-x-la-new-member-dumbbell-pack.html$ /gym-equipment.html permanent;
- Save the file
This will redirect the URL example.com/rwl-x-la-new-member-starter-pack.html to example.com/gym-equipment.html
and so on…the other 2 below will also redirect to gym-equipment.html
Open MTPUTTY
Connect to relevant server – in my case – server 3
type in “ntest” and check for any error messages
if ok – type in “nreload”
That should be it!
Depopulation, has some potential benefits for property investors!
Buying a house in Italy for 1 euro is a great opportunity, promoted by several towns aiming to revive declining populations and renovate old properties.
Here’s a step-by-step guide tailored for a UK resident:
Research and Choose a Town: Several Italian towns have offered homes for 1 euro. Each town has different terms and conditions. Here are some notable ones:
Visit the Official Websites: Each town usually has an official website or a dedicated page for the 1 euro house initiative. Here are some URLs:
Understand the Conditions: Each town has specific conditions that buyers must meet, such as:
Contact the Municipality: Send an email or call the municipal office to express your interest and get detailed information.
Plan a Visit: It’s highly recommended to visit the town and view the properties. Contact the municipality to arrange a visit.
Prepare Your Documents:
Sign the Preliminary Agreement: During your visit, if you decide to proceed, you will sign a preliminary purchase agreement (compromesso).
Open an Italian Bank Account: You will need an Italian bank account to handle transactions and utility payments. Many banks offer services in English.
Hire a Local Notary (Notaio): The notary will handle the legal aspects of the purchase, ensuring the property is free from debts and encumbrances.
Finalize the Purchase: After the preliminary agreement, you will sign the final deed (atto di vendita) before a notary. This completes the purchase.
Commence Renovation: Begin renovation work as per the conditions. Ensure you adhere to local building codes and regulations.
This is a general guide, so make sure to get detailed information from the specific municipality you’re interested in. Good luck with your house hunt in Italy!
The TRIM function removes all spaces from text except for single spaces between words.
=TRIM(A1)If there are non-breaking spaces (which TRIM doesn’t remove), you can use the SUBSTITUTE function to replace them with regular spaces first.
=SUBSTITUTE(A1, CHAR(160), " ") This replaces non-breaking spaces with regular spaces.TRIM function:excelCopy code=TRIM(SUBSTITUTE(A1, CHAR(160), " "))You can also use the Find and Replace feature to remove extra spaces:
Ctrl + H to open the Find and Replace dialog box.For more advanced cleaning, you can use a VBA macro:
Alt + F11 to open the VBA editor.Insert > Module.Sub RemoveSpaces()
Dim cell As Range
For Each cell In Selection
If cell.HasFormula = False Then
cell.Value = Trim(WorksheetFunction.Clean(cell.Value))
End If
Next cell
End Sub
Alt + F8, select RemoveSpaces, and click Run.By using these methods, you can efficiently remove unwanted whitespace from your cells in Excel.
Screaming Frog is the greatest SEO tool of all time. Possibly the greatest tool of all time, closely followed by the George Foreman grill.
There’s a free version and if you have massive ecommerce website, with thousands of URLs, the posh paid version is well cheap too – if I remember rightly, is only about £200.
Absolute bargain.
Before you start – create a crawl config file.

I usually go with default settings, plus exclude cart pages and follow redirects.
You’ll also need to create a Google Drive and Looker Studio Account.
File > Scheduling:

click “+Add”

Give the scheduled crawl a name and set the time and date you want the first crawl to run
Also choose the frequency.
Note —> if you have a computer with a decent processor, that runs fine when you are crawling with Screaming Frog and you’re still able to do you work, then just set it for a date and time when you’ll be in work and on your computer.
However, if you have a slower computer, and running Screaming Frog at the same time as trying to do your normal work slows the computer down too much, you’ll probably want to set the crawl overnight, or at your lunchtime.
You can set windows computers to “wake up”, as long as they are plugged in. So that you’re able to run a crawl before or after work.
Although your IT department might not like it – computer running unattended with a battery etc could be in theory a fire harzard etc.
More on how to wake up your computer, later…
Back to scheduling on Screaming Frog:
On the start options tab, enter the URL you want to crawl and select your config file
I didn’t choose anything for “auth config”
For crawl config – upload the config file you saved earlier

In the Export – choose a folder on your computer and your Google Drive account:


By default, your crawl will go in a sheet in Google Drive at:
‘My Drive > Screaming Frog SEO Spider > Project Name > [task_name]_custom_summary_report’.

When asked – choose Google Sheets as a data source:

Ensure the ‘use first rows as headers’ option is ticked and select ‘Connect’ in the top-right.

You can probably do this in bulk somehow, but I went to each table/graph and added the Google Sheet as the data source:

Screaming Frog won’t run unless your computer is on.
You can ‘wake up’ your computer though.
Search for “Task Scheduler”



schedule the computer to wake up at the same time and frequency that you’ve set for the screaming frog crawls.
Then, that should be it.
The best way to run automatic crawls, is to sin up to Google cloud. At the moment you get $300 worth of credits free, and each crawl on an average ecommerce sure, will cost around a dollar a go.
Here’s the tutorial on how to set up Screaming Frog on the cloud ☁️:
https://www.screamingfrog.co.uk/seo-spider/tutorials/seo-spider-cloud/
It’s a bit of a mission/long process, but worth it. I reckon.
Anyway, here is the report, in all her glory (well, 1 part of 1 page):

Okay so, caffeine is as necessary as oxygen to most parents.
**Drink coffee and consume everything else at your own risk, innit.**
You’re cortisol levels are high and adenesine levels are low in the morning, you can greatly reduce caffeine intake with minimal negative impact by waiting an hour after waking up, before consuming caffeine.
^I robbed this concept from the Huberman Lab podcast…seems to work.
If youre a 3 or 4 a day type of guy, waiting an hour or two in the morning, you can usually cut back by 1 or perhaps 2 coffees per day.
Make the fecker stronger by adding:
– 100mg agmatine – makes it more potent
– 100mg l theanine – makes it less jittery & last longer
Ideally take the agmatine 5 mins before the coffee, doesn’t make a massive difference though.
Agmatine is pretty potent and affects people differently.
There’s good research now on agmatine for depression and it had minimal side effects, usually GI upset and headaches for some at higher doses.
Studies on agmatine and depression used doses around 2.5g per day. Which is high.

Agmatine is classed as a “novel food” in the UK, so do your own research before necking ten ton of it in your next coffee.
Start with 100mg, people take much more but its best to find a sweet spot.
People use agmatine to drop caffeine intake and to reduce tolerance rather than to just make the daily coffee stronger.
1 coffee usually lasts me all day if I take 500mg agmatine in the morning.
Caffeine works by blunting the effects of adenosine. It can also increase dopamine levels slightly.
This isn’t the only way to get more energy. Research optimising mitochondrial function if you want to take your energy up another notch.
ALCAR, PQQ, coQ10, red light therapy and even methylene blue are options to fire up the powerhouses. Just do some research before jumping in, ALCAR can impact TMAO release which may or may not be bad for cardiovascular health (jury is still out), and methylene blue with red light therapy is highly effective but doctors and academics ha e different opinions on methylene blue and its long term effects.
Anything that reduces excessive inflammation will also help you feel better and more energised. Sounds woo woo, but look into the research on grounding and grounding mats (or just stand bare foot on the garden for 5 mins).


Jumping in an ice bath with also give you a big hit of dopamine – the feel good motivational hormone – for at least a few hours.
getting sunlight in your eyes in the morning, and minimising light in the evening, especially blue light, is also good for optimising dopamine.
Light is important yo:

If you have chronic low energy, you could have burnout or even depression.
I’m not fully versed in burnout, but the way I understand it…you will normally derive energy and motivation from dopamine and feel good hormones, when you’re burnt out, you’ve depleted all your dopamine and it hasn’t been restocked – so you start relying on stress hormones to keep going.
Optimising dopamine levels and receptor sensitivity is pretty complex but you want to try and optimise sleep, and avoid too many dopamine peaking activities.
Positive intermittent reinforced is used in gambling and social media to keep people hooked – it hammers your dopamine levels. Adult / pawn films also does the same, as does coke, sugary foods and energy drinks.
Actionable Tip: Familiarize yourself with the latest features of Google Ads API Version 16. Specifically, look into new capabilities for tracking campaign performance and efficiency improvements.

Actionable Tip: Use the new call-to-action features in Performance Max campaigns to create more compelling and effective ads. Focus on designing ads that directly address your target audience’s needs and interests.
Actionable Tip: Take advantage of GA4’s updated Advertising workspace to gain insights into your campaigns. Use the dedicated spaces for tracking and analyzing campaigns and for behavioral insights to refine your marketing strategies.
Actionable Tip: Explore how AI-generated content can enhance your content marketing efforts. Use AI for content ideation, drafting initial content outlines, and optimizing existing content for SEO.
Actionable Tip: Prioritize acquiring backlinks from authoritative and relevant websites. Use tools like Ahrefs or Moz to identify potential backlink sources and monitor your backlink profile’s health.
More info –
https://moz.com/blog/link-building-okrs (OKRs are Objectives & Key Results)
Good tip for link building – is generate your own research with Google Surveys etc – people love to link to statistics
Create Linkable Assets

Actionable Tip: Ensure your SEO strategy complements your social media, email, and PPC campaigns. For example, use insights from PPC campaigns to inform your SEO keyword strategy and vice versa.
Actionable Tip: Explore the GPT Store for plugins specifically designed for SEO tasks, such as content optimization and keyword research. These tools can help streamline your SEO workflow and enhance content quality.
Some of the best Chat GPT SEO Plugins include

Actionable Tip: Create content that directly links to products or services, making it easy for readers to make a purchase. Use platforms like Instagram and Pinterest to showcase shoppable posts and stories.
Actionable Tip: Claim and optimize your Google My Business listing, focus on acquiring local backlinks, and encourage customers to leave positive reviews. Use local keywords in your website’s content and metadata.
Actionable Tip: Regularly read industry blogs and attend webinars to stay updated on the latest SEO and digital marketing trends. Websites like Search Engine Journal, Moz Blog, and Search Engine Land are excellent resources for the latest news and insights.
References

With my copy in column B, starting in cell B2, and with the language short codes “en” for the original language and “no” for Norwegian – what I want to translate the English into, in cells E1 and F1 respectively, the code I place in cell D2 is:
=GOOGLETRANSLATE(B2,$E$1,$F$1)
I can drag the formula down to translate all the English in column B.
That’s it really
🙂
By the way – if you have a site that’s randomly in 2 languages, or more – you can use detect language Google Sheets function
=DETECTLANGUAGE(“cellnumber”)