Category Archives: Google Search

Google Search Position Distribution

Core Add-inGoogle Search Connector

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.

Using the power of the Analytics Edge Core Add-in, the workbook macros will download your website data and do all the analysis work for you.

Download the workbook:
GoogleSearch-PositionDistributions-1-0.xlsx

 

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.

Keep this in mind when building your reports.

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 row limit imposed by the web interface. But even with the API, by including the ‘query’ dimension and the ‘page’ dimension together, Google can limit the number of combinations it makes available.

You can get a lot more combinations if you make separate requests with just the query dimension, filtered for each of your pages in turn, then combine the results. While that sounds like it could be a lot of work, the latest Analytics Edge connector makes it simple: just run a ‘MultiQuery’ request for your ‘top pages’, and use a large number that would include all of your pages.

Making the query

Fields: select ‘query’ and the metrics you want
Dates: pick the date range desired (Last 90 days will yield the most data)
MultQuery: Vertical layout, by Top Pages with a number larger that the number of pages you have

Caution: asking for too much data can take a long time to download and potentially overload Excel.

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! Here’s a quick example made in conjunction with the Analytics Edge Core Add-in.

Average Positions Trend for Top Page-Query Combinations

There are some search queries that bring lots of traffic to various pages on your site, and this quick report lets you see if any of them start to climb or drop in the rankings. Use it to gauge the success of your SEO efforts, or to easily see the impact of new search ranking algorithms.

The report starts with a quick “multi-query” using the Google Search connector. Select the dimensions ‘page‘ and ‘query‘, plus the metrics ‘position‘ and ‘impressions‘. Select the preset date range of ‘Last 90 days‘, and a MultiQuery ‘by 7-Day‘ with a ‘Horizontal – Group by Metric‘ layout.

You will end up with a lot of combinations, many of which get very few impressions, so we will want to filter them. Because we have 12 weekly columns of data, it would help to get a total for the whole 12 weeks first. This is easily accomplished with the Core Add-in’s Table>Total function, summing the last 12 columns. I chose to put the column before any of the others and to remove the weekly impressions columns themselves since they don’t add much to the report.

Once we have the Total Impressions column, it is a simple matter to use a Filter function with an appropriate number (will vary depending on your website traffic – I used 1000 in this example).

Then a Write to Worksheet function finishes off the macro and your report is done! Refresh the report weekly for the latest insights!

As a final step, I tend to use Excel’s custom formatting for visualization of trends. Since we are looking at search engine rankings, page 1 and 2 are where your focus needs to be, so I use a reverse 3-color rule, with red for higher numbers and green for smaller ones. I edit the rule and change the defaults so numbers 9 and lower are green (page 1 search results), numbers 19 and lower are white (page 2 search results), and numbers over 29 are red (page 3 results will shade to red). You can adjust the numbers to your preferences.

The final result now clearly shows page-query combinations that are improving or degrading in rankings, plus it makes new ‘hot’ pages very visible. If you sort the report by page, you can see how new search terms are picking up existing pages and supporting or replacing older terms.

Variations

Track a specific list of page-query combinations. Create a second worksheet of the 2 columns with the desired values, then instead of Filtering, use the Match function to keep matching values from your reference worksheet.

Highlight hot content and queries. Instead of filtering by the total impressions, use Total to get a sum of the last 4 weeks (do not remove the selected columns), then use Total again to get the  sum of the last 12 weeks. Now use Calculate to create a new column with the ratio (4 week total/12 week total) and filter on the result.  Filter on the Total Impressions to remove the really long tail searches… Hot combinations would have a decent number of impressions and a high ratio.

 

 

Google Search Trends Reporting

With the release of v4 of the Analytics Edge Google Search connector, you can now easily get week-to-week or month-to-month reporting in a single command.

Using the new ‘MultiQuery’ capability, you select the dimensions and metrics you want, then pick the time period of interest (select the whole 2-week or 2-month period).

The final step is to select the matching time period on the MultiQuery tab (by 7-Day or by Month), plus choose the Layout option Horizontal – Group by Metric.

The result will be pairs of columns for each metric in your query, one for each time period (colored here for clarity).

Discussion

This time-based multiquery can be used with any combination of dimensions and metrics, even if you use filters (e.g. search metrics for a specific query or page over time).

You can have more than 2 time periods in the trend report, but the Google Search Console only has data for the past 90 days. You could do three 28-Day periods (totaling 84 days), or 12 weeks.

For weekly reporting, you can report rolling 7-Day periods (ending on the last day of the period selected), or calendar weeks (Sunday-to-Saturday or Monday-to-Sunday). Note that if you select calendar weeks, only whole weeks will be reported i.e. no partial weeks. That means you should get 12 periods, but if all the dates are not available on the day you run the report it may drop to 11 periods.

The Date tab selections and the MultiQuery date options interact, so selecting ‘duration 2 months’ and ending at ‘end of Last Month’ on the Date tab allows you to get calendar months when selecting ‘by Month’ on the MultiQuery tab. If you select ‘duration 2 months’ and ending at ‘end of Current’, it would return  a rolling 2 month period ending a couple of days ago (Google Search Console data is delayed by a couple of days).

Sorting works on each individual query, but when the queries are joined, the first time period determines the base report order. So if you report on pages sorted on impressions, the report will be order by the highest impressions for the first time period.This could result in new pages added after that date appearing at the bottom of the report, even though they have lots of impressions.

Optimize Search Engine Rankings

How do we monitor and optimize our website presence and increase our search click-through rates? One approach is to adapt your content to include the terminology that people actually use in their “long-tail” searches — the longer, smaller volume searches. This article explores a technique to discover these ‘common’ phrases that people are already using to find your content, so you can look for opportunities for improvement.

monitor-search-engine-rankings-results

Continue reading

Get Top Queries for Selected Pages

Similar to the Queries for Top Pages report, this article details the steps to create a custom report grabbing the top 5 queries for a selected set of pages [Requires the Analytics Edge Core Add-in and the Google Search Connector].

google-search-repeat-macroThere is a single macro in the workbook [DownloadQueriesForTopPages.xlsx].

The repeat macro reads the pages from the Top Pages worksheet, splits it by the ‘/’ character to extract the web server, then issues a Google Search Console query to get the queries for the specific page on that server. After the download, the results are cut off at the top 5, then a page column is inserted and the results are appended to the Queries worksheet.

Each step is described in more detail below.

REPEAT MACRO Top Pages

google-search-repeat-macro-1

Starting the macro with a Repeat Macro wizard, we pick the Top Pages worksheet to process, 1 row at a time. This means we will process the entire macro for every row in the Top Pages worksheet. The values from each column are available to Analytics Edge wizards as ‘range names’ — meaning you can enter the column name in square brackets (like ‘[page]‘) instead of entering a real value (you will see this later).

We also choose to clear the Queries worksheet before the first iteration. Note that the last step in the macro is to append to the Queries worksheet. This lets us start with an empty Queries worksheet to which we will append the results of each pass through the macro.

Split

google-search-repeat-macro-2

As you can see, the first row of the Top Pages worksheet has been loaded into memory, and the ‘page‘ column contains the full page URL.  To make the next steps easier, we’ll split this column by the ‘/‘ character to make it possible to get the web server portion of the page URL — ‘help.analyticsedge.com‘ in this case.

WT Search Analytics

google-search-repeat-macro-3

With the page URL and server now available in separate columns (‘page‘ and ‘page-3‘), we can make the query to get the Google Search data. Using the default account (‘*‘) and the web server from the URL (as a range name, with the square brackets around the column name ‘[page-3]‘), we get the ‘query‘ dimension, sorted by clicks/impressions/ctr/position.

google-search-repeat-macro-3a

On the Filters tab, we elect to filter by the page URL using the range name (‘[page]‘).

Note: On the Dates tab, I have left it with the default Last 28 days — you can change that if you want.

Keep top 5

google-search-repeat-macro-4

Since the original requirement was only the top 5 queries for each page, we need to get rid of the rest, so we add a keep Top 5 rows step to our macro (using the Table > Top/Bottom wizard).

Arrange Insert column

google-search-repeat-macro-5

So we can tell which queries were for which pages, we use the ArrangeInsert wizard to put a new column into the results and set the initial text value to be the ‘[page]‘ range name we have used. This will create a new column and populate it with the page URL being processed in each loop through the macro.

Append to Worksheet Queries

google-search-repeat-macro-6

Now that we have the results we wanted for that page, we append the results to the Queries worksheet. On each pass through the macro, each page’s queries will be appended to the results, giving us a single worksheet with the top 5 queries for each of our pages listed on the Top Pages sheet.

 

Note: when you finish the macro, it will only show the first page’s results in the Queries worksheet. Run the macro to process all of the rows.

 

SEO Summary Report

Core Add-in, Google Search Connector
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.

seo-summary-report-2

 

The included Analytics Edge macro downloads the last 12 weeks worth of Google Search Analytics data and extracts the data, excluding your branded search terms if desired.

Download the workbook: GoogleSearch-SEOSummaryReport-2-0.xlsx

v2.0 Updated to display counts for position 1 at the bottom of the charts, and added counts for position 21+ at the top.

Configuration: Enter your account and website on the Data worksheet in the highlighted cells, enter any brand terms to be excluded on the Brand Terms worksheet. Click Refresh All.

 

Queries for Top Pages

get-google-search-console-detail-in-minutesCore Add-in, Google Search Connector
This free workbook is a companion to the Simple SEO Report Automation newsletter and video Get Google Search Contents in Minutes. It shows how easily Analytics Edge can automate a sequence of queries; in this case, getting a list of the top pages that appear in Google Search results, then for each of those pages, get the queries that were used to find them.

It includes the impressions, clicks, CTR and position data.

Download the workbook: GoogleSearch-QueriesForTopPages-1-0.xlsx

UPDATE: The functionality in this workbook can easily be accomplished with a single ‘query’ in the Google Search connector v4.0, and it works in the Basic Add-in:

GoogleSearch-QueriesForTopPages-4-0.xlsx

 

Get Queries for All Top Pages

Here’s a short video showing how easy it is to download the Google Search queries for each of your top pages using the Analytics Edge Core Add-in and Google Search connector: less than 5 minutes of work, and no programming!

The Google Search connector uses the Google Search Console API to get your Search Analytics data. The Analytics Edge Core Add-in lets you automate the process of downloading your top pages, then for each page, downloading the queries into a Microsoft Excel worksheet.

Top Queries Trend

Core Add-in, Google Search Connector
google-webmaster-tools-top-queriesSee 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.

It downloads the top queries for each week, and lines them up side-by-side so you can see the number of impressions shift over time, highlighted using Excel’s conditional formatting.

Download the workbook: GoogleSearch-TopQueries-3-0.xlsx [updated 2015-10-16]

 

UPDATE: similar functionality can now be obtained with the Basic Add-in and the Google Search connector v4.0 using a single query:

GoogleSearch-TopQueries-4-0.xlsx

SEO Results Tracker

Core Add-in, Google Search Connector
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 Core Add-in and Google Search Connector take care of the rest.

google-search-phrase-tracker

Continue reading

Top Pages And Queries This Week

Core Add-in, Google Search Connector
search-analytics-position-this-weekSee a day-by-day position changes for the top queries and pages for your website over the past week, direct from Google Search Console.

Just enter your website URL and click Refresh All; Analytics Edge takes care of the rest, downloading the data for each day, combining the results, pivoting by day, and sorting by the highest number of clicks and impressions for the week.

Download the workbook: SearchAnalytics-position-this-week-3-0.xlsx [updated 2015-10-16]

UPDATE: similar functionality can be obtained with the Basic Add-in and the Google Search Connector v4.0:

SearchAnalytics-position-this-week-3-0.xlsx

Weekly Ranking Report

Core Add-in, Google Search Connector
weekly-positionSee a week-by-week summary of the top queries and pages for your website, direct from Google Search Console. Quickly identify trends and changes in ranking of popular terms. It also shows the number of impressions and clicks for the most-recent week!

Just enter your website URL and click Refresh All; Analytics Edge takes care of the rest, downloading the data for each week, combining the results, pivoting and sorting by the to show your search engine rankings over a 7-week period.

Download the workbook: SearchAnalytics-weekly-position-3-01.xlsx [updated 2015-10-16]

Requires the Analytics Edge Core Add-in and the Analytics Edge Connector for Google Search.

UPDATE: similar functionality is now available from the Basic Add-in with the Google Search connector v4.0:

SearchAnalytics-position-this-week-4-0.xlsx

Long Tail Keyword Analysis

Core Add-in, Google Search Connector
long-tail-keyword-analysis (2)This free Analytics Edge report lets you see long-term trends in the individual words used in search queries that showed you site. Refresh weekly and the report maintains previous results, letting you see not just the current hot topics but also those that have fallen out of the rankings.

You don’t have to dig through hundreds of similar but unique query phrases, Analytics Edge splits each term apart and performs a Soundex grouping of word variants to give you a concise summary of the current topics of interest. A companion blog article describes how the report was created.

Download the workbook: GoogleSearch-Word-Frequency-2-0.xlsm

This report can be refreshed with the Analytics Core Add-in, in combination with the Analytics Edge Connector for Google Search.

Web vs Image Search Clicks

Basic Add-in, Google Search Connector
webmastertools-web-image-comparisonThis 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.

Download the workbook: GoogleSearch-web-image-comparison-2-0.xlsx

UPDATE: Similar functionality is now available from the Google Search connector v4.0 with a single query:

GoogleSearch-web-image-comparison-4-0.xlsx

Keeping Google Search Analytics Data

Core Add-in, Google Search Connector
webmaster-tools-monthly-trackerGoogle Search Console provides some excellent insight into your website’s performance in search but it is limited to 90 days of history.

These two workbooks let you keep your weekly or monthly snapshots offline in an Excel workbook. Analytics Edge Core Add-in automation makes it easy to maintain — you can even schedule it to refresh automatically!

Available in weekly and monthly versions; download the workbooks:
SearchAnalytics-Weekly-Tracker-2-0 (1).xlsx
SearchAnalytics-monthly-tracker-2-0.xlsx

 

Search Queries by Country

Core Add-in, Google Search Connector
search-analytics-query-by-countryThis free Analytics Edge report gets Google Search Analytics data for your website and displays your top queries distributed across the countries they came from.

Use this data to better understand how topics and terminology differ between regions.

Download the workbook: SearchAnalytics-query-by-country-1-0 (2).xlsx

UPDATE: most of the functionality in this report can be recreated with a single query using the Google Search Connector v4.0:

SearchAnalytics-query-by-country-4-0.xlsx

Keywords for Top Landing Pages

Basic Add-in, Google Analytics Connector, Google Search Connector
keywords-for-top-landing-pagesYes, you can get the keywords for your top landing pages, but not from Google Analytics — they come from the Google Search Console.

This free workbook uses the Analytics Edge Connector for Google Analytics to grab your top landing pages, then the Connector for Google Search (Webmaster Tools) grabs the keywords used to see each page in search results; clicks, impressions and average position! All you need to do is Refresh!

Download the workbook: SearchAnalytics-KeywordsForTopLandingPages-1-0.xlsx

 

Google Search Top Queries Report

Core Add-in, Google Search Connector
google-search-last-month-queriesGet the top queries from Google Search Console for the past calendar month in this free workbook. Just enter your account and website information, then refresh with Analytics Edge and you’re done in seconds!

Download the workbook: GoogleSearch-Last-Month-Queries-1-0.xlsx

This report can be refreshed with the Analytics Core Add-in, in combination with the Analytics Edge Connector for Google Search (Webmaster Tools) v3.0 or higher. 

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. It’s not yet time to give up the old Webmaster Tools CSV download scripts just yet, though; the new Search Analytics Query method fills a big void but there is still a number of other Search Console datasets unavailable in the new API. Google has said this is not a finished product, though, so expect changes.

The Analytics Edge Webmaster Tools Connector v3.0 supports both the old Webmaster CSV downloads and the new Search Console API, and makes it easy to get your data into Excel.

Not All The Data, No Sorting Options

limited-rowsBefore I get started, though, those of you hoping to start massive data mining projects with your search metrics will be disappointed;  the new API it is limited to 5,000 rows (default 1,000) of data — less in some query combinations. Another annoyance is that the queries are always delivered in order of the most clicks, with a random secondary sort.

The Analytics Edge Connector always downloads the maximum row count, and allows you to sort the results by any metric combination.

Dimension Flexibility

Queries can be made with just the metrics to deliver those top-of-the-report numbers for Total Clicks, Total Impressions, CTR and Avg. Position. You can also include the Date to reproduce the requisite trend chart. The date range is still limited to approximately 90 days (3 months), so longer-term trends will require a download-and-store solution.

Analytics Edge provides a free workbook that automates the process on a weekly or monthly basis.

The meat of the data can be sliced and diced by any combination of Queries, Pages, Countries and Devices, giving the API a capability beyond what you can get in the web interface. This is a dataset begging for a slice-and-dice segment analysis! Unfortunately, as you add dimensions, you get less data, dropping to around 3,500 rows.

dimension-flexibility

The date cannot be combined with the other dimensions.

Filter Freedom

Your filter options mimic the web interface, although most people probably haven’t figured out you can actually filter on Queries, Pages, a specific Country, Device or Search Type all at the same time. One noticeable difference over the old CSV downloads is that you can’t select all search types together, you have to pick one of web, image or video. This is consistent with the new web interface, so it shouldn’t be a surprise.

filter-freedom

Analytics Edge automatically converts from the 3-character ISO 3116-1 alpha-3 codes (GBR) used by the API to full country names (United Kingdom).

Date Challenges

The final caveat has to do with the date range selected. We know there is 90-day limit and that the data may be delayed by a couple of days, but it might be 3 sometimes. You need to test to see which days have data before you can ask for the most recent 7 or 28 days. This means 2 queries are required in many cases: e.g. the first to determine which dates are available, and the second to query the most recent 7 day range.

date-challenges

Analytics Edge automatically does this for you, always giving you the most recent data and flexibly adjusting the date range to suit your needs and the availability of the data.

Summing It Up

The new Google Search Console API provides a good first step to filling the void but there is a long way to go before it satisfies most web analysts cravings for data. Maybe it is a good thing – we can’t get lost in endless analysis sessions and don’t need sophisticated tools. Keep it simple; keep it focused.

sample-analysis

Which referral spam villains are annoying which country the most? The new Search Console API opens up new analysis possibilities. Analytics Edge makes it easy to get the data you need into the format you want it in. The Analytics Edge Webmaster Tools Connector is available for only $50/year (free for 30 days).

Long-Tail Keyword Analysis (Advanced Example)

Updated 2015-10-06 to reference Google Search instead of Webmaster Tools.

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. It goes beyond most keyword reports by splitting the search phrases into individual words, applying a Soundex function to group similar and misspelled words, and merging the results into a historical trend analysis. The result shows which individual words are rising or dropping in interest over time.

long-tail-keyword-analysis

This is an advanced example of the capabilities of the Analytics Edge Core add-in along with the Connector for Google Search. The workbook uses several special techniques to deliver the analysis, and the magic happens with the click of a refresh button:

  1. using a Setup worksheet to configure the macro functions
  2. using Regular Expression search and replace to remove non-letters
  3. splits multiple-word phrases into multiple rows
  4. uses a custom SOUNDEX function written in VBA
  5. merges the results with the existing historical worksheet

Download the workbook from the free report page.

Continue reading

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. The same techniques can be used to combine data from any number of sources.

waterfall-report

Continue reading

SiteAdmin URL Crawl Errors Details

wt-siteadmin-urlcrawlerrorsdetailsDownload a sample (up to 9) of the URLs pointing to a specific page URL with crawl errors.

Account – Either select from the dropdown list provided, or enter a value or an Excel cell reference. You can use the button provided to select a cell in an existing worksheet.

Site – Enter the website URL or an Excel cell reference. You can use the button provided to select a cell in an existing worksheet, or the second button to lookup your available websites.

Category – Select a crawl error category or ‘all’ for all categories.

Platform – Select the user agent type (platform) or ‘all’ for all categories.

PageUrl – enter the URL of the page (without the site). It must be one of the pageUrl values returned by the SiteAdmin URL Crawl Errors Samples query.

Notes about usage:

Using the Analytics Edge Core Add-in, this query would typically be used following a SiteAdmin URL Crawl Errors Samples query, and you would enter the Analytics Edge range name ‘[pageUrl]’ to download details for all of the pages returned by the previous query.

crawl-errors-details

Search Analytics

This Analytics Edge wizard makes it easy to get your Google Search Analytics data into Excel.

Account – pick the Login account to use (set in the Accounts wizard). Optionally use a worksheet cell reference.

Site – pick the website you want to report on. Optionally use a worksheet cell reference.

Fields Tab

Select – select any number of optional dimensions for your report. Note that Google will remove some of the data if you combine ‘query’ with other dimensions.

Dimensions – select the dimensions you want in your results. You can drag-and-drop the entries to reorder them.

Metrics – all available metrics appear by default, but you can remove some if desired. You can change the order of the metrics by dragging them in the list.

Filter Tab

Query – that exactly match or contain certain phrases. Note that there is no wildcard match capability in the API. An optional worksheet cell reference can be used.

Page – that exactly match or contains a portion of the page URL. An optional worksheet cell reference can be used.

Country – select a country from the list. An optional worksheet cell reference can be used. You can use either the full country name or the short ISO-3116-1 alpha-3 code.

Device – select a device (desktop/mobile/tablet) or use a worksheet cell reference to one.

Type – select the type of query (web/image/video) or use a worksheet cell reference to one.

Appearance – enter a search appearance term (run a query with the searchAppearance dimension to see which ones exist in your account). Optional worksheet cell reference can be used instead.

Dates Tab

Preset – pick a date range for the query. Note that you are limited to about the last 90 days, and there is no data for the most recent couple of days. The range will be adjusted automatically if data is not available for the dates you request.

Start/Duration/End – select a combination that defines the time period of interest. Optional worksheet cell references can be used.

Sort/Count Tab

Sort by – select a field from the dropdown, then click Ascending or Descending to add that criteria to the list. Columns will be sorted by the first rule with duplicates sorted by the second rule.

Rows – due to API limitations, all rows available will be downloaded with every query, but you can limit the number of rows written to your worksheet.

MultiQuery

none (single query) – default selection; make a single query based on the selections of the other tabs.

Date-based – make multiple queries in the date range selected on the Dates tab. For example:  ‘by 7-Day’ will make separate queries for each 7-day period. The ‘by Week…‘ queries will not return partial week periods.

By Device/Type – make separate queries for each device or search type available.

By Top Pages/Queries/Countries – this option runs a query to obtain the top number of pages/queries/countries for the sorted metrics selected, then runs queries for each of the top entries. While you can enter any number, entering large numbers is not recommended because:

  • the results must fit into your available memory and worksheet space
  • each query counts against your daily limit for all reporting tools you use
  • you increase the chances of a random (infrequent) server or network error

Layout Options – choose one of three layouts for your results.

  • Vertical will append each query vertically, adding dimension columns for the multi-query dimension selected (e.g. start date and end date).
  • Horizontal – Group by Dimension will append each query horizontally, grouping all the metrics for each query together (by dimension). The column titles will include the [dimension] metric combination.
  • Horizontal – Group by Metric will append the queries horizontally, but group similar metrics together. This would make it easier to create trend or comparison charts.

 

 

SiteAdmin URL Crawl Errors Samples

wt-siteadmin-urlcrawlerrorssamplesDownload samples of the crawl errors for the selected web property.

Account – Either select from the dropdown list provided, or enter a value or an Excel cell reference. You can use the button provided to select a cell in an existing worksheet.

Site – Enter the website URL or an Excel cell reference. You can use the button provided to select a cell in an existing worksheet, or the second button to lookup your available websites.

Category – Select a crawl error category or ‘all’ for all categories.

Platform – Select the user agent type (platform) or ‘all’ for all categories.

SiteAdmin URL Crawl Errors Counts

wt-siteadmin-urlcrawlerrorscountsDownload the crawl error counts for the selected web property.

Account – Either select from the dropdown list provided, or enter a value or an Excel cell reference. You can use the button provided to select a cell in an existing worksheet.

Site – Enter the website URL or an Excel cell reference. You can use the button provided to select a cell in an existing worksheet, or the second button to lookup your available websites.

Latest counts only – check this box to restrict the results to the most recent results only. Uncheck the box to get the past 3 months of daily data.

Category – Select a crawl error category or ‘all’ for all categories.

Platform – Select the user agent type (platform) or ‘all’ for all categories.

 

SiteAdmin Sitemaps

wt-siteadmin-sitemapsDownload a list of the sitemaps that have been detected.

Account – Either select from the dropdown list provided, or enter a value or an Excel cell reference. You can use the button provided to select a cell in an existing worksheet.

Site – Enter the website URL or an Excel cell reference. You can use the button provided to select a cell in an existing worksheet, or the second button to lookup your available websites.

 

SiteAdmin Sites

wt-siteadmin-sitesDownload a list of the sites and permission levels for the selected login.

Account – Either select from the dropdown list provided, or enter a value or an Excel cell reference. You can use the button provided to select a cell in an existing worksheet.

 

Accounts wizard

accountsThis Analytics Edge wizard is used to establish Google login accounts that can be used by the various queries.

Optional Double-Login This connector has access to both the NEW Search Analytics API and the OLD Webmaster Tools CSV Downloads (until about Oct 20, 2015). If you want to access both sources, you will need to login TWICE — once using a login dialog, and the second time by entering your account and password.

Manual Login

ga-manual-authIf you experience a problem with the login, such as second-factor authentication failure, click the Manual link in the upper right corner of the dialog. A new browser window will open. Login to your Google account and Accept the access request. You will be taken to a web page on the Analytics Edge web site, and there should be a code in the URL of the browser. Copy the code part of the URL, close the browser, and paste the code into the dialog box provided.

 

Old Webmaster Tools Queries

If you want access to the OLD Webmaster Tools CSV Downloads, then your account MUST have the Less Secure Apps option enabled. This second login is OPTIONAL, but the old Webmaster Tools Query wizard will not run without it.

License wizard

licenseWhen you first start Excel with the Webmaster Tools connector installed, Analytics Edge will open the license wizard. Click the big Activate Free Trial License button to start your trial.

When you purchase a full license, enter the license key and click the Submit button.