Laustin1878

Member
Joined
Sep 27, 2012
Messages
412
Reaction score
40
I'm fairly certain the jury will almost "always" be out on the latest and greatest, bestest tools to use for [local] SEO. The more recent issue I've encountered is consolidating this information into one report, in a timely manor. Currently, it's taking far too long to pull data from several sources, one being GA, as well as rank tracking reports, etc. I find myself spending more time extracting then analyzing the data. I have to be doing something wrong.

Does anyone have a viable solution? What are you using to automatically extract Google Analytics data? Are you automating the process of extracting data from several sources to include in your reports or manually doing it? Or, are you just using a white label reporting tool from one of your reports and using the other tools for analysis only?
 
Last edited by a moderator:

CodyBaird

Member
Joined
Jan 4, 2013
Messages
341
Reaction score
126
You're asking the right questions. The day is coming when API will be common enough for all software to communicate/share freely and easily. But for now, the options are scarce; with many freebies like gekoboard that don't allow much manipulation of data and have limited number of feeds (ie don't work for me) or more robust solutions like Domo, created by Utahs Josh James previous founder of Omniture, that are being built for enterprise not SMB imo.

Personally we are walking down the path of building an in house solution which offers yet a third can of worms.
 

Linda Buquet

Moderator
Local Search Expert
Joined
Jun 28, 2012
Messages
13,313
Reaction score
4,241
You're asking the right questions.

Ditto Code on that Luke!

I've seen some marketing dashboards that integrate several tools all in one place for unified reporting. But can't remember any names and not sure how well they are suited to local.

And I think some of the big enterprise local services do all that, but they are more for big chains and expensive, I would think.

BrightLocal has lots of the right tools. And I've been BETA testing Places Scout and it has many as well. But none tie into G analytics and not sure there is any tool out there that does it all.

But I'll Tweet this post and see if we can get more feedback for you.
 

raisaroo

Member
Joined
Aug 14, 2014
Messages
6
Reaction score
0
Have you considered using Microsoft's Power BI? It is basically excel on steroids and it is pulling in data from GA, Salesforce and about 20 other data sets. It will soon be pulling in Local SEO data from SweetIQ (I am associated with SweetIQ).
This would allow you to get your rank tracking reports, GMB stats, and all other local data integrated with your GA numbers and potentially your CRM numbers.
We use it internally for our CRM, marketing automation and Google Analytics.
 

Laustin1878

Member
Joined
Sep 27, 2012
Messages
412
Reaction score
40
I have not heard of Power BI nor have I heard of Sweet IQ. I will look into it though. Thanks for pointing them out.

I've tried working with excel files to automatically extract the data from GA and have not had much luck. I'm clearly missing some piece of the puzzle...lol

Cody, I have often considered having someone create a custom script or code to pull some data. I never know where to start unfortunately.

As I mentioned in my original post, I find myself spending so much time trying to extract the data that it takes away from other things I could be doing. Then, I still have to format it and make it look pretty in a report which also takes a little bit of time. There just aren't enough hours in the day anymore.....
 

CodyBaird

Member
Joined
Jan 4, 2013
Messages
341
Reaction score
126
Scripts can work depending on the place you're pulling data. APIs are better but there is often an associated cost. I've found the biggest challenge is deciding what data matters and then displaying it in a meaningful way that isn't worse than what you already have. It's a gnarly puzzle that I haven't been able to put together...yet. it's coming and I will share it when worthy. Well some if it. Winky face.
 
Last edited:
Similar threads
Thread starter Title Forum Replies Date
NickB-Tampa Should all the phone numbers on the landing page to our GMB listing be included in the structured data? Google My Business & Google Maps 2
B Compare/Contrast different GMB location's data? Google My Business & Google Maps 4
djbaxter Schema.org vs. Google's Structured Data Rich Results Organic SEO 0
Zhanna Which tracker shows correct data? Massive drop down in rankings in one of the trackers Help & Support for Google Local 3
H GMB - Dashboard data analysis longer than a quarter NAP, Categories, Dashboard Data 2
Nicole Basham How early can you pull data on GMB Insights? Google My Business & Google Maps 1
john wieber Mobile Local SERPS Location Data in Result Local Search 5
Andrew Scherer Google's Structured Data Testing Tool axed... Bing's Alternative Local Search 1
K Insight Data Stops June 22nd? Google My Business & Google Maps 1
L GMB Insights Data not Updating Properly Google My Business & Google Maps 2
Nikki Stine GMB Insights Data missing for May 4 - 6? NAP, Categories, Dashboard Data 5
P Data aggregator sites - Who to use? Citations 3
Lachlan_Wells GMB Insights data not updating for two weeks Google My Business & Google Maps 1
djbaxter Avast antivirus caught spying on user data - and selling it Websites, Software, and Security 1
djbaxter Google reminder: Structured Data Does Not Impact Ranking Organic SEO 0
P Data around Reserve with Google Google My Business & Google Maps 1
Chaddow Changes to Apple Maps data sources what will this mean ? Local Search 2
S Free tool for local businesses - update data on Google, Facebook, Yelp, etc. - would you use it? Local SEO Tools & Software 7
JSammon512 Better Data in Google Ads & Analytics for Local Pack Ads (Google Local Extensions) Help & Support for Google Local 1
Claire Carlile No 'message you' data showing in Customer actions Google My Business & Google Maps 3
Ellen GMB Dashboard Data Highly Inflated -- Related to Barry Schwartz Inflated Impressions Article NAP, Categories, Dashboard Data 1
Travis Van Slooten Where Does MapQuest Get Its Data? Local Search 9
M BrightLocal Data Aggregator push - Do you have to do it every year? Citations 17
T Data Aggregators and PO Boxes Local Search 2
M Including tracking number when you submit to data aggregators? Ex. BrightLocal NAP, Categories, Dashboard Data 3
N GMB | Intrepreting the Data Google My Business & Google Maps 4
D Does Google Save Data on Unclaimed Listings? Google My Business & Google Maps 2
dannanelli Are agencies allow to hold Google Analytics account data hostage? Local SEO Tools & Software 11
U Is Google creating more listings with data obtained from elsewhere Google My Business & Google Maps 6
Cory Agular Sourcing Movie Time Data on SERP Google My Business & Google Maps 1
Dan Foland Do you renew your data aggregator listings? Citations 11
Colan Nielsen [Missing Data Alert] Knowledge Panel Seems to Have Removed Physical City Data Local Search 9
Somsenater Import data from Google My Business in Bing Places for Business Local Search 11
L What service do you use for data aggregators? Citations 7
AndySimpson Data Studio Report for "What Where Why When and How"...with a little local SEO on the side Local SEO Tools & Software 6
djbaxter Local search from mobile via wifi vs. via cellular data Local Search 9
C Any Evidence Structured Data Schema Makes A Difference? Local Search 3
AMF Incorrect Data Being Reported by D&B and YEXT. Citations 7
JoyHawkins New Structured Data Penalty for Reviews? Local Reviews 13
rosie.brightlocal New BrightLocal data: Online Reputation Management Survey Local Reviews 2
rosie.brightlocal SEO Citations Study - New data! Citations 3
rosie.brightlocal New data: BrightLocal's Voice Search for Local Business Study Local Search 1
djbaxter Google: Structured Data Isn't A Ranking Factor But Can Help Rankings Organic SEO 3
rosie.brightlocal New data: Local Citations Trust Report Citations 0
AndySimpson Are you using GSC for your local data? Tracking your utm's & "Near Me" Queries Local Search 13
D Seo data Local Search 0
L Is it possible to get more that a 3 months worth of data from google my business ? Local Search 3
Tim Colling Citation Data Aggregators List Local Search 1
Linda Buquet To All the Google My Business Data Geeks - Check your Dashboards, Cool Update Google My Business & Google Maps 1
O Best data (citation) aggregation service for SAB? Service Area Businesses 4

Similar threads

Login / Register

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

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