Creative Uses of Grid Rankings

[Andrew Shotland]

Hey Localistas! We built our own grid ranking tool in Looker and are looking for creative ways to use the data. Here's an example of how we use it to do competitor pack analysis. If you have any other ideas, let me know. Using Local Pack Grid Rankings for Competitive Local SEO Analysis | Local SEO Guide

 

[JS Girard]

One thing I've never seen is a "who's on first" map. All these maps are always coded by the top position for whichever GBP you're looking at. How about being able to select a couple GBPs and it colors the map regarding which of the GBPs has the highest position?

 

[Andrew Shotland]

One thing I've never seen is a "who's on first" map. All these maps are always coded by the top position for whichever GBP you're looking at. How about being able to select a couple GBPs and it colors the map regarding which of the GBPs has the highest position?

We kind of do that. For example, here's a list of all GBPs that rank for 55 keywords within 25 mi. We list the total positions, the avg position and the total # of keywords.

It's hard to do a pure "this GBP is #1" unless you look at a very narrow geo and a single query. For example, the 2nd screenshot is for "dog oncologist" within 5 miles of the centroid. You can see 3 GBPs have a #1 ranking in various locations in that geo.

 

[WilliamGMBE]

Very impressive. Didnt know LookerStudio was that flexible.

If possible, one thing that can help is if you can have a headmap of population density overlayed on the map. I am guessing more than the area, it is the population a GMB ranks for that provide actionable insights. It is also something we are exploring here at GMBEverywhere for our Teleport tool. Credible population data is tough though.

Great demo.

 

[GoLocal]

Very impressive. Didnt know LookerStudio was that flexible.

If possible, one thing that can help is if you can have a headmap of population density overlayed on the map. I am guessing more than the area, it is the population a GMB ranks for that provide actionable insights. It is also something we are exploring here at GMBEverywhere for our Teleport tool. Credible population data is tough though.

Great demo.

Interesting, I've never heard this angle before. I always thought of it in relation to pin density, which must be related to population. Cool concept, I've never heard anyone quantify is as targeting more population but ultimately we are. I'm going to start paying more attention to this.

 

[Andrew Shotland]

Very impressive. Didnt know LookerStudio was that flexible.

If possible, one thing that can help is if you can have a headmap of population density overlayed on the map. I am guessing more than the area, it is the population a GMB ranks for that provide actionable insights. It is also something we are exploring here at GMBEverywhere for our Teleport tool. Credible population data is tough though.

Great demo.

Agreed. I love that feature in Apple Maps that kind of does this.

 

[JeffClevelandTN]

Hey Localistas! We built our own grid ranking tool in Looker and are looking for creative ways to use the data. Here's an example of how we use it to do competitor pack analysis. If you have any other ideas, let me know. Using Local Pack Grid Rankings for Competitive Local SEO Analysis | Local SEO Guide

Wow Andrew!!! Super creative use of Looker Studio! Any remote possibility you may publish how to re-create this . We use Brightlocal at our agency for grid reporting and competitor analysis, but also have secondary subscriptions for sanity checks. Right now, I've got one of those issues where BL grid report has some serious issues and this would be a great alternative in lieu of running a test on another paid subscription and/or manually performing coordinate searches on Chrome for verifying. In any case, thanks for the post and your link.