Some options are limited.

This site uses cookies and other tracking technologies to make possible your usage of the website, assist with navigation and your ability to provide feedback, analyse your use of our products and services, assist with our promotional and marketing efforts, and provide better user experience.

By using the website, you agree to our Privacy policy

Accept and continue

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=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'))

Share this article with your friends

Sign In Free Sign Up

You’ve reached your query limit.

Or email
Forgot password?
Or email
Back To Login

Don’t worry! Just fill in your email and we’ll send over your password.

Are you sure?

Awesome!

To complete your registration you need to enter your phone number

Back

We sent confirmation code to your phone number

Your phone Resend code Queries left

Something went wrong.

Contact our support team
Or confirm the registration using the Telegram bot Follow this link
Please pick the project to work on

Personal demonstration

Serpstat is all about saving time, and we want to save yours! One of our specialists will contact you and discuss options going forward.

These may include a personal demonstration, a trial period, comprehensive training articles & webinar recordings, and custom advice from a Serpstat specialist. It is our goal to make you feel comfortable while using Serpstat.

Name

Email

Phone

We are glad of your comment
Upgrade your plan

Upgrade your plan

Export is not available for your account. Please upgrade to Lite or higher to get access to the tool. Learn more

Sign Up Free

Спасибо, мы с вами свяжемся в ближайшее время

Invite
View Editing

E-mail
Message
Optional
E-mail
Message
Optional

You have run out of limits

You have reached the limit for the number of created projects. You cannot create new projects unless you increase the limits or delete existing projects.

I want more limits