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
-
Best way to present Google Analytic Reports
Hi Everyone, I’m just looking to produce some quite detailed reports for our google analytic can someone suggest a format or templates for the best way to present this information. Also can someone suggest what the best variables are to capture from a reporting perspective. We don’t sell on line so im just aliitle bit curious about what to include in terms of conversions etc
Reporting & Analytics | | aplnz20170 -
What does 'Safari (in-app)' mean in Google Analytics browser traffic?
Hi, can anyone explain what 'Safari (in-app)' refers to in my browser sources? Also, it has a very high bounce rate - any ideas why?
Reporting & Analytics | | b4cab1 -
No-indexed pages are still showing up as landing pages in Google Analytics
Hello, My website is a local job board. I de-indexed all of the job listing pages on my site (anything that starts with http://www.localwisejobs.com/job/). When I search site:localwisejobs.com/job/, nothing shows up. So I think that means the pages are not being indexed. When I look in Google Analytics at Acquisition > Search Engine Optimization > Landing Pages, none of the job listing pages show up. But when I look at Acquisition > Channels > Organic and then click Landing Page as the primary dimension, the /job pages show up in there. Why am I seeing this discrepency in Organic Landing pages? And why would the /job pages be showing up as landing pages even though they aren't indexed?
Reporting & Analytics | | mztobias0 -
How does Google Maps/G+ traffic show up in Analytics?
Hi Moz Community, I've been trying to figure out how traffic from Google Maps (and G+) shows up in Google Analytics and am struggling to find a good answer online. If someone finds a business through Google Maps and then clicks on the website in the Maps listing, does that show up as a referral from Google Maps? Our site shows virtually zero traffic from Google Maps even though we have a number of listing. Two related questions: if someone clicks through to a G+ page from a Maps result and then visits our website from the G+ page, does that show up in Analytics as a referral from G+? Is traffic from Google Maps or G+ ALSO counted as organic traffic? (Would it be possible to accidentally double-count a visit as both organic and a referral from Maps/G+? Thanks everybody!
Reporting & Analytics | | JohnGroves0 -
% Change - Google analytics - how to calculate?
Hi All,
Reporting & Analytics | | JohnPalmer
I have two dates with two different numbers I want to calculate the "% Change" like google analytics, The numbers of June 2015 - 127,931 sessions
The numbers of June 2014 - 90914 sessions please tell me what is the %Change. Best. J0 -
Google analytics
I updates all my google analytics accounts after the update and now i went to each campaign and it appears there is a problem and now if I reset it i loose history. Is this a glitch or a problem
Reporting & Analytics | | JAGlasvegas0 -
Seomoz wont connect to my google analytics. waht am I doing wrong?
I enter my details and it says I am connected to a google account but there is GA found, what gives?. PS. I do have a analytics acount I have been using for years, and have input the correct user and pass. I even get to the page in google to allow SEOmoz access to my acount and I confirm then nothing shows up in SEOmoz?
Reporting & Analytics | | stevem980 -
How to Turn Google Analytics Into Your Own Rank Tracker Using Custom Variables
I followed the instructions here http://www.seomoz.org/blog/gettings-rankings-into-ga-using-custom-variables, but cannot see the report in Analytics under "Custom Variables". As I dont know JS syntax, I assume the code is wrong. I just added dohertyjf's code under my normal tracking code. Can someone tell me if and where the error is? | | Much obliged!
Reporting & Analytics | | zeepartner0