Use Google Spreadsheet for Top Keywords Report
-
I've been using the super-awesome Google doc described here http://www.seomoz.org/blog/custom-reporting-using-google-analytics-and-google-docs for all kinds of reporting and I've customized it quite a bit. But I can't figure out how to feed text-based fields from GA into this doc. For example, can I make it so this doc spits out top 10 keywords?
Thanks!
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
-
Conflicting data in Google Analytics
Hi Guys I've been looking at the data for a client in Google analytics and I was wondering if anyone knows why some of the data doesn't tally up. In my case its the following: Under Aquisition
Reporting & Analytics | | Relative
No of Sessions for a Keyword shown in Organic Search tab (compared to)
No of Clicks for a Query in the Search Engine Optimisation tab For example, for a brand term, Google are showing 17 Sessions in Organic Search.
For the same term Google are showing 90 Clicks in the Queries section of Search Engine Optimisation OK, we know that Google are a little cloak and dagger regarding keyword data but surely Sessions and Clicks for the same keyword should be identical unless I'm missing something.0 -
Weird Google Analytics tracking question
I have a client that has a market place site, where people list goods and sell them, think something like Etsy. Instead of developing a system to show the users page views and things like that, does it sound reasonable to let them enter a Google Analytics property on the pages they list on, then let them monitor through GA? Does anyone see any fatal flaws in this thinking?
Reporting & Analytics | | LesleyPaone0 -
Tracking in Google Analytics
My site has just recently (or maybe not so recently...) had a great deal of https URL's indexed (I was really only able to find this out thanks to the recent update to the GWT Index Status). It appears that Googlebot picked up an ssl somewhere (I already know where) on my site and then proceeded to crawl and index pages with https rather than http. Since I understand the issue, it should be an easy fix. My question is, does Google Analytics support (track) both http AND https for one site, or would I need to set up two different tracking codes for http and https? I figured that I might as well grab some data from the https pages that are indexed before I try and remove them. I've done a little research on using Groupings/Groups but I figured I would reach out to the MOZ community to see if anyone else has worked with a similar issue. Thanks!
Reporting & Analytics | | GalcoIndustrial0 -
Results for wrong keyword
I've started to look at ranking and visitor behaviour within a specific product category and I've come across this strange data in GA that i'm struggling to get my head around. keyword - wishbone necklace gold landing - ...necklace-dive-in.html bounce - 99.31% new visits - 0.00% The landing page is not anywhere in the results for the given keyword (nor does the keyword appear anywhere within the page). The data is spread out to date since Dec 2011 and the landing page accounts for about 97% of the traffic for that keyword. I then looked at browser which is 95% Safari (different versions) and breaking that down into City about 30% is (not set), 30% a single city and then there is a spread of locations. It might be fair to assume that therefore 60% could be the same location but there is still 40% to take into consideration. What I can't get my head around is how the landing page is being accessed so regularly for the wrong keyword. The correctly ranking URL only accounts for 5% of the traffic which is more in line with the estimated search volumes for that keyword. I've checked versions of the page going back and none contain the keyword. Am I missing something, or any ideas how to fix?
Reporting & Analytics | | MickEdwards0 -
Google Analytics-Unique visitors?
Does organic search data show unique visitors or all visits? For example, if someone ( a single person) visits my site multiple times after searching the same keyword phrase, does that show in my analytics data as 1 hit from that keyword, or all hits? Thanks!
Reporting & Analytics | | RickyShockley0 -
Google Maps not passing referral data
Google Maps is not passing referral data (URLs, not KWs). Google+ Local is referring, but nothing from maps. Maps referrals appear to be coming across as direct. Any ideas? We haven't found anything online, one of the guys at the office documented what we did find, using Chrome's debugger - http://manofactionmetrics.com/2012/11/02/google-maps-not-passing-any-referral-data/
Reporting & Analytics | | Danieljacobree0 -
Google Analytics - In-Page Analytics
I had a strange thought waking up this morning, and was curious to hear other people's opinions on it. In Google Analytics, under Content > In-Page Analytics, Google shows what links on your site pages get clicked and how many times plus other metrics. Do you think they use that data for ranking back links so-to-speak? What I mean is, say I had a back link to my site on example.com, and example.com had google analytics installed. Google can see through google analytics whether my link has been clicked on. Say that my link gets no clicks, do you think that Google would use that metric against my site deeming it "not popular" or "not a good resource", even if example.com was a very popular site? And it could work the other way. Say my link got thousands of clicks on example.com, do you think that Google might use that to promote my site? I couldn't find any other discussion on this anywhere, so am not sure if people have already thought about this.
Reporting & Analytics | | THB0 -
How to see traffic for specific keywords in GA
Hell guys, What i want to achieve is to generate a list of specific keywords showing traffic for a certain periode of time. I also want so be able to compare this time period with historical data. I want a list as shown in: Traffic sources -> sources -> search -> organic. This shows a list of keywords generating traffic out of the organic search results. When you use a filter you can only use one word so it seems. I just want to create that list but with the specific keywords i choose to display. I tried advanced reports and advanced segments but that doesn't really give me what i want. The idea behind this whole thing is that i want to give my client an overview of the traffic received on the words we are optimizing for. this traffic has to be compared to the previous month so they can see clearly if there were changes. Thx !
Reporting & Analytics | | 5MMedia0