Kunjal
In this blog post, I will share a Google Sheets App Script that will help you flag URLs that are blocked from Crawling and which ones aren’t blocked from Crawling. Use Case: You are handling a huge enterprise website comprising of thousands or millions of pages. A new robots.txt got implemented & you want to … Read more
In today’s post, I will talk about how you can build a text sentiment classification Google Sheets AppScript using Huggingface Inference API. How will this help? It will help you classify text on your Google Sheets cell into the following sentiments Positive Neutral Negative AppScript will allow us to generate a formula using which we … Read more
In this post, I will talk about how you can leverage Reddit API in conjunction with a Python script and Google Colab Notebook to conduct web scraping around a brand name. What’s the use case? Let’s say you want to inquire what people think about the brand in question then in that case this Python … Read more
In this post, I will explain how to use GSC (Google Search Console) API with Python Script to identify the outliers in Search Impressions & Search Clicks data. Outliers here means Anomalies in the data. i.e. query you received impressions or clicks for unusally. Let’s say there are X number of queries you receive clicks … Read more
Ever wondered what Carbon Footprint your webpage left behind? Let’s first establish what a Carbon Footprint is. In the words of Emich.edu A carbon footprint is the total greenhouse gas (GHG) emissions caused directly and indirectly by an individual, organization, event or product. The internet consumes a lot of electricity and the same electricity (at … Read more
Wikipedia has covered pretty much every topic your mind can conceive. Another thing Wikipedia is good at is internally linking from one page to another. Wouldn’t it be great to have this corpus of knowledge as a reference point? I was doing some research & found out that there happens to be a Wikipedia API … Read more
Vector Embeddings are all the rage in SEO right now. Since LLMs like ChatGPT & Google AIO came into the picture vector embeddings are getting an overwhelming adoption for various use cases. What are Vector Embeddings? Simply put, Vector Embeddings are a concept in NLP (Natural Language Processing) here the indication is towards word embeddings … Read more
Cannibalization is a topic in SEO that can be seen as proactive or reactive. Proactive is when you do an existing analysis before launching any new page to ensure that you are not going to cannibalize the existing page with a new page. But if you encounter a website that already has hundreds of thousands … Read more
Have you ever wondered what CSS & JS is responsible for what you see in the frontend? I mean sure it’s easy to determine it by simply enabling or disabling CSS & JavaScript on your browser but what if you want to find the exact CSS or JS files responsible for front-end visibility, features & … Read more
What is Named Entity Extraction? In simpler terms Named Entity Extraction (NER) is a process of extracting entities from unstructured or raw text in Natural Language Processing. The purpose is to classify or cluster documents based on the extracted entities. There can be multiple use cases of NER but at its core, it’s to classify … Read more