On Fri, 2010-08-20 at 18:48 +0200, david blanchard wrote: > [David] Actually, in the current actual_ads tab, there is no mention > of > expenses, just the number of players. > But if I follow you, the idea is to compare the LTV and COA, and I > understand, so I added some marketing expenses follow-up in this tab. > At the bottom of each array.
Yup, that's the last piece that will allow to closely monitor our progression. It's now in good shape now to put the main dashboard, to have a clear overview like: http://500hats.typepad.com/500blogs/2007/09/startup-metrics.html Cf the attached ods file - by having a condensed and brief view like this, we can see in a glimpse how we are doing. This is probably the kind of things we'll want to post here for discussion regularly. > [David] Right - I created one tab for each source, on top of the > 'overall_actual_figures' that will gather all figures. > I have a doubt, can we keep the virality in each tab ? That would mean > that we are able to trace who is inviting people and how themselves > came to the game. I guess it's possible, so I kept the virality in > each tab. It would require to put in place the right tracking, but it's possible - and actually necessary. : ) Which makes me think about the fact that I still need to make sure the right metrics will be extracted. I know I could probably find the list of those metrics by studying the BP, but you know it better than me - would you mind listing all the variables you will need (number of active users, ad prices, etc.) to update the BP and the different timeframes? > [David] done too, I've added leads for overall staff (with a ratio of > 1 per 10 as an average - given that the leads in prod will be on > management only and not on content, this seemed reasonable to me, ok > for you ?) Yup - given that the work reviews are shared with the seniors, it makes sense to be able to manage more people. It could even be possible to increase that number, but we'll see how it goes. > > * International teams (territory lead, translator...) > [David] added Good! It seems to be missing a correlation between CS/CM teams and international development. If we add a new territory, we need to add local CS/CM staff. > - I reviewed the general organization of file, you can check the tabs > and let me know what you think Seems good. > - I added an 'actual expenses' tab that will let us follow-up all our > expenses and compare them to the forecast Thanks! Xavier.
dashboard_overall.ods
Description: application/vnd.oasis.opendocument.spreadsheet
_______________________________________________ Hackit Bar mailing list - [email protected] Wiki: http://community.hackit.cx/ List: http://community.hackit.cx/ml/ Forum: http://community.hackit.cx/forum/ Ideas: http://community.hackit.cx/ideas/ IRC: irc://irc.freenode.net/#politis
