-
Notifications
You must be signed in to change notification settings - Fork 0
/
excel-sistrix-api-massenabfrage.txt
45 lines (27 loc) · 2.75 KB
/
excel-sistrix-api-massenabfrage.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
http://api.sistrix.net/xzy?extended=true
http://api.sistrix.net/keyword.us?api_key=$key&kw=angela+merkel&date=now
date=JJJJ-MM-TT
=XPathOnUrl(VERKETTEN("http://api.sistrix.net/keyword.seo?api_key=BrWBmm8vbNK2drVGWSSxFChCD5Jbr2E6&kw=new%20mail&domain=mail.com&date=now&country=de");"response/answer/result";"url")
&domain=gmx.co.uk&date=now&country=uk");"response/answer/result";"url")\r\n=XPathOnUrl(VERKETTEN("http://api.sistrix.net/keyword.seo?api_key=BrWBmm8vbNK2drVGWSSxFChCD5Jbr2E6&kw=
&domain=gmx.co.uk&date=now&country=uk");"response/answer/result";"position")\r\n=XPathOnUrl(VERKETTEN("http://api.sistrix.net/keyword.seo?api_key=BrWBmm8vbNK2drVGWSSxFChCD5Jbr2E6&kw=
?country=$country
de – Deutschland
at – Österreich
ch – Schweiz
us – USA
uk – England
es – Spanien
fr – Frankreich
it – Italien
=XPathOnUrl(VERKETTEN("http://api.sistrix.net/keyword.domain.seo?api_key=BrWBmm8vbNK2drVGWSSxFChCD5Jbr2E6&domain=tambini.de&date=last%20year&country=de");"response/answer/result";"kw")
=XPathOnUrl(VERKETTEN("http://api.sistrix.net/keyword.domain.seo?api_key=BrWBmm8vbNK2drVGWSSxFChCD5Jbr2E6&domain=tambini.de&date=last%20year&country=de");"response/answer/result";"position")
=XPathOnUrl(VERKETTEN("http://api.sistrix.net/keyword.domain.seo?api_key=BrWBmm8vbNK2drVGWSSxFChCD5Jbr2E6&domain=tambini.de&date=last%20year&country=de");"response/answer/result";"competition")
=XPathOnUrl(VERKETTEN("http://api.sistrix.net/keyword.domain.seo?api_key=BrWBmm8vbNK2drVGWSSxFChCD5Jbr2E6&domain=tambini.de&date=last%20year&country=de");"response/answer/result";"traffic")
=XPathOnUrl(VERKETTEN("http://api.sistrix.net/keyword.domain.seo?api_key=BrWBmm8vbNK2drVGWSSxFChCD5Jbr2E6&domain=tambini.de&date=last%20year&country=de");"response/answer/result";"url")
http://api.sistrix.net/keyword.domain.seo?api_key=$key&domain=bonn.de&date=now&host=www.bonn.de
https://api.sistrix.com/keyword.us?api_key=BrWBmm8vbNK2drVGWSSxFChCD5Jbr2E6&kw=elektroauto&date=now
=Dump(Connector("Sistrix.KeywordUs";"elektroauto";FALSCH;"de";"type,position,position.intern,url";FALSCH))
=XPathOnUrl(VERKETTEN("http://api.sistrix.net/keyword.seo?api_key=BrWBmm8vbNK2drVGWSSxFChCD5Jbr2E6&kw="&c3&"&domain=cosmosdirekt.de&date=now&country=de&url="&b3);"response/answer/result";"position")
=XPathOnUrl(VERKETTEN("http://api.sistrix.net/keyword.seo?api_key=BrWBmm8vbNK2drVGWSSxFChCD5Jbr2E6&kw="&a1&"&date=now&country=de&num=10");"response/answer/result";"position")
=Dump(XPathOnUrl(VERKETTEN("http://api.sistrix.net/keyword.seo?api_key=BrWBmm8vbNK2drVGWSSxFChCD5Jbr2E6&kw="&a1&"&date=now&country=de&num=10");WAHR))
=importXML("http://api.sistrix.net/keyword.seo?api_key=BrWBmm8vbNK2drVGWSSxFChCD5Jbr2E6&kw="&A4&"&domain="&D4&"&date=2016-09-04&country=de&url="&C4,"//@position")