FreeGSC + a spreadsheetAbout 30 min
Build Your Seed Keyword List
Start your keyword list from two free sources. One is your own services. The other is the searches you already show up for in GSC. A seed is a short starting term, like brake repair, that you'll grow in the next lesson.
Why This Matters
Terms you already rank for, even on page 2 or 3, are your fastest chances. They cost nothing to find. Owners also tend to use trade words customers never type. Your query data shows the words real people use.
✓ How To Do It
- List every service, product, and problem you solve. Write problems the way a customer would say them, like car won't start.
- Pull GSC → Queries and add every term you already get impressions for. Set the range to the longest period you have, then export.
- Ask whoever answers your phone what customers ask for by name, and add those words too.
- Combine them into one spreadsheet column as your seed list.
- Don't filter yet. Gather broadly first. Delete only exact duplicates.
Done WhenOne column holds every service and every GSC query with impressions.
Tips & Pitfalls
- Keep your city names in a separate column. You can combine them with services later, without doubling your list now.
- Odd queries in GSC can point to services you never knew people wanted. Note them before you write them off.
- If GSC is brand new and empty, use your service list and your competitor study for now. Come back in a month and add the real queries.
Email Me The Free Course
Get your course link in your inbox so you can pick it up on any device. It's free, with no card.