The free license for the Analytics Edge Core Add-in for Excel includes a Free Google Analytics connector that can download as many rows as you want, effortlessly. The simple wizard-based interface makes it easy to recreate standard reports, and just as easily customize them to suit your needs. No need to learn API field names […]
Year: 2019
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 Fixes problems with !Error(gf): Object reference not set Your MUST re-authorize all of your saved account entries. This can be done from the Analytics Edge ribbon > Google Analytics > Accounts wizard. Simply […]
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.
Extract, Transform, and Load (ETL) With Analytics Edge
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 […]