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 […]
Author: Mike Sullivan
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 […]
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 […]
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 […]
A New Way to Monitor Search Engine Rankings
The rules for search engine optimization have changed. It’s no longer about individual keywords and page rank – experts tell us it’s about topics and the “long tail”. But if position and individual terms aren’t the focus, how do you know if changes you made have any impact? This free Excel report demonstrates a new way to […]
Simple SEO Report Automation
Ever since Google switched to “(not provided)” keywords in Google Analytics, we’ve been forced to look to Google Webmaster Tools (now called Google Search Console) to see how our pages are ranking in search, and what search terms they are ranking for. The new Google Search Console interface allows you to see your top ranking pages, and […]
Excel Report Automation Options
Updating Excel reports is a tedious, mind-numbing activity that many people would love to do without. Looking for a solution to the problem, you will discover that there are a quite a few options available to you. They are all listed below, but something you should consider first… The Analytics Edge Add-in for Microsoft Excel […]
Analytics Edge – Simple Excel Report Automation
No time and no money? Analytics Edge was designed for you. If you are spending hours refreshing Excel workbooks, help is finally here. For Individuals and Owner-Run Agencies With Analytics Edge, I am introducing simple Excel report automation: Wizard-based interface uses no formulas or programming Automatically records your steps; can be instantly replayed Simple step-by-step […]