Skip to main content
dale_parent
dale_parent
Helper ⭐️
Apr 5, 2018 3:33 PM UTC

Geolocation Support

Might there be support for geocode functions in reporting/rules/outreach on the roadmap?

Use case:  Using Gainsight to send invites to contacts when we host in-person events such as Lunch and Learn.  We would want to target customers based within X miles of the event.  I'm sure there are other use cases.

SFDC customization example:

https://success.salesforce.com/answers?id=90630000000430PAAQ

Thanks

      4 replies

      elizabeth_adams_c593ee
      elizabeth_adams_c593ee
      Helper ⭐️⭐️⭐️
      Apr 5, 2018 3:46 PM UTC
      This would be amazing. Currently we have power lists built for each geographical group.
      Translate
      Elizabeth Panska
      jeffrey_dasilva
      jeffrey_dasilva
      Helper ⭐️⭐️
      Apr 5, 2018 7:06 PM UTC
      We had a similar need a few years back to figure out how many customers were within certain distances of where we were evaluating to offer training.  I put together an Excel macro to perform the distance calculation based on zip code mapping to a data sheet of longitude and latitude values of all zip codes.

      Feel free to leverage it, if you think it would help.  Maybe you could calculate distance from your Lunch and Learn then import the data into a custom MDA table which would allow you to do what you are looking for.

      Link to Excel File: https://drive.google.com/file/d/1JM7Txom0CibtB3pR7FEw1cMUUzUEPXth/view?usp=sharing
      Translate
        manu_mittal
        Gainsight Employee ⭐️
        manu_mittal
        Gainsight Employee ⭐️
        Apr 5, 2018 11:35 PM UTC
        Very cool!  I'm thinking we could load the zip-code mapping table into MDA, and then use it from within a bionic rule to look up respective latitude and longitude values. Won't be able to replicate the actual distance formula though, but could do a trigonometric approximation.
        Translate
          dale_parent
          dale_parentAuthor
          Helper ⭐️
          Apr 6, 2018 5:56 PM UTC
          Wow, fantastic!  Thank you for sharing.
          Translate
          Terms & ConditionsAccessibility statement