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 […]
Blog
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 […]
SEO Reporting Tools for Excel
Searching for an affordable SEO reporting tool? Analytics Edge has it! Working from a simple add-in inside Microsoft Excel, get your organic landing page data from all of your Google Analytics accounts in seconds! Add a Google Search connector and Bing Webmaster Tools connector, and you can track your search keywords and position rankings […]
PPC Reporting Solution
Analytics Edge add-ins and connectors make Excel a cost-effective Pay-Per-Click reporting solution that is perfect for owner-run agencies.
Here’s a secret: ɢoogle.com is not google.com
And now lifehacĸer.com is NOT lifehacker.com, and шһатѕарр.com is not whatsapp.com. Internet domain names have gone International! [2017-07-26 add ḷ.com to the list] The Imitation G In fact, the letter ‘G’ in ‘ɢoogle.com’ is a Latin Letter Small Capital, Unicode 0x0262. Compared side by side with a real capital G, they would look like ‘ɢ G’ — see the […]