API’s to query the stats database

oriste · Member · Jul 1, 2008 at 10:08 pm
Copy link

Add topic to favorites
In his blog post on May 7, 2007 (http://andy.wordpress.com/2007/05/07/automattic-stats-day-one/) Andy Skelton kind of promised to one day “expose API’s to let plugin developers query the stats database. This will open the field for anyone to create and share new reporting tools, even ones that live in your own dashboard.”

I can’t find any reference to those API’s more than a year later. Does anybody know about them? Am I looking in the wrong places? I’d really like to start digging into this… ;-)
thesacredpath · Member · Jul 1, 2008 at 10:26 pm
Copy link
Andy is referring to blogs using the wordpress.org software – self-hosted. I would seriously doubt it will ever happen here at wordpress.com.
lloydbudd · Member · Jul 2, 2008 at 12:07 am
Copy link
oriste, that is a fair question, and a team mate messaged Andy asking about it.

thesacredpath, whether using the plugin on a self-hosted wordpress.org or wordpress.com blog it’s the same stats system, so I don’t see why it won’t happen on both at the same time.
oriste · Member · Jul 2, 2008 at 6:54 am
Copy link
Thank you, foolwisdom, I appreciate the bump…
andy · Member · Jul 2, 2008 at 2:43 pm
Copy link
There is already an API for querying WordPress.com stats:

http://stats.wordpress.com/csv.php

It works for WordPress.com blogs as well as self-hosted blogs using the Stats plugin.
oriste · Member · Jul 2, 2008 at 3:43 pm
Copy link
Ah! Thank you Andy, this will do the trick.
vivianpaige · Member · Jul 2, 2008 at 5:34 pm
Copy link
orisite – hopefully, you’ll tell the rest of us how to use that query ;)
oriste · Member · Jul 3, 2008 at 2:59 pm
Copy link
vivianpaige: all the instructions are there, on the link that andy gave. You minimally have to enter your WordPress API key, which you find under your user profile, and your blog id, which you can glean from hovering over one of the small stats symbol on your stats page.
(your status bar will display something like http://dashboard.wordpress.com/wp-admin/index.php?page=estats&view=post&post=nnn&blog=mmmmmmm).
Then you construct an url like e.g http://stats.wordpress.com/csv.php?api_key=xxxxxxxxxxxx&blog_id=mmmmmmm&table=postviews, where xxxxxxxxxxxx is the API key you found in your user profile and mmmmmmm is your blogid.
The &table=postviews is one of the optional parameters detailed in the page linked above. You string parameters together by preceding them with & and sticking them to the end of the URL.
I hope this explains it a bit. Explaining things is not my forte… :-(
vivianpaige · Member · Jul 3, 2008 at 9:01 pm
Copy link
I’ll give it a look. thanks!

No items found.