Keyword Research with SEMRush

What is Keyword Research for?

Summary tasks

  1. Create a new Google sheet: Local SEO Content Plan
  2. List down locations and services
  3. Verify lists of services + locations with client
  4. Generate blog topics and titles

Tools

  • SEMrush
  • Google Sheet
For demonstration purposes, I'm using dental clinic as example.

Initial Service and Location Mapping

  1. List down all dental services offered
  2. List down all service locations
  3. Create a spreadsheet to organize services and locations

Keyword Research Process for blog articles

SEMRush

Please watch tutorial on how to login to this tool - https://docs.google.com/document/d/1kKecFWnEpDSUnLs2ZSMEhN-iHPrjYO47Fl4TAY7v8Ks/edit?usp=sharing

https://dash.3ue.com/#/login
Acc:Sem123412
Pwd:Sem123412

(this is a group buy, ask Daniel to renew if expired)

Use SEMrush or similar tools to:

Tutorial: starts 16min50sec til 29min~
https://www.youtube.com/embed/W0X6bQEBBsM?si=wRYELhodQcbF0HlB&t=1010

1. Generate keywords using "Keyword Magic Tool"

Choose Keyword Magic Tool
Choose location, e.g. Australia

Put in one of the service category or seed keyword, e.g. "cosmetic dental"
Filter:

  • 29% difficulty
  • why, when, what, who, where, how (choose any)
  • min. 3 word count to look for long tail keywords
  • excluded branded terms

Choose 5-10, export to CSV

Go to Keyword Excel Sheet, import and append the CSV file 

Content Creation Process

Use ChatGPT to Generate SEO Optimized Keyword Title

  1. Copy all long-tail keywords to ChatGPT
  2. "Generate me SEO title that includes my main keyword, give me 5 variations for each long-tail keyword"

Tutorial: 31min 15sec → 34min~
https://youtu.be/W0X6bQEBBsM?si=WEVtczBlGVlyi5TK&t=1875

We want these 2 to proceed to bulk blog writing:

  1. PAGE TITLE
  2. MAIN KEYWORD

Content Development

Follow this SOP → Bulk Generate Blog Articles

(This part can be automated with AI writers)
 
 

Was this article helpful?
© 2025 Bingo Digital Marketing PLT