Access SE Ranking in Excel

SE Ranking is a cloud-based platform for SEO and online marketing professionals that provides a complete set of tools for comprehensive.

SE Ranking offers a variety of unique value propositions to its users which include accurate ranking results for the majority of search engines with advanced keyword analysis, keyword grouping, the ability to show which page of your website is ranking and track Google Local and map results.

The platform is useful for experienced SEO and marketing gurus as well as newbies.


Project Summary

  • Summary Statistics - Obtain a project’s summary statistics. Available metrics:
    • Total up - Total number of positions that went up in SERPs
    • Total down - Total number of positions that dropped in SERPs
    • Today Average - Average position for the last ranking check date
    • Yesterday Average - Average position for the previous ranking check date
    • Top 5 - Keywords in the TOP 5
    • Top 10 - Keywords in the TOP 10
    • Top 30 - Keywords in the TOP 30
    • Visibility - Traffic forecast
    • Visibility percent - Visibility in %
    • DA - Moz Domain Authority
    • Yandex X - Number of pages in Yandex’s index

Project Keywords

  • Keyword Overview - Obtain general statistics on a project’s keywords. Also includes a wide range of Google specific features which is either true or false based on appearance in search results. For example: Knowledge Graph, Featured Snippets Top Stories, Images, Videos, Reviews. Available metrics:
    • Name - Query Name
    • Volume - Search Volume
    • Competition
    • Suggested Bid - Cost per Click
    • KEI - Keyword Efficiency Index
    • Results - Number of results for a given keyword in Google
  • Keyword Trend - Obtain the statistics on a project’s keyword ranking check for a specified time period. Available metrics:
    • Date
    • Position - Current position
    • Change - Change in position compared to previous date (could be negative)
    • Price - Price calculated from financial report settings
    • Paid Position - Position in paid Google SERPs
    • Is Map - Indicates where the position was found
    • Map Position - Position in the maps block with the “Display organic and maps search results separately” option enabled
  • Keyword Top 10 - Get a list of the TOP 10 results for the keyword that is tracked in a project. Available metrics:
    • Position - Position in the SERP
    • URL - Page URL
    • Alexa
    • DA - Moz Domain Authority
    • Backlinks - Total backlinks
    • Domains - Number of referring unique domains
    • Yandex X - Site quality index by Yandex that shows how useful a competitor’s site is for visitors
  • Keyword Top 100 - Get a list of the TOP 100 results for the keyword that is tracked in a project. Available metrics:
    • Position - Position in the SERP
    • URL - Page URL

Project Competitors

  • Keyword Trend - Get statistics on the positions of competitor keywords that were added to the project. Available metrics:
    • Position - Current position
    • Change - Change in position compared to previous date (could be negative)
    • Price - Price calculated from financial report settings
    • Paid Position - Position in paid Google SERPs
    • Is Map - Indicates where the position was found
    • Map Position - Position in the maps block with the “Display organic and maps search results separately” option enabled
  • Top Competitors - Find data on the sites that were ranked in the TOP 10 for each of the tracked queries. Available metrics:
    • Domain - Competitor's domain
    • Visibility - Competitor's visibility
    • Alexa
    • DA - Moz Domain Authority
    • Backlinks - Total backlinks
    • Domains - Number of referring unique domains
    • Yandex X - Site quality index by Yandex that shows how useful a competitor’s site is for visitors

Keywords

  • Search Volume - Get the search volume data for a specified region and keyword list (one keyword per row):

Analytics

  • SEO Potential - Enables you to assess the potential traffic volume, cost of traffic, number of new customers. Available metrics:
    • Traffic - Traffic forecast
    • Traffic Value - Traffic cost
    • Leads - Number of clients
    • Leads Price - Estimated profit
  • Available filters:
    • Top N - Calculate based on Top N Results
    • Price - Estimated income from one client
    • Rate - Conversion to Sales

Account

  • Balance - Returns account's balance.

Access

Add from Manager

The SE Ranking Connector is available in the Connectors Manager in the top ribbon:

Head over to the SEO Category and install SE Ranking:

API Key

SE Ranking offers a 14-day free trial (with no credit cards involved) when you can test-drive all major features and the SE Ranking Connector with no strings attached.

  1. Log in to the user account.
  2. Go to Settings -> API.
  3. Click the “Generate API Key” button.
  4. In the SE Ranking Connector taskpane, click on Settings and paste the key:

Contribute

This connector suite is open-sourced on GitHub.


See

Official Documentation

Resources


Get help with this function in the community →