Many webmasters are frustrated by the 999 row limit in the new Google Search Analytics reports. What they may not realize is that you can get 5000 rows of data from the Search Console API per query, and Analytics Edge makes it easy to get that data (and more) into Excel. One user reported over […]
Year: 2015
Do You Have The Time?
When creating Google Analytics reports in Excel, time metrics like Avg Session Duration are delivered in seconds, but people want to see the number shown in minutes and seconds as “1:52” (instead of as “112” seconds). Attempts to format the number as “Time” in Excel prove frustrating because Excel expects time numbers to be fractions of a day, not […]
Valid Combinations of Dimensions and Metrics
When building new Google Analytics queries, you are faced with picking from over 400 dimensions and metrics, not all of which work together. To make the selection process easier, the latest release of the Analytics Edge connectors for Google Analytics will give you a visual indicator of invalid selections (Free version available now, Pro version […]