Lesson 2 of 7

Lesson 1.2.2

Pull your first 120 companies from Google Maps

7 min read5 min videoBeginner

What this costs

Sourcing is charged per row produced. Start at 120 rows so the filter later has something to cut.

Before you start

A workspace and a market in mind. No prior project needed.

Google Maps is the fastest route from an empty workspace to real rows, and the rows come with enough detail to filter on immediately. You will end this lesson with a table you have not spent a single enrichment credit on.

  1. 1

    Start a new research project

    From the dashboard, click New Research. Name the project after the market and the date, not after the client. You will build several versions of this list and you want to tell them apart later.

    The Kuration dashboard with the New Research entry point
    Every project starts here.
  2. 2

    Select Google Maps as your source

    Choose Google Maps from the data source options. If you are unsure whether your market has a physical presence, this is the cheapest way to find out.

  3. 3

    Describe the business in plain words

    The field asks what business you want to extract. Write it the way you would say it out loud, category then place. Plain phrasing beats clever phrasing: write "bookshops in Japan", not "search for bookshops in Japan".

  4. 4

    One location per search, then merge

    This is the rule the panel states and almost everyone breaks. If you put several locations in one search, only the first is really prioritised. Cover a country city by city with separate searches and merge them afterwards, which course 2.3 shows you how to do.

  5. 5

    Set the count in multiples of twenty

    The minimum is 20 and only multiples of 20 are accepted, so 20, 40, 60, 120 and so on. Ask for roughly three times the number of companies you want to end up with, because you are about to cut this list hard. For a 40 row target, ask for 120.

    The Find Local Businesses by City or Region builder in Kuration, with its description field, result count, best practices panel and example output
    1
    2
    3
    4
    5
    1. 1The price, on the builder itself. Sourcing is the cheapest step in the whole loop.
    2. 2What business do you want to extract. Category and place, in plain words.
    3. 3How many. This is the number that decides whether your filter later has anything to cut.
    4. 4The rule the field does not spell out until you break it: minimum twenty, multiples of twenty only.
    5. 5Best practices, from the product itself: one location at a time, city by city, plain phrasing.
    The whole builder on one screen, including the example output it will produce. The best practices panel is worth reading once: two of the three rules are things people otherwise learn by getting a thin list.
  6. 6

    Extract, and watch the table fill

    Click Extract. Rows populate in real time. Each one arrives with business name, address, phone number, website, rating, review count, category and opening hours.

  7. 7

    Then run it again, differently

    Two more searches, and neither is a repeat. One with a different category phrasing, because solar installers and solar panel companies return overlapping but different sets. One for the next city. Merging them is course 2.3.

What good output looks like

Worked example · A Google Maps extraction, first six columns

Business nameCategoryRatingReviewsWebsitePhone
Bayside SolarSolar energy contractor4.8212baysidesolar.comlisted
Helios Panel CoSolar energy company4.238heliospanel.comlisted
Sunline InstallersSolar energy contractor3.19not listedlisted
Vantage RenewablesRenewable energy supplier4.9146vantagerenew.comlisted

Look at row three. No website and nine reviews. That row will fail the filter in the next lesson, and because you have not enriched anything yet, cutting it costs you nothing and saves you the five credits it would otherwise have consumed.

Asked for exactly the number of rows you wanted

What you see
Nothing left after filtering, so you either skip the filter or start again
The fix
Source three times your target. Sourcing is the cheapest step in the whole loop.

A category term nobody uses

What you see
Very few rows return, or the wrong kind of business
The fix
Use the words businesses use about themselves on their own listing, not the industry term you use internally.

Location too broad

What you see
Results skew to one city and miss the rest of the region
The fix
Run several tighter searches by city and merge them, rather than one search for a whole country.

Check yourself

0 of 3 answered

1.You want to end up with about 40 companies. How many should you ask the builder for?

2.How should you cover several cities?

3.You type 50 into the result count and it is rejected. Why?

Answer all 3, then open Turn any directory or listing page into a table to tick this lesson off.

Try it yourself

Source 120 businesses in a category and city you know well. Do not add a single tool column yet.

You have done it when
A table of at least 100 rows where you can already see, by eye, roughly a third you would never contact.
Credit budget
Sourcing only. No enrichment credits spent.