Export keywords for a search query (export_keywords_csv)

export_keywords_csv

Exports a list of keywords for a search query. The naming of the fields in the report depends on the language of the Serpstat interface.

Keywords

The number of queries

CPC

Competition in PPC

Types of keywords

region_queries_count_last

social_domains

region_queries_count_phrase

checked_date

Keyword length

modified_date

Geographical Verifiers

Correct spelling

Keywords (broad match)

Results found

lang

Example Python

Request data:

http://api.serpstat.com/v3/export_keywords_csv?query=example&token=XXX&se=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'))