Export keywords for a search query (export_keywords_csv)

export_keywords_csv

Exports a list of keywords for a search query

Example Python

Request data:

http://api.serpstat.com/v3/export_keywords_csv?query=XXX&se=XXX&token=XXX

Response data:

Keywords	The number of queries	CPC	Competition in PPC	Results found	Keywords (broad match)	region_queries_count_phrase	Types of keywords	Geographical Verifiers	social_domains	Correct spelling	Keyword length	lang	difficulty
tatoo money	10	0	0	1220000000	0	0			yelp,pinterest,twitter,youtube,tumblr,amazon,facebook	tattoo money	2
tatoo of s	90	0	0	1180000000	0	0	pic,related_search		amazon,yelp,wikipedia,pinterest,facebook		3
sexy tatoo for girls	10	0	7	1170000000	0	0			instagram,pinterest,twitter,youtube,tumblr,amazon,facebook	sexy tattoo for girls	4
3d tatoo pic	90	0	14	1170000000	0	0			yelp,pinterest,twitter,youtube,tumblr,facebook	3d tattoo pic	3
silver tatoos	30	0.9	12	1160000000	0	0			pinterest,youtube,twitter,wikipedia,amazon,facebook	silver tattoos	2
kool tatoos	50	0	0	1120000000	0	0	related_search		tumblr,amazon,yelp,facebook,pinterest		2
gallery tatoo	50	0	9	1040000000	0	0	local_pack,related_search,pic		instagram,yelp,facebook		2
kinds of tatoo	70	0	0	1030000000	0	0	related_search,a_box_fsnippet,pic,also_asks		wikipedia,pinterest		3
tatoo potos	70	0	0	1020000000	0	0	pic,related_search		amazon,facebook,yelp,pinterest,instagram		2
tatoo all	50	0	0	1000000000	0	0	pic,related_search		pinterest,facebook,amazon,wikipedia		2
tatoos sleves	70	0	56	975000000	0	0	video,related_search,pic		reddit,pinterest,amazon,twitter,wikipedia		2
tatoos male	90	0	7	974000000	0	0	related_search,pic		facebook,pinterest,wikipedia,amazon		2
free tatoo images	50	0	32	944000000	0	0	related_search,pic		amazon,wikipedia,pinterest		3
beat tatoos	50	0	0	915000000	0	0	related_search,video,refine_by_brand,pic		facebook,youtube,pinterest,yelp,amazon		2
why tatoo	50	0	0	892000000	0	0	video,related_search,also_asks,pic		youtube,wikipedia		2
hart tatoo	50	0	41	842000000	0	0	related_search,also_asks		instagram,yelp,facebook,wikipedia,pinterest,amazon,foursquare,reddit		2
tatoo ships	90	0	0	812000000	0	0	local_pack,related_search,kn_graph_disambiguation		wikipedia,facebook,yelp,tripadvisor		2
cool men tatoos	70	0	0	806000000	0	0	pic,related_search		amazon,pinterest,wikipedia		3
t tatoo	50	0	10	798000000	0	0	pic,refine_by_brand,related_search,video		youtube,twitter,instagram,wikipedia,facebook,pinterest,amazon		2
diy tatoo	70	0	1	797000000	0	0	pic,related_search,video,also_asks		facebook,amazon,wikipedia		2
female tatoo	50	0	5	795000000	0	0	related_search,pic		facebook,amazon,pinterest,wikipedia		2
1 tatoo	480	0	1	789000000	0	0	video,related_search,local_pack,pic,also_asks		instagram,wikipedia,facebook,amazon,youtube,reddit		2

import codecs
import json
import pprint
import urllib.request as urlrequest
from urllib.parse import urlencode

host = 'http://api.serpstat.com/v3'
method = 'export_keywords_csv'

params = {
    'query': 'buy%20laptop',
    'se': 'g_us',
    'token': 'ijmiom4f5m34905g03um8342dm04923lre3w'}

api_url = "{host}/{method}?{params}".format(
    host=host,
    method=method,
    params=urlencode(params, safe=',')
)

try:
    csv_data = urlrequest.urlopen(api_url).read()
except Exception as e0:
    print("API request error: {error}".format(error=e0))

codecs.open('csv_data.csv', mode='w', encoding='utf8').write(csv_data.decode('utf8'))