Help by using reference

Support
#1

Hi,

I'm using the this formula:

=XPathOnUrl("http://api.sistrix.net/keyword.seo?api_key=MYAPI&domain=google.de&date=09.11.2015&kw=google";"//result";"position")

It gives me the position from a keyword to a site from the tool SISTRIX. I want to set the date and and keyword as a reference. Like this:

=XPathOnUrl("http://api.sistrix.net/keyword.seo?api_key=MYAPI&domain=google.de&date=C4&kw=google";"//result";"position")

But I get just an empty cell. If i set the cell-reference in " i get an error. Like this:

=XPathOnUrl("http://api.sistrix.net/keyword.seo?api_key=MYAPI&domain=google.de&date="&C4;"&kw=google";"//result";"position")

Maybe you could help me?

#2

Why not just use the new Sistrix integration in SeoTools 5.1.3?
https://seotoolsforexcel.com/sistrix/

#3

Hi,

thanks for your response. I would be happy, if i could solve the problem without the Pro-Edition. Is this possible?

#4

I buy the pro-Version of SEOTools and try the Sistrix Integration. I search for a way, to see the rankings for a specific keyword and a specific domain.

Could you help me and show, how is it possible to realize this with SeoTools?

#5

Another Problem: I get an error when trying to connect with sistrix.

#6

This mean your API key isn't setup or is incorrect.

http://seotoolsforexcel.com/sistrix/

#7

Hi Niels,

thank you, it seems that the plugin need some minutes, now it works.

Could you help me with the other problem?

I buy the pro-Version of SEOTools and try the Sistrix Integration. I search for a way, to see the rankings for a specific keyword and a specific domain.

Could you help me and show, how is it possible to realize this with SeoTools?

#8

Don't think that's implemented for Sistrix. You'll need https://www.sistrix.com/api/keyword/#keyworddomainseo for that. I can put it on the todo.