.png){kind=logo}
When using the Google Maps API to collect business, any idea why it ca...
When using the Google Maps API to collect business, any idea why it caps at 183-185? Or is it just me?
When using the Google Maps API to collect business, any idea why it caps at 183-185? Or is it just me?
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Hey Marvin, thanks for reaching out! Could you share the link to your table? can take a look. What comes to mind is that the radius or specified query may be limited to those results(?)
I did change radius but still the same both tables stopped at 183 and when I try to rerun for +25 lines it doesn't add any... Link 1: https://app.clay.com/workspaces/102433/tables/t_ZGtvqceaQedl/views/gv_laerG8HAKULB Link 2: https://app.clay.com/workspaces/102433/tables/t_FFdZ4PaZV075/views/gv_tmIwGXelwz8g
Hey Marvin, sorry for the delay! taking a look
Marvin K. dove into these results here! reason why you're seeing 183-185 is the google api is capping our total number of results at 200 (20 per page, 10 pages max). we then automatically dedupe results based on their id - sometimes the same business shows up multiple times in the results. in your search, i saw 14 duplicate results. since google results change slightly over time, that number can change by a bit anytime (so you probably saw 15 and 17 duplicate results just depending on when you ran the search and how google had indexed that day).unfortunately because google limits us to the first 200 results no matter what, we can't get more than 200 results for any one "find local businesses using google maps" source. but a way to work around this is to slightly change your query (maybe change the location you're looking at, or try different keywords) in a new "find local businesses using google maps" source, then add the results to this existing table rather than create a new table.Matthew Q. this is likely why you saw what you saw too. we should update the copy to say you'll see max 200 results rather than 300 though, and to indicate that you'll probably see less because of deduping. i made a PR for this, will lyk when live
Colin P. is there any way around something like this? my use case is a bit different - i'm trying to get a list of every Dentist in a particular metro area but its tough to understand when i have overlap. Is there another way that would work better with Clay to get this list?
Sorry for the delay, Christian! Unfortunately, the way that integration works is limited to those specific options, setting a radius and specifying the location in the query sometimes helps too. In regards to the import amount, that's also a hard limit this provider has for the search
Christian W. wanted to close the loop here - not sure if all this ^ solved your issue! if you add these results to the same table, you should be able to dedupe results by clicking on a column header and selecting dedupe. so in your case, you might add dentists to a table from salt lake city, san francisco, and seattle. then, to avoid any duplicate results, you might dedupe by "address" (unless 2 dentists share the same building, this should be a unique property). lmk if there's anything else we can do to help with this use case!