brettmandoes

Member
Joined
Nov 2, 2018
Messages
81
Reaction score
75
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
 

JoshuaMackens

Local Search Expert
Joined
Sep 12, 2012
Messages
1,950
Reaction score
579
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
81
Reaction score
75
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.
 
Similar threads
Thread starter Title Forum Replies Date
L Issues With Bulk Verification for Enterprise Organization Multi-Location Issues 1
LizP Setting up GMB account for enterprise business (500+ locations) Multi-Location Issues 3
L Best Approach to Claiming Yelp for Enterprise Organizations Citations 17
Garrett Sussman Why Large Enterprises Are So Bad At Review Management Local Reviews 2
Garrett Sussman How To Sell Online Review Management To Enterprises and Franchises Local Reviews 3
Dustybones Tuesday Tip Video Clip: 3 Common Mistakes in Enterprise Local Search Local Search 2
Nicole Basham Cons of Removing Second FB Page Profile/"Extra" Twitter account for Local SAB? Mobile & Social 1
M Google Local Services Ads - Lack of Leads Paid Search and Local Service Ads 12
rustybrick Google Local ranking update? Google Algorithm Discussions 6
Matt Chauhan Serious Problem With A Dentist's Local Rankings. NAP, Categories, Dashboard Data 1
S Local Services Ads - Fake Reviews Local Reviews 1
chrism Local Competitor Keyword Stuffing/Similar Words In GMB Spam on Google 2
buzzrank Home inspector business category not available in Canada, but local competitors have NAP, Categories, Dashboard Data 3
djbaxter New Local SEO tool from BrightLocal: Local Search Grid Local SEO Tools & Software 7
Stef Kiley Temp closed business ranking higher in local pack Help & Support for Google Local 2
F Turkish post: Google My Business local seo Recycle Bin 0
accessted Local Falcon GMB Question Service Area Businesses 2
F Google My Business local seo Google Local 101 3
S What makes a great Home/Landing Page in Local? Local Search 6
E What is the Click Through Rate / Conversion Rate for GMB or Local 3 Pack listings? Google My Business & Google Maps 3
J New local pack display? Google Algorithm Discussions 2
N Dedicated local search Local Search 12
djbaxter Webinar The State of Local Search 2021 [Webinar + Q&A] Events 0
Imperialpest Page Speed and Local / Ranking Question Ask a LocalU Expert [PRIVATE] (LocalU) 5
djbaxter Online Conference Pubcon Local Services Marketing Conference, January 20-21, 2021 Events 3
L Local Service Ad for Attorney Paid Search and Local Service Ads 1
Professor M No Reviews on Local Packs for Car Wash Category in Different Countries Google My Business & Google Maps 1
SpectateSwamp How about discussing local search... Like the Spectate one; everything a 50+ years of programming Geezer wants Break Room: Chat and Off Topic 3
B Google Beacons helping Local visability? Local Search 1
JoyHawkins Are Local Services Ads Stealing Clicks from Google My Business? A Case Study of 110 Listings Paid Search and Local Service Ads 0
M Decreased traffic to Google maps due to local service ads Paid Search and Local Service Ads 1
Eoghan_MFeed Looking for a SaaS but more importantly Local Search experienced product managers 🔍 Local SEO Job Board 0
Professor M Google Maps and Google My Business Big Changes - Google Maps Local News Feed Google My Business & Google Maps 26
Shelly "On the menu: [item]" visual label in local pack Help & Support for Google Local 3
Brian Barwig Unconventional Approaches to Local Link Building Local Search 0
Marty Twelves Local links: are they really that much better? Local Search 1
Y Whenever I publish update for my local business, my local rankings drop for 3-4 days Local Search 1
H Recorded Sessions from Local U Local Search 1
jeff_taylor GMB Removes Reviews from Local Pack Local Search 0
Scott ClientClicks Call Tracking for Local Service Ads Paid Search and Local Service Ads 4
jpayne7 Google Favoring Rich Snippets for Job Postings over Local Business Listings? Google Local 101 4
NexstarNickR Google Local Service Ads: Price Increases due to Bidding Rollout Paid Search and Local Service Ads 3
K New local business using stock photos for portfolio Local Content 5
Kayla Adam Canadian Local SEO Agency Needed Local Search 3
shively Microsoft Clarity (Local SEO heatmap tool) Local Search 2
Brian Barwig How to Win at Local Search with Service Area Businesses Service Area Businesses 3
Charles Jenkins SCHEMA For local business with address hidden? Local Search 1
N Local services Ad Approach for Businesses with Multiple locations on one GMB Account Paid Search and Local Service Ads 4
NickB-Tampa URL is updated in Google My Business but doesn't show up correctly in maps or on Bright Local Local Search 2
N Cost of Local Service Ads (LSA) Paid Search and Local Service Ads 15

Similar threads

Login / Register

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

Newest Posts

Most UpVoted Answers

LocalU Podcasts

  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...
Google Product Exert


Top Bottom