The Analytics Edge Basic Add-in is free, as is the included Free Google Analytics Connector. There are no account restrictions, no query restrictions, and the product is updated, maintained and supported. To keep it that way, I need your help to SPREAD THE WORD! Twitter, Facebook, Reddit, at conferences, in meetups, or just mention it over a beer with colleagues. More
Analytics Edge makes it easy to combine data from different sources in the same report. This article describes one of our free workbooks that combines data from Google Analytics with Google Webmaster Tools and Moz. More
This is a PROVEN WORKING SOLUTION for how to remove referral spam in your Google Analytics.
2018-06-23 final update. This article was started in January 2015 to help Google Analytics users deal with a new form of ‘ghost referrals’, or false information, being injected into their analytics reports. Over the last 3 1/2 years, a number of people have used a variety of techniques to manipulate the data being reported, and I have maintained a series of filters for limiting their effectiveness. For the most part, Google is now responding on its own, and I am moving on. More
For people measuring their website traffic with Google Analytics, there is nothing more frustrating than building a really popular web page that gets tons of visits, but GA shows Session Duration close to ZERO! The problem is that Google Analytics doesn’t measure the time on the last page of a visit, so even if they read your article for 5 minutes, if they don’t click on another page, their session is recorded as 0 seconds. Sigh…. More
The Google Analytics report for Frequency displays a Count of Sessions dimension that is misleading in several ways. More
How can the Average Session Duration be less than the Average Time on Page? In Google Analytics, seeing the time spent on your website or on individual pages is not as obvious as it first appears. This Misunderstood Metrics article explores the concept of time in Google Analytics…or lost time as the case may be. More
Google Analytics has recently changed, introducing a new Unique Events metric calculation. This article has not yet been updated to reflect that change — Mike Sullivan.
When the Facebook Ads API returns an error 500, it is telling you that the combination of the number of metrics and rows of data being asked for is too large for them to process all at once. More
Many analysts, consultants and agencies use Excel to create reports for their clients because it allows them to deliver a unique solution, tailored to the client’s needs. By using Analytics Edge to generate and automate the report refresh, the monthly process becomes a lot easier and doesn’t require any changes to the client’s environment. More
When I was working on a new Excel report for my Google Webmaster Tools connector, I started seeing traffic from a specific query phrase that didn’t make sense, so I dug a little deeper, and what I found made me question the very foundation of conventional SEO wisdom and the meaning behind Google Webmaster Tools data. More
While all of us fight to get Google Analytics referral spam under control, one piece of well-intentioned, but bad advice comes up over and over again: use the Referral Exclusion List. Some people (myself included) have stated that is a bad idea, but no one has taken the time to really explain why. Here is the Why… More