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
-
AMP Session Stitching - How to deal with Google's Client ID AMP Policy
Hello, I recently attended SMX East and the concept of 'session stitching' for AMP was brought up (https://www.stonetemple.com/amp-tech-guide/). I reached out to my development team and they told me they could do it, but that we would need to agree to the new TOS changes and making users aware of then... https://support.google.com/analytics/answer/7486055 Has anyone here done something like this? And if so how did you deal with the Google's Client ID AMP policy? Thank you all! -Margarita
Reporting & Analytics | | MargaritaS1 -
Google Search Console - > Google Search Analytic gives figure for google organic or adwords or combine of both?
Hi All, In Google Search Console -> In Search Analytics. I can see Clicks, Impressions, CTR and Position. I want to know all these 4 - Clicks, Impressions, CTR and Position gives information related to google organic only? or combine or google organic and google adwords? Thanks!
Reporting & Analytics | | wright3350 -
Google Analytics Set-Up for site with both http & https pages
We have a client that migrated to https last September. The site uses canonicals pointing to the https version. The client IT team is reluctant to put 301 redirects from the non-secure to the secure and we are not sure why they object. We ran a screaming frog report and it is showing both URLs for the same page (http and https). The non-secure version has a canonical pointing to the secure version. For every secure page there is a non-secure version in ScreamingFrog so Google must be ignoring the canonical and still indexing the page however, when we run a site: we see that most URLs are the secure version. At that time we did not change the Google Analytics setup option to use: "https" instead of "http" BUT GA appears to be recording data correctly. Yesterday we set up a new profile and selected "https" but our question is: Does the GAnalytics http/https version make a difference if so, what difference is it?
Reporting & Analytics | | RosemaryB1 -
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 -
Using Google Analytics network service provider
Hi What are people's views on using the Technology > Network > Service provider part of Google Analytics as a way to find companies that have visited a website? Then potentially contact them companies etc? Thanks
Reporting & Analytics | | Hughescov0 -
Conversion via Paypal not showing order value in google analytics
Hello All, I have an e commerce site, when goal conversion happens by CC(credit card) I can see order value in e commerce tab in Google analytics but when conversion happens through paypal I always see order value zero. I want see order value for Pay pal also.Please help me out. Thanks
Reporting & Analytics | | Alick3000 -
Google Analytics - Cross Domain Tracking Goals
Hi guys, looking at the best way to organize this - Site 1 - Shoe Store - (Old site with analytic history - UA-12345-1) Site 2 - Clothing Store - (Brand New UA-54321-1) Right now i have 2 separate GA Accounts for the sites. But i would like to track goals from Site 2 to Site 1. For that i need to set up cross domain tracking. So i take it i would need to create another account under Site 1 - (UA-12345-2) and put that new code on Site 2? Or do the UA numbers have to be exact? example both 12345-1? In which case, i would need to set up 2 different profiles with filtering? Main concern is i want to keep separate data for both sites, espically if UA's will be the same. Trying to visualize - UA-12345-1 Profile 1Shoes/Master Profile 2 Shoes Profile 3 Clothes Or UA-12345-1 Shoes UA-12345-2 Clothes Thanks, Mike
Reporting & Analytics | | IsHot0 -
Google Analytics session update question
Hello, With reference to seomoz blog post - http://www.seomoz.org/blog/panda-24-and-analytics-session-update-rolled-out-simultaneously#jtc151292 , i would like clarification about the following - User searches Google for "Product Name" and clicks on your AdWords advertisement. User leaves site and searches a few more times, click on competition and comparing prices and features. User ultimately decides to with your product, Googles "Your Brand + Product Name", clicks your organic listing, and buys the product. This whole process takes less than 30 minutes. "Your Brand + Product Name" will appear in your organic keyword report with 1 visit. My question is whether "Product Name" will also appear in organic keyword report with 1 visit if the visitor is not signed in. ( as search won't be encrypted ) Thanks
Reporting & Analytics | | seoug_20100