http://localhost/query?component=ecportal&milestone=ckan-sprint-2012-04-16&group=status&order=id The open source data portal software en-US http://assets.okfn.org/p/ckan/img/ckan_logo_shortname.png http://localhost/query?component=ecportal&milestone=ckan-sprint-2012-04-16&group=status&order=id Trac 0.12.3 http://localhost/ticket/2251 http://localhost/ticket/2251 Wed, 21 Mar 2012 11:57:09 GMT kindly <p> Page views and Resources clicks need to be tracked. </p> <h2 id="UserStories">User Stories</h2> <p> US1 As a Site Admin / Visitor (?) I want to see how often a page has been viewed (every page) and how often resources have been downloaded. </p> <p> US1a Next to a resource or a dataset see how often it has been downloaded / viewed </p> <p> US1b I want to see datasets or resources ranked by most downloaded or viewed </p> <p> US1c See a trend graph for a dataset (and resources) </p> <p> Adminstrative Dashboard (?) </p> <ul><li>I want to see the traffic breakdown by country to my site ... </li><li>Ditto for browser type, language, etc etc </li><li>I want to see it graphed over time ... </li></ul><h2 id="ImplementationDetails">Implementation Details</h2> <ol><li>How do we store this data in CKAN? </li><li>How do we track (and store)? </li><li>How do we display </li></ol><ul><li>Config option ckan.status.enabled = False (by default) </li></ul><h3 id="StoringData">Storing Data</h3> <p> How does ckanext-googleanalytics do this? Current table: </p> <p> package_id | count_recent | count_total </p> <p> Move to a new stats_summary table </p> <p> id | item_id | object_type | stats_type (total, month_yyyy_mm, ...) | value </p> <p> Do we store this data into the search (solr) so we can search by it? </p> <h3 id="DisplayingData">Displaying Data</h3> <ul><li>Helper functions / dictize: <ul><li>Helper function: h.stats_get(object_type, id, stats_type) <ul><li>h.stats_top_ranked(object_type, number) -&gt; returns object_dicts or just labels or ... </li></ul></li><li>Change to dictize </li></ul></li><li>Location in the default theme (do we show for example in search results too!) </li><li>Support for ranking by most popular in search? </li></ul><h3 id="TrackingData">Tracking Data</h3> <ul><li>Our own solution (just write to site_tracking) </li><li>Google analytics (plus extension for retrieving data) &lt;- would need a refactor </li><li>Piwiki </li></ul><h4 id="OwnSolution">Own Solution</h4> <p> (For later: not as part of this ticket probably) </p> <p> site_tracking table </p> <p> id | url | timestamp | action (page_view, resource_download) | </p> <ul><li>Make javascript to make request to ckan to store clicks and page views. </li><li>Add middleware so these requests do not go through pylons and just store data quickly. </li></ul> Results http://localhost/ticket/2251#changelog http://localhost/ticket/2260 http://localhost/ticket/2260 Mon, 26 Mar 2012 09:31:59 GMT johnglover Results http://localhost/ticket/2260#changelog