The next generation of Analytics Edge add-ins is coming, version 7, with faster refreshes and a little bit of new technology thrown in. Backward compatibility and low cost are maintained. This sets the stage for new capabilities and additional connectors to come in 2020. There will also be a modest price increase, effective Jan. 25, […]
Author: Mike Sullivan
Export more than 5000 rows in Google Analytics
The free Analytics Edge Basic Add-in for Excel includes a free Google Analytics connector that can download as many rows as you want. The simple wizard-based interface also includes features to minimize the effects of sampling, converting dates to Excel dates, and converting percentage metrics to numbers that can be formatted as percentages in Excel […]
Connector for Google Analytics (Free and Pro) Update
2020-01-08 New releases of the Analytics Edge connectors for Google Analytics (Free 4.4 and Pro v4.7). How to Update Analytics Edge Connectors [There are also updates for all three add-ins, Basic, Standard and Core] Fixes problems with !Error(gf): Object reference not set Your MUST re-authorize all of your saved account entries. This can be done […]
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 […]