DEADLINE Sept. 1, 2020 – on this date the Analytics Edge Basic Add-in [and Analytics Edge Standard Add-in] will be unable to get a new license key. License keys could be required after a Windows update or hardware change. This is due to a server upgrade that no longer supports the encryption algorithm used in […]
Blog
Download Google Search Analytics Data FAST!
SEO reporting just got a lot easier: the Analytics Edge connector for Google Search is now faster than ever! Parallel downloads and processing gets you all your data as quickly as possible, automatically running multiple queries to download more than 1000 rows, more than 5000 rows, more than 25000 rows — you can even download […]
Export more than 5000 rows in Google Analytics
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 […]
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 […]
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 […]
From Microsoft Excel to Google Sheets [to Google Data Studio]
The Analytics Edge Core Add-in for Microsoft Excel can be used to automate your report updates, with connectors to Google Analytics, Facebook Ads, Google Search Console and more. Now it can also copy the results directly to a Google Sheets worksheet — automatically! Since the queries are run from your PC, and only the data […]
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 […]
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 […]
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 […]