This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
The Q2 2020 Business and Location Insights data packages are now available for your analysis. The packages include analytics-ready data from a variety of vendors as well as data-specific analysis tools which will empower users to get the most from the packaged data. Here’s what you have to look forward to in this release!
If you need more geographical information on a coordinate, try converting it into a spatial object and using the Find Nearest Tool to find coinciding Experian geographical data from an Allocate Input Tool.
Have some Latitude/Longitude points and not much else? Working with Spatial Objects and need more information than a simple map point? Time to call in the Reverse Geocoding macro. Reverse Geocoding can give some robust information to help make important business decisions when working with spatial data. Case in point: Your “friend” has hacked the Pokémon Go APK and hands you a list of Pokémon with the associated Latitude/Longitude. You can’t make an informed decision on your next weekend Poke-session without first understanding more than just the location on a map!
Hi, we had shared in our release documentation that end users are reminded if they have not installed the geocoder and reverse geocoder macros from the Q3 2017 release that they do so due to several key changes implemented in that release. The below changes were -
Geocoder (affects UK/ROI, AU/NZ, BR and EU Spatial installs only)
Migration to TomTom’s Online Search API and license key update therefore geocoders installed prior to the Q3 2017 release will not be active after December 31, 2017
The macro has been updated to meet the currently supported version of Alteryx Designer 10.5.9.15014
Updated Customer Support error messaging
Reverse geocoder – last two bullets plus,
Adding logic to replace missing latitude and longitude values with 0 and alerting users when these missing values are converted to 0
Migration to TomTom’s Online Search API and license key update therefore reverse geocoders installed prior to the Q3 2017 release will not be active after December 31, 2017
Please ensure that you have installed the Geocoder (where applicable) and Reverse Geocoder macros from installs including and after Q3 2017.
If you have any questions, please contact firstname.lastname@example.org.
Thank you -
Alteryx Data Artisans occasionally identify problems with how street segments are displayed or where addresses may be located. They want to pass along corrections and may reach out to Alteryx to help. Artisans can actually provide feedback directly back to our spatial vendor, TomTom, by logging into this web site: http://www.mapsharetool.com/external-iframe/external.jsp.
You can submit a report after logging in with Facebook, Google or Yahoo. As noted on the linked page, your reports help them keep their maps as accurate as possible.
In June of 2012, the USPS made a change to how a P.O. Box operates. That change now allows for a street address to be used in lieu of a P.O. Box. This format, known as a P.O. Box Street Address (PBSA), is actually the address of the post office of where the P.O. Box is located. How does this affect Alteryx? One client brought to our attention that this could potentially affect address and demographic analysis. Let's say a user has a small list of competitors and they want to run a competitive analysis. The only issue is that several of these records are using a PBSA. The demographics for these records will revolve around the post office, not the actual business. How do we combat this? The first thing to keep in mind is that Alteryx is perfect for this sort of scenario. The USPS has posted a list of their post office locations as a .txt file. Attached to this post you will find an Alteryx Zip Package that informs you of where you can find the file (hint: here) and parses it. Once it is parsed, one option would be to merge that with the D&B Business Matching Macro to validate or invalidate your list of businesses. Another option would be to take your business list and compare it to this file to find out if any businesses are using a PBSA. Either way, we have options! One final note is that it is important to remember that these are valid street addresses. While the Alteryx Street Geocoder will mark a P.O. Box as invalid, it will see these and most likely geocode them all the way to the street level. If you would like to read more about this USPS feature, click here. Until next time! Chad Follow me on Twitter! @AlteryxChad
Also, HUGE THANKS to John H. for his help with this post!