Export keywords for a search query (export_keywords_csv)
export_keywords_csv
Exports a list of keywords for a search query
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'))