In my niche, the transactional KWs don't generally have locations in the actual keyword.
But Google serves local results for them.
So if you search from City X, Google serves businesses and directory pages located or related to City X.
I think I need to make city pages to rank for these types of transactional keywords (correct me if I'm wrong).
The thing is, I'm trying to figure out search volume by cities, so I can create city pages for the areas where more people are searching.
But tools like Ahrefs show little to no volume for KWs with the actual city name in them, since most people just search the main keyword without their city name in it.
Any tools/strategies you know of? Or any other input about ranking for keywords that serve local results? I don't want to waste time creating state and city pages if that's not the key to ranking for these kws. Thanks!