Seedhub Usage

From Seed Hub

Contents 1 Unique Logins 2 Unique Searches 3 Monthly Online Samples 4 Monthly Bulk Certificates‎ 5 Online Samples Created 6 Technical

Unique Logins

This shows the number of times users have logged into SeedHub since it was first offered in 2006.

The user may do many things after logging in, or just look up one sample result and leave.

The peak usage is just after harvest, and during the sale of seed in the spring.

Unique Searches

Monthly Online Samples

Monthly Bulk Certificates‎

Online Samples Created

These are the number of samples submitted onlin from the end of 2006 thru April of 2009. This has not been heavily promoted, and is used only be a few customers at three labs.

Colorado

csga  	2006  	22
csga 	2007 	29
csga 	2008 	55
csga 	2009 	28

Wyoming

wsal 	2006 	4
wsal 	2007 	214
wsal 	2008 	168
wsal 	2009 	73

Washington

wsda 	2007 	50
wsda 	2008 	10
wsda 	2009 	4

Technical

Seed hub logins

SELECT substring(start_time,1,7), count(*)       
FROM pureh.web_logins 
where hub_database = 'seedhub'
group by substring(start_time,1,7)

sample search

seedhub searches
SELECT substring(visit_when,1,7), count(*)  
FROM seedhub.visit_log
group by substring(visit_when,1,7)

bulk sales

SELECT substring(create_date,1,7), count(*)                  
FROM bulk_sales                                              
group by substring(create_date,1,7)                          

Online Samples

SELECT substring(create_date,1,7), count(*)                  
FROM my_samples                                         
group by substring(create_date,1,7)