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
-
Poor quality PDF exports from analytics.moz.com
The new reports look great http://analytics.moz.com/dashboard/overview/ But when I export to PDF, the text is low quality and images are low quality. Not as good as the old report. In fact, the PDF is such low quality we are not providing them to our customers. We're using the old reports. ETA for HQ PDF Export please?
Moz Pro | | OPUS-Cambodia0 -
Rank tracking in Excel via MOZ API?
Hi there, i hope someone knows the solution to this problem. I created/ copied the "advanced Excel Keyword Analysis Report" that Dan Peskin was kind enough to share, you can find it here: http://moz.com/blog/how-to-build-an-advanced-keyword-analysis-report-in-excel. Now i m looking for a solution to rank my Keywords by using an API, preferably the MOZ API. My keywords are alligned in a column "Keword List", which will be regularly updated. Next to this column i would like to have a column with the corresponding rank. Is there a automatic solution, or do i have to do it manually?
Moz Pro | | Juri.Rabiner0 -
Duplicate Titles Shown in Moz Analytics
Hello, My Moz analytics show over 50 duplicate titles. This because my website title is shown on each page (eg About us | Social Engagement, Contact us | Social Engagement, etc.) Is this really an error to be fixed, that otherwise will impact rankings? Or can I leave it as it is? I don't mind having my website title on each page, but if its worth removing it due to duplicate issues impacting ranking, I will remove 🙂 In this case, does someone have any suggestion on how to do this? Which files should I modify? (Im using Wordpress CMS, and I dont see each page code) Thanks in advance.
Moz Pro | | socialengaged
Regards, Eugenio | Social Engagement (http://socialengagement.it)0 -
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 -
Can I setup SEOmoz PRO's 3 organic traffic metrics within Google Analytics (as custom reports)?
I like the 3 organic traffic metrics in SEOmoz PRO: 1) Organic Search Visits
Moz Pro | | AndreVanKets
2) URLs Receiving Entrances Via Search
3) Non-Paid Keywords Sending Search Visits They rock - especially for a high-level view of SEO / Organic performance. Is it possible to setup these metrics as custom reports directly in Analytics? Does anyone have these reports setup? Or maybe there are similar custom reports that give a similar high-level view?0 -
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 -
Greater Number of Linking Domains in Anchor Text Excel Export?
I exported the anchor text for a domain from Opensite Explorer and when I sum the "Number of Linking Root Domains Containing Anchor Text" it is higher than the total amount of linking root domains for the site. Is this because some domains use multiple anchor text links, so it is counted more than once in the exported spreadsheet?
Moz Pro | | ProjectLabs0 -
Problem with connection to Analytics Account
Hey Boys & Girls, I'd just like to say Hi, currently loving the site and the feedback that i'm now able to receive. Just a quick question, signed up last Wednesday and connected my Analytics account. So far, it has had a problem atleast 4 times where i've had to disconnect and re-connect it to my campaign which then erase's the data that it has received. Is this a common problem or am i doing something incorrectly? Thanks Guys!!
Moz Pro | | Chris_CDC0