Rock U - Rock Fundamentals - IP Address Geocoding

Transcribed Video Content

You might be familiar with Brock's address standardization and geocoding features. And it works roughly the same with IP addresses as well. When a visitor comes to your site, you can capture their IP address and send it to a service, which can then geocode based off of that IP address to show you where your visitors are coming from. Let's take a look at how to set it up. Okay. So before you can start geocoding IP addresses, you need to sign up with an IP address geocoding service. Currently, Rock only supports IP registry, and there's a link to them in our documentation on in the admin hero guide. But after you're all signed up with IP registry, you'll navigate over to, admin tools, system settings, and IP address location service. And the setup here is pretty simple. You'll just open this up and provide the API key that you got from IP registry and make it active. And that's all you need to do. Next, you'll need to make some adjustments to your site settings under admin tools and CMS configuration and sites. Okay. So we'll be looking at the external website here because, that's where our visitors are gonna be coming from. And if we, edit the site, under the site's advanced settings, we wanna turn on log page views, which is on, and that's good. And we want to make sure that we have turned on enable page view geotracking. Okay. So, we need both of those to be on. Okay. So, with all of that in place, we're ready to run the populate interaction session data job. So, let's go over to admin tools, and system settings, and jobs administration. And we'll take a look at this job's options. Okay. So first we have the command time out, which is just thirty six hundred, but you can change that if you need to. Then down here we have the IP address geocoding component. Typically, from here you'd select your IP registry configuration. But if you don't select one here, Rock will actually go out to the configuration and use the first one that it finds. The look back maximum, this is how many days back the job should look for IP addresses that haven't been geocoded. And then the max records to process per run, this simply limits the number of records that get submitted to the geocoding service. Because Rock won't resend an IP address that has already been geocoded within the past ninety days, organizations with more than 5,000 records will have all of them processed after only a few iterations of the job. And so again, this job, its main purpose is to take the IP addresses that we've captured in the interaction session data and geocode them so we get location information out of them. Okay. So we're gonna look at that. This next part gets a little technical, but again, we're gonna talk about how to get geocoded information out of Rock for you to actually use. This data is tied to interactions. So, the table that you're gonna be looking at is called interaction session location. And on that table, you'll find the following fields. So, first you have the country code. Okay. So, there's the country code field here on the interaction session location table, and that's simply, the country code. So, The US is United States, CA is Canada, MX is Mexico. You can tell what country they're coming from. There's also a geopoint field so that you can get an exact geopoint associated with the IP address. Now, these are not a % accurate, but they're they're pretty close. You'll you'll be in the ballpark with these. Next, you can look at the location itself. , so this will give, in the case of America, it'll give the city and the state, but you might also see something London, England or Sydney, New South Wales, but there's a location field and that's what it'll give you. And in addition to these, it'll also tell you the Internet service provider, their postal code, and their region code. So, that's how you set up and use Rock's IP address geocoding features. For more details on this feature, check out the Rock admin hero guide. And thanks for watching.