Being the start of a new year, I had a look back at the Google Search performance of my websites for the past 12 months. Looking at the Google Search Console reports was frustrating — the numbers were meaningless for a variety of reasons. Thus started my journey into Google Search data analysis, and my […]
Blog
Google Analytics Pro Connector Update
The Google Analytics Pro connector from Analytics Edge has been updated (v3.0.1) to use the GA v4 API, and the Bulk Queries wizard has been cleaned up. ACTION REQUIRED: when you update, you may be prompted to refresh the account credentials on your system. Open the Accounts wizard and click on each entry — a […]
Free Google Analytics Connector: Still Improving
I am constantly looking for ways to improve the Analytics Edge add-ins for Excel and the connectors that work with them. For the free products (Basic Add-in and Free Google Analytics connector), I have noticed 2 things seem to consistently affect a number of people on a daily basis. The latest release of the Free Google […]
From Microsoft Excel to Google Sheets [to Google Data Studio]
A new feature has been added to the Analytics Edge Core Add-in for Microsoft Excel: the ability to copy results directly to a Google Sheets file. This provides a simple solution to client reporting for Excel users. Since the queries are run from your PC, and only the data is written into Google Sheets, you […]
Google Search Connector Supports 25,000 Rows Per Query
The latest release of the Google Search connector (v4.5.0) from Analytics Edge now supports the API’s expanded 25,000 rows per query. As previously, if there are more rows available, the connector will automatically get them as well, but the new API limit should reduce the number of API queries required to do so. The new […]
Facebook Connector Problems
As of July 11, 2018, the Facebook connector can still download Page Insights data, but the Post Insights and Page Posts queries return !Error 400. This is partially due to a bug in the Facebook API, and partially due to a change in Facebook’s access policies. When they fix the bug, you should be able […]
Analytics Edge for Mac
A number of people have been searching for an Apple Mac version of the Analytics Edge add-ins, but that does not exist yet. It is possible to run the add-ins on a Mac using products like Parallels, but you will also need a copy of Microsoft Windows and a Windows version of Excel. A native […]
Google Search Analytics: Compare Date Ranges
In preparation for the heavily expected 16 months of search history coming to the Google Search Console API (not quite here yet), the Analytics Edge connector for Google Search has been updated with a new Date Compare feature! Now you can easily compare the search results for the previous period or year-over-year (as soon as […]
Analytics Edge Add-in Updates: Game Changer!
“@AnalyticsEdge PS thanks for adding the Query Sheet, #GameChanger!” Released today (2018-01-22): Analytics Edge Basic Add-in v5.2; Analytics Edge Standard Add-in v3.0 With these updates, Analytics Edge gives you even more control and capability to automate your Excel reports. Both add-ins now provide full access to a user-editable query worksheet. While it is hidden by […]
Time on Site Metrics Deprecated
Way back on 2014-04-16, Google Analytics changed the “Time on Site” and “Avg. Time on Site” metrics into “Session Duration” and “Avg. Session Duration“. The old metrics continued to work for over 3 years, but as of July 2017, they stopped working. If your report used the old metrics, you are probably getting errors complaining about “unknown […]