=UrlProperty("https://seotoolsforexcel.com","depth") => 0
=UrlProperty("https://seotoolsforexcel.com/","depth") => 0
=UrlProperty("https://seotoolsforexcel.com/foo","depth") => 1
=UrlProperty("https://seotoolsforexcel.com/foo/","depth") => 1
=UrlProperty("https://seotoolsforexcel.com/foo/bar","depth") => 2
=UrlProperty("https://seotoolsforexcel.com/foo/bar/","depth") => 2
=XPathOnUrl("https://nielsbosma.se","count(//A)")=>0
=UrlProperty("https://seotoolsforexcel.com","depth") => 0
=UrlProperty("https://seotoolsforexcel.com/","depth") => 0
=UrlProperty("https://seotoolsforexcel.com/foo","depth") => 0
=UrlProperty("https://seotoolsforexcel.com/foo/","depth") => 1
=UrlProperty("https://seotoolsforexcel.com/foo/bar","depth") => 1
=UrlProperty("https://seotoolsforexcel.com/foo/bar/","depth") => 2
<IntervalBetweenRequests RandomFrom="1000" RandomTo="1500" IfSame="Host" />
This will ensure that requests to the same host will be executed with a delay of random ms between 1000 and 1500. IfSame can be "Host" (default), "Domain" or "Url". This is used in some scrapers as a strategy to not get blocked too quickly.
UrlProperty("https://nielsbosma.se/foo?query=value";"left")
=>https://nielsbosma.se/foo
<Proxies>
<Proxy Address="87.110.149.80:8080" Username="foo" Password="bar"/>
</Proxies>
You can enter as many proxies as you want. SeoTools will distribute requests.
=SeoToolsClearCache()Clear all pages from https://nielsbosma.se (use '*' as wildcard):
=SeoToolsClearCache("https://nielsbosma.se*")
From VBA:Application.Run("SeoToolsClearCache","https://nielsbosma.se*")
=HttpStatus("HEAD")
=UrlProperty("https://www.nielsbosma.co.uk","name")
=>"nielsbosma"
<GoogleAnalytics OAuthClientIdentifier="" OAuthClientSecret="" StayAuthenticated="true"/>
=SEOlyticsSVR(string domain, string lcc, [int weeksBack=1, string fields="position", includeHeaders=false]]) : tableReturns SEOlytics SVR (Search Visibility Rank).
=SEOlyticsMonitoredKeywordRanking(string domain, string lcc, string keywords, [Date date=null, int daysBack=1, string searchEngine="google", string fields="position", includeHeaders=false]) : tableReturns daily ranking data for the registered domains of the keywords registered by the caller via the Ranking Resource - similar to the Monitoring/Positions section in the SEOlytics tool.
=SEOlyticsDomainMetrics(string domain, string lcc, [Date date=null, int daysBack=1, string fields="google-backlinks", bool includeHeaders=false]) : tableObtain daily domain detail and social media data for the registered domains - similar to the Monitoring/Domain Details/Social Media sections in the SEOlytics tool.
=SEOlyticsLinkCount(string domain, [int weeksBack=1, string fields="no-links-total", bool includeHeaders=false]) : tableReturns link statistics for an url of a registered domain - as available via the Backlinks/Link Popularity section in the SEOlytics tool.
=SEOlyticsLinkHistory(string domain, [int monthsBack=1, string fields="links-incoming", bool includeHeaders=false]) : tableRetrieval of link history - as available via the Backlink/History section in the SEOlytics tool.
=SEOlyticsBacklinks(string url, int limit, string fields, [bool includeHeaders=false, bool exactUrl=false, string achorText=null, string status=null, string type=null, string srcDomain=null, string srcCountry=null, int srcACRank=0, int backlinksLinkingToSrcDomain=0, int domainsLinkingToSrcDomain=0])Import backlinks - as available via the Backlink/Overview section in the SEOlytics tool.
=DmozEntries(string host) : stringReturns the number of entries found for a host or domain on dmoz.org.
=UnshortUrl(string shortenedUrl) : string.Traverse HTTP redirects until final location is found.
=WikipediaLinks(string url, [string languageCode]) : intReturns the number of exernal links found on url on [languageCode].wikipedia.org. Default languageCode is "en" for english. Maximal number to be returned is 5000. Wildcards '*' can be used in url.
WikipediaLinks("*.seomoz.org","en") => 89
=Velocity(string template, range vector) : stringVelocity string templating functionality to Excel.
$P0, $P1, $P2...
$SeoTools.UrlEncode('niels is awesome!')
$Utils.Eval('A1')
$Utils.Eval('A1:C1')
$Utils.Eval('SUM(A1:C1)')
=NormalizeWhitespace(string text) : stringReplace all whitespace in a text to single spaces.
=StripWhitespace(string text) : stringRemoves all whitespace in a text.
=NiceColors(strin baseColor, int howMany, bool skipHash) : list of colorsReturns a list of nice colors that plays nice with each other.
=CheckBacklink("https://nielsbosma.se","http://*.uservoice.com","Suggestion*",TRUE)
Thanks to Serge Esteves for suggesting this.
=HtmlMeta("http://ogp.me/","og:title")