Clay Icon
Join the Community
02 Support

Assigning Client Locations to Leads Based on Shortest Distance

Avatar of Bharat D.Bharat D.
·
·

Ned some help on this:

  1. 1.

    I have lead database with 5000 rows.

  2. 2.

    Another table with 20 client locations.

  3. 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 ?

3 comments

  • Avatar of Channeled
    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

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Did that answer your question?

  • Avatar of Channeled
    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 02 Support.