A new release of the Analytics Edge connector for Google Analytics (Pro) is available: v4.0. Note that this update is necessary due to changes in the Google Oauth authentication. If you do not upgrade, you may get an ‘untrusted’ message when you try adding a new account. After the upgrade, you will be REQUIRED to […]
Blog
Search 360 Dimensions and Metrics
The new Google Analytics Search 360 dimensions and metrics are available in the Analytics Edge connectors. To get all the latest dimensions and metrics, just click the Update button on the Fields tab when making a query.
Exploring Possibilities with Extract, Transform, and Load (ETL)
Way back in the 1970’s, the concept of ‘extract, transform and load’ (ETL) became popular in data warehousing environments. ETL tools could grab data from multiple sources, combine and transform it through various operations, then load it into database tables. In 2013, Analytics Edge brought that same capability to Microsoft Excel in the form of […]
Stop Using Google Search Console Property Sets
2019-05-06 for users of the Google Search connector for Analytics Edge: If you have regular reports running to collect Google Search data, check to see if they are still working. It looks like Google has stopped delivering any data for the old Property Sets. It is time to switch your reports over to reference the […]
Facebook Ads Connector Update Required by May 14th, 2019
The Analytics Edge connector for Facebook Ads requires an update to v3.4.0 before May 14th, 2019. This release implements the latest Facebook API version which includes some changes to the conversion metrics. Specifically, the release includes a reorganization to the the new standard events (like App Activations and Purchases). Some old, unused metrics have been […]
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 […]