How to log/work with site stats in an Aware IM application

Contains tips for configurators working with Aware IM
Post Reply
hpl123
Posts: 2579
Joined: Fri Feb 01, 2013 1:13 pm
Location: Scandinavia

How to log/work with site stats in an Aware IM application

Post by hpl123 »

Hi all,
This is a tip on how to use Aware IM to log and work with site (websites) stats (visits etc. etc.). The solution is to use Piwik (www.piwik.org) to log stats and then access the data from an Aware IM app via an external MySQL connection. Works like a charm and is real powerful. The data we can get from Piwik is basically the same as data from Google Analytics.

PS: This can also be used to log email opens via pixel image tracking (read the Piwik documentation for more info).
Henrik (V8 Developer Ed. - Windows)
RLJB
Posts: 914
Joined: Tue Jan 05, 2010 10:16 am
Location: Sydney, Australia

Re: How to log/work with site stats in an Aware IM applicati

Post by RLJB »

Hey Henrik

Can you tell us how you are using this? How it is set-up (very high level)? And what you;re getting from it?

I'm looking to put some analytics into our app about what users are doing, like a simplified Google Analytics - is this a possible solution?

Tks.
Rod. Aware 8.6 (latest build), Developer Edition, on OS Linux (Ubuntu) using GUI hosted on AWS EC2, MYSQL on AWS RDS
hpl123
Posts: 2579
Joined: Fri Feb 01, 2013 1:13 pm
Location: Scandinavia

Re: How to log/work with site stats in an Aware IM applicati

Post by hpl123 »

Hi Rod,
Sure, here is short about Piwik. It's a great solution and can track all kind of things related to site visitors etc.. If you have used Google Analytics before, it's basically the same solution (might be small differences in functionality but overall it is a Google Analytics clone) i.e you can track the same things, it's implementation/tracking is also the same (small javascript script in in html).

Piwik has one important feature that Google analytics don't, you get full data access i.e you log the data in your own MySQL database. I use Piwik for all our sites (+ for email sendouts to track email opens) and then connect to the MySQL database from different Aware IM applications (external DB connection).

Setting it up (Piwik) is simple and I use it in Amazon AWS (free tier takes you a long way and if you go over the free tier limits you don't pay very much). There is a company providing a Piwik prebuilt instance for AWS so installing it is literaly a press of a button. Here is more information about this prebuilt etc. solution: https://aws.amazon.com/marketplace/pp/B0062Q8G2A .
One note, AWS do not allow remote MySQL out of box so you need to work around that by connecting to the DB via SSH in a program like Navicat and then sync the DB to a local/server DB Aware IM in turn can connect to.

Regarding your scenario, I am not sure what you want to track but if it is application usage, I would probably build it directly into the application instead because doing it in Piwik could be tricky (difficult to automate/differentiate between logged in users) but can probably be done if thought through. Piwik is great for things like websites, email opens (pixel image tracking) and is a very good and advanced solution (and easy to use i.e not high-level in implementation or usage).

If you do some cool stuff or implement Piwik, please share your results.
Henrik (V8 Developer Ed. - Windows)
RLJB
Posts: 914
Joined: Tue Jan 05, 2010 10:16 am
Location: Sydney, Australia

Re: How to log/work with site stats in an Aware IM applicati

Post by RLJB »

Thanks for the detailed reply Henrik!

We really just wanted to track usage of our modules by user and bsv. I was hoping it might be a quick and easy solution. You have me interested though - I will delve into the docs and see how we may use it. Tks.
Rod. Aware 8.6 (latest build), Developer Edition, on OS Linux (Ubuntu) using GUI hosted on AWS EC2, MYSQL on AWS RDS
Post Reply