Here is the simple and trick to get the Alexa ranking of your website.
=IMPORTXML("http://data.alexa.com/data?cli=10&dat=snbamz&url="&B1,"//POPULARITY/@TEXT")
Do you understand this?
If you are a Microsoft Spreadsheet expert you should have an idea about this.
If no, don’t worry I will guide you to set up this in your google sheet.
This is just importing the Alexa Ranking of the website through XML value from the Alexa website.
You can check this manually from the website by entering the below link.
http://data.alexa.com/data?cli=10&dat=snbamz&url=webanvar.com//POPULARITY/@TEXT
In the Google Sheet, we are getting the data from the particular Cell B2 and Fetching the respective value from the Alexa website.
Example: https://docs.google.com/spreadsheets/d/11-vSmWgxKeSAvYn50-Y5dtmKpI9NUGTtnY5m9_dYVpk/edit?usp=sharing
If you are an SEO Expert you can use this SEO trick to use get the most popular website
[…] function will call the Alexa ranking of the website and It will show you the Real Alexa […]
Yes, You can check by entering your URL ( YOURWEBSITE.COM ) in the example
http://data.alexa.com/data?cli=10&dat=snbamz&url=YOURWEBSITE.COM//POPULARITY/@TEXT