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
New Idea
Geolocation Support
This would be amazing. Currently we have power lists built for each geographical group.
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
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
+2Very 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.
1 person likes this
Wow, fantastic! Thank you for sharing.
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.