Building a job list
List the keywords
Enter one trade, category or product per line in Keywords. Near-identical lines are merged:
Roofersandroofercount once, as doBed & Breakfastandbed and breakfast. Anything merged is listed under lines left out.List the locations
Enter one place per line in Locations: a town, a postcode district such as
LS6, an area name, or a point written as53.96, -1.08. A number after a point, as in53.96, -1.08 15, sets the zoom for that point only.Pick the joining word
Choose in or near. Place-name searches are written as
keyword in placeorkeyword near place; coordinate searches need no joining word.Set zoom and language
Zoom for coordinate locations (1 to 21, default 14) applies to points without their own zoom. Map language adds
hl=to each link, which changes the language Google Maps uses for its interface.Use the links
The first 20 links in the table open in a new tab when clicked. Download CSV saves every job with its ID, keyword, location, query, coordinates, zoom and link; Copy all links puts them on your clipboard, one per line.
Example: roofing trades around York and Harrogate
A roofing supplier wants to list contractors in North Yorkshire and north-west Leeds. The keyword list has a careless duplicate, Roofers, which is dropped because it matches roofer. Four locations times three keywords gives 12 jobs. The last location is a point near Harrogate with its own zoom of 15, so its three links are centred searches rather than in searches. Map language is set to English (UK).
Jobs are grouped by location: all keywords for York first, then Harrogate, and so on, which is the order you would usually work through by hand.
Keywords: roofer Roofers scaffolding loft conversion Locations: York Harrogate LS6 53.9921, -1.5418 15
job_id,keyword,location,query,latitude,longitude,zoom,url J0001,roofer,York,roofer in York,,,,https://www.google.com/maps/search/roofer+in+York/?hl=en-GB J0002,scaffolding,York,scaffolding in York,,,,https://www.google.com/maps/search/scaffolding+in+York/?hl=en-GB ... J0010,roofer,"53.9921,-1.5418",roofer,53.9921,-1.5418,15,"https://www.google.com/maps/search/roofer/@53.9921,-1.5418,15z?hl=en-GB" 12 jobs in total; 1 keyword left out (Roofers, same as roofer)
Two shapes of search link
The builder writes one of two formats depending on how a location is written. Both open a normal Google Maps results list.
| Location written as | Link written and how Google Maps treats it |
|---|---|
| A place name or postcode | /search/plumber+in+Bath/. Google works out where Bath is and frames the results itself. Good for towns with a clear centre. |
| Coordinates | /search/plumber/@51.38,-2.36,14z. The map opens centred on that exact point at that zoom, and results are drawn from the visible area. Good for suburbs, industrial estates and grid cells. |
| Either, with a language | ?hl=en-GB on the end. Interface language only; it does not restrict results to one country. |
Why a keyword list times a place list beats one big search
A single search for builders Yorkshire asks the map to rank a whole county at once, and it shows a limited list of the strongest matches. Splitting the job into one search per trade and per town gives each search a smaller patch to rank, so local firms that would sit far down a county-wide list come to the top of their own town's list. It also makes the work countable: you know there are 12 searches, you can tick them off, and you can see which pairs returned nothing.
Writing those combinations by hand goes wrong quickly. A typo in one town name, a keyword pasted twice with different capitals, or a forgotten space in a link means a search silently never happens. The builder normalises spacing, merges near-duplicates and encodes every character correctly, including accents and ampersands, so café & bakery in St Ives becomes a link that works.
If a town is too big for one search, replace it with several coordinate points. The city grid search generator produces evenly spaced points you can paste straight into the locations box.
Tidy the lists before you build
- Write keywords the way a customer would search, such as
electricianrather thanelectrical contracting services. - Use postcode districts (
LS6,YO1) for dense cities and town names for market towns. - Keep the job count you can actually work through; the builder stops at 5,000 jobs.
- Check the lines left out list in case a merge removed a keyword you meant to keep.
- Save the CSV before you start, so you can record results against each job ID.
Questions people ask
What is the Google Maps search URL format?
A search link is https://www.google.com/maps/search/ followed by the search text, with spaces written as plus signs, for example /maps/search/florist+in+Chester/. To centre the map on a point, add /@latitude,longitude,zoomz after the text, as in /maps/search/florist/@53.19,-2.89,14z. The builder writes both forms for you.
How many search links can I generate at once?
Up to 5,000 jobs per run, which is the keyword count multiplied by the location count. If your lists multiply past that, the counter shows the full total and the builder keeps the first 5,000, grouped by location. Split the location list into batches and build each one separately.
Should I use "in" or "near" in the search?
"In" usually keeps results inside the named place, which suits towns and postcode districts with clear edges. "Near" can pull in businesses just over the boundary, which helps for villages with few listings. Try a couple of searches both ways for your trade and area, then build the full list with the one that gives cleaner results.
Does the language setting change which businesses appear?
The hl parameter sets the language of the Google Maps interface, such as button labels and category names. It is not a country filter. Which businesses appear depends mainly on the search text, the location and the map area, so to stay within one country, name places in that country or use coordinates inside it.
Can I open all the links at once?
The first 20 links in the table are clickable and open in new tabs one at a time, which keeps browsers from blocking a flood of pop-ups. For the full list, use Copy all links or the CSV, then work through the jobs in order and note the results against each job ID.
Where your data goes
The links are written by this page from what you type. Nothing is sent to Map Extract or to Google while you build the list. A search reaches Google only when you click one of the links, and then it goes from your browser to Google directly, as any search would.
Checked against the tool on