It will give you the full list upon selection but there are few more additions to the metrics like unique visitors, etc. I need to do a nice excel spreadchat that calculates metrics for goals…1 year, 6 month,3 month, 1 month, weekly, and daily goals.
I should be able to enter the 1 year goals and then it trickles down and automatically fills in the rest of the chart. I will have a metrics list of site goals in terms of traffic, sales, conversions, etc.
I should be able to adjust the monthly growth rate to also manipulate the chart.
I will have data like this
http://tctechcrunch.files.wordpress.com/2010/05/grouponcategories.png
http://tctechcrunch.files.wordpress.com/2010/05/groupondeals.png
http://tctechcrunch.files.wordpress.com/2010/05/grupontable3.png
http://tctechcrunch.files.wordpress.com/2010/05/groupontable4.png
I essentially want to just customize a working forecasting model to help manage projections and forecasts for key metrics for my website.
Maybe we can customize something from this list
http://www.exinfm.com/free_spreadsheets.html
