convert an [login to view URL] database to a google visualization API. Here is example survey of the data that needs to be charted, or just sorted into a list for non chartable answers:
Name1: Steve smith~
Age1: 35-44~
Gender1: Male~
Phone1: 205-381-0332~
Email1: ~
1stApt: 8/13/2010~
What did you do today?: Lease~
What Salesperson Assisted you today?
Salesperson1: Brian Hall~
Salesperson2: ~
Salesperson3: ~
none4: ~
What advertising did you see or hear that Prompted you to visit us today?
ad1: ~
ad2: ~
ad3: ~
ad4: ~
ad5: Received a Letter~
ad6: ~
ad7: ~
ad8: ~
ad9: ~
ad10: ~
ad11: ~
ad12: ~
ad13: ~
ad14: ~
ad15: ~
Please rate these items as on 1-10 scale, as far as how much they influence your decision on where to purchase a vehicle?
.Location: 8~
.Friendly: 9~
.Low Pmt: 10~
.Large Selection: 8~
.Service Dept Reputation: 8~
.Price: 9~
.Price Protection After Sale: 7~
.Tradeinvalue: 8~
.3 Day Exchange Policy: 9~
What did you Like about your Experience Here?
like1: Easy to work with Staff - we where here to do a deal and we did a deal to our satifaction~
What areas do we need to improve? What did you dislike?
dislike1: NA - at this time~
What Other Dealerships did you visit before coming here?
OtherDLR1: ~
OtherDLR2: ~
OtherDLR3: ~
OtherDLR4: ~
OtherDLR5: ~
NODLR6: 1~
Did you Use the Internet while shopping for your vehicle?
UseInternet1: No~
What websites did you visit?
Website1: ~
Website2: ~
Website3: ~
Website4: ~
Website5: ~
Website6: ~
What Newspaper do you read?
WhatNewspaper1: Birmingham News~
WhatNewspaper2: ~
WhatNewspaper3: ~
WhatNewspaper4: ~
WhatNewspaper5: ~
WhatNewspaper6: ~
WhatNewspaper7: OTHER~
WhatNewspaper8: ~
What days do you read the Newspaper?
Saturday1: ~
Sunday2: Sunday~
Monday3: ~
Tuesday4: ~
Wednesday5: Wednesday~
Thursday6: ~
Friday7: ~
What Radio Stations do you listen to?
Radio1: 98.7 Kiss WBHK~
Radio2: ~
Radio3: ~
Radio4: ~
Radio5: ~
Radio6: Talk Radio 105.5 WERC~
Radio7: ~
Radio8: 103-7 the Q WQEN~
Radio9: ~
Radio10: ~
Radio11: 106.98 The Eagle WBPT~
Radio12: Rock 99.5 WZRR~
Radio13: ~
Satellite14: ~
Other15: ~
When do you watch the LOCAL news on TV?
News Time A1: Morning (6-9a)~
News Time A2: ~
News Time A3: LateNight (10pm)~
News Time A4: ~
What Network TV station do you watch the news on?
Network1: ABC~
Network2: ~
Network3: ~
Network4: Fox~
What TV Programs do you watch?
tvshows1: NCIS~
tvshows2: Greys Anatamy~
tvshows3: The Mentalist~
tvshows4: Criminal Minds~
tvshows5: CSI~
NOshows6: ~
How do you get your TV?
T1: ~
T2: Satellite (e.g. Dish/Direct TV)~
T3: ~
T4: ~
T5: ~
T6: ~