I want to create reports directly from Piwik database. For example, I want to query URLs that a user visited. However, it seems the URLs are not stored as such but as hash-values instead (in table *_log_action). And the name field contains the title of the page, not the URL.
As a feature I suggest the URLs are saved in the table *_log_action. And how can I access the URLs now? Is there somewhere a mapping between URLs and hashes?
Thanks in advance! I find Piwik absolutely great!