Using AI Tools to Discover Duplicates at Scale

[cleverlyengaged]

I have a client with 700+ gas station locations and we are discovering a variety of problems on Google Maps.

1. Old gas stations that are still open in Google Maps at the same address as the client.
2. Convenience store partners that are incorrectly categorized as gas station, creating two businesses with the same category, same phone # and same address.

Here is an example of a duplicate:
https://maps.app.goo.gl/CitzGtr6ysHLB6MNA
https://maps.app.goo.gl/fbbcQ3pwhsPSVXcUA

I have attempted to get AI tools to help with this effort, but none appear to be able to crawl or access Google Maps. This is where most of the issues are coming from. Trying to scale and look at all locations, but curious if anyone has a recommendation

 

[ElizabethRule]

@noahlearner might be able to help with this one

 

[noahlearner]

If I had to solve this problem I would :

• build a list of all the gas stations in my client's portfolio into a google sheet
• get the zip codes for each one as a column in the google sheet
• work with a rank tracker api (I like dataforseo for adhoc problems like this)
• build a script that performs a search in each zip code for "gas station"
• store the results in Google BigQuery.
• build a looker studio report to help me look at each city to find problems
• compile a list of problem locations
• go through normal GBP processes to report problems.

I know this is a pain in the behind amount of engineering, but this is that kind of problem to solve.