Scatterplot for Enterprise Local SEO

brettmandoes

Member
Joined
Nov 2, 2018
Messages
65
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!

 

JoshuaMackens

Local Search Expert
Joined
Sep 12, 2012
Messages
1,824
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?
 

brettmandoes

Member
Joined
Nov 2, 2018
Messages
65
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.
 

Weekly Digest

Weekly Digest
Subscribe/Unsubscribe

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...

Local Search Forum


Google Product Exert

@LocalSearchLink

Join Our Facebook Group

Top