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.
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
-
GWMT / Search Analytics VS OpenSiteExplorer
Just had the experience of using OSE data to show what we call "linkrot" to a client -- only to find that GWMT / Search Analytics shows no such thing. Fortunately the client is an old friend and no face was lost, but it was dicey there for a bit as I have come to rely on and reference OSE again and again and again, OSE showed Domain Authority dropping by about 1/3 in the last 12 months, presumably due to old links getting broken, linking sites changing their architecture etc. And of course, ranking is tanking, as you would expect. But Google shows many more (and much more spammy looking!) backlinks. Has anyone had any experience benchmarking the 2 data sets of backlinks against each other? Dr Pete?
Moz Pro | | seo_plus
Does one update more frequently than another? Do you trust one more than another?? If so, why?? Thanks!0 -
Moz analytics telling me I have duplicate content issues - how to fix this?
Hey guys, Okay I ran into moz analytics - I have I have 199 Issues, priority issues are showing 38 Duplicate page content. I began looking into the URL's and from what I have noticed from all the urls are showing me a common theme. The urls are pointing to my blog pages - my blog is using wordpress. What iv noticed is the urls all have "Tag" in it Here are 3 examples that I have found. All url's take me to a blank page: Does anyone know what the solution is to fixing this? I read the article for duplicate content covering 301 redirects and Rel=Canonical tags - I'm wondering if this would need to be considered in this case? However I find it confusing that these pages for to a blank page. https://www.zenory.com.au/blog/tag/dysfunctional-relationships/ https://www.zenory.com.au/blog/tag/change/ https://www.zenory.com.au/blog/tag/intuitive/ Appreciate some assistance.
Moz Pro | | edward-may0 -
What exactly is Moz Analytics?
I've taken a look at this page - http://moz.com/products/tour and I'm trying to determine if Moz Analytics is live yet? I don't think it is, just wanted to make sure. Because right now I'm just seeing all the same tools as we've always had + Fresh Web Explorer. Anyways, let me know if I'm missing something.
Moz Pro | | CAndrew14.1 -
Does Anyone Know The Moz Analytics Release Date?
I know it's coming soon, but does anyone know the actual release date for Moz Analytics? Thanks!
Moz Pro | | eglassman0 -
Internal Links Data on OSE and poor ranking despite excellent metrics
Hi folks, I use OSE a lot for comparing where we stand against our competitors and I'm always surprised to see most of our competitors have loads more internal links than we do. For example, comparing 'www.kensyard.co.uk' with 'www.sterlingbuild.co.uk', we are better on every Root Domain Metric except for the Total Links metric and this is down to a much smaller number of internal links. They are ranking better than us in Google so I'm wondering if there is something wrong with the way our site is coded / structured that means Google and OSE are not picking up our internal link network properly? We have over nine times as many external root domains linking to our site than theirs, which is surely a far more valuable metric than internal links right? Or is there an issue with our internal link structure that is confusing Google and causing us to rank lower? Many thanks for any advice, Luke
Moz Pro | | LukeyB300 -
Changing linked analytics account
When setting up a new campaign, I attempted to add GA. I entered the wrong GA account to this profile. How do I change the GA profile that is linked to this campaign?
Moz Pro | | sgavin0 -
Google analytics sync with SEOMOZ
Hey guys, I'm looking to sync our clients google analytic profiles to our clients campaigns in SEO MOZ. However all our clients google analytic profiles are on the one google account and not separate accounts. So I'm asking does SEO MOZ only allow you to grab the traffic data of one clients profile from a google account instead of multiple profiles from the same google account for different campaigns? If so has anybody got a workaround or any suggestions? If I haven't explained myself clearly let me know and I'll break it down further. Thanks again. Rob
Moz Pro | | daracreative0