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 […]