Recently, during a webinar I heard an absolutely magnificent piece of insight, which inspired me to create the resource I am sharing today:
‘There is no such thing as keyword cannibalization, only search intent cannibalization’
Bernard Huang, Co-Founder of Clearscope
I am presenting a keyword classifier Data Studio Dashboard, which utilizes the search intent categories we know and use:
* informational
* navigational
* transactional
* commercial
Setting up is as easy as 1-2-3: 1. Export data from Semrush or Ahrefs. 2. Copy the Search Intent Keyword Classifier Data Studio Dashboard 3. Connect your data
(optional) 4. Create a multi-page report, using different keywords to create a 360-degree view of a topic cluster.
Using the dashboard in your content creation process 1. Get an overview of the keyword cluster. 2. Find out what the search intent keyword distribution is for a related keyword. 3. Search keywords by type of SERP feature.
Automatically Generate Your Meta Descriptions Using Python And BERT
If you want a quick and dirty way to programmatically meta descriptions at scale using Python, this is the tutorial for you.
Meta descriptions are used as part of the site’s metadata, as well as shown in SERPs to provide search engine users with a brief summary of a page.
They impact search rankings indirectly. By being visible in the SERPs, meta descriptions can impact the click-through ratio (CTR).
If your site has thousands or even millions of pages, hand-crafting description meta tags probably isn't feasible. In this case, you could automatically generate description meta tags based on each page's content.
How to filter a column of broad match keywords, using a REGEX match filter formula to return question-type long-tail keywords. 🧵 #seo
Question-type keywords are long-tail keywords that contain the seed keyword in any order, plus a “question word” like “how,” “what,” “where,” “when,” or “why.”
Export a list of keyword recommendations from @semrush Magic Keyword Tool.
In order to fill the Questions column, we use a regex match formula in the filter criteria, referencing the list of keywords exported via the Keyword Magic Tool from SEMrush.