Need help? Check out our Support site, then


API’s to query the stats database

  1. 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... ;-)

  2. Andy is referring to blogs using the wordpress.org software - self-hosted. I would seriously doubt it will ever happen here at wordpress.com.

  3. 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.

  4. Thank you, foolwisdom, I appreciate the bump...

  5. 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.

  6. Ah! Thank you Andy, this will do the trick.

  7. orisite - hopefully, you'll tell the rest of us how to use that query ;)

  8. 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... :-(

  9. I'll give it a look. thanks!

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags