More threads by brettmandoes


Nov 2, 2018
Reaction score
Hey guys, I've been in the Enterprise Local game for a few years now and I've worked with a number of partners to create some fun/unique resources. Thought I'd share one of my favorites with you. A few years ago, a client asked me to identify the locations that were performing below the average, but I felt that just looking at keyword rankings didn't tell the full picture. So we created this scatterplot in Tableau. Each month it's updated and shows each center's position relative to one another. The y-axis is % of keywords on page 1 (from our targeted keyword set), and the x-axis is organic sessions. What's neat is I can highlight the ones in the lower left quadrant to see who is lagging, and from there do some analysis to figure out why. It's a huge time saver, and I thought you all might enjoy. Cheers!

enterprise local management.png
That is pretty cool.

I'm sure Tableau can import Google Analytics. Is that how you set up the session reporting?

What about the ranking reporting?

Does it update in real time or does it take work on your end?
Tableau can import GA easy. The rankings data is imported via csv once a month manually. A little equation in the back end measures the number of keywords on page one and turns that into a percentage.

Thought about changing that to average position but this works better. Average position gets skewered by outliers.

Login / Register

Already a member?   LOG IN
Not a member yet?   REGISTER

LocalU Event

Live Webinar - Local SEO Audits

  Promoted Posts

New advertising option: A review of your product or service posted by a Sterling Sky employee. This will also be shared on the Sterling Sky & LSF Twitter accounts, our Facebook group, LinkedIn, and both newsletters. More...
Top Bottom