Analytics Edge makes it easy to get your data into Microsoft Excel. You can place multiple queries anywhere in your workbook as this video explains. More
Helpful Articles (filter at right)
2 Help Resources Available
The Analytics Edge help site has plenty of resources available for learning and assistance with reporting. This video explains what is available and highlights the ‘account not found’ problem people experience when sharing workbooks. More
3 Reproducing Standard Reports
This video reviews the common problems that people have when trying to reproduce standard web reports in Microsoft Excel using Analytics Edge. More
4 Creating Custom Reports
Analytics Edge was designed to create the customized reports people need for their website or campaign tracking needs. This video explains the common errors you may run across and what you can do about them. More
5 Licenses and Updates
This video explains how Analytics Edge products are licensed and updated. It demonstrates how to identify updates available and how to install them. More
Account Reference Names
Analytics Edge takes account security very seriously. When you use the add-in or one of the connectors to access one of your accounts, the product will encrypt a security token and save it to your computer. You will be asked for an account reference name for this token. More
Amazing SEO Reporting In Excel
With version 4.0 of the Analytics Edge Google Search connector, you can quickly create SEO analysis reports with tremendous insight potential; way beyond what you can do in Google Search Console itself! More
Bulk URL Index Inspection Queries
if you manage a large number of Search Console accounts and sites, this workbook will help you cope 2 big hurdles: the 2000-URL per day limit, and aligning which account to use for each URL. More
Caution: Last Day of Data May Not Be Accurate
According to a tweet by John Mueller of Google (2017-06-23), the most recent day of data from the Google Search Analytics API may contain partial results, so you should plan to refresh that data the next time you run your report. More
Error: Account not found. Check Account wizard
This error usually occurs when you share workbooks with coworkers, or after a computer move or rebuild. Analytics Edge stores a reference to the account in the workbook, but the actual security tokens are stored on your computer. More
Error: Invalid/missing dates
This error usually occurs when the cells you referenced in a query have moved or the contents are changed. Analytics Edge connectors offer the ability to use cell references for the dates, but the references can get out of alignment if you add rows or columns in the worksheet, or if you renamed the worksheet. More
First Looks: Google’s New Search Console API
The long awaited Google Search Console (Webmaster Tools) API update is finally out, and here’s a quick review of some of the new capabilities and limitations. More
Get Impressions From Google Analytics
A lot of people want to include the Google Analytics clicks and impressions metrics in their reports, and are frustrated when they see most reporting tools do not offer those metrics. The reason is that they don’t actually come from Google Analytics — they come from Google Search Console, and that uses a separate API.
Google Search: Annual Reporting
Long-term reporting with Google Search Console data is fraught with challenges. This article discusses some of the unique problems time can create, and how Analytics Edge products can save you time while solving them. More
Google Search: Branded Versus Non-Branded
The filtering capability in Google Search Console is very restrictive (single phrase match), making it useless for separating branded from non-branded search terms in all but the simplest cases. Enter the Analytics Edge Core Add-in — a quick regular expression filter and your work is done. More
Google Search: Branded vs Non-Branded for Large Sites
If you manage several large websites, the Analytics Edge Core Add-in allows you to build an efficient template for separating branded and non-branded search queries from the Google Search connector. More
Google Search: Download All Your Page And Query Data
Downloading your Google Search Console data into Excel is easy with Analytics Edge. The Google Search Connector uses the API to pull down all of the query and page metrics — without the 1000 or 5000 row limit imposed by the web interface. More
Google Search: Eliminating Noise
As discussed in a companion blog article, while trying to create an annual report for my own websites, I discovered that Google Search data is full of ‘noise’ — data that actually makes it harder to make useful observations about trends. This article includes the workbook I used.
Google Search: Get 16 Months Of Search Data
The Google Search API now supports a full 16 months of historical data, but the only date-related field is ‘date’, so this is how to get all that data out in a meaningful way — in weekly or monthly buckets. The Google Search Connector from Analytics Edge provides a MultiQuery tab that does just what you need, and your appears in Excel in seconds! More
Google Search: Quick SEO Analysis
See how quickly the Analytics Edge Core Add-in can transform a pile of Google Search data into a spreadsheet of actionable information (video 7:17). More
Google Search: Trends Reporting
With the Analytics Edge Google Search connector, you can easily get week-to-week or month-to-month reporting in a single query. More
Long-Tail Keyword Analysis (Advanced Example)
Long-tail keyword phrases are often made up of many different combinations of similar words, making it difficult to tell when there is a common topic of interest. This article walks through the creation of a keyword analysis report, based on weekly snippets of data from Google Search Console. More
Making a CTR versus Position Chart By Device
The Analytics Edge Core Add-in is perfect for doing a quick analysis of search engine ranking data. In this article, I show how to get a CTR versus Position chart by Devices — showing the difference for click-thorough-rate of desktop versus mobile. More
Misunderstood Metrics: Average Position
Google Search Console makes it easy to track the position of your website pages in Google’s search results, but the numbers are averages, and averages don’t tell the whole story. When it comes to search engine ranking, they can be really misleading. More
Multi-Source Waterfall Report
The wizard-based automation provided by the Analytics Edge Core Add-in for Excel makes it easy to combine data from multiple sources. This article explores how you can build a Waterfall Report that includes data from Google Webmaster Tools (now Google Search), Bing Webmaster Tools, Google Analytics and an external database. More
Optimize Search Engine Rankings
How do we monitor and optimize our website presence and increase our search click-through rates? More
Reading Sitemaps to Get a Full Listing of Pages
When analyzing website traffic, there are times you might want a full listing of the website’s pages…even those that never get any traffic or impressions. Google Analytics and Google Search Console will only report on pages were there is data, so these unrecognized pages continue to be overlooked. This article shows how the Analytics Edge Core Add-in can read the website’s sitemap files to extract a full listing of pages. More
Selecting a Date Range
In most Analytics Edge wizards, you can select a data range for your query. There are a large number of combinations possible, but here are the most common selections. More
Simple Google Search Console Query
See how quickly (20 seconds) you can get your Google Search Console data into Microsoft Excel using Analytics Edge products. (video 1:01) More