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
-
Google Optimize via Google Tag manager not working properly
Hi All, I am using google optimize via tag manager. I have successfully implemented it and my experiment appeared in google analytic but google optimize chrome addon always give me add script not installed properly. How to solve solve error? Thanks!
Reporting & Analytics | | amu1230 -
Query on Google Experiment?
Hello All, I am doing A/B testing via google analytic experiment now my query is for my ecommerce site homepage i am trying to add newsletter in 3 different way so it will be variation A, Variation B and Variation C. So my query is what should be then original page? Currently there is no newsletter form on homepage. Do I consider original page as Variation A? i.e. abcd.com?variation-A as original page? Then google will decide winner between original page i.e. variation A and Variation B & C Thanks!
Reporting & Analytics | | dsouzac0 -
Google Analytics goals by source report?
Hello everybody. Is there way in Google analytics to create report on what goals have been completed per each source? Example: Lets say I have 3 goals: Subscription, Purchase, Quote. How can I get report, saying something like this: google / organic - Subscription - 5 conversions
Reporting & Analytics | | DmitriiK
Purchase - 3 conversions
Quote - 10 conversions and so on. P.S. Basically, I want the reverse of standard Google Analytics goal completions report, where you can click on goal and see which sources/mediums completions came from. I'd like to do the opposite - "click" on source/medium and see which goals have been completed. Thanks0 -
Splitting Google analytics data
Hi Everyone I'm not sure if this can be done but thought i would ask anyway. One of our clients has a website which is a 3 tiered website, basically this means different access levels for different users depending on their ip address. The split is as follows (business 1, business 2 and the general public all see different things and areas within the website) Now what we are wanting to do is essentially split our analytics data for each of the 3 different users on the site, Can this be done through Google analytics? Thanks in advance. ps If im not clear enough let me know and ill try clear it up
Reporting & Analytics | | TheZenAgency0 -
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 -
Can you filter referring keywords in Google Analytics by language?
Hi All! So yes, I know that you can see/filter the language that the computer or browser was set to (en-us, ru, fr, etc.), but if you look at the keywords used by visitors falling under "fr", some are in English. Is there any way to get, say, just the keywords in Russian - regardless of what the visitor's browser language was set to? Thanks! Aviva
Reporting & Analytics | | debi_zyx0 -
How can I see the history reports?
Hi, I want to see the history reports for my ranking. For example I can how my website traffic changed in past few months using Google Analytics but I am not able to monitor the performance of my keywords on seomoz. Is there any way to do it?
Reporting & Analytics | | ashish2110 -
Search within search? Weird google URLs
Good morning afternoon, how are you guys doing today? I'm experiencing a few Panda issues I'm trying to fix, and I was hoping I could get some help here about one of my problems. I used Google analytics to extract pages people land on after a Google search. I'm trying to identify thin pages that potentially harm my website as a whole. It turns out I have a bunch of pages in the likes of the following: /search?cd=15&hl=en&ct=clnk&gl=uk&source=www.google .co.uk, and so on for a bunch of countries (.fi, .com, .sg, .pk, and so on, maybe 50 of them) My question is: what are those pages? their stats are awful, usually 1 visitor, 100% bounce rate, and 0 links. Do you think they can explain my dramatic drop in traffic following Panda? If so, what should I do with them? NOINDEX? Deletion? What would you suggest? I also have a lot of links in the likes of the following: /google-search?cx=partner-pub-6553421918056260:armz8yts3ql&cof=FORID:10&ie=ISO-8859-1&sa=Search&siteurl=www.mysite.com/content/article They lead to custom search pages. What should I do with them? Almost two weeks ago, Dr. Pete posted an article untitled Fat Panda and Thin Content in which he deals with "search within search" and how they might be targeted by Panda. Do you think this is the issue I'm facing? Any suggestion/help would be much appreciated! Thanks a lot and have a great day 🙂
Reporting & Analytics | | Ericc220