This free workbook includes 15 different SEO reports, each with an Analytics Edge macro to automate the data download and analysis. Inspired by the work of Antoine Eripret’s gsc_wrapper, this collection goes well beyond simple data dumps.
Enter a few values in the Setup sheet, then run the macro of choice to populate the respective report worksheet with your site’s results.
Most SEO rank tracking reports show a series of top keywords that change very little over time. What you really need to see is which queries made the biggest changes recently. This free report uses Analytics Edge macros to automate the analysis for you. More
Refresh this workbook with Analytics Edge to get your Bing Webmaster Tools results for the most recent calendar month. More
Refresh this workbook with Analytics Edge to get your Google Search Console results for the most recent calendar month. More
Refresh this workbook with Analytics Edge to get your Google Analytics 4 traffic results for the most recent calendar month. More
This example workbook shows 2 methods to combine data from Google Analytics and Google Search Console using Analytics Edge. See how your top pages changed ranking over the past 90 days, as well as which countries and devices generated the most engagement. More
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
Inspired by work provided by Britney Muller (and Masaki Okazawa) at Mozcon21 (bit.ly/mozcon-21), this workbook provides an excellent SEO analysis highlighting keyword cannibalization, performance changes and top page categories.
This free Excel report works with the Analytics Add-in for Excel and Google Analytics connector to summarize the user engagement of your top website pages. More
This free workbook provides a quick summary of your website traffic over the past year, highlighting key changes last month. More
In this one report, see the impressions and number of unique keywords, by month, for branded and non-branded searches, split into 4 search engine ranking groups: More
When embarking on an SEO review for a website, it helps to be able to see what queries are already ranking and how successful they are (click-through rate) at generating traffic. More
The Google Search Console metric for “position” is an average, and it doesn’t tell the whole story. This report looks at the individual queries used for each of your pages over the past 12 weeks, groups them by position, and shows you the distribution of impressions and clicks by position.
Search Engine Optimization is a changing market. It’s not about keywords, it’s about topics and long-tail in aggregate. This free report summarizes your website’s appearance in search, showing the distribution of the # of keywords, impressions and clicks by position.
See the status of ALL of your client accounts in this simple dashboard, designed specifically for Constant Contact Solution Providers. More
See 10 weeks worth of Google Search Console data in one report. Analytics Edge makes it easy with this workbook and the Connector for Google Search. More
See how your content marketing or search optimization efforts have affected traffic to your site with this free Microsoft Excel report. Enter the target phrase and your account and website information, then let the Analytics Edge Add-in and Google Search Connector take care of the rest.
See a day-by-day position changes for the top queries and pages for your website over the past week, direct from Google Search Console. More
See a week-by-week summary of the top queries and pages for your website, direct from Google Search Console. More
This free Analytics Edge report lets you see long-term trends in the individual words used in search queries that showed you site. More
This free workbook uses the Analytics Edge connector for Google Search to download your website search query performance for the past month, and compares the clicks coming from web search to those from image search. More
Google Search Console provides some excellent insight into your website’s performance in search but it is limited to 90 days of history. More
This free Analytics Edge report gets Google Search Analytics data for your website and displays your top queries distributed across the countries they came from. More
Yes, you can get the keywords for your top landing pages, but not from Google Analytics — they come from the Google Search Console. More
Get the top queries from Google Search Console for the past calendar month More
Download your Google Ads campaign activity for the past 30 days directly into Microsoft Excel. More
See the latest week’s performance of your Facebook page with this free Excel report from Analytics Edge. More
This free workbook shows how to get the same metrics as displayed in the online Facebook Insights reports. More
This free Analytics Edge report can be used by Constant Contact Solution Providers, email marketing agencies and small businesses to deliver branded reports to their clients. Combined with the Analytics Edge Add-in or App and Constant Contact connector, you can cost effectively run reports for all your clients. More
This free Analytics Edge report shows the weekly search page positions for each of your top queries and top web pages. More
Standard reports only touch the surface, so people use spreadsheets to build customized reporting to show the metrics and performance indicators important to them. More
