AlexaRank: ArgumentException

#1
Exception: ArgumentException
Message: Connector '{identifier}' not found

SFTE 8.0.90,
Excel 365, Version 1906 (Build 11727.20230)
Win10x64

SeoTools_v8.1.40.0_20190627 (with included ReverceDNS) doesn't work - Excel crashs down 2 seconds after start.

#2

Hi, when does this exception occur? Have you tried updating the Alexa connector via Manager?

#3

It occurs just when i try to get data with
=Dump(Connector("Alexa.Statistics";C3;"GlobalRank,BounceRate,PageViews,TimeOnSite,SearchVisits";TRUE))

Alexa connector is up to date. and, oh, i see, it has these options no longer...:frowning: Just global rank, local rank and referring domains. Is it correct or is it another bug?

#4

That is correct, changed to a more stable way to scrape. Does it work if you use the new metrics in the formula?

#5

at least as values, yes. I maintained some dashboards with data from Alexa - they work no longer, because of no longer available metrics. Are there plans to bring missed metrics (BounceRate, PageViews, TimeOnSite, SearchVisits) back? Haven't tried XpathOnUrl for Alexa yet - maybe it would work

#6

You can get the old connector file via Github history:
https://github.com/nielsbosma/SeoTools-for-Excel-Connectors/blob/4c7ad7c5ba7f3f57a40128a17a91d964cc91dc53/Alexa.xml

Replace the current Alexa.xml with the above and you should be able to do the old requests.

1 Like
#7

Cool! Thank you!

#8

Old connector delivers #NULL!

#9

Okay, perhaps that is why I changed to the new one. I remember one or more of the metrics becoming unstable and so the site may have changed structure completely. If you are comfortable with XPath or regex, perhaps you can fix the old metrics if you specifically want them?