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
-
Tracking Sessions for 301 Re-Direct in Google Analytics
Trying to track clicks for individual slides on a homepage slider. I cannot enter UTM codes on the slide links, just choose from a dropdown containing pages on my site (WordPress). So, I set-up 301 re-directs for all the slides. /slide1-redirect
Reporting & Analytics | | jbernier
/slide-2-redirect etc.. Will these redirect pages show up in GA? I cannot see them. I'm trying to create a Dashboard for Homepage slider clicks. John0 -
Android Webview & Safari (in-app) without any referrer information in Google Analytics
I've got a client that gets a considerable amount of traffic that: Enters on an interior page (that we are running properly tagged ads for on various platforms) Bounces Has a browser of either Android Webview or Safari (in-app) which I believe indicates the website is being viewed within a mobile app Has no referrer data: (direct) / (none) We've tested several scenarios (Facebook app, Gmail app, etc.) and ruled them out. Anyone know what this might be? Thanks in advance!!
Reporting & Analytics | | SarahLK0 -
Google Analytics goals only show unique event triggers
I have some goals in GA which is linked to different event triggers. However I've found out that the goal is only showing the unique event triggers and not the total. I need it to show the total in order to be accurate. Is there any way to switch that option? I can't find any options like that in GA or guides to do so.
Reporting & Analytics | | WebGain0 -
Does Google Analytics track conversions in real time?
Looking at the section: Conversions > Goals > Overview - does Google Analytics provide real time / same day metrics for this conversion data or does it take 24 hrs?
Reporting & Analytics | | Rich_Coffman0 -
Conflicting numbers in Google Analytics
I am getting 2 completely different numbers in Google Analytics.According to the graph on my Dashboard organic traffic decreased ~40% comparing June 7 -> June 6.However, when I dig a bit deeper and look at the 2 dates specifically compared to each other I get a `3% increase in traffic.When I look at the traffic on just June 7, I get the number indicating the increase.Any ideas or someone getting similar conflicting numbers??
Reporting & Analytics | | theLotter0 -
Moving data between Google Analytics Properties
Last summer we setup another Google Analytics property for us with Universal Analytics and have been running this alongside the old Google Analtyics property. is there a way of exporting all the old data from the old property into the new Universal Analytics property?
Reporting & Analytics | | ese0 -
How Accurate Is Google Analytics Audience Location
Cioa from Latitude 53.92705600 Longitude -1.38481600 Clients love to know which part of the country there visitors originate adn cant get enough of this type of data:
Reporting & Analytics | | Nightwing
http://i216.photobucket.com/albums/cc53/zymurgy_bucket/country-level_zps41f273a3.jpg But just how innacurate is this data when you consder is getting the data from isp locations put another way if i was sat in darkets deepest hole of Paisley Scotland and my ISP was in London would i be tagged as visitor originating in London? Ta muchly,David0 -
Strange increase in Direct traffic in Google analytics
For past 2 weeks, several of our sites have strange increase in direct traffic in Google Analytics. we also have another tracking code, and in this account we don't have any big changes, so this is very strange what is happening. We didn't changed any codes, and none of the changes were done to application. Any ideas why this is happening? z7ME9.jpg
Reporting & Analytics | | InformMedia0