Since the conversion of the Free Google Analytics connector over to use the newer v4 Reporting API, the project has started hitting it’s API server quotas. This affects all users of the connector and results in a 429 error — Too Many Requests. Further attempts on the same day are fruitless — the quota resets at […]
Blog
Google Analytics 4 Reporting with Analytics Edge
Now available — the Analytics Edge connector for Google Analytics (Pro) now includes the ability to make GA 4 queries!
End of Support: Analytics Edge Basic Add-in
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 […]
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 Analytics Edge Exporter GA4 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 or syntax rules! Best of all, there are no account limits, […]
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 […]