User Intent - Office Chairs & Content Writing

[BeckyKey]

Hi

I'm trying to look for ideas for content on office chairs. Any ideas on where to start with user intent for this type of search query? I'm using answer the public to gather some ideas.

Some are good ideas, but I can't actually find any search volume for the phrase so then I'm unsure whether to devote time to writing something.  Surely most people want to just find a supplier, buy the chair & they don't want a huge informational piece how to buy a chair.

Our competitors are the likes of amazon, and a load of other huge companies with high DA - so I'm looking at types of content we can write, people are interested in reading about chairs, which is less competitive..I'm not sure that exists...

Any help is appreciated

[Igor.Go]

Here's what I would do if I needed keywords about chairs with commercial intent.

Step 1: Get as many keywords related to this topic as possible.

Step 2: Paste your list of keywords into notepad++

Step 3: Use replace feature (Ctrl+H) to start each line* with "google.com/search?q=" https://i.imgur.com/sJ1g854.png
this will turn your list of keywords into the list of search queries. https://i.imgur.com/sJ1g854.png
This symbol ^ stands for the beginning of the line in Notepad++, so set N++ to replace ^ with that google thing.
Replace all spaces with a + sign for keywords that have more than 1 word to get google.com/search?q=best+chairs

Step 4: Use crawler tool (Netpeak Spider has 2 weeks free trial) set it up to crawl your list of "google" URLs from Notepad ++ and fetch

's This is where page titles are nested in SERPs, there will 10 h3's for every keyword you used.

Example: https://i.imgur.com/x5UMGSU.png

Step 5: Paste Page titles with google URLs into spreadsheet and use conditional formatting to highlight titles where words like buy, for sale, price, delivery and etc. are used. Use words that indicate commercial intent.

Step 6: count number of commercial titles per SERP for every keyword to see if SERP is commercial or informational.

Step 7: separate commercial queries from informational

Step 8: analyze informational keywords only and build your content strategy around those keywords, they will be easier to rank for with articles and etc.

[BeckyKey]

Wow thanks, I'll give this a go

[BeckyKey]

Can you do the same thing with screaming frog? I'm not sure how you do it?

[Igor.Go]

Not sure how to do it with Frog, but I'm pretty sure you can. You can always start a chat with guys from Netpeak Spider's support, they'll show you how to setup everything, just send them a link to this thread

[ThompsonPaul]

Yup, can do the same approach with SF. You can run it in List Mode which will let you upload the list of URLs to crawl, and you can set up an Extraction to separate out the h3s (Configuration > Custom > Extraction)

Paul