Home
Events
Groups
Members

01 Watercooler
02 Bugs
02 Starting with Clay
Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
Gtm Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Powered by Tightknit

Assigning Client Locations to Leads Based on Shortest Distance

·

·

Ned some help on this:

1.
I have lead database with 5000 rows.
2.
Another table with 20 client locations.
3.
Both have addresses

Is there a way that I can assign client location to each lead based on shortest distance of client location from the lead location ?

Assigning Client Locations to Leads Based on Shortest Distance | Clay

3 comments

· Sorted by Oldest

Channeled
APP
·
·
You can use our Mapbox integration to calculate distances between locations and determine the closest client location for each lead. Here's how: 1. Set up the Mapbox integration in Clay to enable distance calculations between addresses. 2. Define your routing rules based on geographic location, which will help assign leads to the nearest client location. 3. Use the "Find Distance Between Two Locations" action to calculate distances between: • Lead location (using their address) • Each client locationThe Mapbox integration will calculate the distance and estimated travel duration between the specified locations, allowing you to determine which client location is closest to each lead. Sources: Find Distance Between Two Locations with Mapbox | Clay.com What is Lead Routing? | Clay
Channeled
APP
·
·
Did that answer your question?
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.