2019-03-25 update: most of the API functionality appears to be working once again. 2019-03-22 There are two problems currently affecting Facebook Insights API, one causing no results for Page Insights and one causing errors for Post Insights. Both problems have been acknowledged by the Facebook Engineering team and have been assigned, but no estimated time for […]
Blog
Google Analytics User Activity Report
Experimental Release: The Google Analytics Pro connector for the Analytics Edge add-ins has been updated (v3.9.0) to add a new User Activity query capability. It is now possible to get a report of a specific user’s activity IN DETAIL.
Adventures in Google Search Data Analysis
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 […]
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 […]