For the past 11 years, the Analytics Edge portfolio has been rooted in making it easy to get your data from various API services like Google Analytics and Google WebmasterTools (Search Console). It is designed to run on your computer, making direct API calls and processing the results without requiring any programming or API knowledge. […]
Author: Mike Sullivan
Minimize Sampling in GA4 Reports
Analytics Edge has added a new option for GA4 Reporting — Minimize Sampling! If your reports suffer from sampling, it is now possible to split the report by month, week or day, with separate queries for each. Available now in version 11.16.0 of the Add-in for Excel. Download
Chrome UX, PageSpeed Insights, URL Inspection Report Automation
The Analytics Edge connector for Google Search has added the ability to get data from THREE new sources: the Chrome UX Reports API, the PageSpeed Insights API, and the new Google Search Console URL Inspection API! Each of the new query wizards can use an Analytics Edge range name (reference to a column of URLs) […]
LinkedIn Ads Reporting in Microsoft Excel
Save your self time and money by automating your advertising reports on your own computer with Microsoft Excel and Analytics Edge! Combine the flexibility of Excel with the simple automation capabilities of the Analytics Edge Core Add-in. Now you can pull your LinkedIn Ads data right into your spreadsheet!
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 […]
SEO Tools for Excel
Searching for an easy-to-use SEO reporting tool? Analytics Edge has it! Working from a simple add-in inside Microsoft Excel, get your Google Analytics, Google Search and Bing Webmaster Tools data in seconds! Feed the results to an AI Request or connect to other APIs using a generic Web Request. No formulas, no programming: just simple […]
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 […]