Great examples of innovative use of the GA API guys, really impressive, thanks for posting.

One issue I have with the keyword tree, however, is that with a large volume of long-tail keywords, it is quite easy to get the report to extend way beyond the confines of the initial view - zooming out renders the keywords completely unreadable.

Thus I am stuck with the 'middle ground' keywords, whereas what I really want to look at is the gold at the top and bottom, which contains the optimisation opportunities.

A simple scrolling interface might solve this issue?

Thanks,
Tim.

Thanks Chris - yes, I'd seen (and liked) that functionality, however if you're trying to analyse a very common kw for your site (such as 'Review' - we are a reviews website), then there are just a lot of single words used before this.

Also, clicking words along the bottom sometimes makes the whole display disappear off the right-hand side of the screen! :)

Great stuff though, love the general look and feel, really prompts some 'fun' investigation.

Cheers,
Tim.

The PyGTrends.py API looks really fascinating to me. I have almost converted the Code to Java and will publish this week with a Swing Interface. Any better suggestions on that?

Hi Yadab! Could you please share the Java code you have written? I am also working on it. Please contact me by email.

aavaliani (at) gmx.net

The PyGTrends.py API is really awesome. I have a question though. Does Google frown upon iterative pings to Google Trends to pull Relative traffic. To make it more specific, if I have 2,000 keywords and I code iterative pulls from Google trends, do I stand a chance of getting banned?

Gautham.

This Python script is great and provides an excellent solution. However, I have never used Python before so I was hoping someone could email (james.solo |AT| mathworks.com) me step by step instructions on how to modify this script to work with keywords of my choice ( I have 40 total ) and to grab data from 2004 to-date using the "CSV with relative scaling" data file.

Many thanks,
James

I have been using the pyGTrends module and have encountered problems when using keywords with more than one word. For instance, "air express" was one of the keywords. It has a search history--when I manually download the data from Google Trends, the historical data shows up fine. However, when I use the pyGTrends module, the data comes out as all zeroes.

The same problem occurs with all keywords/phrases that contain more than one word. Is pyGTrends compatible with only one-word keywords, and if not, how do I fix this problem?

If someone could email me, arjunrmodi at gmail dot com, that would be great. Thanks.

Great module.

Hi,

I am wondering if you Google Gurus know of how to attack a project I am trying to accomplish. I want to be able to run a script, query, software that can give me the answer to something like the following.."I want to know what search terms have been searched 1500 a day on average and have less than 200,000 results". The 1,500 and 200,000 are variables that can be changed. It would be cool to be able to have a drop down menu to say "last 30 days" "last 90 days" etc. I have posted this project on Elance and Guru and I have mostly gotten "never heard of it, can't be done." Some talked of building a library through API and then running queries on it. Does this query exist or how can I go about getting it done?

Hi Sal,

This is really a great tool. I am facing the same issue as Arjun. I am not able to extract keyword combinations for phrases with e.g. two words. Single keywords work fine...
You mentioned, that this issue has been resolved. I downloaded the latest version from github, can you give me some advise how to extract keyword combinations, or how to adjust the code respectively.

Thanks in advance, this is really a great work.

Hi,
The code has (obviously) changed with later versions which makes the instructions above harder to follow. Where to enter the keywords, in this line?

def download_report(self, keywords, date='all', geo='all', geor='all', graph = 'all_csv', sort=0, scale=0, sa='N'):

I have never used Python before...

The lib does not work correctly at the moment. It messes up the headers, the header for the first column (e.g. 'Week') is not inserted by the code as it generates the headers from the first line, while the all tables ('sections') have one more column whose name you actually use to identify the section. Thus one solution is to insert the requested section name as the name of the first column.

I really loved this and it works great.

I have one question though, whenever I put in a single query it splits it into alphabets. How does one circumvent this?

Sal,

This is great, and it was working great for me. However, after a few calls in an iterative script, I started getting a 503 Service Unavailable message. I'm guessing they figured out I was running a script. Any idea how to get around this?

Thanks Sal. That's what I've been trying, and it works now that I'm on a different computer with a different IP. Any idea on how long I'll have to wait before I can run it on my original machine?

redneckjedi: I've also run into this. No idea for how long they will ban your IP but you could use a proxy in the meanwhile.

Hi Sal
Great tool- very useful indeed, many thanks.

I'm new to Python but pulled together a little code to cycle through different keyword inputs. It seemed to be working fine but then I ran into the issue mentioned by redneckjedi unfortunaltely. I had included a sleep(10) but clearly that wasn't enough and I am now getting Http Error 503: Service Unavailable. When I access the site manually I am greeted with a captcha so I can still run the queries manually just not through the script- has anyone else come across this? I hope the block will stop soon and I will then add a much longer sleep. I only have about 20 or so keyword sets which should be ok I think?

Anyone any ideas how long the ban lasts?
cheers
Piers

Below is my rudimentary loop which I'm sure could be improved upon

#----- import pygtrends
import sys
sys.path.append('c:\\python_code')
from pyGTrends import pyGTrends
connector = pyGTrends('username','password')

#----- initiate output file
import time
final_output = str()

#-----load csv inputs file
import csv
gtrends_input = csv.reader(open("google_trends_inputs.csv","rb"))
gtrends_input_list = []
gtrends_input_list.extend(gtrends_input)

#---- define loop
loop_range = range(1,len(gtrends_input_list))

for x in loop_range:

#---- parameters
tmp_row = gtrends_input_list[x]
tmp_terms = tmp_row[:5]
tmp_geo = tmp_row[5]

#---- save parameters to output
final_output = final_output + tmp_geo + '\n'

#---- get data
connector.download_report((tmp_terms),geo=tmp_geo,scale=1)

#---- append output
tmp_output = connector.csv() + '\n'
final_output = final_output + tmp_output
time.sleep(100)
print 'done',x, tmp_terms, tmp_geo, tmp_symbol

#---- end loop

#---- output

outfile = open('output.csv','w')
outfile.write(final_output)
outfile.close()

My IP was blocked for a day after submitting less than 100 queries.

resp = self.opener.open(self.url_ServiceLoginBoxAuth,params).read();

print " resp ::"+resp;

Im getting the response from google that says "Your browser's cookie functionality is turned off. Please turn it on". ie, not able to login to google account for trends.

Please help me out.

This is a great idea--I've been waiting for google to roll out their long promised API...

Has anybody but Dheeru experienced the limitations of this API. I would like to set up a datasource to integrate cleanly into a cakePHP app, but it doesn't seem worth the while if google cuts off access to an account/ip(?) after a small number of queries.

Anybody have any specifics on this?

No doubt, This code is an excellent start.,
But As-it-is I tried your code, I am getting

Exception("Could not find requested section") [line number:101]

Can anyone reply on what should I do exactly ?

I would Thank anyone who takes kindness to mail me at sivatumma@hotmail.com.

Hi Sal,

Thank you so much for the wonderful code - really looks promising.

A quick question..I had used the following script

from pyGTrends import pyGTrends
from csv import DictReader
r = pyGTrends('my email', 'passwd')
r.download_report(('spain', 'wine'))
print DictReader(r.csv().split('\n'))

As a result of it, one "pyGTrends.pyc" got created and output was printing as "<csv.DictReader instance at 0x8b8998>". I didn't see any error display btw..

How do i get the CSV output of the report? Could you please assist with me on this?

Thanks

I have the same questions as the above.
also, is there a document for using this API.
Thanks

I want to ask about section in csv function. I was trying to get a certain csv, but the interpreter stops at line 115 that produces error message : "KeyError: 'main'"

I want to ask about the other parameter. I can not print the csv because of the section parameter there.

Thanks.

From yesterday, This script can't do print connect.csv(). It always returns "Could not find requested section" error. Do you know where the problem is?
I also download the original script in case I modify anything but the error remains.
Thanks

the api looks super friendly yet powerful, I'm so glad someone finally made these reports available programatically, awesome stuff man!

I wonder if this violate Google Analytics' TOS and how long before Google changes something that things break apart.

Using the example above shouldn't it be connector.list_sites() to get a list of all the site id's. Also for me this only returning the first site.

The report list, connector.report_list(), seems not to be comprehensive here's a better one:

Google Analytics Reports

-Visitors-
VisitorsOverviewReport
GeoMapReport
VisitorTypesReport
LanguagesReport

-Visitor Trending-
VisitsReport
UniqueVisitorsReport
PageviewsReport
AveragePageviewsReport
TimeOnSiteReport
BounceRateReport

-Visitor Loyalty-
LoyaltyReport
RecencyReport
LengthOfVisitReport
DepthOfVisitReport

-Browser Capabilities-
BrowsersReport
PlatformsReport
OsBrowsersReport
ColorsReport
ResolutionsReport
FlashReport
JavaReport

-Network Properties-
NetworksReport
HostnamesReport
SpeedsReport
UserDefinedReport

-Traffic Sources-
TrafficSourcesReport
DirectSourcesReport
ReferringSourcesReport
SearchEnginesReport
AllSourcesReport
KeywordsReport

-Adwords-
AdwordsReport
KeywordPositionReport
OfflineAudioReport

CampaignsReport

-Content-
ContentReport
TopContentReport
ContentByTitleReport
ContentDrilldownReport
EntrancesReport
ExitsReport

This is awesome work. Do you think this python script could work in conjunction with superkaramba on Linux?

This is great. I put this together with a Samurize desktop to display Analytics data on my desktop.
Thanks!