Analytics to Excel
-
I am looking for a Excel template to pull GA directly into the spreadsheets. I have seen them around before, but I have always had trouble with them. Does anyone know a good how to or template somewhere?
Hopefully this can include some areas to customize areas such as date and fields.
-
I miss this tool from my PC !! I would love for them to develop a MAC version now
but that just ins't a reality yet. Nice suggestion. I would have done said the same thing! -
This looks like a great program and has great reviews, but my company is behind on versions of MSO Products.** We have 2002, this calls for 2007, does anyone have a alternative?
**I will try this on my personal computer when I get home
-
Awesome. I will try this out.
-
I completely agree with Brendan - Excellent Analytics really is excellent
It's useful in allowing you easily save your queries in text format so if you want to get similar data, you don't have to go through the rigmarole of recreating it via the interface, just copy and paste! I have not tried to dynamically build the queries yet, but I'm sure you could build the query string based on variables set elsewhere in a spreadsheet...
I also like the fact that you can grab all your data in one go (unlike the web interface which forces you do click endlessly...).
-
Hi,
I think the best one around is Excellent Analytics. It's a free plugin for Excel, has decent(ish) 'how to' guides on their site and is recommended by Google so should do everything you're looking for.
Hope that helps.
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
-
Analytics reporting
I am new to the world of SEO and Google Analytics specifically. I want to find a way to easily see top pages, search terms, and traffic. In Moz I thought I could see this by using "traffic from search", but I only see one page that is ghost spam nothing related to any of my pages. I made sure the right account is connected and it is. Any suggestions on how to get this data easily?
Moz Pro | | CRMI0 -
Link Analysis-Moz analytics
Good afternoon, I relay hope someone can help me out with this report In link analysis I have viewed inbound links where I see many links linking to our site but among them I see also many times our site listed with various anchor text. How is this possible. Our site is linking to our site or what? It realy does not make sense to me. Can somebody explain me this please?
Moz Pro | | Rebeca10 -
Why the discrepancy in organic traffic - monthly report vs analytics
I've been going through my monthly reports, and noticed something odd in the SEO Moz report section showing the visits from organic (non-paid) search engine results. When checking this data against the same data in Google Analytics, everything for the most part seems to line up with the exception of two dates: Jan 09 and Jan 23 of the SEO Moz report show 0 visits, but Analytics shows I do have visits on those days. Any ideas why this would be in the report or what I'm missing? IsePEAS hWBASOd
Moz Pro | | EEE30 -
Issue Using MozScape wtih SEOGadet's Link Excel Extension
Howdy Everyone! Since i've seen the MozCon presentation by Richard Baxter at SEOGadget, i've been completely amazed by the links extension for Excel. I tried this morning to give it a try. Unfortunately, I cannot get it working, and was hoping that someone here could help me out. I know it's out of the usual "realm" of questions, but I figure it's worth a try 🙂 I successfully installed the addon and entered my Access id (as "member-xxxxxxxxxx" member is in my id) and the secret key. I then downloaded the "OSE" excel spreadsheet" just to make sure I get all the calls right (as I know the doc works) Once I do this, and enter anything in, I get the "an error occured: the remote server returend an error: 401 unauthorized. I then went into the config file (as the setup doc suggests) and disabled run time caching (or at least set "SEOMOZ_API_use_cache_YN":"N") and the SEOMOZ_API_timeout to 100000 from 60000. I have also tried uninstalling and reinstalling the addin, along with regenerating the MozScape API Key Anyway, i'm not an excel wiz, and would appreciate any help that I could get on this. I'm also about to experiment with SEO Tools For Excel if anywone wants to check that out. Thanks in advance Zach Russell
Moz Pro | | Zachary_Russell0 -
Data from Open Site Explorer to Excel
Hello, Im having a problem with the data I pull off from Open Site Explorer. Everytime I download a report in CSV, when I open it in Excel 2007, all the information is like this: http://i.imgur.com/rwMxO.png What can I do to extract the information exactly as it appears in the Open Site Explorer with all the fields in the right place? Tks guys, Regards, Pedro Pereira [
Moz Pro | | PedroM
](<a href=)" target="_blank">a> rwMxO.png
0 -
Excel tips or tricks for duplicate content madness?
Dearest SEO Friends, I'm working on a site that has over 2,400 instances of duplicate content (yikes!). I'm hoping somebody could offer some excel tips or tricks to managing my SEOMoz crawl diagnostics summary data file in a meaningful way, because right now this spreadsheet is not really helpful. Here's a hypothetical situation to describe why: Say we had three columns of duplicate content. The data is displayed thusly: | Column A | Column B | Column C URL A | URL B | URL C | In a perfect world, this is easy to understand. I want URL A to be the canonical. But unfortunately, the way my spreadsheet is populated, this ends up happening: | Column A | Column B | Column C URL A | URL B | URL C URL B | URL A | URL C URL C | URL A | URL B | Essentially all of these URLs would end up being called a canonical, thus rendering the effect of the tag ineffective. On a site with small errors, this has never been a problem, because I can just spot check my steps. But the site I'm working on has thousands of instances, making it really hard to identify or even scale these patterns accurately. This is particularly problematic as some of these URLs are identified as duplicates 50+ times! So my spreadsheet has well over 100K cells!!! Madness!!! Obviously, I can't go through manually. It would take me years to ensure the accuracy, and I'm assuming that's not really a scalable goal. Here's what I would love, but I'm not getting my hopes up. Does anyone know of a formulaic way that Excel could identify row matches and think - "oh! these are all the same rows of data, just mismatched. I'll kill off duplicate rows, so only one truly unique row of data exists for this particular set" ? Or some other work around that could help me with my duplicate content madness? Much appreciated, you Excel Gurus you!
Moz Pro | | FMLLC0 -
Ultimate Ranking Tool integrating Analytics / Adwords / Google WM Tools
I currently use SEOMOZ Campaigns and Advanced Web Ranking for monitoring our KW rankings and those of competition. AWR is a brilliant tool with so many different reports, methods of viewing etc. SEOMOZ campaigns are good but don't come close to the monitoring power of AWR (EG I monitor over 50 competitors on over 1000 KW's on a Daily basis with AWR and recieve a variety of set emailed reports on the data). However, one thing that SEOMOZ campaigns have that is useful is the traffic data - but this is still a bit basic and I think could be improved. The problem with AWR is that it doesn't integrate with your Analytics / Adwords / Google WM Tools - so it is only showing you half the picture. Knowing how your site ranks for each keyword is helpful, but it would be nice to understand the value of each keyword. For example, being able to see your rank position and how much traffic that keyword has sent you over time would be helpful. It would also be nice to see the number of searches that are performed for that keyword each month . For example, lets say I saw that I was ranking at number 11 for “hover mower” and getting 500 hits per month. Two months from now, if I was ranking at position 7, it would be nice to be able to immediately see how that changed the amount of traffic I was receiving for the term. Is a position of 11 (first item on page two) better than position 10 (last item on page one)? If you can link it to your analytics, you could then link it to your goals, and goal values to get a complete picture of where your keywords rank the value of the rank, and the improvment on that value when rank changes. If browsed around for such software but can't find anything like this - does anyone know of any software that can do this - or something close to this? Many thanks
Moz Pro | | James770 -
Where do I find "URLs Receiving Entrances Via Search" and "Non-Paid Keywords Sending Search Visits" in Google Analytics?
These are two metrics highlighted in the "Organic Traffic Data" report in the PRO campaigns. Since this report is composed of data linked from Google Analytics, I bet there's a way to find this same information in GA. So...anyone know how to do that in Google Analytics? I want this information for some long-tail productivity/potential research.
Moz Pro | | jcolman0
