Show a count of new installs per day
February 11, 2009
Everytime we launch a new application in a social network, after a few weeks it’s important to know if we have upward growth.
The only thing I can think that demonstrates this is more installs per day. In our databases we capture full timestamps of the new installed user.
To turn this into something I can look at and understand, I have to run this query.
SELECT date_format( date_added, ‘%Y-%m-%d’ ) , count( * )
FROM fb_user
GROUP BY date_format( date_added, ‘%Y-%m-%d’ )
ORDER BY date_format( date_added, ‘%Y-%m-%d’ ) ASC
I am going to try to make a graph to view this in flex… first time Flex graphing đŸ™‚ I’ll post an update when it works..
Advertisements