brettmandoes

Member
Joined
Nov 2, 2018
Messages
85
Reaction score
77
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
85
Reaction score
77
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
Chris Ratchford Google Ads- Local Pack- one GMB location only? Paid Search and Local Service Ads 0
W Local Search Ecosystem Diagram Local SEO Tools & Software 1
C Franchise hub site ranking higher then local franchise sites for the brand? Organic SEO 1
koji Local business with online nationwide services in a post-corona world Google Local 101 5
Barb Davids Phone number not local area code Moving or Name Changes 2
Shelly Pros & Cons of Facebook Locations for Local SEO (for a Credit Union) Multi-Location Issues 3
rich_marlatt Do the number of backlinks from a domain have any impact on local SEO? Local Search 2
zach.todd What do you look for in a local website audit? Organic SEO 7
Professor M New Local European Local listing removals Process Google My Business & Google Maps 1
D Can you set an end-date for Local Services Ads? Paid Search and Local Service Ads 1
Barb Davids Ad fraud with Local Service Ads? Paid Search and Local Service Ads 6
djbaxter Brightlocal Tool shows Large Google Local Search Algorithm Update March 10, 2021 Google Algorithm Discussions 1
D Local Services and Google my Business Paid Search and Local Service Ads 2
Annika Neudecker One year later, is your GMB/local SEO traffic still up? Local Search 3
Colan Nielsen Find Local Link Opportunities with ZipSprout’s FREE Local Sponsorship Finder! Local SEO Tools & Software 8
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 14
rustybrick Google Local ranking update? Google Algorithm Discussions 12
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 8
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

Similar threads

Login / Register

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

Most UpVoted Answers

Trending: Most Viewed

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