Useful query – shows how many users registered on a Drupal site each month: select count(uid), month(from_unixtime(created)) as bmonth, year(from_unixtime(created)) as byear from users group by bmonth, byear order by byear, bmonth; SELECT count(uid), MONTH(FROM_UNIXTIME(created)) as bmonth, YEAR(FROM_UNIXTIME(created)) as byear FROM users GROUP BY bmonth, byear ORDER BY byear, bmonth;
How to use google analytics to track events in flash. Google Analytics lets you track any browser based event, including Flash and JavaScript events. To track an event, call the urchinTracker() JavaScript function with an argument specifying a name for the event. For example, calling: javascript:urchinTracker(‘/someeventhappened’); will cause each occurrence of that Flash event to… Read more »