Aitch's Place …

Posts Tagged ‘software development’

Over the holiday period, Sarah and I went visiting at her mum’s in Ipswich.  Now, I’m not saying that they lack technology down there or anything, but there was no internet connection.  None whatsoever.  Zilch.  Nada.  Eeek!

What’s a techie guy meant to do in that situation?  I didn’t have a laptop or notebook with me, so I had to make do with my Android phone as the only source of technological entertainment and sole connection into the real world

Now, I’d heard about the Damon Kohler’s ASE (Android Scripting Environment) quite a while back, but never really got round to looking at it or taking it for a spin.  I’ve developed a few apps using the Android SDK, and even though Java isn’t my primary language, the whole platform has been designed to make it easy for developers to get their apps working really quickly.

However, day-to-day at Linden Lab, I work primarily in Python, so this looked like the perfect opportunity to have a delve into Python scripting use ASE, and it suited my circumstances perfectly — after all, you can type directly into the Android terminal and edit your Python scripts there and then without having to be tethered to a computer.

Installing ASE was a breeze directly from the web-site, and the supported environments were easy to install from within ASE itself — you can develop in Lua, JavaScript, Ruby, BeanShell, or Perl;  Python was my choice though, obviously.  So, following the instructions, getting started was really quick.  There are some example scripts to get you going, including a test script which quickly runs through some of the features.

And then I saw it:
import gdata.docs.service

Oooh.  Nice.  I was going to install the Google Data API Python libraries and have a play with those, and fortunately for me all the Google Data API Python modules were included in the standard ASE install.  Yay! In fact, you have everything you need to talk to all of Google’s APIs — Google Docs, Base, Blogger, Calendar, Contacts, YouTube, Webmaster Tools, Maps … they’re all there!

I was thinking of having a script that could check the stats on my web-site via Google Analytics.  I know I could have just browsed to the stats pages using Android’s built in browser, but where’s the fun in that   Now I can use the Google Analytics API to directly query the stats via a Python script running on my Android.

I’ve done quite a bit of work with Google Adwords APIs, but nothing in Python, but reading through the Analytics API documentation gave enough direction.  Essentially you need to authenticate yourself with the service you’re after, then make a query against the data with the parameters you want to filter on.  Seriously, it’s that simple.

Of course, it being a small soft keyboard, it took a day and an age to type in the Python code.  Fortunately for me, I had a lot of time to kill, and this was the closest I was going to get to any kind of computing power for a few days!  Get those fat fingers typing on that diddy screen …

Seriously, that’s how easy it is to work with the Analytics API.

The USERNAME and PASSWORD are the same as the email address and password that you would use to log into your Adwords/Analytics dashboard on the web.  And no, strangely enough, what you see in the above code is not my username/password

In the code, the following snippet warrants a little more explanation:

The ids, here set to ga:123456, is the profile id(s) of the web-site(s) you want to retrieve details of (and no, ga:123456 is not my profile id either!).  Profile id is also referred to as tableId in the Google Analytics API. You can find your profile id easily enough by logging into your Adwords/Analytics account and then selecting edit on the profile.  As you can see in the screenshot below, the profile id is clearly displayed.  The profile id is a number, and you just need to add the ‘ga:’ in front of it.

The dimensions parameter describes how you want your data categorised; the metrics parameter describes what details you actually want to see.  In my script, I wanted to see the number of visits to this web-site split by what keyword the visitor used to find the site.  The sort parameter above shows that I wanted the results displayed in descending order of visits, i.e. the highest number of visits first.

The start_date and end_date parameters speak for themselves.

The values for dimensions and metrics could contain more than one item, separated by commas, and the full list of available dimensions and metrics can be found in the Google Analytics Dimensions and Metrics reference.

I originally used droid.makeToast() to pop-up the results on the screen, but the pop-up didn’t stay on the screen long enough for me to read all the returned information!  The original Java implementation allows you to change the time it shows on the screen, but ASE’s makeToast() doesn’t have that parameter available.  So instead I’ve used droid.getInput() to display the Google Analytics data.

This method, as the name suggests, is usually used to get input from the user, however I found that using it provides a convenient way to display the data in a modal dialog, complete with OK button and scroll-bars if necessary.  ASE doesn’t yet provide any other dialog capabilities — or in Android SDK speak, intents — and no other GUI design is available.  If I were to extend this mini-app, I would prefer a more esoteric display, but if I’m going to do that it would be easier to develop the whole thing in Java from scratch … hrm, perhaps an idea for another project …

… and remember, the main reason for starting this scripting endeavour was because I didn’t have any computer available to develop on, and so Python via ASE was the perfect way to achieve my goal.

So there you have it, a simple Google Analytics Python script on the Google Android using ASE (Android Scripting Environment).  If you have questsions, just let me know!

[Edit: I've added a follow-on update to improve the user interface using the latest ASE Python Android Scripting Environment here]

[All files are released under Creative Commons BY-SA-NC 3.0]