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!
Blog Articles
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 […]
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 […]
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 […]