Need help? Check out our Support site, then


WordPress.com Forums » Support

API’s to query the stats database

  1. oriste
    Member

    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. thesacredpath
    Member

    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. lloydbudd
    Staff

    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. oriste
    Member

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

  5. andy
    Staff

    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. oriste
    Member

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

  7. vivianpaige
    Member

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

  8. oriste
    Member

    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. vivianpaige
    Member

    I'll give it a look. thanks!

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags