GA plug in for Excel
-
Hi,
Anyone know of a good GA plug in for Excel?
-
SEOTools for Excel has Google Analytics capabilities.
Here is more info on it: http://nielsbosma.se/projects/seotools/functions/googleanalytics/
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
-
What's more accurate? GA queries data or Moz/SEMRush keyword data for rankings
What do you guys think? What's more accurate? GA queries data or Moz/SEMRush keyword data for rankings? Any thoughts appreciated.
Reporting & Analytics | | znotes0 -
Weird Math in GA Ecommerce Tracking
Hi everybody. I've recently discovered that I have a problem with the ecommerce tracking on a client's website. The client sells concert tickets at an average price of $10 per ticket. The custom ecommerce platform they use is kind of unusual; the same product often has different SKUs, but not always. This isn't associated with different seats, etc. In fact, I don't yet know why they've set it up that way. The problem that I'm facing is this: the data in Analytics is calculating the "average price" of a SKU item as the total price. If, for example, the actual average price for a SKU item is $10 and four of those SKU items were sold, Analytics will tell me the average price is $40. This means that the total revenue for that SKU shows up as $40 x 4 = $160. Needless to say, this is enormously skewing the data. Here's a screenshot. Note, it's the same product: http://screencast.com/t/JyLQkb3jzz6s The total revenue for ticket sales is way off because of this, and I'm not sure if it's a problem with the ecommerce tracking code in Analytics, or something that the ecomm platform is doing. Have any of you experienced anything like this, and if so is it a fix in Analytics? Thank you!
Reporting & Analytics | | newwhy0 -
How do i add GA to my companies flashed based platform?
Hi, I work for a company were the service we offer is a flashed based trading platform. We are wanting to add GA to the platform to get an idea of how customers are using this. 1. Can this be done and produce relatively accurate results 2. How can it be done? Regards Ben
Reporting & Analytics | | benjmoz0 -
Has GA changed how it calculates bounce rate?
Updated website from Magento backend to Wordpress and since the redeploy, my bounce rate has dropped from 40% to 4%. I did check to see if there was duplicate GA tracking code but only one call. I checked reports under "visitor flow" and one page visits seem inline with the previous bounce rate. Weird. Never experienced this before.
Reporting & Analytics | | Timmmmy0 -
Tracking Social Interactions with GA and WordPress
Hi, One of the things I'm looking to do is to track clicks on my social follow buttons. I know I can try to add GA events for each button and go from there. But in order to simplify the process, I'm looking for a WP plugin that can help. Currently I've only come across AddThis and Share This as viable options, though Add This has very mixed reviews, and Share This isn't updated for WP 3.6.1. For my social shares at the end of blog posts I'm wondering the same thing about tracking shares. I've used AddThis in the past with success in tracking shares, but I wanted to see what other are doing or if there's a newer technique. The bottom line is that I want to try to see as much of the "social" as I can in GA. Thank you in advance!!
Reporting & Analytics | | Titan5520 -
GA not recording visitors PART 2
Further to my question yesterday where all data for Wednesday 31st July 2013 was not showing - the data did reappear yesterday afternoon. But today, all data for yesterday seems odd - across all my projects visitor numbers appear to be around 40% down on the norm. Sales were normal, so I wonder if this is another glitch - anyone else seeing strange stats in GA for yesterday?
Reporting & Analytics | | FDFPres0 -
New Google Analytics Site Speed tool and excel
Hello, I was wondering if there is a good tool or method to pull the new Google Analytics Site Speed data into excel and use this document to track site speeds on a weekly basis for multiple clients? Any good articles or how-to's would be awesome!
Reporting & Analytics | | Hakkasan0 -
GA custom reports involving pages and goals - what are the metrics saying?
Hi, All! I would like to create a custom report that will enable me to see which of my pages are contributing to goal completion on my site (so I can then optimize the pages that are contributing the most, with maximal ROI for the optimization investment). If I make the dimension "page/page title" and the metric "goal X completions" - which would make sense - what exactly are the numbers that I am seeing telling me? Is it how many times a person started the goal funnel from that pages (meaning every goal would appear only once and there be no overlap)? That doesn't appear to be the case with the numbers, because the headline in the main "Goals" section tells me I have 30 goal completions for that goal, for example, but the headline in the custom report (which is adding up all the numbers) is, say, 100. Or does it mean the number of times that this page was ever in the navigation path of someone who ended up completing a goal? Then the same goal would be counted multiple times, for each page in the path. Additionally, I see this strange thing on some of my reports where the actual funnel pages appear as contributing towards goals, which I guess makes sense, but again the numbers don't match up. If the goal was to get to page B, and the funnel was A->B, and there were supposedly 30 goal completions, my custom report says that A gave 28 goal completions and B gave 25. Anyone know for sure - or through testing - what the case is with all these things? Any explanations will be much appreciated!
Reporting & Analytics | | debi_zyx0