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 […]
Author: Mike Sullivan
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 a 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 version […]
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 […]
Saving Google Search Console Data in Excel
Someday soon we may see more than 90 days worth of data from Goggle Search Console..or so the rumor said a year ago…in the meantime, Analytics Edge makes it easy to save your historical metrics in Microsoft Excel. Before we get into the details, there are a few things you should know about grabbing data from […]
Here We Grow: Introducing Analytics Edge Inc.
It is a subtle change in the name: Analytics Edge Inc. The Analytics Edge products have filled out over the past 4 years, delivering on the promise of simple Excel report automation with over 15,000 happy users in 120 countries. With the incorporation of my business, I am increasing the investment in my dream: building […]
Explaining the Changes to Google Search Console Data
On July 13, 2017, Google changed the way it collects data for their Search Analytics reports to provide “better accounting for results in lower positions. This change might cause increase in impressions, but also a decrease in average position.” But how did it affect your metrics, and are their other changes hiding behind the confusion?