Blog

How to Use the Google Search Console API

This guide documents how I use Search Console API to be more flexible in accessing Google Search Console data, so I can easily replicate the setup in another computer

How to Use Google Search Console to improve SEO

Learn how to use Google Search Console to unlock easy SEO wins. Find untapped keyword opportunities, discover hidden insights and fix indexing issues.

13 Practical Use Cases of RegEx in Google Search Console

Learn how to use regex in Google Search Console to filter queries and pages. This guide provides practical examples and tips for better SEO analysis.

Google Apps Script for SEO

Create custom function in Google Sheets with this Google Apps Script cheat sheet. Automate tasks like checking HTTP status codes and fetching meta data.

Automate SERP processing for keywords in bulk with Python and Google Colab

Learn how to bulk check Google SERP for multiple keywords using Python in Google Colab. Simplify your bulk SERP processing with ease.

How to Extract Page Titles and Descriptions in Google Sheets

In this guide, we'll walk through a simple method to extract page titles and descriptions from URLs in Google Sheets using a combination of functions.

How to Highlight Entire Row with Conditional Formatting in Google Sheets

Let's learn about how to highlight an entire row using conditional formatting in Google Sheets.

29 Google Sheets Formula for SEO

Learn how to quickly and easily analyze, plan, and track your SEO campaigns. Save time and effort by using these 29 powerful Google Sheets formulas.

Install Google Analytics 4 with Google Tag Manager

Learn how to easily set up Google Analytics 4 using Google Tag Manager. so you can gain valuable insights into your website's performance and user behavior.

5 Best Chinese Keyword Research Tools

I've picked out five of the best tools for keyword research for Chinese.This article is targeting users who need to research Chinese keywords for Google.

To Space or Not to Space: How does spacing work in Chinese writing

Are you struggling with spacing between Chinese characters (and English words)? Learn more about how spacing work in Chinese writing.

Chinese Date Format

Learn how to write dates in Chinese and understand how Chinese date format impact your SEO.

How to Create (SEO-friendly) Chinese URL

Learn how to create effective SEO-friendly URLs for your Chinese website so you can get optimal results in organic search traffic.

Cantonese vs Mandarin

Learn more about the nuances between Cantonese and Mandarin can help you localise the content for the right Chinese-speaking market.

Traditional Chinese vs Simplified Chinese

Learn the key distinctions between Traditional and Simplified Chinese so that you can make an informed decision when creating a strategy for marketing success.

Content Inventory: Organize, audit, and optimize website content

This article outlines how I create a content inventory and how I use it to improve your content strategy.

Refining Content Strategy through SERP Similarity and Overlap Analysis

Learn to build your own SERP overlap tool with Python in Google Colab to analzye SERP similarity and identify ranking opportunities.

Content Freshness: How Publish Date impact SEO

Discover how displaying a visible publish date on web pages impacted organic traffic, CTR, and rankings.

How to Stand Out and Beat Content Saturation

In this blog, let’s talk about content saturation and discuss how to ensure your content gets the attention it deserves.

How to Conduct a Content Gap Analysis

Learn how to conduct a thorough content gap analysis to identify areas for growth and help you reach your target audience more effectively.

Why is having duplicate content an issue for SEO?

Having duplicate content can actually hurt your SEO efforts and result in lower search engine rankings.

How to use Google Sheets to Track Content Decay

With Google Search Console and Google Sheets, you can easily get a holistic view of your content performance.

What is Content Decay and How to Fix it?

Learn what content decay means for SEO, why you should care about it and how to fix it in order to ensure your website's organic performance remains strong.

SERP Analysis

Learn about the benefits and the best practices of SERP analysis, including optimizing content, researching keywords, and analyzing the competitive landscape.

How to create content using AI… and rank on Google?

In 2022, I published 3 articles using AI writing tool and the main words are ranking on 1st page. Check out my process and key takeaways about AI content.

Optimize Your International SEO with Hreflang Best Practices

This blog post will explain the hreflang attribute, when it should be used, and provide practical tips for implementation.

How to Change Google Search Location

Here's a step-by-step guide on how you can change your location on Google Search to get location-specific results.

International SEO Best Practice

International SEO is essential to enhance your visibility in various markets and make sure that your website is visible worldwide.

International SEO URL Structure

Everything you need to know about international SEO URL structure, and how you could up your search engine game even more for a global audience.

Keyword Localisation

In this blog, we will discuss keyword localisation and its importance for effective global SEO.

How to use Google Search Console for Keyword Research

In this blog post I will show you how I use Google Search Console for keyword research and find keyword opportunities.

How to use Google Search Console to find question keywords

Learn how to use Google Search Console to uncover question keywords that can boost your SEO strategy.

What is Keyword Mapping?

In this blog, we will discuss what keyword mapping is, how it works, and why it is important in SEO.

How to remove sitemap from Google Search Console

This guide explains how to remove a sitemap from Google Search Console, and explains when you should (or shouldn’t) do it.

How to use site: search operator

The site: search operator can help you identify indexing issues, optimize internal linking, or analyze competitor websites.

Best Chrome Extensions for SEO

In this post, I’m sharing my favorite free SEO Chrome extensions that I personally use to get the job done faster and more effectively.

SEO Bookmarklets

SEO bookmarklet is a code snippet saved as a browser bookmark to perform different SEO tasks. Check out these SEO bookmarklets to boost your productivity.

Should Outbound Links Be Nofollow?

Should outbound links be "nofollow"? Learn when and how to strategically implement nofollow links.

How Many Outbound Links Per Blog?

This article aims to guide you on the importance of outbound links and how many is too many.

E-commerce Schema Markup Best Practices

Discover 13 e-commerce schema markup best practices to help crawlers and AI agents understand your product and business.

Brand schema markup

This guide explains what brand schema markup is, which properties matter, how to implement it correctly, and why it’s becoming critical for AI-driven search experiences.

Can Event schema be used for Ecommerce promotion?

Event schema isn’t meant for ecommerce promotions. Learn when it’s appropriate, why most sales shouldn’t use it, and what to use instead.

How to use audience in schema markup

This guide explains how to use the audience schema markup correctly, with practical patterns and examples tailored to real-world eCommerce and SaaS implementations.

How to implement Product Variant schema with ProductGroup

Learn how to implement ProductGroup and Product variant schema correctly for single-page and multi-page setups.

Local Business Schema for Multiple Locations

In this guide, we will discuss the steps to implement LocalBusiness schema for multiple locations and provide helpful tips and example.

ProfilePage Schema Markup

ProfilePage schema identifies a webpage as a profile about a specific person or organization. It helps search engines understand that the page represents someone’s identity.

Schema Markup for Product Category Pages

Learn how to implement schema markup for product category pages using CollectionPage and ItemList.

The Benefits of Schema Markup

Learn why schema markup is important and how it helps search engines understand your content,.

Breadcrumb Schema

Breadcrumb schema is a type of structured data that helps search engines understand a page’s position in a site’s hierarchy and display breadcrumb navigation in search results.

Organization schema

Many brands overlook Organization schema. Learn how structured data can give your company a competitive edge in Google’s search results and knowledge panels.

How to Mark Up a Product with Regular and Discounted Prices

To show both regular and sale prices in schema markup, use priceSpecification with priceType: StrikethroughPrice for the original price.

7 schema markup for e-commerce websites

The 7 most useful types of schema markup for ecommerce websites are Product, Offer, aggregateRating, Breadcrumb, FAQ, Organization, and Carousel.

How to use SoftwareApplication Schema

Learn how to implement SoftwareApplication schema to boost your software’s visibility in search results. Includes best practices, rich result tips, and structured data examples.

How to Integrate FAQ Structured Data with WebPage or Article Schema Markup

Learn how to nest FAQPage schema into WebPage or Article structured data using the hasPart property.

How to fix unparsable structured data

Receive an “unparsable structured data issues detected” warning? Don’t panic – learn how to fix structured data error in this guide.

How to use event schema for multiple dates

How to use event schema for multiple dates? Let’s dive into two main scenarios that you may encounter when creating the Event schema markup.

How to use “knowsAbout” schema

This article will explore how to use the "knowsAbout" schema and what properties to include.

How to use Author schema for E-E-A-T?

Author Schema is a structured data markup that showcases the author's expertise and credibility. Learn how to implement it effectively on your website now.

How to add schema markup with Google Tag Manager

In this step-by-step guide, let's discover how to add schema markup with Google Tag Manager.

How to choose @id for Schema

Let’s take a closer look at how to choose the @id for your schema markup, especially if you're an SEO specialist looking to optimize your website.

What is sameAs Schema

Let's take an in-depth look at the sameAs schema and how to implement it properly on your website.

What is Schema Markup

In this beginner’s guide, let’s take a look at what schema markup is, how it works, and how it can benefit your website.

Person Schema Markup

A Person Schema markup is a type of structured data that helps search engines understand specific information about a person.

How to Check Schema Markup

Adding schema markup to a webpage can help it appear more prominently in SERPs. Learn how to check and test schema markup for your website so you can ensure that you're implementing it correctly.

8 common site name problems in Google Search and how to solve them

This guide will walk you through common questions about site names and practical troubleshooting tips to help you better understand how Google handles them.

How to change the links that appear under your site on Google

You can’t change the links under your site on Google as it’s determined algorithmically. But here are some best practices to improve your sitelinks.

How to Remove 404 Error Pages From Google

Removing or redirecting 404 error pages is essential to ensure optimal SEO performance. Let’s uncover the steps to remove 404 error pages from Google.

How to Optimize HTML Structure for SEO

Learn how a well-organized HTML structure boosts SEO. Discover tips and common mistakes for better search engine rankings.

Google Apps Script for SEO

Create custom function in Google Sheets with this Google Apps Script cheat sheet. Automate tasks like checking HTTP status codes and fetching meta data.

How to Extract URLs from a Sitemap Using Google Sheets

Learn how to extract URLs from a Sitemap using Google Sheets.

Optimize Your International SEO with Hreflang Best Practices

This blog post will explain the hreflang attribute, when it should be used, and provide practical tips for implementation.

How to solve “No Referring Sitemaps Detected”

"No referring sitemaps detected" message in your Google Search Console isn't necessarily an error that needs to be fixed. Let's find out why.

How to Optimize URL Slug for SEO

Learn more about what URL slugs are, why they're important for SEO, and how you can optimize URL slugs for better search engine performance.

How to Manage RSS Feed URLs in Google Search Console

Are you having many RSS feed URLs in your Google Search Console Indexing Report error? Learn how to manage them to improve your SEO.

How to Submit Your Robots.txt File to Google Search Console

Learn how to submit your robots.txt file to Google Search Console with a step-by-step guide.

How to Fix Non-Canonical URLs in a Sitemap

Non-canonical URLs are URLs that have the same content but with a different URL structure. Learn how to fix non-canonical URLs in a sitemap.

Trailing Slash in URLs

Having a trailing slash at the end of URLs is a matter of preference, but it's a good practice for maintaining consistency.

How to Find Broken Links in Screaming Frog

In this article, I will show you how to find broken links in Screaming Frog.

What is robots.txt file?

A robots.txt file is a simple text file that is placed on a website's server to instruct search engine crawlers on how to interact with the website's pages.

How to view page as Googlebot

In this blog post, let’s explore why viewing your site as Googlebot is so important, how to do it, and what insights you can gain from the experience.