Google Analytics & Google Sheets
-
Hi guys,
I'm looking to use google analytics google sheets extension to pull data into a google sheet with metrics from other tools e.g. semrush, moz, etc.
From my understanding with google analytics google sheet extension its designed to run reports and doesn't really allow you to add other metrics.
Basically what i'm trying to do is this:
https://www.useloom.com/share/c1e42bfa60bd46fca2b1120018969ce8
Any suggestions/advice on how to do this would be great.
Cheers.
-
Hi Jay,
We implemented a similar feature using GA and Google Search Console to combine data into a single sheet. To accomplish this we had to write custom javascripts that accessed the Search Console API and inserted the data into the proper columns. It was successful, however we grew the dashboard so much that we are now building this as a standalone app to make it a bit less cumbersome.
If you're going to pull the data from providers other than already integrated systems (like Google Analytics), then you're looking at some custom code that you'll have to implement in the Script Editor (Tools > Script Editor).
Good luck!
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
In google analytic for google /cpc it is showing url with 404 which even not exists in my database
Hello All, In google analytic for google /cpc it is showing url with 404 which even not exists in my database that also more than 300 per day. How can it is possible? it is showing /black-friday-offers but I don't have such page. Thanks!
Reporting & Analytics | | pragnesh96390 -
How accurate is Google analytics at measuring traffic? (Free version)
Hi Guys. When we compare our actual sales to Google analytics conversions it can be way out. Sometimes as much as 50%. Is this the same for the data on traffic? And if so, does the data tend to be out by a similar amount over time? i.e) If we compare this year and last year it give us a good indicator of differences in traffic volume? (albeit not 100% accurate?) Thanks. Isaac.
Reporting & Analytics | | isaac6630 -
Different transaction data social channel on Google Analytics
Hi there, On my ecommerce, in order to find out the number of transactions that came directly from my social channels I go to Acquisition->Channels and then I look at the column Transactions for the Social channel. Surprisingly this number differ from the one that I find under Acquisition->Social->Overview and then I select Transaction under Conversions. Then I look at Last interaction Social Conversions to find the number of transactions. The two quantities are totally different for a month window and they should be the same. Can any of you explain to me the reason why? Thanks and regards
Reporting & Analytics | | footd0 -
Stop getting info from Google analytics on purchases in our site
Hi guys, We have eCommerce.
Reporting & Analytics | | WayneRooney
We connected the site to the Google analytic eCommerce.
Everything was work fine until 3 weeks ago. Suddenly we stooped getting purchases information in the analytic although i see purchases in the website. We didn't change anything in the website and i really don't know how to solve this problem.
If someone here can point me where i can get some info on how to fix it it can be great. Thanks a lot!0 -
How to find goo.gl/ URLs in Google Analytics
Hello! How does one go about finding the impact of goo.gl/ shortened URLs in Google Analytics? (I know I should be using Campaigns, but this was for an old project.) Thanks in advance! Erik
Reporting & Analytics | | SmileMoreSEO0 -
Google Analytics - Keywords (not set) or ( not provided) WHY???
In Analytics, most of my visitors are landing on my home page, but when trying to see wich keywords they use, most of them are: (not set) or ( not provided) See screencast: http://screencast.com/t/AKwPW76qLVsN Can you tell why? What is going on? Is there a way to solve this? Thank you, BigBlaze
Reporting & Analytics | | BigBlaze2050 -
Wordpress + Google Analytics = Pulling My Hair Out
Hey Mozzers, Quick question for you- I have analytics set-up for a personal site I run and I know, verifiably it's receiving traffic, however, whenever I access my Google Analytics dashboard, it says I've had zero visits. Interestingly, today I had a colleague check the site from a foreign country and I could see the page views (within 15 minutes), however, I could not get any information about the site viewer. I have verified that the Analytics profile is 'receiving data' (which it is) and my Google Webmaster Tools is not reporting any issues? Finally, I went ahead and updated my profile so that it is pulling from 'www.mydomain.com' instead of 'mydomain.com', I don't know if that'll make any difference, but likewise, I didn't want to go and create the 'little kid in the elevator' analogy, where I'm just pressing a bunch of buttons just because they're there. So the only changes I've made thus far were deactivating Yoast's SEO plug-in and manually placing the GA code in the header and updating the 'Website's URL' in the profile settings tab of GA from 'mydomain.com' to 'www.mydomain.com'. With that, I am stumped and praying another one of the esteemed Mozzers out there may be able to help me resolve this. Any thoughts?
Reporting & Analytics | | NiallSmith0 -
Alternatives for google analytics multi account dashboard overview
Hi there, I like the new Google Analytics layout don't get me wrong but I really miss the old possibility to have a quick overview of all your accounts. Does anyone know an alternative for this? Please share your experiences and recommendations.
Reporting & Analytics | | Robbern0