Filter Google Maps local business list by number of locations & review response rate

I’m trying to filter the Google Maps list of local business with two additional data set: 1) number of locations; and 2) how often do they respond to reviews (%). The first one requires finding duplicates from a large list but wondering if there’s an easier way (e.g., Google Maps can organize listing as chains). Not sure Clay can pull review responses though. Thanks.

✅1

7 comments

Tarik Q.
·
·
https://app.clay.com/workspaces/210328/tables/t_OMrtxAPIV1SO/views/gv_6pZaQvshb1gW
Clay Team
APP
·
·
Hey there Tarik sorry for the delay, let me take a look.
Clay Team
APP
·
·
Ok, to answer the first question, if you use filters, you can filter out a row entry who name is equal a specific business. For example in your table you have Subway, so you can filter all locations whose name is equal to Subway. Then you can duplicate a view for that particular business chain and repeat for all other chains you may have.For the second questions if you use a formula you can tell Clay to give you the response percentage on reviews. For example a formula prompt like "Return the response percentage rate from /Reviews" should return the percentage of review responses.
Tarik Q.
·
·
Thanks, with regard to your second answer; don’t I need to find the responses first so I can add this formula? Hence my initial question, is there a way to fetch the number of review responses on Clay?
Clay Team
APP
·
·
So review response are also pulled when running the "Find Business Reviews Text and Keywords". If a review was responded to it will show up as "response" underneath the snippet box
b311d97f-2c25-41b7-99d3-ce2f1ef8a6ef.png(101 kB)
Clay Team
APP
·
·
So yes if there is a response clay can pull it.
Tarik Q.
·
·
Aaaah got it thanks a lot Luis.