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
Free Reports (filter at right)
Google Search: Branded/Non-Branded Report
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
Google Search: Bulk URL 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
Google Search: CTR vs Position Analysis
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
Google Search: Data Skeptic
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.
Google Search: Keeping Search Analytics Data
Google Search Console provides some excellent insight into your website’s performance in search but it is limited to 90 days of history. More
Google Search: Keywords for Top Landing Pages
Yes, you can get the keywords for your top landing pages, but not from Google Analytics — they come from the Google Search Console. More
Google Search: Long Tail Keyword Analysis
This free Analytics Edge report lets you see long-term trends in the individual words used in search queries that showed you site. More
Google Search: Position Distribution – More Than Just An Average
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.
Google Search: Queries by Country
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
Google Search: SEO Results Trends
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.
Google Search: SEO Summary Report
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.
Google Search: Top Pages And Queries This Week
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
Google Search: Top Queries Report
Get the top queries from Google Search Console for the past calendar month More
Google Search: Top Queries Trend
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
Google Search: Web vs Image vs Video Search Clicks
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: Weekly Ranking Report
See a week-by-week summary of the top queries and pages for your website, direct from Google Search Console. More